[Mod_log_sql] using mod_log_sql segmentation fault

[Edward Rudd]

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.