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
pgpUzt5nUT8YS.pgp
Description: PGP signature
