[Issues] [mod_log_sql 0000027]: virtual host subdomains
issues at outoforder.cc
issues at outoforder.cc
Sat Jan 21 12:29:57 EST 2006
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
======================================================================
More information about the Issues
mailing list