- Previous message: Holm Kapschitzki: "Re: cyrus and realm"
- Maybe in reply to: Holm Kapschitzki: "cyrus and realm"
- Next in thread: Holm Kapschitzki: "Re: cyrus and realm"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
|
|
|
From: Berger, Stefan (IT - Management) ("Berger,)
Date: Mon Jan 02 2006 - 14:32:06 EST
> Berger, Stefan (IT - Management) schrieb:
>
>>if you use a sql table with a column "mailadress" including the whole
mailadress of an user e.g. 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 . 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 ='%u@%r' 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
"" see, that the user login consist of
%u=" 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:
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
|
|
|