[Mod_log_sql] Possible to limit 414 (URI too long) entries?

Jorey Bump list at joreybump.com
Fri Mar 25 15:22:08 EST 2005

I'm considering using mod_log_sql for my virtual hosting setup. One of 
the first things I do when configuring apache is to prevent the logging 
of 414 (URI too long) requests, to reduce clutter/size of the log:

  # %!414r reduce clutter, only a "-" will be displayed
  LogFormat "%h %l %u %t \"%!414r\" %>s %b" common

This allows me to track these requests in the log, without actually 
storing the request string itself. Is there a similar capability in 

Note that I want to control this based on the status code, not a 
substring of the full request, so LogSQLRequestIgnore will not work.

Also, LogSQLRequestIgnore will prevent the logging of any information to 
the db, which is undesirable. I simply want to replace the full request 
string (r) with "-", without resorting to a regular cron job.

More information about the Mod_log_sql mailing list