<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1479" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi everybody,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I hope someone here can help me.</FONT></DIV>
<DIV><FONT face=Arial size=2>I didn't get an answer of <FONT
face="Times New Roman" size=3><FONT face=Arial size=2>Brian Thurlow</FONT> <FONT
face=Arial size=2>who released the windows version of
mod_log_sql.</FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I'm running a webserver on Windows 2000
Professional</FONT></DIV>
<DIV><FONT face=Arial size=2>Apache 2.0.54</FONT></DIV>
<DIV><FONT face=Arial size=2>PHP 5.0.3</FONT></DIV>
<DIV><FONT face=Arial size=2>MySQL 4.1.8</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>
<DIV><FONT face=Arial size=2>I have a problem with mod_log_sql.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I get following entry in my Errorlogfile of the
depending virtualhost where I (want to) use mod_log_sql:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>[Tue May 24 16:52:45 2005] [error] [client
84.151.147.72] File does not exist: G:/WWWRoot/light-gap.net/knauserer/css,
referer: <A
href="http://knauserer.light-gap.net/">http://knauserer.light-gap.net/</A><BR>[Tue
May 24 16:52:58 2005] [error] [client 84.151.147.72] File does not exist:
G:/WWWRoot/light-gap.net/knauserer/modules, referer: <A
href="http://knauserer.light-gap.net/lexikonein.php">http://knauserer.light-gap.net/lexikonein.php</A><BR>>>[Tue
May 24 16:52:58 2005] [error] mysql_query returned (1)<BR>>>[Tue May 24
16:52:58 2005] [notice] db reconnect successful<BR>[Tue May 24 16:52:58 2005]
[error] [client 84.151.147.72] File does not exist:
G:/WWWRoot/light-gap.net/knauserer/css, referer: <A
href="http://knauserer.light-gap.net/lexikonein.php">http://knauserer.light-gap.net/lexikonein.php</A><BR>[Tue
May 24 16:53:10 2005] [error] [client 82.83.247.111] File does not exist:
G:/WWWRoot/gleitgeb.at/members/lulabi<BR>>>[Tue May 24 16:53:43 2005]
[error] mysql_query returned (1)<BR>>>[Tue May 24 16:53:43 2005] [notice]
db reconnect successful<BR>[Tue May 24 16:53:58 2005] [error] [client
82.83.247.111] File does not exist:
G:/WWWRoot/gleitgeb.at/members/lulabi<BR>[Tue May 24 16:54:01 2005] [error]
[client 84.151.147.72] File does not exist:
G:/WWWRoot/light-gap.net/knauserer/modules, referer: <A
href="http://knauserer.light-gap.net/">http://knauserer.light-gap.net/</A><BR>[Tue
May 24 16:54:01 2005] [error] [client 84.151.147.72] File does not exist:
G:/WWWRoot/light-gap.net/knauserer/css, referer: <A
href="http://knauserer.light-gap.net/">http://knauserer.light-gap.net/</A><BR>[Tue
May 24 16:54:04 2005] [error] [client 84.151.147.72] File does not exist:
G:/WWWRoot/light-gap.net/knauserer/modules, referer: <A
href="http://knauserer.light-gap.net/lexikon.php">http://knauserer.light-gap.net/lexikon.php</A><BR>>>[Tue
May 24 16:54:04 2005] [error] mysql_query returned (1)<BR>>>[Tue May 24
16:54:04 2005] [notice] db reconnect successful<BR>[Tue May 24 16:54:06 2005]
[error] [client 84.151.147.72] File does not exist:
G:/WWWRoot/light-gap.net/knauserer/css, referer: <A
href="http://knauserer.light-gap.net/lexikon.php">http://knauserer.light-gap.net/lexikon.php</A><BR>[Tue
May 24 16:55:40 2005] [error] [client 82.83.247.111] File does not exist:
G:/WWWRoot/gleitgeb.at/members/lulabi</FONT></DIV>
<DIV><FONT face=Arial size=2> </DIV></FONT>
<DIV><FONT face=Arial size=2>At the same time (short after it) my
Apache-Service crashes and gets restarted:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV><FONT face=Arial
size=2>>>[Tue May 24 16:53:07 2005] [notice] Parent: child process exited
with status 3221225477 -- Restarting.<BR>[Tue May 24 16:53:08 2005] [notice]
Apache/2.0.54 (Win32) DAV/2 PHP/5.0.3 mod_jk/1.2.8 configured -- resuming normal
operations<BR>[Tue May 24 16:53:08 2005] [notice] Server built: Apr 16 2005
14:25:31<BR>[Tue May 24 16:53:08 2005] [notice] Parent: Created child process
2588<BR>[Tue May 24 16:53:09 2005] [notice] Disabled use of AcceptEx() WinSock2
API<BR>[Tue May 24 16:53:10 2005] [notice] Child 2588: Child process is
running<BR>[Tue May 24 16:53:10 2005] [notice] Child 2588: Acquired the start
mutex.<BR>[Tue May 24 16:53:10 2005] [notice] Child 2588: Starting 250 worker
threads.<BR>[Tue May 24 16:53:10 2005] [notice] Child 2588: Listening on port
80.<BR>>>[Tue May 24 16:53:51 2005] [notice] Parent: child process exited
with status 3221225477 -- Restarting.<BR>[Tue May 24 16:53:52 2005] [notice]
Apache/2.0.54 (Win32) DAV/2 PHP/5.0.3 mod_jk/1.2.8 configured -- resuming normal
operations<BR>[Tue May 24 16:53:52 2005] [notice] Server built: Apr 16 2005
14:25:31<BR>[Tue May 24 16:53:52 2005] [notice] Parent: Created child process
5860<BR>[Tue May 24 16:53:53 2005] [notice] Disabled use of AcceptEx() WinSock2
API<BR>[Tue May 24 16:53:54 2005] [notice] Child 5860: Child process is
running<BR>[Tue May 24 16:53:54 2005] [notice] Child 5860: Acquired the start
mutex.<BR>[Tue May 24 16:53:54 2005] [notice] Child 5860: Starting 250 worker
threads.<BR>[Tue May 24 16:53:54 2005] [notice] Child 5860: Listening on port
80.<BR>>>[Tue May 24 16:54:13 2005] [notice] Parent: child process exited
with status 3221225477 -- Restarting.<BR>[Tue May 24 16:54:15 2005] [notice]
Apache/2.0.54 (Win32) DAV/2 PHP/5.0.3 mod_jk/1.2.8 configured -- resuming normal
operations<BR>[Tue May 24 16:54:15 2005] [notice] Server built: Apr 16 2005
14:25:31<BR>[Tue May 24 16:54:15 2005] [notice] Parent: Created child process
4908<BR>[Tue May 24 16:54:15 2005] [notice] Disabled use of AcceptEx() WinSock2
API<BR>[Tue May 24 16:54:16 2005] [notice] bw_mod : Version 0.6 - Initialized [0
Confs]<BR>[Tue May 24 16:54:16 2005] [notice] Child 4908: Child process is
running<BR>[Tue May 24 16:54:16 2005] [notice] Child 4908: Acquired the start
mutex.<BR>[Tue May 24 16:54:16 2005] [notice] Child 4908: Starting 250 worker
threads.<BR>[Tue May 24 16:54:16 2005] [notice] Child 4908: Listening on port
80.<BR></FONT>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>If I disable mod_log_sql everything works
fine.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Do anyone of you have an idea what can
cause this problem?</FONT></DIV>
<DIV><FONT face=Arial size=2>What does "mysql_query returned (1)"
mean?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I also tried the debug mode but there was no
depending additional information in the logfile.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I hope for a fast answer.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Best regards</FONT></DIV>
<DIV><FONT face=Arial size=2>Günther Leitgeb</DIV></FONT></DIV></BODY></HTML>