[Mod_log_sql] mod_log_sql 1.97 with Apache 2 with MySQL on FreeBSD...

[Edward Rudd]

On Sun, 2004-07-11 at 03:26, Paul Chvostek wrote:
> Hiya.
> 
> I've been using mod_log_sql v1.18 with Apache 1.3 for quite some time
> with great success.  I thought it might be fun to play around with
> Apache 2, but I've hit a (perhaps small) roadblock.

> The problem is, Apache is reporting segfaults to its error_log:
> 
> [Sun Jul 11 03:59:30 2004] [notice] child pid 3866 exit signal Segmentation fault (11)
> [Sun Jul 11 03:59:35 2004] [notice] child pid 3867 exit signal Segmentation fault (11)
> 
Can you get me a backtrace??
download mod_backtrace from
http://www.apache.org/~trawick/exception_hook.html

Hopefully the freebsd build of apache 2.0.50 has exception hooks
enabled.. 
just use 
apxs -cai mod_backtrace.c
then add 
EnableExceptionHook On
Backtracelog logs/backtrace.log

into your configuration file.
Then mail the contents of the backtrace.log after a crash.

You can also use GDB and just
gdb /path/to/httpd pidid

where the pidid is a child process of apache (use ps ax to list
processes )

and then do a bt when apache segfaults

Also try using the latest mod_log_sql and see if it works.. but I've had
reports of that version doing the same on some linux systems.

> FAQ question 2.1 seemed plausable enough until I noticed that PHP5 seems
> to use the real MySQL libraries rather than rolling its own.

> Thanks.
-- 
Edward Rudd <urkle at outoforder.cc>
Website http://www.outoforder.cc/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://lists.outoforder.cc/pipermail/mod_log_sql/attachments/20040711/4228611c/attachment.bin