Berger, Stefan (IT - Management) schrieb:
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:
yes you have to try it.... if you use an column "email" then you don't
need a coumn realm!
ok i understand.
the sql select is:
...
...
select_field=username
where_field=email
in smtpd.conf
no this is for your postfix SQL lookup tables
ok a misunderstanding, you mean its the map i should create in postfix
to use the sql function ? For mydestination or vitual_alias_maps ?
in smtpd.conf
sql_select: SELECT password FROM "TABLE" WHERE mailadress = '%u'
i have tried it... in my config i had ='[EMAIL PROTECTED]' but the %R is not
necessary
so i removed %r and all works fine
cyrus will now look in the sql table column mailadress and for e.g
"[EMAIL PROTECTED]" see, that the user login consist of
[EMAIL PROTECTED]" so forget the %r
thanks
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 ?
yes you leave it empty and there is no realm.... because you have virtual
domains your smtpd_realm e.g. "@domain1.tld" for domain1 or
"@domain2.ltd"
for domain2 is alway different. But when you use the column "mailadress"
then you don't specify smtpd_sasl_local_domains because all is
included in
the login name=mailadress=5u of the user!!
ok
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
