<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Edward,<br>
<br>
I currently have the module removed so as not to break my CGI, however
still in my apache2 error.log is the following excerpt from when I
enabled the module but had the conf directives commented out:<br>
<br>
<tt>PHP Warning: PHP Startup: Unable to load dynamic library
'/usr/lib/php5/20060613+lfs/imagick.so' - libWand.so.9: cannot open
shared object file: No such file or directory in Unknown on line 0<br>
[Tue Jul 01 10:23:50 2008] [error] mod_log_sql: insufficient
configuration info to establish database link<br>
[Tue Jul 01 10:23:50 2008] [error] mod_log_sql: child spawned but
unable to open database link<br>
[Tue Jul 01 10:23:50 2008] [error] mod_log_sql: insufficient
configuration info to establish database link<br>
[Tue Jul 01 10:23:50 2008] [error] mod_log_sql: child spawned but
unable to open database link<br>
[Tue Jul 01 10:23:50 2008] [error] mod_log_sql: insufficient
configuration info to establish database link<br>
[Tue Jul 01 10:23:50 2008] [error] mod_log_sql: child spawned but
unable to open database link<br>
[Tue Jul 01 10:23:50 2008] [error] mod_log_sql: insufficient
configuration info to establish database link<br>
[Tue Jul 01 10:23:50 2008] [error] mod_log_sql: child spawned but
unable to open database link<br>
[Tue Jul 01 10:23:50 2008] [error] mod_log_sql: insufficient
configuration info to establish database link<br>
[Tue Jul 01 10:23:50 2008] [error] mod_log_sql: child spawned but
unable to open database link<br>
[Tue Jul 01 10:23:50 2008] [notice] Apache/2.2.8 (Ubuntu)
PHP/5.2.4-2ubuntu5.1 with Suhosin-Patch mod_perl/2.0.3 Perl/v5.8.8
configured -- resuming normal operations<br>
[Tue Jul 01 10:23:55 2008] [error] [client 127.0.0.1] Premature end of
script headers: test.pl<br>
[Tue Jul 01 10:26:34 2008] [notice] caught SIGWINCH, shutting down
gracefully</tt><br>
<br>
I have attached the entire file... The changes occurring during this
log include my adding directives to the conf to configure mod_log_sql.
One problem encountered was that I had to create a table "scoreboard"
which was undocumented but table parameters were mentioned in a forum
somewhere. The configuration process was difficult (I might suggest
that a working minimal snippet for the conf file be shown on the site
rather than the line by line description of every possible directive...)<br>
<br>
The following is in my apache2.conf (currently commented out, passwords
and names removed):<br>
<br>
<tt>### MySQL Logger ##########################<br>
<br>
#LogSQLLoginInfo localhost [Insert MySQL Username Here] [Insert MySQL
Password Here]<br>
#LogSQLDatabase [Insert Database Name Here]<br>
#LogSQLSocketFile /var/run/mysqld/mysqld.sock<br>
#LogSQLTCPPort 3306<br>
#LogSQLCreateTables On<br>
#LogSQLMassVirtualHosting On<br>
#LogSQLMachineID [Insert Machine Name Here]<br>
#LogSQLPreserveFile /tmp/sql-preserve<br>
<br>
### End MySQL Logger ######################</tt><br>
<br>
Versions:<br>
<br>
Ubuntu Hardy, 32 bit desktop version <br>
<br>
Via Synaptic:<br>
<br>
<tt>apache2 2.2.8-1ubuntu0.3<br>
apache2.2-common 2.2.8-1ubuntu0.3<br>
apache2-mpm-prefork 2.2.8-1ubuntu0.3<br>
libapache2-mod-perl2 2.0.3-2ubuntu2<br>
libapache2-mod-php5 5.2.4-2ubuntu5.1</tt><br>
<tt>cgilib 0.5-5</tt><br>
<br>
When installed:<br>
<br>
<tt>libapache2-mod-log-sql 1.100-11.1</tt><br>
<br>
In short, both Perl and Bash CGI files generate "end of script headers"
when there is nothing wrong with the files. Removing mod_log_sql's
module restores the scripts without having to edit them in any way.
According to appache.org "any misbehaving third party module can cause
this problem". It was driving me nuts when I thought there was a
syntax error in any of the CGI files as I could find nothing wrong.<br>
<br>
I am also attaching some of the CGI files mentioned in the log.<br>
<br>
Thank you for your assistance,<br>
<br>
Mike Southworth<br>
<br>
<br>
<br>
Edward Rudd wrote:
<blockquote
cite="mid:5964765D-DE56-4D04-ABCC-0CA0A3A563DA@outoforder.cc"
type="cite">
<pre wrap="">That is very strange.
I can't think of any reason it would do that.
Can you attach part the part of the apache error_log when this occurs??
Also can you set the apache "LogLevel" command to "debug" when you do
this.
On Jul 1, 2008, at 5:38 PM, Mike Southworth wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hello,
I would like to bring the following issue I posted to the Ubuntu
forums
to the attention of the mod_log_sql mailing list:
<a class="moz-txt-link-freetext" href="http://ubuntuforums.org/showthread.php?t=846184">http://ubuntuforums.org/showthread.php?t=846184</a>
A short description: Every time I enable mod_log_sql it breaks CGI
functionality in Apache2.
Hopefully someone might recognize the problem and be able to assist me
in getting the module working without taking out CGI in Ubuntu Hardy.
I am available with whatever configuration information is required
to duplicate and troubleshoot this problem.
Thank you,
Mike Southworth
_______________________________________________
Download the latest version at <a class="moz-txt-link-freetext" href="http://www.outoforder.cc/projects/">http://www.outoforder.cc/projects/</a>
apache/mod_log_sql/
To unsubscribe send an e-mail to
<a class="moz-txt-link-abbreviated" href="mailto:mod_log_sql-unsubscribe@lists.outoforder.cc">mod_log_sql-unsubscribe@lists.outoforder.cc</a>
</pre>
</blockquote>
<pre wrap=""><!---->
_______________________________________________
Download the latest version at <a class="moz-txt-link-freetext" href="http://www.outoforder.cc/projects/apache/mod_log_sql/">http://www.outoforder.cc/projects/apache/mod_log_sql/</a>
To unsubscribe send an e-mail to
<a class="moz-txt-link-abbreviated" href="mailto:mod_log_sql-unsubscribe@lists.outoforder.cc">mod_log_sql-unsubscribe@lists.outoforder.cc</a>
</pre>
</blockquote>
<br>
</body>
</html>