On Tue, Feb 06, 2001 at 03:56:38PM +0100, Emiliano mentioned:
> > Still trying to work this one out. I stuck mysql into debugging mode, and
> > apache isn't even trying to access it; so it must be the apache/midgard
> > configuration.
>
> Your setup looks OK so far. Set LogLevel to 'debug', stop and start
> apache, and try again. If midgard is active. it will tell you what it's
> doing.
Bah. Turns out that there was a wierd error in the mysql.user table that
caused it to drop connections silently when it got a few lines into the
table.
It's now giving a decent error...though it's not the error I was
expecting.
==> httpd/error_log <==
[Tue Feb 6 16:01:23 2001] [debug] mod_midgard.c(1178): [client 172.24.1.104]
midgard_translate_handler(latin1, http://midgard.sunnydale.antefacto.com:80/asgard)
[Tue Feb 6 16:01:23 2001] [debug] /var/tmp/midgard-1.4/usr/include/mgd_apache.h(135):
[client 172.24.1.104] Midgard: select_database opened midgard
[Tue Feb 6 16:01:23 2001] [debug] mod_midgard.c(1221): [client 172.24.1.104] Midgard:
host record for midgard.sunnydale.antefacto.com:80 not found
[Tue Feb 6 16:01:23 2001] [error] [client 172.24.1.104] File does not exist:
/var/www/midgard/html/asgard
The host table contains:
Database changed
mysql> select * from host;
+----+---------------------------------+------+-------+------+-------+------+--------+---------------------+-----------+
| id | name | root | style | info | owner | port | online |
|prefix | sitegroup |
+----+---------------------------------+------+-------+------+-------+------+--------+---------------------+-----------+
| 1 | midgard.sunnydale.antefacto.com | 4 | 1 | auth | 0 | 80 | 1 |
|/asgard | 0 |
| 2 | midgard.sunnydale.antefacto.com | 4 | 2 | auth | 0 | 80 | 1 |
|/asgard/framed | 0 |
| 3 | midgard.sunnydale.antefacto.com | 4 | 3 | auth | 0 | 80 | 1 |
|/asgard/framed/top | 0 |
| 4 | midgard.sunnydale.antefacto.com | 4 | 4 | auth | 0 | 80 | 1 |
|/asgard/framed/main | 0 |
+----+---------------------------------+------+-------+------+-------+------+--------+---------------------+-----------+
4 rows in set (0.00 sec)
Is there anyway to make midgard try to connect to a specific host, for the
database ? There is nothing in the local mysql logs to suggest that it's
connecting locally...it seems like it's opening a database...but not on this
machine!
John
--
When I say 'free', I mean 'free': free from bond, of chain or command:
to go where you will, even to Mordor, Saruman, if you desire. "
-- Gandalf, paraphrasing the choice between Free and Non-free software
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
