[Issues] [mod_vhost_dbi 0000071]: How to solve `www.` Alias

[issues at outoforder.cc]

The following issue has been SUBMITTED. 
====================================================================== 
http://issues.outoforder.cc/view.php?id=71 
====================================================================== 
Reported By:                zeno
Assigned To:                
====================================================================== 
Project:                    mod_vhost_dbi
Issue ID:                   71
Category:                   Apache Integration
Reproducibility:            always
Severity:                   feature
Priority:                   normal
Status:                     new
Apache Version:             unspecified 
====================================================================== 
Date Submitted:             04-13-2007 04:20 EDT
Last Modified:              04-13-2007 04:20 EDT
====================================================================== 
Summary:                    How to solve `www.` Alias
Description: 
Could you please update the documentation for someone may be interested.

If your domain in your database do not contain www. use this query to
include it:

VhostDbiQuery 'SELECT ServerName, DocumentRoot, Username FROM vhost_info
WHERE ServerName = &{RequestHostname}"  OR  ServerName = SUBSTRING(
&{RequestHostname}, 5 )'

If you do have www. in your database:

VhostDbiQuery 'SELECT ServerName, DocumentRoot, Username FROM vhost_info
WHERE ServerName = &{RequestHostname}"  OR  ServerName = CONCAT( 'www.',
&{RequestHostname})'

Thank you so much, it is a great module!
====================================================================== 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
04-13-07 04:20  zeno           New Issue                                    
04-13-07 04:20  zeno           Apache Version            => unspecified     
======================================================================