Hello,
libapache-mod-auth-mysql does NOT Work with mysql5:
----------------------------------------------------------------------
[Fri Jun 15 20:21:36 2007] [debug] mod_auth_mysql.c(1483): Handling an
authentication request for section /home/jan/Webs/out/restricted/
[Fri Jun 15 20:21:36 2007] [debug] mod_auth_mysql.c(1524): Starting
basic user auth for [jan] in /home/jan/Webs/out/restricted/, child pid
2804
[Fri Jun 15 20:21:36 2007] [debug] mod_auth_mysql.c(1339): Constructing
password collection query with passfield=[passwd],
table=[mysql_auth_user], userfield=[jan], where_clause=[]
[Fri Jun 15 20:21:36 2007] [debug] mod_auth_mysql.c(1193): sec->dbh in
/home/jan/Webs/out/restricted/ is
[Fri Jun 15 20:21:36 2007] [debug] mod_auth_mysql.c(1200): Ordinary
query
[Fri Jun 15 20:21:36 2007] [debug] mod_auth_mysql.c(1205): No DB
connection open - firing one up
[Fri Jun 15 20:21:36 2007] [debug] mod_auth_mysql.c(1097): Opening DB
connection for /home/jan/Webs/out/restricted/
[Fri Jun 15 20:21:36 2007] [debug] mod_auth_mysql.c(1166): Persistent in
/home/jan/Webs/out/restricted/ is 1
[Fri Jun 15 20:21:36 2007] [debug] mod_auth_mysql.c(1213): Correctly
opened a new DB connection
[Fri Jun 15 20:21:36 2007] [debug] mod_auth_mysql.c(1217): Running
query: [SELECT passwd FROM mysql_auth_user WHERE username='jan']
[Fri Jun 15 20:21:36 2007] [debug] mod_auth_mysql.c(1299): Checking with
Plaintext
[Fri Jun 15 20:21:36 2007] [debug] mod_auth_mysql.c(1299): Checking with
Crypt_DES
[Fri Jun 15 20:21:36 2007] [debug] mod_auth_mysql.c(1299): Checking with
MySQL
[Fri Jun 15 20:21:37 2007] [notice] child pid 2804 exit signal
Segmentation fault (11)
----------------------------------------------------------------------
I use debian etch (apache: 2.2.3-4, libmysql-client: 5.0.32-7etch1) and
have mod_auth_mysql 4.3.9-3 from lenny backported.
I've fixed it with the folliwing patch:
----------------------------------------------------------------------
--- orig/mod_auth_mysql.c 2007-06-20 17:10:34.000000000 +0200
+++ mod_auth_mysql.c 2007-06-20 17:14:22.000000000 +0200
@@ -229,7 +229,7 @@
static int check_mysql_encryption(const char *passwd, char *enc_passwd)
{
- char scrambled_passwd[32];
+ char scrambled_passwd[SCRAMBLED_PASSWORD_CHAR_LENGTH];
make_scrambled_password(scrambled_passwd, passwd);
return (!strcmp(scrambled_passwd, enc_passwd));
----------------------------------------------------------------------
Jan
Attachment:
pgpTB_iul2Rvg.pgp
Description: PGP signature