Berger, Stefan (IT - Management) schrieb:
if you use a sql table with a column "mailadress" including the whole
mailadress of an user e.g. [EMAIL PROTECTED] then the %r is the right
option for you. The user have to login with his whole email adress, not
only the user name!! Then your sql statement is correct. Try it and read
carefully your logs.
ok, i think i have to try it, cause i am a little bit confused cause of
username and realm. In your case it depends how the mailadress is stored
in the mysql table ? I have the following columns:
username, userrealm, userpassword and auth with the default "1"
You mean i should add a column "email" with [EMAIL PROTECTED] But
wahts with the username. Is this the same like emailadress. And whts
with the realm inmy table?
the sql select is:
...
...
select_field=username
where_field=email
in smtpd.conf
But in postfix don't specify smtpd_sasl_local_domain,
leave it empty.
On my machine it works fine!
Here i define the realm ? When i leave it empty, there is no realm ?
greets Holm
----
Cyrus Home Page: http://asg.web.cmu.edu/cyrus
Cyrus Wiki/FAQ: http://cyruswiki.andrew.cmu.edu
List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html