[Issues] [mod_vhost_dbi 0000064]: Query not behaving as expected

[issues at outoforder.cc]

The following issue has been SUBMITTED. 
====================================================================== 
http://issues.outoforder.cc/view.php?id=64 
====================================================================== 
Reported By:                standk
Assigned To:                
====================================================================== 
Project:                    mod_vhost_dbi
Issue ID:                   64
Category:                   Apache Integration
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     new
Apache Version:             2.0.54 
====================================================================== 
Date Submitted:             07-15-2006 01:18 EDT
Last Modified:              07-15-2006 01:18 EDT
====================================================================== 
Summary:                    Query not behaving as expected
Description: 
I am running Ubuntu (6.06) Apache 2.0.55, mod_dbi_pool 0.4.0, and
mod_vhost_dbi 0.1.0.

There's a bit of behavior that's confusing. 

With ServerName set to "www.domain.com" and the URL visited as
"www.domain.com" I receive this message:

[error] [client *.*.*.*] File does not exist: /ERROR

If, however, I try to access just "domain.com" this is the error
received:

[notice] vhost_dbi_translate_name: no host found in database for
'domain.com', using defaults.

I am confused as to why those are different queries, and why when the
query is correct pages are not served. If we attempt to serve the page
using mod_alias (hostname.domain.com/~account) it works fine.

Also, with the default template being used, I received this messsage:

Syntax error on line 422 of /etc/apache2/apache2.conf:
VhostDbiQuery takes one argument, SQL Query to Execute to find the Domain
Info
  ...fail!

So we changed this:

  VhostDbiQuery "SELECT ServerName, DocumentRoot, Username " \
            FROM vhost_info WHERE ServerName = &{RequestHostname}"

to:

  VhostDbiQuery "SELECT ServerName, DocumentRoot, Username FROM vhost_info
WHERE ServerName = &{RequestHostname}"

Any help with this would be greatly appreciated.
====================================================================== 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
07-15-06 01:18  standk         New Issue                                    
07-15-06 01:18  standk         Apache Version            => 2.0.54          
======================================================================