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

[Shawn Michael]

You may try the attached patch.  I had the same problem on linux apache-2.  The problem has to do with trying to detect 
the character set to write the output in (for backslashifying purposes).


Edward Rudd wrote:
> 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.
>>
>>
>>------------------------------------------------------------------------
>>
>>_______________________________________________
>>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 at lists.outoforder.cc

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Shawn Michael                                   smichael at rightnow.com
RightNow Technologies                           Hosting Administrator
                                  A Better Way to Serve your Customers
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mod_log_sql-1.98.diff
Type: text/x-patch
Size: 741 bytes
Desc: not available
Url : http://lists.outoforder.cc/pipermail/mod_log_sql/attachments/20040712/cba12220/attachment.bin 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3202 bytes
Desc: S/MIME Cryptographic Signature
Url : http://lists.outoforder.cc/pipermail/mod_log_sql/attachments/20040712/cba12220/attachment-0001.bin