From: Holm Kapschitzki (no email)
Date: Mon Jan 02 2006 - 14:59:17 EST
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. 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 ='%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
>
>
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
|
|
|