[Issues] [mod_log_sql 0000010]: X-Forwarded-For header logging for proxies

[issues at outoforder.cc]

A NOTE has been added to this issue.
======================================================================
<http://issues.outoforder.cc/view.php?id=10> 
======================================================================
Reported By:                urkle
Assigned To:                urkle
======================================================================
Project:                    mod_log_sql
Issue ID:                   10
Category:                   Feature Request
Reproducibility:            N/A
Severity:                   minor
Priority:                   normal
Status:                     assigned
Apache Version:             unspecified
======================================================================
Date Submitted:             09-05-2004 12:16 EST
Last Modified:              04-16-2005 16:28 EST
======================================================================
Summary:                    X-Forwarded-For header logging for proxies
Description: 
e-mail from Paul Chvostek

Heya.

I'm trying to get mod_log_sql running on a web server behind a proxy
(Pound, from http://apsis.ch/pound/).  The proxy correctly sends the
X-Forwarded-For header lines to indicate the original requestor, so in
the bad-old-days, I built my combined logs with:

LogFormat "%{X-Forwarded-For}i %l %u %t \"%r\" %>s %b \"%{Referer}i\"
\"%{User-Agent}i\"" combined

Now...  how do I get out of the bad-old-days?  Section 3.6.17 of the
version 1.18 documentation (I'm using Apache 1.3) doesn't mention the
X-Forwarded-For header, nor is it mentioned in the equivalent unnumbered
section of the docs for 2.0.  I also can't find anything that would
allow me to specify additional headers myself.

Am I missing something obvious, or am I really making a feature request?
Given the benefits of mod_log_sql for aggregating the log data of a farm
of web servers, support for X-Forwarded-For would seem like an obvious
requirement.  :)

======================================================================

----------------------------------------------------------------------
 urkle - 04-16-05 16:28 
----------------------------------------------------------------------
e-mail from Michael Bourquin

we need to add a Load balancer in front of the network... The load
balancer will send an 'X-Cluster-Client-Ip' header. The remote_host field
will be the Load balancer IP.We need to retrieve the 'X-Cluster-Client-Ip'
and place into remote_host in the DB or in a new field.We would like to
know if it's possible to make this modification for us, because it's
necessary to have the real IP in the remote_field.

Issue History
Date Modified  Username       Field                    Change              
======================================================================
09-05-04 12:16 urkle          New Issue                                    
09-05-04 12:16 urkle          Apache Version            => unspecified     
09-05-04 12:16 urkle          Status                   new => assigned     
09-05-04 12:16 urkle          Assigned To               => urkle           
04-16-05 16:28 urkle          Note Added: 0000038                          
======================================================================