[Mod_log_sql] LogSQLRequestIgnore favicon.ico

Andy Nash andy at kourou.com
Sat Apr 23 09:41:17 EST 2005


I've successfully got logging working with v. 1.100, and its great - thanks!

However I'm trying to ignore favicon.ico requests and am having no luck. I
have the following i my virtual host stanza:

        # SQL Logging with mod_log_sql
        #LogSQLTransferLogTable access_log
        LogSQLTransferLogFormat AabcHhIlMmpRSsTUuVQqz
        #LogSQLRequestAccept *.html *.gif *.jpg
        LogSQLRequestIgnore favicon.ico root.exe cmd.exe default.ida
        LogSQLWhichNotes mod_gzip_result mod_gzip_compression_ratio
        LogSQLWhichHeadersOut Expires Content-Type Cache-Control
        LogSQLWhichHeadersIn UserAgent Accept-Encoding Host
        LogSQLPreserveFile /tmp/sql-preserve

and the following in my server-wise config:

	# Configuration information for mod_log_sql
	LogSQLLoginInfo mysql://********:*******@****.*********.***/******
	LogSQLCreateTables on
	LogSQLMassVirtualHosting On
	#LogSQLForcePreserve On
	LogSQLMachineID www-1

Yet mysqld.log is still showing inserts like this:

41603 Query       insert  into access_www_kourou_com
e,ssl_cipher) values ('Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB;
rv:1.7.6) Gecko/20050226

I have also tried using '/favicon.ico' rather than just 'favicon.ico' though
I was not expecting that to work. Any ideas as to where I am going wrong?



More information about the Mod_log_sql mailing list