| Zoner |
08-02-2011 07:37 AM |
pam_mysql_check_passwd() returning 6 - pam_mysql authentication issue
I'm having trouble with my pam_mysql authentication. I've double checked my md5 password but its correct.
What should I be looking at? My /etc/pam.d/system-auth is completely identical to my other server (that works), but this one is somehow reporting that my password is wrong.
I've bolded out the questionable output.
Here's my error log while trying to connect:
Code:
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - option verbose is set to "1"
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - option db is set to "hidden"
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - option table is set to "hidden"
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - option usercolumn is set to "username"
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - option passwdcolumn is set to "password"
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - option crypt is set to "3"
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - option md5 is set to "true"
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - pam_mysql_close_db() called.
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - pam_sm_authenticate() called.
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - pam_mysql_open_db() called.
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - pam_mysql_open_db() returning 0.
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - pam_mysql_check_passwd() called.
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - pam_mysql_format_string() called
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - pam_mysql_quick_escape() called.
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - SELECT password FROM hidden WHERE username = 'hidden'
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - pam_mysql_check_passwd() returning 6.
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - pam_mysql_sql_log() called.
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - pam_mysql_sql_log() returning 0.
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - pam_mysql_converse() called.
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - pam_mysql_open_db() called.
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - pam_mysql_check_passwd() called.
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - pam_mysql_format_string() called
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - pam_mysql_quick_escape() called.
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - SELECT password FROM hidden WHERE username = 'hidden'
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - pam_mysql_check_passwd() returning 6.
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - pam_mysql_sql_log() called.
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - pam_mysql_sql_log() returning 0.
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - pam_sm_authenticate() returning 7.
Aug 2 16:16:23 la2 sshd[8006]: Failed password for invalid user hidden from ****** port ***** ssh2
For comparison, the following is what my working server is outputting for its authentication:
Code:
Aug 2 05:33:42 server1 sshd[18446]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=hidden user=hidden
Aug 2 05:33:42 server1 sshd[18446]: pam_mysql - option verbose is set to "1"
Aug 2 05:33:42 server1 sshd[18446]: pam_mysql - option db is set to "hidden"
Aug 2 05:33:42 server1 sshd[18446]: pam_mysql - option table is set to "hidden"
Aug 2 05:33:42 server1 sshd[18446]: pam_mysql - option usercolumn is set to "username"
Aug 2 05:33:42 server1 sshd[18446]: pam_mysql - option passwdcolumn is set to "password"
Aug 2 05:33:42 server1 sshd[18446]: pam_mysql - option crypt is set to "3"
Aug 2 05:33:42 server1 sshd[18446]: pam_mysql - option md5 is set to "true"
Aug 2 05:33:42 server1 sshd[18446]: pam_mysql - pam_mysql_close_db() called.
Aug 2 05:33:42 server1 sshd[18446]: pam_mysql - pam_sm_authenticate() called.
Aug 2 05:33:42 server1 sshd[18446]: pam_mysql - pam_mysql_open_db() called.
Aug 2 05:33:42 server1 sshd[18446]: pam_mysql - pam_mysql_open_db() returning 0.
Aug 2 05:33:42 server1 sshd[18446]: pam_mysql - pam_mysql_check_passwd() called.
Aug 2 05:33:42 server1 sshd[18446]: pam_mysql - pam_mysql_format_string() called
Aug 2 05:33:42 server1 sshd[18446]: pam_mysql - pam_mysql_quick_escape() called.
Aug 2 05:33:42 server1 sshd[18446]: pam_mysql - SELECT password FROM hidden WHERE username = 'hidden'
Aug 2 05:33:42 server1 sshd[18446]: pam_mysql - pam_mysql_check_passwd() returning 0.
Aug 2 05:33:42 server1 sshd[18446]: pam_mysql - pam_mysql_sql_log() called.
Aug 2 05:33:42 server1 sshd[18446]: pam_mysql - pam_mysql_sql_log() returning 0.
Aug 2 05:33:42 server1 sshd[18446]: pam_mysql - pam_sm_authenticate() returning 0.
Aug 2 05:33:42 server1 sshd[18446]: pam_unix(sshd:account): account hidden has password changed in future
Aug 2 05:33:42 server1 sshd[18446]: Accepted password for hidden from 123.456.789.123 port 12345 ssh2
Aug 2 05:33:42 server1 sshd[18446]: pam_unix(sshd:session): session opened for user hidden by (uid=0)
|
