headers
ax | 29 Sep 2009 00:50
Picon

using mod_log_sql segmentation fault


Iam running tests on using mod_log_sql in production

Having in the apache2.conf

===========
LogSQLLoginInfo mysql://apache:apacheapache <at> localhost/apache
LogSQLCreateTables on
#LogSQLTransferLogTable test
LogSQLTransferLogFormat AabcfHhIlMmPpRrSsTtUuvio
===========

and after trying to access some page on the Testserver the page  
actually never loads, and in the error.log I get

===== error.log
[Tue Sep 29 02:32:46 2009] [info] server seems busy, (you may need to  
increase StartServers, or Min/MaxSpareServers), spawning 32 children,  
there are 0 idle, and 0 total children
[Tue Sep 29 02:32:46 2009] [notice] child pid 19004 exit signal  
Segmentation fault (11)
[Tue Sep 29 02:32:46 2009] [notice] child pid 19005 exit signal  
Segmentation fault (11)
=====
Commenting out the log_sql directives its working again.

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

Its stated in
(Continue reading)

Permalink | Reply | 2 comments |
headers
Rene Kanzler | 29 Sep 2009 10:49
Picon
Picon
Favicon

Re: using mod_log_sql segmentation fault

Hello

On Tue, 29 Sep 2009 00:50:53 +0200, ax <list@...> wrote:

> Now I want to know if there is any other possibility to get this  
> working.
> Will it be possible just to give the directive somewhere in php.ini,   
> or any other "trick" to make it work?
> (I dont want to recompile PHP since I want it to be managed by apt)

It is not possible without recompile mod_log_sql or php as far as I know.

> Or maybe any idea if it might not even be this problem described
> 
> 
> or any idea on this problem?

The segmentation fault is caused by php-mysql and mod_log_sql not compiled
with the same libmysqlclient version.
At first you can check with ldd with which libmysqlclient version
mod_log_sql_mysql.so and mysql.so are compiled.
Try to install php and mod_log_sql from the same apt repository.

Bye
Rene 
_______________________________________________
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@...
(Continue reading)

Permalink | Reply | 0 comments |
headers
Edward Rudd | 1 Oct 2009 02:41
Favicon
Gravatar

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 <at> 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.
(Continue reading)

Permalink | Reply | 0 comments |

Gmane