Koozali.org: home of the SME Server

Obsolete Releases => SME 9.x Contribs => Topic started by: SchulzStefan on October 16, 2015, 07:59:54 PM

Title: HOW-TO migrate from ZARAFA to SOGo
Post by: SchulzStefan on October 16, 2015, 07:59:54 PM
First thing to be said is, that if you are used to work with invitations, a frontend is needed. If you are used to  zarafa-webaccess you know at least, that invitations for your calendar can easily be handled. Don't expect this with the SOGo web-gui. There are no buttons to accept or decline invitations. I couldn't find one and it seems to me, there is none.

As a frontend SOGo recommends mozilla thunderbird http://www.sogo.nu/downloads/frontends.html (http://www.sogo.nu/downloads/frontends.html). Additionally the thunderbird addon lightning is needed. At last you need to have the SOGo-Connector for thunderbird.

If you are used to get with activesync contacts, calendar, tasks and emails on your mobile, for my mobile it can only be done with two accounts. One exchange account to sync calendar and contacts with SOGo, and one imap-account to sync emails against your (imap-) smeserver. SOGo activesync seems not to be possible syncing emails with my mobile. Maybe it syncs other models, you have to find out for yourself.

Let's start with pulling out the emails from zarafa. Thanks to Stephano for his hint using imapsync http://wiki.contribs.org/Imapsync (http://wiki.contribs.org/Imapsync).

Stop receiving emails during imapsync:

/usr/local/bin/svc -d /service/qpsmtpd/
/usr/local/bin/svc -d /service/sqpsmtpd/

Disable the user you want to migrate in zarafa:

db accounts setprop $USERNAME Zarafa disabled
signal-event user-modify $USERNAME

You may have a look here: http://wiki.contribs.org/Zarafa_on_SME_9#To_enable_an_individual_user_if_Global_is_disabled (http://wiki.contribs.org/Zarafa_on_SME_9#To_enable_an_individual_user_if_Global_is_disabled)

Have a look at the last example on the page http://wiki.contribs.org/Imapsync (http://wiki.contribs.org/Imapsync). Just turn the ports and modify the command for your users. Depending on the ammount of your emails, this can take a long time.

When finished, start receiving email again:

/usr/local/bin/svc -u /service/qpsmtpd/
/usr/local/bin/svc -u /service/sqpsmtpd/

Check on the server, if the emails are in the mail-folders. You may do this with webmail.

Next step is to install thunderbird and configure thunderbird as a frontend of zarafa. We need to get the contacts and the calendar from zarafa in thunderbird. In thunderbird you have to add a remote adressbook. And a network calendar. This helps us to find the correct configuration: http://wiki.contribs.org/Zarafa_on_SME_9#Thunderbird (http://wiki.contribs.org/Zarafa_on_SME_9#Thunderbird).

I used https://server:8089/ical/ which gives you a login to the zarafa ical service.

The calendar has to be exported as an ics-file.

For pulling out the contacts from zarafa I used the tzpush add-on for thunderbird. You'll find your contacts in your personal adressbook in thunderbird. If thunderbird is in sync with zarafa, you'll have to export the adresses in a ldif-file.

Check the files - you may do this by removing in thunderbird the zarafa-sync. Just delete the adressbook and the calendar you created before. Restart thunderbird and import the ldif-file and the ics-file. Have a close look at all data. If you alter data in thunderbird, export again in ldif or ics.

Now clear all data in thunderbird. I tried to sync from thunderbird to SOGo and found out (for me) the other way round might be better. So let's install SOGo.

This is the page we need http://wiki.contribs.org/Sogo (http://wiki.contribs.org/Sogo). Just follow the contrib.

When finished, call the SOGo-gui. Login with your credentials. Move to the calendar. On the left side you'll see your personal calendar. Move with the mouse over it and click the right button. In the context you choose import a calendar (ics-file). Go ahead and import your formerly exported and saved ics-file from thunderbird. Do the same with your adressbook.

When finished, check all data carefully. Zarafa has more/other fields as SOGo. There's some work to do.

If this is done, we'll have to sync thunderbird with SOGo. In fact it's nearly the same way how we configured thunderbird to sync with zarafa. All we need is the CalDAV and CardDAV of SOGo. You'll find this by clicking with the right button of your mouse while hovering over your calendar and your adressbook. Click on settings. Choose the right tab, you'll see the link we need. It should look like this:

https://your-IP or domain/SOGo/dav/user-name/Calendar/personal/ and
https://your-IP or domain/SOGo/dav/user-name/Contacts/personal/

Be patient - depending on the amount of the data, syncing can take a while.

Last thing you have to configure an imap-accout in thunderbird to get your emails from the smeserver.

Now, if you want to sync SOGo with a mobile please follow the SOGo people on the bottom of this page: http://www.sogo.nu/downloads/frontends.html (http://www.sogo.nu/downloads/frontends.html). For my Nokia E7-00 I had to configure two mailboxes. One as an Exchange-Server which syncs the calendar and the contacts with SOGo. And another account as an IMAP-account to sync emails with the smeserver. Make sure that the settings for receiving email through IMAP in the server-manager are correct.

At least I found out if you synced zarafa with z-push to your mobile, you should remove z-push. That interferes with the SOGo-activesync. This works for me, I can't tell for other mobiles.

If everything is tested and working as expected, you may remove zarafa from your server. Additionally you may drop the zarafa-database.

Be careful with contacts and calendar - check carefully. On my mobile I'm still unhappy with the synced calendar. It seems some appointments are synced, others not. I'll have a look on this, but maybe, it depends on my mobile.

