List:General Discussion« Previous MessageNext Message »
From:Mogens Melander Date:June 21 1999 10:47am
Subject:mod_auth_mysql
View as plain text  
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
Thread
mod_auth_mysqlMogens Melander21 Jun
  • Re: mod_auth_mysqlMassimo Ferrario21 Jun
  • Re: mod_auth_mysqlBenjamin Pflugmann23 Jun