Ok the saga continues but with much more positive results this time. I
deleted the midgard database again, recompiled expat and reinstalled using
datagard. It worked! Everything is set up as it should in the database as
far as I can tell.
Now we are down to other issues - spider-admin and aegir return 404 not
found errors. Their host entries in the database are correct as far as I
can tell. I think I have seen this before somewhere but cannot seem to find
a reference to it.
I have attached the apache vhost conf (generated by datagard) for the
192.168.6.64:8080 domain:
<VirtualHost *:8080>
ServerName 192.168.6.64
DocumentRoot /var/local/lib/midgard/vhosts/192.168.6.64/8080
MidgardBlobDir /var/local/lib/midgard/blobs/midgard
<Directory /var/local/lib/midgard/blobs/midgard>
Allow from all
</Directory>
MidgardEngine on
#MidgardRootfile /usr/lib/apache2/modules/midgard-root-nommp.php
MidgardPageCacheDir /var/local/cache/midgard
<Directory /var/local/cache/midgard>
Allow from all
</Directory>
MidgardRootFile /usr/lib/apache2/modules/midgard-root.php
MidgardParser UTF-8
MidgardDefaultRealm "Midgard"
MidgardDatabase midgard midgard midgard
RLimitCPU 20 60
RLimitMem 67108864 134217728
# Global virtual host level PHP settings for all Midgard applications
#
# Required for uploading attachments
php_admin_flag file_uploads On
# Required by majority of the Midgard PHP applications
php_flag magic_quotes_gpc Off
# Required by MidCOM <= 1.4 (comment this out with newer releases)
php_flag short_open_tag On
# Recommended at least for MidCOM AIS (8M is the minimum requirement)
# (change and enable if you want to set different value than in php.ini)
#php_value memory_limit 8M
# Maximum size of POST data (affects attachment uploads)
# (change and enable if you want to set different value than in php.ini)
#php_value post_max_size 8M
# Maximum size for uploaded files (affects attachment uploads)
# (change and enable if you want to set different value than in php.ini)
#php_value upload_max_filesize 2M
# Location specific PHP settings for certain Midgard applications
#
<Location /spider-admin>
php_flag register_globals On
</Location>
<Location /aegir>
php_flag short_open_tag On
php_flag register_globals On
</Location>
AddDefaultCharset utf-8
</VirtualHost>
And the apache log file generated for the spider-admin when the page is
accessed:
[Fri Feb 04 09:22:03 2005] [debug] midgard-apache2.c(2077): [client
192.168.6.243] midgard_translate_handler(UTF-8,
http://192.168.6.64:8080/spider-admin)
[Fri Feb 04 09:22:03 2005] [debug] select_db2.h(87): [client 192.168.6.243]
Midgard: select_database reused open (midgard)
[Fri Feb 04 09:22:03 2005] [debug] midgard-apache2.c(513): [client
192.168.6.243] Midgard: lang set to 0
[Fri Feb 04 09:22:03 2005] [debug] select_db2.h(33): [client 192.168.6.243]
Midgard: select_database kept current databasemidgard
[Fri Feb 04 09:22:03 2005] [debug] midgard-apache2.c(443): [client
192.168.6.243] Midgard: user admin (1) authorized
[Fri Feb 04 09:22:03 2005] [debug] select_db2.h(33): [client 192.168.6.243]
Midgard: select_database kept current databasemidgard
[Fri Feb 04 09:22:03 2005] [debug] midgard-apache2.c(1287): [client
192.168.6.243] Midgard: extension = .php, default: .php, parser = UTF-8
[Fri Feb 04 09:22:03 2005] [debug] midgard-apache2.c(1314): [client
192.168.6.243] Midgard: regenerating /var/local/cache/midgard/7-57-12-0.php:
cannot open, assuming non-existant
[Fri Feb 04 09:22:03 2005] [debug] midgard-apache2.c(2253): [client
192.168.6.243] Midgard: Couldn't create cache file
[Fri Feb 04 09:22:03 2005] [error] [client 192.168.6.243] File does not
exist: /var/local/lib/midgard/vhosts/192.168.6.64/8080/spider-admin
I realise there is a cache error but have bee unable to resolve it. The
cache folder exists, is owned by apache and has 777 permissions. Not sure
why there is a 'File does not exist' error either
midgard-pageresolve -h 192.168.6.64 -p 8080 returns that it has found the
root page
Connecting to mysql://midgard:<hidden>@localhost/midgard
Resolving host: http://192.168.6.64:8080/
Host found: 5 in sitegroup 0
Resolving page: http://192.168.6.64:8080/
Page found: 50, active=2, redirect=0
And midgard-pageresolve -h 192.168.6.64 -p 8080 -u /spider-admin returns
Connecting to mysql://midgard:<hidden>@localhost/midgard
Resolving host: http://192.168.6.64:8080/spider-admin
Host found: 7 in sitegroup 0
Resolving page: http://192.168.6.64:8080/spider-admin
Page found: 57, active=2, redirect=1
*** AUTHENTICATE ***
Spider-admin does successfully ask for a username and password before
returning the 404 error.
----------------------------------------------------
Michael Ross - Pan Leeds Web Developer
Health Informatics Service����� Tel: (0113) 305 7416
2nd Floor������ ������� ������� Fax: (0113) 305 7398
North West House
West Park Ring Road
West Park
Leeds
LS16 6QG
-----Original Message-----
From: Michael Ross (PCT North West)
[mailto:[EMAIL PROTECTED]
Sent: 03 February 2005 16:28
To: [email protected]
Subject: RE: [midgard-user] Upgrade to 1.6.2
Hi Piotras,
You must be fed up with this by now. Thanks for your patience.
Expat is 1.95.8
Glib is 2.4.8
All the packages except those two multilang packages say they were imported
successfully by the output from datagard. Looking through the database
seems to partly back that up. Its almost as if some bits of the packages
are missing.
article - 5 entries
blobs - empty
cache - empty
element - 184 entries
event -empty
eventmember - empty
file - empty
grp - 4 entries
host - empty
image - empty
member - 1 entry
page - 108 entries including Aegir, PHPmole connector, midcom, webalizer to
name a few
pageelement - 101 entries
pagelink - empty
person - 1 entry (admin)
preference - empty;
quote - empty;
record_extension - empty;
repligard - 28462 entries;
sitegroup - empty;
snippet - 11869 entries;
snippetdir - 489 entries including Spider admin
style - 12 entries including Aegir, Midcom and Spider
topic - 9 entries including Midcom
I have deleted the midgard database and tried a reinstall from scratch but
have the same issues. I tried reinstalling these specifically
AegirAddOn_FileSync
AegirAddOn_Gallery
AegirAddOn_Schedule
AegirAddOn_Tools
AegirAddOn_Webstats
AegirCMS
AegirSampleSite
Midcom-example
Midcom-template
Midcom
Midgard-welcome
Spider-admin
Will now try re-creating database from scratch manually using old methods.
Cheers
Mike.
----------------------------------------------------
Michael Ross - Pan Leeds Web Developer
Health Informatics Service����� Tel: (0113) 305 7416
2nd Floor������ ������� ������� Fax: (0113) 305 7398
North West House
West Park Ring Road
West Park
Leeds
LS16 6QG
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
