pam_mysql

#%PAM-1.0
auth    sufficient      pam_unix.so
auth    sufficient      pam_mysql.so    user=[usr] passwd=[pw] db=usr_web2_1 table=bm60_users usercolumn=email passwdcolumn=passwort crypt=3
account sufficient      pam_unix.so
account sufficient      pam_mysql.so    user=[usr] passwd=[pw] db=usr_web2_1 table=bm60_users usercolumn=email passwdcolumn=passwort crypt=3
password        required        pam_mysql.so    user=[usr] passwd=[pw] db=usr_web2_1 table=bm60_users usercolumn=email passwdcolumn=passwort crypt=3

#%PAM-1.0
auth    sufficient      pam_unix.so
auth    sufficient      pam_mysql.so    user=[usr] passwd=[pw] db=usr_web2_1 table=bm60_users usercolumn=email passwdcolumn=passwort crypt=3 where=locked="no"
account sufficient      pam_unix.so
account sufficient      pam_mysql.so    user=[usr] passwd=[pw] db=usr_web2_1 table=bm60_users usercolumn=email passwdcolumn=passwort crypt=3 where=locked="no"
password        required        pam_mysql.so    user=[usr] passwd=[pw] db=usr_web2_1 table=bm60_users usercolumn=email passwdcolumn=passwort crypt=3 where=locked="no"

Mar 26 12:01:08 empsrv01 saslauthd[4217]: pam_mysql - SELECT passwort FROM bm60_users WHERE email = 'caspar@emailpoint.de' AND (locked=\"no\")
Mar 26 12:01:08 empsrv01 saslauthd[4217]: pam_mysql - MySQL error(You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\"no\")' at line 1)

Zum Vergrößern anklicken....

Mar 26 22:19:36 empsrv01 saslauthd[4214]: pam_mysql - option verbose is set to "1"
Mar 26 22:19:36 empsrv01 saslauthd[4214]: pam_mysql - option where is set to ""locked='on'""
Mar 26 22:19:36 empsrv01 saslauthd[4214]: pam_mysql - pam_mysql_close_db() called.
Mar 26 22:19:36 empsrv01 saslauthd[4214]: pam_mysql - pam_sm_authenticate() called.
Mar 26 22:19:36 empsrv01 saslauthd[4214]: pam_mysql - pam_mysql_open_db() called.
Mar 26 22:19:36 empsrv01 saslauthd[4214]: pam_mysql - pam_mysql_open_db() returning 0.
Mar 26 22:19:36 empsrv01 saslauthd[4214]: pam_mysql - pam_mysql_check_passwd() called.
Mar 26 22:19:36 empsrv01 saslauthd[4214]: pam_mysql - pam_mysql_format_string() called
Mar 26 22:19:36 empsrv01 saslauthd[4214]: pam_mysql - pam_mysql_quick_escape() called.
Mar 26 22:19:36 empsrv01 saslauthd[4214]: pam_mysql - pam_mysql_quick_escape() called.
Mar 26 22:19:36 empsrv01 saslauthd[4214]: pam_mysql - pam_mysql_quick_escape() called.
Mar 26 22:19:36 empsrv01 saslauthd[4214]: pam_mysql - pam_mysql_quick_escape() called.
Mar 26 22:19:36 empsrv01 saslauthd[4214]: pam_mysql - pam_mysql_quick_escape() called.

Zum Vergrößern anklicken....