[Issues] [mod_log_sql 0000027]: virtual host subdomains

[issues at outoforder.cc]

A NOTE has been added to this issue.
======================================================================
<http://bugs.outoforder.cc/view.php?id=27> 
======================================================================
Reported By:                else
Assigned To:                
======================================================================
Project:                    mod_log_sql
Issue ID:                   27
Category:                   Feature Request
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     new
Apache Version:             unspecified
======================================================================
Date Submitted:             02-04-2005 01:31 EST
Last Modified:              04-11-2005 17:21 EST
======================================================================
Summary:                    virtual host subdomains
Description: 
Is it possible to have mod_log_sql expand the domain names.

So that 'site.com' and 'www.site.com' log to the same table.
Not sure if this is an issue with mod_log_sql or how apache handles it


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

----------------------------------------------------------------------
 urkle - 02-04-05 20:11 
----------------------------------------------------------------------
This is a known issue, and I have been trying to find a way to resolve it.
it is an issue with how apache handles things and the mass virtual hosting
in mod_log_sql.

----------------------------------------------------------------------
 else - 04-11-05 17:21 
----------------------------------------------------------------------
I just recently thought about something that might fix this.  Useing SQL to
search for host names the Query can be changed to 'WHERE &{host} LIKE
Alias'
Alias is an extra column on in the table that contains what to match
against.  An entry with
*
Hostname       Folder      User   Alias
www.site.com   /site.com/   -     %.site.com
www.site.com   /site.com/   -     site.com

would match Anything requesting for '*.site.com' and 'site.com'

Now abuot the logging,  is it not possible to change the
request_rec->hostname field to the HostName column?  I dont know if that
would affect the ap_get_server_name function used in mod_log_sql though. 
If it does, then login would go to access_www_site_com  for all of them.

Issue History
Date Modified  Username       Field                    Change              
======================================================================
02-04-05 01:31 else           New Issue                                    
02-04-05 01:31 else           Apache Version            => unspecified     
02-04-05 20:11 urkle          Note Added: 0000033                          
04-11-05 17:21 else           Note Added: 0000036                          
======================================================================