SASLAuthd + PAM + MySQL = Realm problem

[Warrick FitzGerald]

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