[turba] Moving from old webemail to turba addressbooks

[Matthias Mahrholz]

Hi,

I have two tests realized:

1. Test

imp2turba.pl / imp2horde.pl
---------------------------
        .
        .
        my $domain = 'sunny.urz.uni-magdeburg.de';
        .
        # Remove the @domain.com part from the $owner, doesn't work in Turba
        $owner =~ s/\@.*$//;
        $owner .= "\@$domain";
        .
        .

./imp2turba.pl

in Database horde - table turba_objects owner_id
all @sunny.urz.uni-magdeburg.de !!

in Database horde - table imp_addr user e.g.:
hammer@dfnserv1.urz.uni-magdeburg.de
hammer@sunny.urz.uni-magdeburg.de

./imp2horde.pl

DBD::mysql::st execute failed: Duplicate entry
'hammer@sunny.urz.uni-magdeburg.de-horde-identities' for key 1 at ./imp2horde.pl
line 73.
DBD::mysql::st execute failed: Duplicate entry
'hammer@sunny.urz.uni-magdeburg.de-horde-identities' for key 1 at ./imp2horde.pl
line 73.

in Database horde - table imp_pref user e.g.:
hammer@dfnserv1.urz.uni-magdeburg.de
hammer@sunny.urz.uni-magdeburg.de


2. Test

imp2turba.pl / imp2horde.pl
---------------------------
        .
        .
        # $owner =~ s/\@.*$//;
        # $owner .= "\@$domain";
        .
        .

./imp2turba.pl

in Database horde - table turba_objects owner_id e.g:
hammer@dfnserv1.urz.uni-magdeburg.de
hammer@sunny.urz.uni-magdeburg.de
o.k.

./imp2horde.pl

in Database horde - table horde_pref user e.g.:
hammer@dfnserv1.urz.uni-magdeburg.de
hammer@sunny.urz.uni-magdeburg.de
o.k.


B U T

in two tests after 'Log in':

- no Options
- no entries in 'My Addressbook'


New entry in 'Options' and 'My Addressbook':
owner_id in turba_objects and pref_uid in horde_prefs without domain!


Regards

Matthias


> > We are replacing our old IMP version 2.2.7 with version 3.1 + turba.
> > Lots of the users of this service have address book entries, and I
> > was wondering
> > about how I should move these address book entries into turba.
>
> There are scripts provided with turba to migrate the databases from IMP 2.2.x
> to Horde 2.x and Turba 1.x.  These scripts may need to be modifed by the
> user for things like database used, etc.
>
> >  I found a method for moving the addresses in SQL :
> >
> >  insert turba_objects (object_id, owner_id, object_name, object_alias,
> > object_email) select MD5(RAND()) as object_id,
> > REPLACE(user,'@localhost','') as owner_id, fullname, nickname, address
> > from imp_addr;
>
> That may work.  But I'd use the scripts provided...
>
> > It appears from the SQL command that I found, that the user's imap
> > server will get
> > split out in the transition, and could lead to the possibility that a
> > users address
> > book in Turba will be viewable/editable by multiple accounts (which may
> > not be the same person).
>
> Then modify it not to split out the realm.
>
> > Are my fears justified?
>
> Yes.
>
> >  How should I be handling the use of Turba with multiple
> > imap servers?
>
> Use realm support in IMP and your horde authentication, and keep the realm
> info when you migrate the database.
>
> > Ie, without moving over the old addresses, are users of the new
> > IMP/Turba setup going to suffer username conflicts?
>
> There is support for multiple domains.  Just be sure to configure it
> properly.
>
> >  Note:// we have horde/imp configured such that IMP can handle the login
> > into horde.
>
> Just make sure you setup realms right in IMP, and import the IMP 2.x
> stuff into Horde/IMP/Turba with the realm info intact (or added, if need
> be).
>
> The question is a little vague to provide concrete help at this time.
>
> >  Thanks,
> >
> >   Matt Larson
>
> --
> Eric Rostetter
> The Department of Physics
> The University of Texas at Austin
>
> Why get even? Get odd!