Hi list,
I've got some troubles setting up authentication via DBD with a MySQL
database and passwords crypted with MD5.
My setup (Gentoo Linux):
Apache 2.2.8
apr 1.2.11
apr-util 1.2.10
MySQL 5.0.54
My configuration:
DBDriver mysql
DBDParams "host=192.168.0.x dbname=auth user=auth pass=xxxx"
DBDPersist On
DBDMin 1
DBDKeep 2
DBDMax 10
DBDExptime 60
<Location />
AuthName "secure"
AuthType basic
AuthBasicProvider dbd
Require valid-user
AuthDBDUserPWQuery "select password from user where login = %s"
</Location>
When I want to connect to the secured site it won't work. The log shows:
[error] [client xx.xx.xx.x] user myuser: authentication failure for "/":
Password Mismatch
If I choose a non-existent user I'll get:
[error] [client xx.xx.xx.xx] user notmyuser not found: /
So the MySQL connection works, but something with the MD5 password is
not ok. Any ideas what could be the problem?
-Matthias
---------------------------------------------------------------------
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: [EMAIL PROTECTED]
" from the digest: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
