mod_authn_dbd, MySQL and MD5 passwords

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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: users-unsubscribe@xxxxxxxxxxxxxxxx
  "   from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx
For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx


[Index of Archives]     [Open SSH Users]     [Linux ACPI]     [Linux Kernel]     [Linux Laptop]     [Kernel Newbies]     [Security]     [Netfilter]     [Bugtraq]     [Squid]     [Yosemite News]     [MIPS Linux]     [ARM Linux]     [Linux Security]     [Linux RAID]     [Samba]     [Video 4 Linux]     [Device Mapper]

  Powered by Linux