[Mod_log_sql] LogSQLRequestIgnore favicon.ico

[Andy Nash]

Hi,

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
        #LogSQLWhichCookie
        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
(agent,request_args,bytes_sent,cookie,request_protocol,remote_host,id,remote
_logname,machine_id,request_method,server_port,referer,time_stamp,status,req
uest_duration,request_uri,remote_user,virtual_host,ssl_maxkeysize,ssl_keysiz
e,ssl_cipher) values ('Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB;
rv:1.7.6) Gecko/20050226
Firefox/1.0.1',NULL,'1501','-','HTTP/1.1','217.196.228.10','UOSEW9nE5AoAAEgt
P3sAAAAA',NULL,'www-1','GET','80','-','1114261902','404','0','/favicon.ico',
'-','www.*******.com','0','0','0')

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?

Thanks,

Andy