Hi,

I am attempting to get Midgard 1.8.6 running on a fresh install of RHEL 5 ( Apache 2.2, MySQL 5.0, PHP 5.0 ). The install completed with no problems at all. However, when I initially ran datagard to create a new database, it failed when trying to import languages.xml. The problem seemed to be that it was looking for the metadata_deleted column in the person table, but the column did not exist. In looking at the datagard code, I found the following 2 lines around line 206:

               mgd_import_nonml_app auto
               mgd_update_db

It appears that it is attempting to import the apps before it has updated the database. I swapped these 2 lines and the process was then able to complete successfully. So, question #1 is, should I have had to do this or am I missing something else ?

I decided to continue on and install AegirCMS. It is failing with pretty much the same problem. It produces a bunch of output indicating that it is updating the tables, and then fails with an error on the repligard command. When running repligard manually with strace, I get the following
output:

# strace -s 200 repligard -c /usr/local/etc/midgard/repligard.conf -a -b -i /usr/local/share/midgard/data/AegirCMS.xml.gz

[... snip ... ]
write(3, "e\0\0\0\3SELECT gid FROM member WHERE uid=1 AND sitegroup in (0, 0) AND metadata_deleted=0 ORDER BY gid DESC", 105) = 105 read(3, "<\0\0\1\377\36\4#42S22Unknown column \'metadata_deleted\' in \'where clause\'", 16384) = 64 open("/lib64/charset.alias", O_RDONLY) = -1 ENOENT (No such file or directory) write(2, "\nrepligard-CRITICAL **: Error logging into Database\naborting...\n", 64
repligard-CRITICAL **: Error logging into Database

The strange thing this time is that the column DOES exist, and this query works perfectly fine when I run it manually.

Any ideas on what the problem might be ?  Thanks in advance.

Martin

_______________________________________________
user mailing list
[email protected]
http://lists.midgard-project.org/mailman/listinfo/user

Reply via email to