[Issues] [mod_log_sql 0000027]: virtual host subdomains

[issues at outoforder.cc]

The following issue has been ASSIGNED. 
====================================================================== 
http://issues.outoforder.cc/view.php?id=27 
====================================================================== 
Reported By:                else
Assigned To:                urkle
====================================================================== 
Project:                    mod_log_sql
Issue ID:                   27
Category:                   Feature Request
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     assigned
Apache Version:             unspecified 
====================================================================== 
Date Submitted:             02-04-2005 01:31 EST
Last Modified:              01-21-2006 12:29 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                          
01-21-06 12:29  urkle          Status                   new => assigned     
01-21-06 12:29  urkle          Assigned To               => urkle           
======================================================================