saslauthd pam_mysql problem for virtualdomains

ram ram at netcore.co.in
Tue Apr 17 03:20:23 EDT 2007


I have a pam_mysql setup with a simple mysql table
and saslauthd is running with the "-r" option on 
If I test with a user on the primary domain it works fine , but for a
user on any other domain there is an auth failure



-----------
cat /etc/pam.d/imap
#%PAM-1.0
auth sufficient pam_mysql.so user=mail passwd=password verbose=1
host=localhost db=mail table=users usercolumn=email
passwdcolumn=password crypt=0

auth sufficient pam_unix_auth.so

auth required pam_mysql.so user=mail passwd=password verbose=1
host=localhost db=mail table=users usercolumn=email
passwdcolumn=password crypt=0

account  sufficient       pam_unix_acct.so
----------------------------







--------------

/usr/sbin/testsaslauthd -u shantanu   -p shantanu  -s imap
0: OK "Success."

 /usr/sbin/testsaslauthd -u shantanu -r xyz.com  -p test  -s imap
0: NO "authentication failed"

----------------

But pam_mysql logs in /var/log/secure report no errors at all 
So what could be the issue 



-------------
pam_mysql - SELECT password FROM users WHERE email = 'shantanu at xyz.com'
Apr 17 07:17:56 indiamart saslauthd[16123]: pam_mysql -
pam_mysql_sql_log() called.
Apr 17 07:17:56 indiamart saslauthd[16123]: pam_mysql -
pam_mysql_sql_log() returning 0.
Apr 17 07:17:56 indiamart saslauthd[16123]: pam_mysql -
pam_mysql_check_passwd() returning 0.
Apr 17 07:17:56 indiamart saslauthd[16123]: pam_mysql -
pam_sm_authenticate() returning 0.
Apr 17 07:17:56 indiamart saslauthd[16123]: pam_mysql -
pam_mysql_release_ctx() called.
Apr 17 07:17:56 indiamart saslauthd[16123]: pam_mysql -
pam_mysql_destroy_ctx() called.
Apr 17 07:17:56 indiamart saslauthd[16123]: pam_mysql -
pam_mysql_close_db() called.
---------------------------





Thanks
Ram





More information about the Info-cyrus mailing list