On Sat, Jan 26, 2002 at 11:37:29AM +0100, James R. Ullman wrote: > 12. I searched for "sitegroup id" > I found this in the LAST 2% of the file. Line 301916 of 305118 lines. > Above the <sitegroup id="some_long_nummer"> tag was the tag </member> > It had a changed="date" in the sitegroup tag. Good. > It had a <admingroup>some_long_nummer</admingroup>. Good. > It had a <name><![CDATA[Sitegroup Name]]></name>. Good. > Then I see that there is an ending <realm/> tag, but NO > starting <realm> tag, so I searched for it. The starting <realm> tag > was not to be found. NOT good. > After the ending <realm/> was the ending </sitegroup> tag to > end the sitegroup info. This is all OK, tag <realm/> is allowed shortcut for <realm></realm> (with empty content) and Repligard optimizes output to squeeze few bytes.
> ********************************************************************************* > Importing steps: > > 1. Using a "live" working 1.4.2 midgard database, I copied it to a > database called "import". > I also copied the "live" blobs dir to a dir called blobs_import. > > 2. Ran myisamchk -o *.MYI under the newly created import database. > No errors. > myisamchk, because the database has *.MYI files > > 3. Using phpMyAdmin 2.2.3 : > 3a. Selected database "import" > 3b. Added a new user "import" with access to localhost & passwd "import" > 3c. Selected privileges, allowing user "import" to access "import" > database with Select, Insert, Update, Delete, Create, Drop privileges. > 3d. Still in phpMyAdmin, under "Database mysql - table db running on > localhost" area, I inserted a new row : Host=localhost, Db=import, > User=import, Select_priv=Y, Insert_priv=Y, Update_priv=Y, > Delete_priv=Y, > Create_priv=Y > The rest were set to N. > 3e. Ran "Reload MySQL" > > 4. Made a file called import.conf > import.conf has the required info to connect to the "import" database > as admin. > This includes the correct schema repligard_withsg.xml. > Blob dir points to correct blobs_import dir > <replicate all="yes"/> commented out > . > 5. Ran repligard -d -d -c /somedir/import.conf -i export.xml > > ********************************************************************************* > RESULTS - TEST #1: > > table host > Sets imported HOSTS to SG0. NOT Good. I'll look at it. > table sitegroup > Created new a NEW sitegroup. Good. > > Checking the rest of the tables and selecting the correct SG id > under "table sitegroup", I found this: > > table article - 0 of 73 > table blobs - 0 of 216 > table element - 0 of 96 > table grp - 5 of 6 > table member - 0 of 34 > table page - 39 of 164 > table pageelement - 0 of 32 > table person - 13 of 13 ! > table snippet - 0 of 23 > table snippetdir - 0 of 18 > table style - 5 of 13 > table topic - 21 of 38 > > As far as I can see, everything imported fine. No errors while using > repligard. > For example, articles/blobs... were imported, but to SG0 only. This is porbably connectes with wrong hosts import. > RESULTS - TEST #2: > > After doing Importing Steps #1 and #2, again, > I corrected the error found in Exporting Steps #12. > I added the missing tag <realm><![CDATA[sitegroup_name]]> infront of the > ending <realm/> tag. > > Ran repligard -d -d -c /somedir/import.conf -i export.xml > REPLIGARD/READ-CRITICAL **: mismatched tag in line 301920 > 301920 is the ending </sitegroup> tag from Exporting Steps #12. This is correct. > So I changed the <realm/> tag to </realm> and re-ran repligard import. > No error. Newly imported hosts still in SG0. > > RESULTS - TEST #3: > > After doing Importing Steps #1 and #2, again, > > Moved entire <sitegroup id=...> </sitegroup> content to top of xml file. > Just under <Database xmlns="http://www.midgard-project.org/repligard/1.4";> > > Ran repligard -d -d -c /somedir/import.conf -i export.xml > No errors. Newly imported hosts still in SG0. > > Conclusion: > I am running out of ideas on how to make this work. > A simple question, which I am unsure of is: > Is the system admin required to CREATE the sitegroup on the new computer > running midgard, BEFORE you import that SG ? Currently it is so, I think. It is not so easy to make appropriate change in Repligard because it means a possible hole in security. Could you try to create a sitegroup with the GUID before importing and then repeat import? -- / Alexander Bokovoy $ cat /proc/identity >~/.signature `Senior software developer and analyst for SaM-Solutions Ltd.` --- Nov 21 20:58:58 alconost kernel: VFS: Busy inodes after unmount. Self-destruct in 5 seconds. Have a nice day... --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
