Re: using mod_log_sql segmentation fault

On Sep 28, 2009, at 18:50 , ax wrote:

>
> Iam running tests on using mod_log_sql in production
>
> Having in the apache2.conf
>
> ===========
> LogSQLLoginInfo mysql://apache:apacheapache@localhost/apache
> LogSQLCreateTables on
> #LogSQLTransferLogTable test
> LogSQLTransferLogFormat AabcfHhIlMmPpRrSsTtUuvio
> ===========
>

Can you also paste your LoadModule lines for mod_log_sql?

> I have php installed (actually running latest stable Debian) using
> latest stable PHP from apt.

Another possibility is you are not loading the "second" mod_log_sql  
modules (ie.. mod_log_sql_mysql.so)

Failure to load that module will result in segfaults (it's fixed in  
the SVN repository I just need to make a release)

So Make sure you have a
LoadModule log_sql_mysql_module modules/mod_log_sql_mysql.so
in somewhere in your apache config.


If it IS the php-vs-mod_log_sql mysql linkage you can check by using  
"ldd" to see what libraries each is linked to.

(find where the mysql.so file is for the php-mysql extension)
ldd mysql.so
or
ldd mysqli.so

(probably both)

and do

ldd mod_log_sql_mysql.so


They *SHOULD* reference to the same mysql library.  If not, then one  
or the other needs to be re-compiled so they use the same libraries.

_______________________________________________
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