That's it. Welcome to SOGo. Big thank to Stéphane de Labrusse and all others who contributed.
Title: Re: HOW-TO migrate from ZARAFA to SOGo
Post by: stephdl on October 17, 2015, 08:06:25 AM
+1 merci
Title: Re: HOW-TO migrate from ZARAFA to SOGo
Post by: Stefano on October 17, 2015, 08:51:12 AM
-GONE--
Title: Re: HOW-TO migrate from ZARAFA to SOGo
Post by: SchulzStefan on October 18, 2015, 10:37:02 PM
I'll do, if I found a solution for this:

Quote
Be careful with contacts and calendar - check carefully. On my mobile I'm still unhappy with the synced calendar. It seems some appointments are synced, others not. I'll have a look on this, but maybe, it depends on my mobile.

I tried to import the ics-file in TB, syncing from TB to SOGo. No luck at all syncing completly my mobile. I tried to import the ics-file in SOGo, also no luck. Some appointments are synced, some not. Of course, all (and only) imported appointments. Seems new ones are working. Initial syncing from the mobile to SOGo didn't work at all. Meaning syncing contacts and calendar from my mobile to SOGo to my untouched SOGo account.

I have to check the raw-data while creating an appointment in TB, in SOGo and with my mobile. Could be an approach to find the reason for this buggy behaviour. The SOGo people say on their homepage: "Microsoft Outlook and ActiveSync - SOGo provides native Microsoft ActiveSync support. Mobile devices such as Apple iPhone, Android, Windows Phone, and BlackBerry 10 can fully synchronize emails, contacts, events and tasks with SOGo." Read this: http://www.sogo.nu/ (http://www.sogo.nu/).

At least for a Nokia E7-00 that's not true. And this mobile provides native M$ ActiveSync support. I.e. http://globephone.blogspot.de/2010/12/nokia-e7-reviews.html (http://globephone.blogspot.de/2010/12/nokia-e7-reviews.html). And I can assure, it works on a native M$ Exchange Server as well, as I already said for z-push and zarafa.


To all who might consider to migrate from zarafa (or any other groupware) to SOGo:

READ AND SEARCH THIS CAREFULLY: http://www.sogo.nu/bugs/view_all_bug_page.php

Search especially for all calendar related bugs, activesync, importing ics-files and mobiles. It seems to me, SOGo is not stable enough for a production enviroment. IMVHO the SOGo-people should seriously think about adapting z-push.

For the moment (for me), zarafa is the better choice.
Title: Re: HOW-TO migrate from ZARAFA to SOGo
Post by: guest22 on October 19, 2015, 10:04:30 AM
JFI I migrated a user data from Zarafa to Sogo using imapsync and the Sogo webgui for importing contacts and calendar. Activesync with an android device was setup in no time.
Title: Re: HOW-TO migrate from ZARAFA to SOGo
Post by: SchulzStefan on October 19, 2015, 10:25:52 AM
Quote
Posted by: RequestedDeletion

JFI I migrated a user data from Zarafa to Sogo using imapsync and the Sogo webgui for importing contacts and calendar. Activesync with an android device was setup in no time.

One thing is migrating and setup - the other thing, which seems to be more important to me, is to work flawlessly, i.e.: http://www.sogo.nu/bugs/view.php?id=3368 (http://www.sogo.nu/bugs/view.php?id=3368)

As I said:

Quote
READ AND SEARCH THIS CAREFULLY: http://www.sogo.nu/bugs/view_all_bug_page.php

Search especially for all calendar related bugs, activesync, importing ics-files and mobiles. It seems to me, SOGo is not stable enough for a production enviroment. IMVHO the SOGo-people should seriously think about adapting z-push.
Title: Re: HOW-TO migrate from ZARAFA to SOGo
Post by: SchulzStefan on January 29, 2016, 02:36:01 PM
Hi Stephan, many thanks, impressive job.

please, wolud you mind to get a wiki access and put this how to in the wiki?

Thank you again

Did as you requested. I'm not quite sure if the how-to is o.k. and at the right place. Should be under How-To's, can't see it so far. Could anybody give me a feedback?
Title: Re: HOW-TO migrate from ZARAFA to SOGo
Post by: TerryF on January 29, 2016, 03:43:46 PM
Hi

The page needs to be renamed so it can be categorised.

It will need a wiki admin to rename it.
Title: Re: HOW-TO migrate from ZARAFA to SOGo
Post by: guest22 on January 29, 2016, 03:52:42 PM
It will need a wiki admin to rename it.


http://wiki.contribs.org/Zarafa_migration_to_SOGo
Title: Re: HOW-TO migrate from ZARAFA to SOGo
Post by: TerryF on January 29, 2016, 04:07:13 PM
Now that HF has done that, thanks HF :-), you should have a look at the formatting etc..

Have a look at other pages on paras, headings etc
Title: Re: HOW-TO migrate from ZARAFA to SOGo
Post by: SchulzStefan on January 29, 2016, 07:05:51 PM
Now that HF has done that, thanks HF :-), you should have a look at the formatting etc..

Have a look at other pages on paras, headings etc

Done.

https://wiki.contribs.org/Zarafa_migration_to_SOGo
Title: Re: HOW-TO migrate from ZARAFA to SOGo
Post by: SchulzStefan on January 29, 2016, 07:09:56 PM
BTW I opened a bug in the sogo bugtracker for the mobile syncing with a Nokia symbian device. http://sogo.nu/bugs/view.php?id=3460 (http://sogo.nu/bugs/view.php?id=3460). Maybe someone wants to follow.
Title: Re: HOW-TO migrate from ZARAFA to SOGo
Post by: TerryF on January 29, 2016, 11:32:03 PM
Sweet..a thing of beauty :-) many hands make etc etc...thank you