SASLAuthd + PAM + MySQL = Realm problem

[Igor Brezac]

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
>

-- 
Igor
---
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