su succeeds but is denied

[James Pic]

Hello everybody,

I have no idea why i can't change user with the correct password.
User is in the mysql database.

Any tip please?

Thanks in advance, James.

Jul 18 16:33:11 [su] pam_mysql - INSERT INTO log (message, user, host, remote_host, pid, time) VALUES ('AUTHENTICATION SUCCESS (FIRST_PASS)', 'mmm', '(unknown)', '(unknown)', '7457', NOW())
Jul 18 16:33:11 [su] pam_mysql - pam_mysql_sql_log() returning 0.
Jul 18 16:33:11 [su] pam_mysql - pam_sm_authenticate() returning 0.
Jul 18 16:33:13 [su] pam_authenticate: Authentication failure
Jul 18 16:33:13 [su] pam_mysql - pam_mysql_release_ctx() called.
Jul 18 16:33:13 [su] pam_mysql - pam_mysql_destroy_ctx() called.
Jul 18 16:33:13 [su] pam_mysql - pam_mysql_close_db() called.
Jul 18 16:33:13 [su] FAILED su for mmm by jpic
Jul 18 16:33:13 [su] - pts/9 jpic:mmm
Jul 18 16:33:24 [su] pam_unix(su:auth): authentication failure; logname=jpic uid=1000 euid=0 tty=pts/9 ruser=jpic rhost=  user=mmm
Jul 18 16:33:24 [su] pam_mysql - option debug is set to "1"
Jul 18 16:33:24 [su] pam_mysql - option user is set to "pam"
Jul 18 16:33:24 [su] pam_mysql - option passwd is set to "<HIDDEN>"
Jul 18 16:33:24 [su] pam_mysql - option host is set to "localhost"
Jul 18 16:33:24 [su] pam_mysql - option db is set to "itbm"
Jul 18 16:33:24 [su] pam_mysql - option table is set to "users"
Jul 18 16:33:24 [su] pam_mysql - option usercolumn is set to "name"
Jul 18 16:33:24 [su] pam_mysql - option passwdcolumn is set to "password"
Jul 18 16:33:24 [su] pam_mysql - option crypt is set to "1"
Jul 18 16:33:24 [su] pam_mysql - option md5 is set to "y"
Jul 18 16:33:24 [su] pam_mysql - option sqllog is set to "y"
Jul 18 16:33:24 [su] pam_mysql - option logtable is set to "log"
Jul 18 16:33:24 [su] pam_mysql - option logtimecolumn is set to "time"
Jul 18 16:33:24 [su] pam_mysql - option logpidcolumn is set to "pid"
Jul 18 16:33:24 [su] pam_mysql - option loghostcolumn is set to "host"
Jul 18 16:33:24 [su] pam_mysql - option logrhostcolumn is set to "remote_host"
Jul 18 16:33:24 [su] pam_mysql - option logusercolumn is set to "user"
Jul 18 16:33:24 [su] pam_mysql - option logmsgcolumn is set to "message"
Jul 18 16:33:24 [su] pam_mysql - pam_mysql_close_db() called.
Jul 18 16:33:24 [su] pam_mysql - pam_sm_authenticate() called.
Jul 18 16:33:24 [su] pam_mysql - pam_mysql_open_db() called.
Jul 18 16:33:24 [su] pam_mysql - pam_mysql_open_db() returning 0.
Jul 18 16:33:24 [su] pam_mysql - pam_mysql_check_passwd() called.
Jul 18 16:33:24 [su] pam_mysql - pam_mysql_format_string() called
Jul 18 16:33:24 [su] pam_mysql - pam_mysql_quick_escape() called.
Jul 18 16:33:24 [su] pam_mysql - SELECT password FROM users WHERE name = 'mmm'
Jul 18 16:33:24 [su] pam_mysql - pam_mysql_check_passwd() returning 0.
Jul 18 16:33:24 [su] pam_mysql - pam_mysql_sql_log() called.
Jul 18 16:33:24 [su] pam_mysql - pam_mysql_format_string() called
Jul 18 16:33:24 [su] pam_mysql - pam_mysql_quick_escape() called.
                - Last output repeated 3 times -
Jul 18 16:33:24 [su] pam_mysql - INSERT INTO log (message, user, host, remote_host, pid, time) VALUES ('AUTHENTICATION SUCCESS (FIRST_PASS)', 'mmm', '(unknown)', '(unknown)', '13116', NOW())
Jul 18 16:33:24 [su] pam_mysql - pam_mysql_sql_log() returning 0.
Jul 18 16:33:24 [su] pam_mysql - pam_sm_authenticate() returning 0.
Jul 18 16:33:27 [su] pam_authenticate: Authentication failure
Jul 18 16:33:27 [su] pam_mysql - pam_mysql_release_ctx() called.
Jul 18 16:33:27 [su] pam_mysql - pam_mysql_destroy_ctx() called.
Jul 18 16:33:27 [su] pam_mysql - pam_mysql_close_db() called.
Jul 18 16:33:27 [su] FAILED su for mmm by jpic
Jul 18 16:33:27 [su] - pts/9 jpic:mmm