paredes wrote:
It sounds like you are getting *something* returned by your authentication query, just not the exact password hash.Greetings! I've been running OS-X 10.3.9, with apache2.2.3 [ldap w/failover to mod_authn_dbd], mysql5.0.3x & php5.1 all built from source. I've just upgraded our test server to OSX 10.5, apache2.2.6 & mysql5.0.51. The problem is that while the DBDDriver connects it refuses to authenticate valid users. The apache logs which are set to debug return: "user jones: authentication failure for "/ProtectedArea": Password Mismatch" When I deliberately provide an unknown user the logs return: "user mary not found: /ProtectedArea"
Possibly the problem is trailing spaces. The behavior of MySQL CHAR and VARCHAR fields for trailing spaces has changed over time per http://dev.mysql.com/doc/refman/5.0/en/char.html
Try a SQL statement like: "SELECT TRIM(password_field) FROM user_table WHERE user_field = %s" instead of: "SELECT password_field FROM user_table WHERE user_field = %s" Additional clues might be found by enabling MySQL logging per: http://dev.mysql.com/doc/refman/5.0/en/query-log.html and checking what your SQL statement actually looks like to MySQL. -tom- --------------------------------------------------------------------- The official User-To-User support forum of the Apache HTTP Server Project. See <URL:http://httpd.apache.org/userslist.html> for more info. To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx " from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx
|