Re: [midgard-user] Re: Sitegroup migration via xsg

[Philipp Rotmann, Linksystem Muenchen]

     Hi,

now I changed my repligard.xml file and exported SG0 again w/o
problems, even re-import via repligard went smoothly.

On 19.01.01 (23:01), Philipp Rotmann, Linksystem Muenchen wrote:
> > You import that xml.gz file into the new database and into
> > the new SG you just created (use the username and password
> > of the adminuser in the repligard.conf file), and ...

Well, repligard imported my SG0 into SG0 again, not in sitegroup
#1 what I intended by supplying it with the username and
password of sitegroup #1's admin user -- and everything seems
fine for me:

| mysql> select * from sitegroup;
| +----+----------------+-------+------------+
| | id | name           | realm | admingroup |
| +----+----------------+-------+------------+
| |  1 | wochenanzeiger |       |          2 |
| +----+----------------+-------+------------+
| 1 row in set (0.00 sec)
| 
| mysql> select id,name,sitegroup from grp where id=2;
| +----+------+-----------+
| | id | name | sitegroup |
| +----+------+-----------+
| |  2 | wanz |         1 |
| +----+------+-----------+
| 1 row in set (0.00 sec)
| 
| mysql> select id,uid,gid,sitegroup from member where gid=2;
| +----+-----+-----+-----------+
| | id | uid | gid | sitegroup |
| +----+-----+-----+-----------+
| |  2 |   2 |   2 |         1 |
| +----+-----+-----+-----------+
| 1 row in set (0.00 sec)
| 
| mysql> select id,username,password,sitegroup from person where id=2;
| +----+-----------+-----------+-----------+
| | id | username  | password  | sitegroup |
| +----+-----------+-----------+-----------+
| |  2 | wanzadmin | **test123 |         1 |
| +----+-----------+-----------+-----------+
| 1 row in set (0.00 sec)

My repligard.conf looks like this:

| dilbert:~/xsg > cat  ../sgmove-repligard.conf
| <?xml version="1.0" encoding="ISO-8859-1" ?>
| <Repligard xmlns="http://www.midgard-project.org/repligard/1.4">
|         <!-- Database description -->
|         <!-- Path to optionally compressed Repligard schema file -->
|         <database schema="/usr/local/share/midgard-lib/repligard.xml"
|                 name="newmidgard"
|                 username="midgard"
|                 password="midgard"
|                 encoding="ISO-8859-1"
|                 blobdir="/usr/local/apache/newblobs"
|         />
|         <!-- Login account description for Repligard operation -->
|         <login 
|                 username="wanzadmin"
|                 password="test123"
|         />
| </Repligard>

Any help appreciated.

     phr
-- 
Linksystem Muenchen GmbH                          [EMAIL PROTECTED]
Schloerstrasse 10                           http://www.link-m.de
80634 Muenchen                              Tel. 089 / 890 518-0
We make the Net work.                       Fax 089 / 890 518-77

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]