[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