[Mod_log_sql] using mod_log_sql segmentation fault

ax list at ax21.de
Mon Sep 28 18:50:53 EDT 2009


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
===========

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
http://www.outoforder.cc/projects/apache/mod_log_sql/docs-2.0/?chapter=/4/#id_4_1_2_1
subsection 2.1 That one would have to recompile PHP using  --with- 
mysql=/your/path

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)

Or maybe any idea if it might not even be this problem described


or any idea on this problem?











More information about the Mod_log_sql mailing list