by Hello all, I've been trying in vain for the last two hours to get
mod_auth_mysql2.20 and apache1.3.12 with php4.0RC1 to work. Maybe
someone can see what I'm doing wrong.
My .htaccess file is as follows:
AuthName testauth
AuthType Basic
require valid-user
Auth_MySQL_DB testauth
Auth_MySQL_Password_Table System_IDMap
Auth_MySQL_Group_Table System_IDMap
Auth_MySQL_Username_Field UserName
Auth_MySQL_Password_Field Password
Auth_MySQL_Group_Field UserGroup
Auth_MySQL_Encryption_Types Plaintext
Auth_MySQL_Encrypted_Passwords Off
Auth_MYSQL On
The table looks like:
mysql> describe System_IDMap;
+-----------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+----------------+
| ID | int(11) | | PRI | 0 | auto_increment |
| UserName | varchar(20) | YES | | NULL | |
| Password | varchar(20) | YES | | NULL | |
| UserGroup | varchar(20) | YES | | member | |
+-----------+-------------+------+-----+---------+----------------+
Just one excert from the error log is:
[Tue May 16 23:48:19 2000] [error] [client 192.168.1.2] user miggy:
authentication failure for "/css/style.css": password mismatch
And in the httpd.conf file I have the AllowOverRide ALL statement.
Now I'm absolutely sure that I typed in the password correctly... but
it never seems to work.
This is running on a Debian 2.0.38 system. Oh and yes the httpd daemon
(as www-data) can connect to the database as I've done it many times
before using PHP queries.
Any ideas?
Thanks!
Sent via Deja.com http://www.deja.com/
Before you buy.