Hello,
just to let you know that we have the same problem on a debian
installation with:
Apache 1.3.33-3
libapache-mod-auth-mysql 4.3.9-2
following mysql table setup:
AuthType Basic
Auth_MySQL_Password_Table mysql_passwd
Auth_MySQL_Group_Table mysql_groups
Auth_MySQL_Username_Field username
Auth_MySQL_Password_Field passwd
Auth_MySQL_Group_Field groups
Auth_MySQL_Encrypted_Passwords On
Auth_MySQL_Encryption_Types MySQL
Auth_MySQL_Non_Persistent On
Auth_MYSQL On
Auth_MySQL_Empty_Passwords Off
# Put here specific rights:
require group test
CREATE TABLE `mysql_groups` (
`username` varchar(25) NOT NULL default '',
`group` varchar(25) NOT NULL default '',
KEY `username` (`username`)
) TYPE=MyISAM COMMENT='.htaccess group information';
-- Table structure for table `mysql_passwd`
CREATE TABLE `mysql_passwd` (
`username` varchar(25) NOT NULL default '',
`passwd` varchar(25) default NULL,
PRIMARY KEY (`username`)
) TYPE=MyISAM;
When we create a user 'testing' with one entry in the group table
group name 'test' but then the server quits with 'Internal Server
Error' and the following log entries:
[Mon Aug 22 14:48:01 2005] [crit] [client xxx.xxx.xxx.xxx]
configuration error: couldn't check access. No groups file?: /blabl/
blabl/bla.php
User authentication works ok, only groups do not work, neither if
their are in the same table as the passwords nor if there are two
different tables.
The SQL query:
SELECT COUNT( * )
FROM mysql_groups
WHERE username = 'testing'
AND FIND_IN_SET( 'test', groups )
Returns a number > 0...
Any ideas what could be wrong ?
Thanks
Matthias
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
