Slackware ver 12.2
Mysqld Ver 5.0.67
Apache/2.2.16
mod_auth_mysql-3.0.0 patched with apache22.diff

Symptom: when trying to use mod_auth_mysql to validate access to a directory via mysql DB, get prompted for user name and password but never find user and password combination despite using good values for login to mysql (same values in apache directory statements work as a cli login to mysql) and confirmed as valid in the user_info table (see values supplied to prompt in select * from user_info). Mysql general log does not show any attempt to access, strace does not show any attempt to setup local connection to mysql port. In a working version in Fedora I setup to test do see access described in the general log and strace shows a setup to mysql port. No useful messages in slackware apache access_log, error_log, mysql error logs, system logs.

Have tried many combinations of mysqld variables, apache variables, mod_auth_mysql versions and variables, to no avail. Reinstalled apache, mysqld, etc. Anyone have this working with slackware 12.2? If so, can you give me a simple example (for a simple mind)??

Hi,

IIRC for apache 2.2 you need:
If that doesn't work post the whole .htaccess, so we can help you.

Regards

*** This evening's fun

Upgraded spare server to slackware 13.1

Incuded are:
mysql-5.1.46-i486-2
httpd-2.2.16-i486-1_slack13.1

Still not working


**** Loading mod_auth

From CLI

wget http://sourceforgnet/projects/modaut....tar.gzownload

wget http://www.bleb.o/software/mod_auth_...he-2.2.3.patch

patch -p0 mod_auth_myl.c mod_auth_mysql-3.0.0-apache-2.2.3.patch

apxs -c -L/usr/lib/mys -I/usr/include/mysql -lmysqlclient -lm -lz mod_auth_mysql.c

apxs -i mod_auth_mysql.la

-- Edit into httpd.conf
LoadModule mysql_auth_module lib/httpd/modules/mod_auth_mysql.so


***** SQL

CREATE DATABASE auth;
USE auth;
CREATE TABLE users (
user_name CHAR(30) NOT NULL,
user_passwd CHAR(20) NOT NULL,
PRIMARY KEY (user_name)
);
GRANT SELECT
ON auth.users
TO authuser@localhost
IDENTIFIED BY 'PaSsW0Rd';

INSERT INTO users VALUES ('testuser', 'testpass');



**** HTTP


Alias /testsql "/srv/httpd/htdocs/testsql"
<Directory /srv/httpd/htdocs/testsql>
AuthName "MySQL authenticated zone"
AuthType Basic
AuthMySQLAuthoritative Off
AuthUserFile /dev/null
AuthMYSQLEnable on
AuthMySQLUser authuser
AuthMySQLPassword PaSsW0Rd
AuthMySQLDB auth
AuthMySQLUserTable users
AuthMySQLNameField user_name
AuthMySQLPasswordField user_passwd
AuthMySQLPwEncryption none
require valid-user
</Directory>



--- Message in httpd/error_log when trying to enter testuser, testpass x 3

[Wed Sep 01 00:21:29 2010] [error] [client 192.168.1.102] user testuser not found: /testsql
[Wed Sep 01 00:21:34 2010] [error] [client 192.168.1.102] user testuser not found: /testsql
[Wed Sep 01 00:21:39 2010] [error] [client 192.168.1.102] user testuser not found: /testsql

Hi,

Note it's:
not
I had the same problem (i.e. apache was not even connecting to mysql) and it was solved by adding that "AuthBasicAuthoritative Off" directive

Regards

Great catch, thank you thank you thank you!!!! Now works after making that one change.