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