[turba] Difficult upgrade from 1.2 to 2.x
Piotr Legiecki
piotrlg at sci.pam.szczecin.pl
Wed May 28 13:40:07 UTC 2008
Michael Rubinsky pisze:
....
> Well, I'm assuming that you know which address book actually belongs to
> user1 at relam.a vs user1 at realm.b....I'm also assuming you are using a SQL
> backend for address book storage since you do not mention this.
mysql
> If you were NOT using shares it's an easy fix - you update the
> 'owner_id' field in the turba_objects (or whatever table you have been
> using) to the correct username. If the entries that currently have
> 'user1' as the owner all belong to user1 at realm.a it's an easy:
>
> UPDATE turba_objects SET owner_id='user1.realm.a' WHERE owner_id='user1';
Ok, but what if I have 500 users? Is it possible to add realm.a to user1
automatically? Or SQL can't do that?
> ...but if the contacts marked as owned by user1 are mixed between
> different users, you will have to update them in groups.
> UPDATE turba_objects SET owner_id='user1.realm.a' WHERE object_id IN
> (....);
What do you mean by groups?
From what I have seen in turba database no one can say to what server
one user belongs?
> If you are using shares it is a bit more complicated...if that's the
> case respon d back to the list and we can go from there.
I think I'm not using shares.
Thanx very much
P.
More information about the turba
mailing list