Alright I have been trying to figure this out for a few days now and have not been able to. I am attempting to get mod_log_sql working correctly on my Fedora 14 box. Everything is working fine until I enable the logging of bytes_in and bytes_out using "i" and "o" respectively. As soon as I add these two letter to the LogSQLTransferLogFormat configuration option my Apache error_log is flooded with:<br>
<br>[Sun Jan 02 10:26:20 2011] [error] Log Format 'i' unknown<br>[Sun Jan 02 10:26:20 2011] [error] Log Format 'o' unknown<br>[Sun Jan 02 10:26:20 2011] [error] Log Format 'i' unknown<br>[Sun Jan 02 10:26:20 2011] [error] Log Format 'o' unknown<br>
[Sun Jan 02 10:26:23 2011] [error] Log Format 'i' unknown<br>[Sun Jan 02 10:26:23 2011] [error] Log Format 'o' unknown<br>[Sun Jan 02 10:26:24 2011] [error] Log Format 'i' unknown<br>[Sun Jan 02 10:26:24 2011] [error] Log Format 'o' unknown<br>
[Sun Jan 02 10:26:37 2011] [error] Log Format 'i' unknown<br>[Sun Jan 02 10:26:37 2011] [error] Log Format 'o' unknown<br><br>messages. I am using version 1.101 and have the mod_logio module disabled. The fields "bytes_in" and "bytes_out" both exist in the table I am logging to. Is there something else I need to set for this to work properly? My complete httpd.conf file can be found here (username/passwords/emails removed): <a href="http://dbunyard.homeip.net/stuff/httpd.conf">http://dbunyard.homeip.net/stuff/httpd.conf</a> and my phpinfo page can be found here: <a href="http://dbunyard.homeip.net/phpinfo.php">http://dbunyard.homeip.net/phpinfo.php</a> Thanks!!<br clear="all">
--<br>Dan<br><br><a href="http://www.bunyardpics.com" target="_blank">http://www.bunyardpics.com</a><br><a href="http://www.linkedin.com/in/danbunyard" target="_blank">http://www.linkedin.com/in/danbunyard</a><br><a href="http://www.danodemano.com" target="_blank">http://www.danodemano.com</a><br>
<a href="http://www.dansrandomness.com" target="_blank">http://www.dansrandomness.com</a><br><a href="http://www.danandshelley.com" target="_blank">http://www.danandshelley.com</a><br><br>This is not a problem that requires infinite wisdom, Benj. This is a problem that requires enough neural organization to qualify as a vertebrate, apparently a stretch for some folks these days.<br>
~Cecil Adams.<br>