Recent changes to bugs

#16 mod_auth_mysql doesn't work with Apache 2.4

2014-06-25T01:03:45.099000Z

Why not add a comment to the main description page of this project indicating that it's no longer maintained? Even better - with links to current modules that offer similar functionality?

It would save people a lot of time, and maybe also discourage current Linux distributions (e.g. Ubuntu) from making this package installable from distros that use Apache 2.4 by default.

#16 mod_auth_mysql doesn't work with Apache 2.4

2014-05-19T19:24:31.924000Z

You didn't say what your entries are, so there is no way to help you. However, you should know that mod_auth_mysql has been replaced by the more generic Apache module mod_auth_db.

mod_auth_mysql doesn't work with Apache 2.4

2014-05-19T18:46:51.951000Z

If credentials is right I receive 401 error and "[:error] [pid ####] No requires line available" in error.log. Else - just 401.

Authentication issue with clause 'OR' in conditions

2008-09-02T13:19:42Z

Hi,

I can had authenticate with this mod without actual positive response from MySQL.
This Apache server authentication is used for SVN-WEB/DAV purposes.

Apache version :
Server version: Apache/2.2.6 (FreeBSD)
Server built: Aug 27 2008 18:30:57

MySQL client :
mysql Ver 14.12 Distrib 5.0.45, for portbld-freebsd7.0 (i386) using 5.2

Mod_Auth_MySQL :
3.0.0

Configuration file :

AuthMySQLHost ******.cyanide-studio.com
AuthMySQLUser svn
AuthMySQLPassword ********
AuthMySQLNameField username
AuthMySQLPasswordField password
AuthMySQLPwEncryption md5

AuthMySQLDB cyanide
AuthMySQLUserTable svn
AuthMySQLUserCondition "code='super' OR code='loki'"

With this AuthMySQLUserCondition parameter it authenticate anyone.
I modified the AuthMySQLUserCondition in : "(code='super' OR code='loki')" to make it working.

I'm not sure, but with the few tests I ran it seems that if there's one or more result from the SQL request, you're authenticated. and without the () there's always more than one result (the "super" group users).
And anyone within or not the super group can login.
It seems that the actual mod request is a SELECT * request, which causes the problem.

You can contact me at : admin AT cyanide-studio DOT com

Best regards,
Bastien Semene

Symbol not found: ap_pstrcat

2008-07-28T18:52:21Z

Problem:
httpd: Syntax error on line 117 of /private/etc/apache2/httpd.conf: Cannot load /usr/libexec/apache2/mod_auth_mysql.so into server: dlopen(/usr/libexec/apache2/mod_auth_mysql.so, 10): Symbol not found: _ap_pstrcat\n Referenced from: /usr/libexec/apache2/mod_auth_mysql.so\n Expected in: dynamic lookup\n

Solution:
Replace the line that says "#define STRCAT ap_pstrcat" with "#define STRCAT apr_pstrcat"

Mistake on CONFIGURE page

2008-03-12T15:00:41Z

There's a mistake on the CONFIGURE page on http://modauthmysql.sourceforge.net/CONFIGURE

In "EXAMPLE of Basic Authentication" you have:

CREATE TABLE user_info (
user_name CHAR(30) NOT NULL,
user_passwd CHAR(20) NOT NULL,
user_group CHAR(10),
[ any other fields if needed ]
PRIMARY KEY (user)
)

While I think it should be:

CREATE TABLE user_info (
user_name CHAR(30) NOT NULL,
user_passwd CHAR(20) NOT NULL,
user_group CHAR(10),
[ any other fields if needed ]
PRIMARY KEY (user_name)
)

doesn't compile with apache 2.2

2007-02-12T15:40:21Z

I have those error messages

bash-3.1$ /user/ndebeiss/home/Desktop/apache/apache-2.2.4/bin/apxs -c -lmysqlclient -I/user/ndebeiss/home/Desktop/installs/apache/mysql/include -lm -lz mod_auth_mysql.c
/user/ndebeiss/home/Desktop/apache/apache-2.2.4/build/libtool --silent --mode=compile gcc -prefer-pic -DLINUX=2 -D_REENTRANT -D_GNU_SOURCE -D_LARGEFILE64_SOURCE -g -O2 -pthread -I/user/ndebeiss/home/Desktop/apache/apache-2.2.4/include -I/user/ndebeiss/home/Desktop/apache/apache-2.2.4/include -I/user/ndebeiss/home/Desktop/apache/apache-2.2.4/include -I/user/ndebeiss/home/Desktop/installs/apache/mysql/include -c -o mod_auth_mysql.lo mod_auth_mysql.c && touch mod_auth_mysql.slo
mod_auth_mysql.c:591: error: expected expression before 'mysql_auth_config_rec'
mod_auth_mysql.c:591: error: initializer element is not constant
mod_auth_mysql.c:591: error: (near initialization for 'mysql_auth_cmds[0].cmd_data')
mod_auth_mysql.c:595: error: expected expression before 'mysql_auth_config_rec'
mod_auth_mysql.c:595: error: initializer element is not constant
mod_auth_mysql.c:595: error: (near initialization for 'mysql_auth_cmds[1].cmd_data')
mod_auth_mysql.c:599: error: expected expression before 'mysql_auth_config_rec'
mod_auth_mysql.c:599: error: initializer element is not constant
mod_auth_mysql.c:599: error: (nea

APR_OFFSETOF should be used instead of APR_XtOffsetOf

2007-02-06T17:26:00Z

http://mail-archives.apache.org/mod_mbox/apr-dev/200205.mbox/%3C20020517130442.B14245@clove.org%3E

On debian etch, this won't compile without this change.

Chad Skeeters

phpmyadmin error

2006-12-12T22:46:21Z

mod_auth_mysql-3.0.0
phpMyAdmin 2.6.2-Debian-3sarge3 with http_auth
MySQL 4.0.24_Debian-10sarge2
Apache/1.3.33 (Debian GNU/Linux)

i use this 4 program on a debian server and when im activate the mod_auth_mysql plugin in the phpmyadmin page database content page is empty.

mod_auth_mysql + apache 2.2

2006-11-19T11:42:16Z

There is a problem with mod_auth_mysql with apache 2.2

My .htacces file looks like:
<IfModule mod_auth_mysql.c>
AuthName "Login"
AuthType Basic
require valid-user
AuthMySQLUser login
AuthMySQLPassword password
AuthMySQLDB db
AuthMySQLUserTable admin
AuthMySQLNameField admin_login
AuthMySQLPasswordField admin_password
AuthMySQLNoPasswd Off
AuthMySQLAuthoritative On
#AuthMySQLKeepAlive off
AuthMySQLPwEncryption MD5
AuthMySQLEnable On
AuthMySQLUserTable "admin"
AuthMySQLUserCondition "(admin.admin_type = 'admin' or admin.admin_type = 'admin2')"
</IfModule>

and when i try to log in i have error in apache log:

[error] Internal error: pcfg_openfile() called with NULL filename

In google You can find informations about this error. You can repair this with directive:

AuthUserFile /dev/null

but when i add this i can't log in:

[error] [client ...] user admin not found: /area/

mod_auth_mysql don't even try to connect to my mysql server.