Re: mod_log_sql not logging; also no debug output

"Perry Sebastian" <[email protected]> Tue, 18 Jan 2005 13:22:03 -0500
Newsgroups gmane.comp.apache.mod-log-sql
Message-ID <[email protected]>
Ha! Of course, the most important check when debugging hardware and software...check to see if the darn thing is turned on.

Thanks!

>>> Edward Rudd <[email protected]> 01/17/05 11:45PM >>>
On Mon, 2005-01-17 at 19:43, Perry Sebastian wrote:
> Sure, here it is:
> 
> LoadModule log_sql_module modules/mod_log_sql.so
> LoadModule log_sql_mysql_module modules/mod_log_sql_mysql.so
> <IfModule mod_ssl.c>
> 	LoadModule log_sql_ssl_module modules/mod_log_sql_ssl.so
> </IfModule>
> 
> LogSQLLoginInfo mysql://loguser:[email protected]/apachelogs 
> #LogSQLLoginInfo localhost loguser
> #LogSQLDatabase apachelogs 
> LogSQLCreateTables on
> # if localhost use
> LogSQLDBParam socketfile /var/lib/mysql/mysql.sock
> LogLevel debug
> ErrorLog /usr/local/apache2/logs/logsql-messages 
> 
> LogSQLRequestIgnore root.exe cmd.exe default.ida
> LogSQLRequestIgnore .gif .jpg
> 
> 
> Perry

Ahh, I found it.
The issue is you don't have the LogSQLTransferLogTable directive set.
this directive IS required to be set unless you use
LogSQLMassVirtualHosting.  I will add to the next release to through an
error when this isn't configured correctly.  

-- 
Edward Rudd <[email protected]>
Website http://www.outoforder.cc/


_______________________________________________
Download the latest version at http://www.outoforder.cc/projects/apache/mod_log_sql/

To unsubscribe send an e-mail to 
mod_log_sql-unsubscribe-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org