[Issues] [mod_vhost_dbi 0000064]: Query not behaving as expected
issues at outoforder.cc
issues at outoforder.cc
Sat Jul 15 01:18:48 EDT 2006
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
======================================================================
More information about the Issues
mailing list