[Mod_log_sql] Logging environment variables

Edward rudd urkle at outoforder.cc
Thu Nov 24 11:49:59 EST 2005


On Thu, 2005-11-24 at 16:22 +0000, Mike Cardwell wrote:
> * on the Thu, Nov 24, 2005 at 10:51:52AM -0500, Edward rudd wrote:

[snip]
> 
> I think mod_log_sql would be a lot more powerful if you were able to
> specify column names to be filled by the contents of Environment
> variables eg:
> 
> LogSQLEnvVar virtual_host "VHOST"
> LogSQLEnvVar remote_port  "REMOTE_PORT"
> 
> Using a mod_rewrite map you can fill in those env variables with almost
> any data you can think of, and then log them to the database in a column
> name of your choice. Granted, that's a very specialised feature request
> that most people wouldn't require.
> 
> Technically, you could drop altogether LogSQLTransferLogFormat if this
> were the case.

I am planning on adding something similar to allow "dynamic"
configuration of the fields (even adding in new ones). It just requires
some extra work to get that to work w/ the auto-creation of tables
mechanism.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://lists.outoforder.cc/pipermail/mod_log_sql/attachments/20051124/af4dc1d0/attachment.bin 


More information about the Mod_log_sql mailing list