> 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! > 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? yes username=mailadress any problems with that? > the sql select is: > > ... > ... > select_field=username > where_field=email > > in smtpd.conf no this is for your postfix SQL lookup tables 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 >>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=%u of the user!! > 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 > -- Stefan Berger - Systemadministrator - DIMA Systems AG Nonnenstraße 39 04229 Leipzig Tel.: +49 341 2668 - 0 Fax.: +49 341 2866 - 333 mailto: [EMAIL PROTECTED] www.dima-systems.de This e-mail may contain information that is privileged and confidential. The information is intended only for the use of the addressee. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify DIMA Systems AG immediately and erase all copies of the message. ---- 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
