On Mon, Mar 14, 2005 at 12:27:10AM -0800, C.Y.M wrote:
Thanks for the debug patch. I have applied it and reproduced the error, but I do not get any new debug info in the log. I am running apache2 in debug mode.
That's... odd. Once "Running query" gets printed, and "Query maybe-failed isn't printed, you're out the bottom of safe_mysql_query, and then your options for the next log message are one of "Group query failed", "Store result failed", or "mysql_check_group complete". I don't suppose you might not have installed the compiled module correctly? Perhaps change AUTH_MYSQL_VERSION at the top to something unique, so you can check that version string appears in the error log when you restart apache.
I'm sorry.. I must have messed up the patch the first time. Now I am seeing the additional debug. The result gives me a "0" which seems correct since the user is not in the "adm" group.
[Mon Mar 14 03:19:16 2005] [debug] mod_auth_mysql.c(1483): Handling an authentication request for section /var/www/
[Mon Mar 14 03:19:16 2005] [debug] mod_auth_mysql.c(1524): Starting basic user auth for [test_user] in /var/www/, child pid 16898
[Mon Mar 14 03:19:16 2005] [debug] mod_auth_mysql.c(1338): Constructing password collection query with passfield=[passwd], table=[user_info], userfield=[test_user], where_clause=[]
[Mon Mar 14 03:19:16 2005] [debug] mod_auth_mysql.c(1192): sec->dbh in /var/www/ is
[Mon Mar 14 03:19:16 2005] [debug] mod_auth_mysql.c(1199): Ordinary query
[Mon Mar 14 03:19:16 2005] [debug] mod_auth_mysql.c(1204): No DB connection open - firing one up
[Mon Mar 14 03:19:16 2005] [debug] mod_auth_mysql.c(1096): Opening DB connection for /var/www/
[Mon Mar 14 03:19:16 2005] [debug] mod_auth_mysql.c(1165): Persistent in /var/www/ is 1
[Mon Mar 14 03:19:16 2005] [debug] mod_auth_mysql.c(1212): Correctly opened a new DB connection
[Mon Mar 14 03:19:16 2005] [debug] mod_auth_mysql.c(1216): Running query: [SELECT passwd FROM user_info WHERE username='test_user']
[Mon Mar 14 03:19:16 2005] [debug] mod_auth_mysql.c(1298): Checking with SHA1Sum
[Mon Mar 14 03:19:16 2005] [debug] mod_auth_mysql.c(1300): Auth succeeded
[Mon Mar 14 03:19:16 2005] [debug] mod_auth_mysql.c(1442): Making group query with auth_table=[user_group], auth_user_field=[username], esc_user=[test_user], esc_group=[adm], auth_group_field=[groups], where_clause=[]
[Mon Mar 14 03:19:16 2005] [debug] mod_auth_mysql.c(1449): Group query created; [SELECT count(*) FROM user_group WHERE username='test_user' and FIND_IN_SET('adm',groups)]
[Mon Mar 14 03:19:16 2005] [debug] mod_auth_mysql.c(1192): sec->dbh in /var/www/ is
[Mon Mar 14 03:19:16 2005] [debug] mod_auth_mysql.c(1199): Ordinary query
[Mon Mar 14 03:19:16 2005] [debug] mod_auth_mysql.c(1216): Running query: [SELECT count(*) FROM user_group WHERE username='test_user' and FIND_IN_SET('adm',groups)]
[Mon Mar 14 03:19:16 2005] [debug] mod_auth_mysql.c(1466): mysql_check_group complete; result [0]
[Mon Mar 14 03:19:16 2005] [crit] [client 10.1.1.66] configuration error: couldn't check access. No groups file?: /adm/, referer: https://my.website.net/
[Mon Mar 14 03:19:16 2005] [info] Connection to child 4 closed with unclean shutdown(server my.website.net:443, client 10.1.1.66)
-- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
