Hallo!
Ich versuch grad was mit pam_mysql...
So funktioniert auch schon alles:
CODE #%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
Aber so gehts nicht:
CODE #%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"
und dann kommt:
QUOTE 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)
Der Sinn dahinter ist, dass überprüft werden soll, dass der Wert im Feld "locked" [enum('yes', 'no'] "no" ist.... Was mach ich falsch?
Wieso wird "no" in der Abfrag zu \"no\"? Ist das korrekt?
Ich versuch grad was mit pam_mysql...
CODE #%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
Aber so gehts nicht:
CODE #%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"
und dann kommt:
QUOTE 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)
Der Sinn dahinter ist, dass überprüft werden soll, dass der Wert im Feld "locked" [enum('yes', 'no'] "no" ist.... Was mach ich falsch?
Wieso wird "no" in der Abfrag zu \"no\"? Ist das korrekt?