SASLAuthd + PAM + MySQL = Realm problem

[Warrick FitzGerald]

Igor Brezac wrote:

>
> Start saslauthd with -r.  If -r is not available you will need to 
> upgrade cyrus sasl.
>
> -Igor
>
> On Mon, 4 Oct 2004, Warrick FitzGerald wrote:
>
>> Hi All,
>>
>> I'm sure this has been asked before but I cant seem to find it in the 
>> archives.
>>
>> I''m running SASLAuthd + PAM + MySQL  - The config seems to work 
>> fine, as this works:
>>
>> [root at mail2 sysconfig]# /usr/sbin/testsaslauthd -s imap -u 
>> test at test.com -p test
>> 0: OK "Success."
>>
>> However when I use Mozilla Thunderbird to connect to the server I see 
>> the following in auth.log:
>>
>> SELECT password FROM accountuser WHERE username='test'
>>
>> So I'm guessing the @test.com is being stripped and used as a realm 
>> or something like that.
>>
>> Reading the logs I see that there's a way around this using auxprop 
>> instead of PAM, but I would really like to use PAM.
>>
>> [root at mail2 sysconfig]# cat /etc/pam.d/imap
>> auth       optional     pam_mysql.so user=root passwd=pqlbt5lin 
>> db=mail table=accountuser usercolumn=username passwdcolumn=password
>> account    required     pam_mysql.so user=root passwd=pqlbt5lin 
>> db=mail table=accountuser usercolumn=username passwdcolumn=password
>>
>> The docs do not say anything about appending a realm or something of 
>> that nature.
>>
>> Thanks
>> Warrick FitzGerald
>>
>>
>> ---
>> 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
>>
>
Thank you Sir, adding the "-r" to to the startup worked like a charm.
---
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