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