Hi,
My problem has nothing to do with mysql, i think, but i guess
people using mod_auth_mysql module are most likely hanging out
on this list.
I get no auth response from apache when accessing "protected"
areas on the server. To me it seems like the auth module are
not active at any point.
Im running:
Slackware 3.4 2.0.33 on i486
MySQL 3.22.22
Apache 1.3.6
PHP 3.0.9
mod_auth_mysql 2.20
All but mod_auth_mysql works perfectly.
I have a .htaccess file in the directory i want protected like this
--(.htaccess)------------------------------
AuthName "Matrix-Users Administrative Area"
AuthType Basic
order deny,allow
allow from all
require group staff
Auth_MYSQL on
Auth_MySQL_DB matrix
Auth_MySQL_Password_Table user
Auth_MySQL_Group_Table groups
Auth_MySQL_Username_Field login
Auth_MySQL_Password_Field passwd
Auth_MySQL_Group_Field usergroup
Auth_MySQL_Empty_Passwords off
Auth_MySQL_Encryption_Types MySQL
-------------------------------------------
Accessing the page i get in Apache access.log:
"GET /matrix-user/admin/ HTTP/1.0" 304 -
Nothing in Apache error.log
In mysql.log i have:
/usr/local/libexec/mysqld, Version: 3.22.22-log, started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
<connected to mysql from shell client>
990620 23:31:38 1 Connect root@localhost on matrix
1 Query show databases
1 Query show tables
1 Field List groups
1 Field List user
990620 23:31:54 1 Query select * from user
990620 23:32:03 1 Quit
<connect from .php page>
990620 23:56:46 2 Connect root@localhost on
2 Init DB matrix
990620 23:56:47 2 Quit
No sign of mod_auth_mysql who should have been logged in the time
between mysql-client and apache-php.
httpd -l show mod_auth_mysql.c so it should be in there.
Does anybody have some hint on what i did wrong here.
Maybe im missing something in httpd.conf ??????
BTW, the tables mentioned in .htaccess looks like this:
Database: matrix Table: user Rows: 1
+---------+---------------+------+-----+------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+---------------+------+-----+------------+----------------+
| userid | int(11) | | PRI | 0 | auto_increment |
| fname | char(30) | | MUL | | |
| lname | char(30) | | | | |
| email | char(30) | | | | |
| phone | char(15) | | | | |
| company | char(30) | | | | |
| addr1 | char(30) | | | | |
| addr2 | char(30) | YES | | | |
| postnr | char(6) | | | | |
| city | char(30) | | | | |
| login | char(10) | YES | | | |
| passwd | char(30) | YES | | | |
| changed | timestamp(14) | YES | | | |
| created | date | | | 0000-00-00 | |
+---------+---------------+------+-----+------------+----------------+
Database: matrix Table: groups Rows: 1
+-----------+---------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+---------------+------+-----+---------------------+-------+
| login | char(20) | | PRI | | |
| usergroup | char(20) | | PRI | | |
| logincnt | int(11) | | | 0 | |
| loginlast | datetime | | | 0000-00-00 00:00:00 | |
| changed | timestamp(14) | YES | | | |
+-----------+---------------+------+-----+---------------------+-------+
--
Later
Mogens Melander mailto:mogens@stripped
http://www.fumlersoft.dk http://www.trader.dk
http://www.birkerod.dk http://tux.trader.dk
