mod_log_sql not logging

I'm pulling my hair out over this one. I've got mod_log_sql installed, but it's not working. I've checked everything I'd think there was, and still it doesn't work.

It was giving me this error in error_log:
Code: 
[Thu Mar 02 20:28:51 2006] [error] mod_log_sql: child spawned but unable to open database link
I went in and looked at privileges, made sure it matched what was in my 10_mod_log_sql.conf settings. I gave the user any privilege it could conceivably need, and reloaded the privileges table. Now nothing shows up in error_log on visits, but nothing is getting added to the access_log table, but hits are ending up in the access_log file.

Each VirtualHost has "LogSQLTransferLogFormat AbHhmRSsTUuv" in it. I have the LogSQLLoginInfo and "LogSQLCreateTables on" lines in httpd.conf too, after all the LoadModules and all.

/etc/conf.d/apache2 does include "-D LOG_SQL" in APACHE2_OPTS.

What am I missing?! mod_log_sql not logging

 

 

 

 

Top