[Mod_log_sql] using mod_log_sql segmentation fault
Edward Rudd
urkle at outoforder.cc
Wed Sep 30 20:41:25 EDT 2009
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.
More information about the Mod_log_sql
mailing list