I posted this to <a href="http://issues.outoforder.cc/view.php?id=64" title="http://issues.outoforder.cc/view.php?id=64" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://issues.outoforder.cc/view.php?id=64
</a> as well, but I am unsure if the developer for mod_vhost_dbi still is active there, as the last activity was around a year ago for that module:
<br><br>
I am running Ubuntu (6.06) Apache 2.0.55, mod_dbi_pool 0.4.0, and mod_vhost_dbi 0.1.0.<br>
<br>
There's a bit of behavior that's confusing. <br>
<br>
With ServerName set to "<a href="http://www.domain.com" title="http://www.domain.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">www.domain.com</a>" and the URL visited as "<a href="http://www.domain.com" title="http://www.domain.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
www.domain.com</a>" I receive this message:<br>
<br>
[error] [client *.*.*.*] File does not exist: /ERROR<br>
<br>
If, however, I try to access just "<a href="http://domain.com" title="http://domain.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">domain.com</a>" this is the error received:<br>
<br>
[notice] vhost_dbi_translate_name: no host found in database for '<a href="http://domain.com" title="http://domain.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">domain.com</a>', using defaults.
<br>
<br>
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 (<a href="http://hostname.domain.com/%7Eaccount" title="http://hostname.domain.com/~account" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">hostname.domain.com/~account</a>) it works fine.
<br>
<br>
Also, with the default template being used, I received this messsage:<br>
<br>
Syntax error on line 422 of /etc/apache2/apache2.conf:<br>
VhostDbiQuery takes one argument, SQL Query to Execute to find the Domain Info<br>
...fail!<br>
<br>
So we changed this:<br>
<br>
VhostDbiQuery "SELECT ServerName, DocumentRoot, Username " \<br>
FROM vhost_info WHERE ServerName = &{RequestHostname}"<br>
<br>
to:<br>
<br>
VhostDbiQuery "SELECT ServerName, DocumentRoot, Username FROM vhost_info WHERE ServerName = &{RequestHostname}"<br>
<br>
Any help with this would be greatly appreciated.<br><br>Kent<br><br>Other info:<br><br>(
+--------------+------------+------+-----+---------+----------------+<br>
| Field | Type | Null | Key | Default | Extra |<br>
+--------------+------------+------+-----+---------+----------------+<br>
| id | int(11) | NO | PRI | NULL | auto_increment |<br>
| ServerName | mediumtext | NO | | NULL | |<br>
| DocumentRoot | mediumtext | NO | | NULL | |<br>
| ServerAlias | mediumtext | NO | | NULL | |<br>
| Username | mediumtext | NO | | NULL | |<br>
<br>
# mod_vhost_dbi config here:<br>
<br>
PoolDbiDriver Server1 mysql<br>
PoolDbiHost Server1 localhost<br>
PoolDbiUsername Server1 *****<br>
PoolDbiPassword Server1 *****<br>
PoolDbiDBName Server1 vhost_dbi<br>
PoolDbiConnMin Server1 1<br>
PoolDbiConnSoftMax Server1 1<br>
PoolDbiConnHardMax Server1 5<br>
PoolDbiConnTTL Server1 30<br>
<br>
<VirtualHost *:80><br>
VhostDbiEnabled On<br>
VhostDbiConnName Server1<br>
VhostDbiQuery "SELECT ServerName, DocumentRoot, Username FROM vhost_info WHERE ServerName = &{RequestHostname}"<br>
</VirtualHost>)