https://wiki.koozali.org/api.php?action=feedcontributions&user=SchulzStefan&feedformat=atomSME Server - User contributions [en]2024-03-29T11:03:16ZUser contributionsMediaWiki 1.35.5https://wiki.koozali.org/index.php?title=Zarafa_migration_to_SOGo&diff=30274Zarafa migration to SOGo2016-01-31T20:29:26Z<p>SchulzStefan: /* HOW-TO migrate from zarafa to sogo */</p>
<hr />
<div>{{Languages|pagename of English version}} <br />
{{Level|medium|The instructions on this page require a basic knowledge of linux.}}<br />
==HOW-TO migrate from zarafa to sogo==<br />
{{Note box|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. Tested on SME 9.1 with SOGo 2.3.5-1.centos6.i686}}<br />
<br />
{{Tip box|As a frontend SOGo recommends mozilla thunderbird http://sogo.nu/download.html#/frontends. Additionally the thunderbird addon lightning is needed. At last you need to have the SOGo-Connector for thunderbird.}}<br />
<br />
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.<br />
<br />
<br />
Let's start with pulling out the emails from zarafa. Thanks to Stephano for his hint using imapsync http://wiki.contribs.org/Imapsync.<br />
<br />
'''Stop receiving emails during imapsync:'''<br />
<br />
/usr/local/bin/svc -d /service/qpsmtpd/<br />
and:<br />
/usr/local/bin/svc -d /service/sqpsmtpd/<br />
<br />
<br />
'''Disable the user you want to migrate in zarafa:'''<br />
<br />
db accounts setprop $USERNAME Zarafa disabled<br />
and:<br />
signal-event user-modify $USERNAME<br />
<br />
{{Tip box|You may have a look here: http://wiki.contribs.org/Zarafa_on_SME_9#To_enable_an_individual_user_if_Global_is_disabled}}<br />
<br />
{{Tip box|Have a look at the last example on the page 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.'''}}<br />
<br />
'''When finished, start receiving email again:'''<br />
<br />
/usr/local/bin/svc -u /service/qpsmtpd/<br />
and:<br />
/usr/local/bin/svc -u /service/sqpsmtpd/<br />
<br />
Check on the server, if the emails are in the mail-folders. You may do this with webmail.<br />
<br />
<br />
Next step is to install thunderbird and configure thunderbird as a frontend of zarafa. <br />
We need to get the contacts and the calendar from zarafa in thunderbird. <br />
{{Note box|'''In thunderbird you have to add a remote adressbook. And also a network calendar.'''}}<br />
{{Tip box|This helps us to find the correct configuration: http://wiki.contribs.org/Zarafa_on_SME_9#Thunderbird.}}<br />
<br />
I used https://server:8089/ical/ which gives you a login to the zarafa ical service.<br />
<br />
{{Note box|'''The calendar has to be exported as an ics-file.'''}}<br />
<br />
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. <br />
<br />
{{Note box|'''If thunderbird is in sync with zarafa, you'll have to export the adresses in a ldif-file.'''}}<br />
<br />
{{Note box|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.}}<br />
<br />
'''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.<br />
<br />
{{Tip box|This is the page we need http://wiki.contribs.org/Sogo. Just follow the contrib.}}<br />
<br />
When finished, call the SOGo-gui. Login with your credentials. Move to the calendar. On the left side you'll see your personal calendar. <br />
'''Move with the mouse over it and click the right button. In the context you choose import a calendar (ics-file).'''<br />
Go ahead and import your formerly exported and saved ics-file from thunderbird. Do the same with your adressbook.<br />
<br />
{{Note box|When finished, check all data carefully. Zarafa has more/other fields as SOGo. There might be some work to do.}}<br />
<br />
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:<br />
<br />
https://your-IP or domain/SOGo/dav/user-name/Calendar/personal/<br />
and<br />
https://your-IP or domain/SOGo/dav/user-name/Contacts/personal/<br />
<br />
Be patient - depending on the amount of the data, syncing can take a while.<br />
<br />
Last thing you have to configure an imap-accout in thunderbird to get your emails from the smeserver.<br />
<br />
<br />
Now, '''if you want to sync SOGo with a mobile''' please follow the SOGo people on this page: http://sogo.nu/download.html#/frontends. 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.<br />
<br />
{{Note box|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.<br />
<br />
If everything is tested and working as expected, you may remove zarafa from your server. Additionally you may drop the zarafa-database.<br />
<br />
{{Tip box|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.}}<br />
<br />
That's it. Welcome to SOGo. Big thank to Stéphane de Labrusse and all others who contributed.<br />
<br />
[[Category:Howto]]</div>SchulzStefanhttps://wiki.koozali.org/index.php?title=Zarafa_migration_to_SOGo&diff=30235Zarafa migration to SOGo2016-01-29T18:03:58Z<p>SchulzStefan: </p>
<hr />
<div>{{Languages|pagename of English version}} <br />
{{Level|medium|The instructions on this page require a basic knowledge of linux.}}<br />
==HOW-TO migrate from zarafa to sogo==<br />
{{Note box|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. Tested on SME 9.1 with SOGo 2.3.5-1.centos6.i686}}<br />
<br />
{{Tip box|As a frontend SOGo recommends mozilla thunderbird 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.}}<br />
<br />
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.<br />
<br />
<br />
Let's start with pulling out the emails from zarafa. Thanks to Stephano for his hint using imapsync http://wiki.contribs.org/Imapsync.<br />
<br />
'''Stop receiving emails during imapsync:'''<br />
<br />
/usr/local/bin/svc -d /service/qpsmtpd/<br />
and:<br />
/usr/local/bin/svc -d /service/sqpsmtpd/<br />
<br />
<br />
'''Disable the user you want to migrate in zarafa:'''<br />
<br />
db accounts setprop $USERNAME Zarafa disabled<br />
and:<br />
signal-event user-modify $USERNAME<br />
<br />
{{Tip box|You may have a look here: http://wiki.contribs.org/Zarafa_on_SME_9#To_enable_an_individual_user_if_Global_is_disabled}}<br />
<br />
{{Tip box|Have a look at the last example on the page 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.'''}}<br />
<br />
'''When finished, start receiving email again:'''<br />
<br />
/usr/local/bin/svc -u /service/qpsmtpd/<br />
and:<br />
/usr/local/bin/svc -u /service/sqpsmtpd/<br />
<br />
Check on the server, if the emails are in the mail-folders. You may do this with webmail.<br />
<br />
<br />
Next step is to install thunderbird and configure thunderbird as a frontend of zarafa. <br />
We need to get the contacts and the calendar from zarafa in thunderbird. <br />
{{Note box|'''In thunderbird you have to add a remote adressbook. And also a network calendar.'''}}<br />
{{Tip box|This helps us to find the correct configuration: http://wiki.contribs.org/Zarafa_on_SME_9#Thunderbird.}}<br />
<br />
I used https://server:8089/ical/ which gives you a login to the zarafa ical service.<br />
<br />
{{Note box|'''The calendar has to be exported as an ics-file.'''}}<br />
<br />
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. <br />
<br />
{{Note box|'''If thunderbird is in sync with zarafa, you'll have to export the adresses in a ldif-file.'''}}<br />
<br />
{{Note box|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.}}<br />
<br />
'''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.<br />
<br />
{{Tip box|This is the page we need http://wiki.contribs.org/Sogo. Just follow the contrib.}}<br />
<br />
When finished, call the SOGo-gui. Login with your credentials. Move to the calendar. On the left side you'll see your personal calendar. <br />
'''Move with the mouse over it and click the right button. In the context you choose import a calendar (ics-file).'''<br />
Go ahead and import your formerly exported and saved ics-file from thunderbird. Do the same with your adressbook.<br />
<br />
{{Note box|When finished, check all data carefully. Zarafa has more/other fields as SOGo. There might be some work to do.}}<br />
<br />
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:<br />
<br />
https://your-IP or domain/SOGo/dav/user-name/Calendar/personal/<br />
and<br />
https://your-IP or domain/SOGo/dav/user-name/Contacts/personal/<br />
<br />
Be patient - depending on the amount of the data, syncing can take a while.<br />
<br />
Last thing you have to configure an imap-accout in thunderbird to get your emails from the smeserver.<br />
<br />
<br />
Now, '''if you want to sync SOGo with a mobile''' please follow the SOGo people on this page: http://sogo.nu/download.html#/frontends. 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.<br />
<br />
{{Note box|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.<br />
<br />
If everything is tested and working as expected, you may remove zarafa from your server. Additionally you may drop the zarafa-database.<br />
<br />
{{Tip box|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.}}<br />
<br />
That's it. Welcome to SOGo. Big thank to Stéphane de Labrusse and all others who contributed.<br />
<br />
[[Category:Howto]]</div>SchulzStefanhttps://wiki.koozali.org/index.php?title=Zarafa_on_SME_9&diff=27272Zarafa on SME 92015-01-20T18:57:56Z<p>SchulzStefan: /* smeserver-zarafa-unix */</p>
<hr />
<div>[[Category: Contrib]] [[Category: Groupware]] [[Category: Mail]] [[Category: Webapps]]<br />
{{Languages|Zarafa on SME 9}}<br />
{{Level|Advanced}}<br />
{{Note box|<br />
'''This wiki page is specific to SME9 only.'''<br />
<br />
'''There is a separate wiki page on how to install Zarafa 7.x on SME7 [[Zarafa|Zarafa on SME 7]].'''<br />
<br />
'''There is a separate wiki page on how to manually install Zarafa 7.x on SME8 [[Zarafa_on_SME8|Zarafa on SME 8]].'''<br />
}}<br />
{{Note box|This is a tested contrib and currently works on SME9beta2. It should be ready for production servers when SME9 reaches RC stage.<br />
This contrib will NOT work on SME 7 or SME8, there are unresolved dependencies.}}<br />
{{Warning box|This contrib does not use the standard mail locations of SME. The mail delivery is changed to a new service that uses MySQL to store mail messages and /home/e-smith/files/zarafa/ to store attachments. By default, MySQL and /home/e-smith/files/zarafa/ are included in the standard SME backup schema. Make sure you include these if you have a custom backup schema}}<br />
<br />
===Maintainers===<br />
Paul Floor<br />
<br />
===Version===<br />
{{#smeversion:smeserver-zarafa-unix}}<br />
<br />
===Description===<br />
http://www.zarafa.com<br />
<br />
Zarafa is a workgroup sharing solution based on the look-and-feel of Microsoft<br />
Outlook, which enables the sharing of mail and appointments from Outlook and a<br />
web-based interface.<br />
<br />
There is an additional interface called zarafa-webapp with additional features<br />
<br />
===Installation===<br />
<br />
====Latest zarafa tested version====<br />
Information on latest and previous versions of zarafa rpms can be found in the [http://download.zarafa.com/community/final/7.1/final-changelog-7.1.txt changelog document]<br />
<br />
====Zarafa rpms installation====<br />
<br />
http://download.zarafa.com/community/final/7.1/<br />
<br />
Select the appropriate rhel-6 arch for your application.<br />
<br />
Note: The free version contains the free 3 Outlook license version. if you are planning on using or testing this with any outlook clients, you will want to download the free version.<br />
<br />
tar -zxvf zcp*.tar.gz<br />
cd into zcp directory<br />
rm -f *dev*.rpm <<This is to remove the dev rpms, they are not required.<br />
yum localinstall *.rpm<br />
<br />
This will also install several dependencies.<br />
<br />
====smeserver-zarafa-unix====<br />
<br />
{{Note box| This contrib uses the unix plugin and automatically and properly enables all valid users as Zarafa users and all valid groups as Zarafa groups. Everything is initially done automatically for you by the post-install event so you do not need to do anything further. In addition, when you add or delete a user or group from the server manager, the user or group is automatically added or deleted in Zarafa. Also, any password change will automatically change the zarafa login password to match.<br />
<br />
By default, Zarafa is enabled for all users except admin. You can change this to 'per user' via db entries. <br /><br /><br />
If Zarafa was used with the db-plugin before, the InnoDB engine has to be enabled. To enable the InnoDB engine, run the following commands:<br />
<br />
db configuration setprop mysqld InnoDB enabled<br /><br />
expand-template /etc/my.cnf<br /><br />
sv t /service/mysqld<br /><br /><br />
Users accounts have to match the existing zarafa-users.}}<br />
Now install smeserver-zarafa-unix by performing the following:<br />
yum install smeserver-zarafa-unix --enablerepo=smecontribs<br />
<br />
NOTE: If you installed the GPL version of Zarafa, you must disable zarafa-licensed...<br />
config setprop zarafa-licensed status disabled <br />
<br />
After rpm install execute the following:<br />
signal-event zarafa-post-install<br />
signal-event post-upgrade; signal-event reboot<br />
<br />
=====MySQL=====<br />
The default MySQL database created is named 'zarafa' and the default user is named 'zarafa'<br />
<br />
The MySQL password is a strong random string and automatically set. See:<br />
config showprop zarafa-server DbPassword<br />
<br />
To reset the existing database password you can use:<br />
/etc/e-smith/events/actions/zarafa-reset-db-password<br />
<br />
=====Controlling Zarafa Services=====<br />
To control the zarafa services (start/stop etc.) the following command can be used:<br />
signal-event zarafa-services [option]<br />
Where the [option] can be on of the following:<br />
start|stop|restart|update|enabled|disabled<br />
The update option will rebuild the zarafa config files based on the current db settings.<br />
<br />
=====To disable global Zarafa for all users=====<br />
config setprop zarafa-server GlobalForward disabled<br />
signal-event user-modify<br />
<br />
=====To enable an individual user if Global is disabled=====<br />
db accounts setprop $USERNAME Zarafa enabled<br />
signal-event user-modify $USERNAME<br />
=====To enable the admin account=====<br />
db accounts setprop admin Zarafa enabled<br />
signal-event user-modify-admin<br />
<br />
====Webmail====<br />
Access with a browser,<br />
https://server/zarafa<br />
https://server/webmail (with Horde disabled '/server-manager > Email > Webmail Access')<br />
https://server/zarafa-webapp (This is the new Zarafa Webapp with additional features)<br />
<br />
====Outlook====<br />
To use MS Outlook install the zarafaclient-*.msi add-on contained in the win32 directory of zarafa-*.tar.gz<br />
<br />
=====Known working hardware=====<br />
Tested and working with Android 4.1.1 on a Samsung Galaxy 3S over a SSL connection / mail-push is working.<br />
<br />
<br />
<br />
===Additional Refrences===<br />
<br />
<b>The following is from the original Zarafa page and is provided for reference only. Items below are UNTESTED...</b><br />
<br />
<br />
====IMAP====<br />
The default ports for Zarafa are 8000 + default values<br />
so imap = 8143, imaps 8993<br />
<br />
SME and Zarafa use different folder naming.<br />
<br />
drafts > Drafts [client specific ?, Drafts is default Thunderbird-2.0]<br />
sent-mail > Sent Items<br />
trash > Deleted Items<br />
junkmail > Junk E-mail<br />
<br />
====Thunderbird====<br />
<br />
The Thunderbird client uses its own Trash folder, not the Zarafa "Deleted Items" folder, <br />
<br />
Change in the config editor<br />
<br />
Preferences > advance > config editor, find mail.server.number and add new string as below<br />
user_pref("mail.server.server5.port", "8143");<br />
user_pref("mail.server.server5.name", "zac@232.net");<br />
user_pref("mail.server.server5.numHdrsToKeep", 30);<br />
user_pref("mail.server.server5.timeout", 29);<br />
<br />
right click > new<br />
preference name > mail.server.server5.trash_folder_name<br />
value > Deleted Items<br />
<br />
+user_pref("mail.server.server5.trash_folder_name", "Deleted Items");<br />
<br />
Drafts and Sent Items can be changed in : Account Settings > user > Copies and Folders<br />
<br />
If junkmail exists just delete it.<br />
<br />
====Calendar CalDAV / iCal====<br />
Starting from Zarafa 6.30 there is decent CalDAV/iCal support for calendars (tasks not yet) that can be accessed with an CalDAV or iCal client eg, Thunderbird with Lighting, Sunbird, Evolution, MAC ical, ...<br />
{{Note box|Currently there is a bug in smeserver-zarafa package (bug #5410) that might prevent you from accessing the calendar. If so, replicate the steps described in the bug report to correct this and issue the following command from the commandline and you should be good to go: <tt>/etc/init.d/zarafa-ical restart</tt>}}<br />
<br />
* In Thunderbird/Lightning: New Calendar > on network > CalDAV > Location: see table below<br />
* In Evolution: New Calendar > Type: CalDAV > URL: see table below (remove the 'Use SSL' option)<br />
* In Mac iCal client: iCal > Preferences > click '+' > Account URL: see table below<br />
<br />
{| align="center" {{Prettytable}}<br />
|-<br />
|{{Hl3}}|'''URL'''<br />
|{{Hl3}}|'''Calendar''' <br />
|-<br />
|<nowiki>http://server:8089/ical/</nowiki><br />
|user's own default calendar via ical (not recommended)<br />
|-<br />
|<nowiki>http://server:8089/caldav/</nowiki><br />
|user's own default calendar<br />
|-<br />
|<nowiki>http://server:8089/caldav/<other-user></nowiki><br />
|0ther-user's calendar<br />
|-<br />
|<nowiki>http://server:8089/caldav/<user>/<calendar></nowiki><br />
|user's self created calendar in user's (own) store<br />
|-<br />
|<nowiki>http://server:8089/caldav/<user>/<calendar>/<subcal></nowiki><br />
|user's self created subcalendar in a self created calendar<br />
|-<br />
|<nowiki>http://server:8089/caldav/public/<calendar>/</nowiki><br />
|calendar folder in the public folder<br />
|-<br />
|colspan="2" {{Hl3}}|'''URL For MAC OSX ical client'''<br />
|-<br />
|<nowiki>http://server:8089/caldav/</nowiki><br />
|User's calendar list<br />
|-<br />
|<nowiki>http://server:8089/caldav/<other-user></nowiki><br />
|Other-users calendar list<br />
|-<br />
|<nowiki>http://server:8089/caldav/public</nowiki><br />
|Public folders list<br />
|-<br />
|{{Hl3}}|'''URL'''<br />
|{{Hl3}}|'''Tasks''' <br />
|-<br />
|-<br />
|<nowiki>http://server:8089/caldav/<user>/tasks</nowiki><br />
|user's default tasks list. '''ONLY WITH Zarafa 6.40.2 or newer !!'''<br />
|-<br />
|}<br />
Port 8089 is used for secure SSL connections, port 8088 for unsecured connections.<br />
<br />
====Mobile synchronisation====<br />
To enable synchronization of your mobile phone through ActiveSync with Zarafa, Z-push needs to be installed.<br />
<br />
z-push now has RPM's built for RHEL6 making the install simple...<br />
<br />
For i386 go here http://download1.rpmfusion.org/free/el/updates/6/i386/repoview/letter_z.group.html<br />
<br />
For X86_64 go here http://download1.rpmfusion.org/free/el/updates/6/x86_64/repoview/letter_z.group.html<br />
<br />
You will need 2 packages, <b>z-push</b> and <b>z-push-zarafa</b>. Download the latest packages, as of this writing, 2.0.7-1 works without any issue.<br />
<br />
yum localinstall z-push*<br />
<br />
=====Know working hardware=====<br />
Tested and working with Android 4.1 on a Samsung Galaxy 3S over a SSL connection / mail-push is working.<br />
<br />
Tested and working with WinMobile 6.1 on a HTC TyTN II over a SSL connection / mail-push is working.<br />
<br />
Tested and working with WinMobile 6.1 on an upgraded QTEK9100 over SSL connection. Push mail not tested.<br />
<br />
Tested and working with WinMobile 2003 on an QTEK9090 over SSL connection. Push mail not tested.<br />
<br />
Tested and working with IPHONE. Push mail not tested.<br />
<br />
Tested and working with Nokia 6120 Classic. Push mail not tested.<br />
<br />
=====Additional Mobile Synchronization Information=====<br />
<br />
'''SSL Synchronization with Windows Mobile devices'''<br />
<br />
Synchronization over a secured connection is possible if you can add your site as a trusted one with corresponding certificate on your mobile.<br />
<br />
This is the case for Windows mobile 6 (WM6) devices. Problems should occurs on several WM5 devices, because of a bug that limits addition of certificates with that OS.<br />
Here are the steps to add your server as a trusted platform on your WM6 mobile :<br />
1. to convert your server's certificate into a (Binary coded DER X.509) .cer file you can either run the following command and skip to step 4 or just start at the next step.<br />
openssl x509 -in /home/e-smith/ssl.pem/<certificate name>.pem -inform PEM -out /root/<certificate name>.cer -outform DER<br />
2. copy your server's certificates located in /home/e-smith/ssl.crt/ on a Windows XP/Vista computer<br />
3. we need to transform those .crt certificates to .cer certificate ( same type of certificate but .crt are text-encoded ). To do so :<br />
*in microsoft windows open a certificate by double clicking on it<br />
*in "Detail" Tab pane choose "Copy to file" <br />
*Choose Binary coded DER X.509 (.cer) format<br />
*save resulting .cer certificates on local machine<br />
4. transfer .cer certificates on your mobile using windows explorer<br />
5. When done, on your WM6 mobile use file explorer to open those certificates. When opening one, the certificate is automatically added to trusted sites.<br />
6. You can then change your Exchange server parameters to use SSL. It will be asked to reenter your password.<br />
<br />
====Command line admin====<br />
man zarafa for details<br />
<br />
List users:<br />
/usr/bin/zarafa-admin -l<br />
<br />
Update a user to admin status:<br />
/usr/bin/zarafa-admin -u <username> -a 1<br />
<br />
====Migrating users and data to Zarafa====<br />
<br />
http://wiki.contribs.org/Imapsync<br />
<br />
====Customizing the Calendar====<br />
<br />
The labels and categories in the calendar can be altered to suit user requirements.<br />
<br />
The labels are defined in<br />
/usr/share/zarafa-webaccess/client/layout/dialogs/standard/appointment.php beginning at line 225<br />
The categories are in <br />
/usr/share/zarafa-webaccess/client/layout/dialogs/modal/categories.php beginning at line 51.<br />
<br />
==== Zarafa Bayesian learning ====<br />
<br />
This howto enables SpamAssasin [[:Zarafa Bayesian Learning? | Bayesian learning for Zarafa]]<br />
<br />
==== Mail Sorting ====<br />
Maildrop as configured with <br />
[http://www.dungog.net/wiki/Smeserver-mailsorting smeserver-mailsorting] will deliver to ~/Maildir rather than zarafa<br />
<br />
Procmail will sort to zarafa for enabled users from smeserver-mailsorting-1.2-29, <br />
<br />
==== Backup and restore ====<br />
===== Backup =====<br />
Backup is done normally with [[SME_Server:Documentation:Administration_Manual:Chapter10|standard backup tool]] provided with SME, or with other backup contribs ([[affa]]). Be sure that those datas are correctly saved :<br />
*zarafa database. All backup tools are saving all mysql database in standard mode, it should be Ok<br />
*attachment files. Those one are stored in '/home/e-smith/files/zarafa' directory.<br />
<br />
===== Restore =====<br />
{{Warning box| Database restoring has been tested when facing an issue during upgrade of zarafa from 6.20 to 6.20.4. No problems were detected, meaning there is no compatibility issues between those 2 versions. It should not be the case with every version}}<br />
<br />
Standard full restore function provided by SME or other backup tools will restore Zarafa datas.<br />
In certain cases, it is interessant to restore only zarafa database backup (ie update issue). This is done following those steps :<br />
*stopping zarafa server<br />
/etc/rc.d/init.d/zarafa-server stop<br />
*deleting all tables currently into zarafa database<br />
mysql zarafa -e "show tables" | grep -v Tables_in | grep -v "+" | \<br />
gawk '{print "drop table " $1 ";"}' | mysql zarafa<br />
*import the backup of zarafa database<br />
cd /directory/containing/your/backup<br />
mysql < zarafa.dump<br />
* restart zarafa server<br />
/etc/rc.d/init.d/zarafa-server start<br />
<br />
=== Bugs ===<br />
Check your logs when troubleshooting or reporting bugs<br />
<br />
tail -f /var/log/zarafa/*<br />
tail /var/log/slapd<br />
tail /var/log/messages<br />
<br />
Please raise bugs under the SME-Contribs section in {{BugzillaFileBug|product=|component=|title=bugzilla}}and select the smeserver-zarafa component or use {{BugzillaFileBug|product=SME%20Contribs|component=smeserver-zarafa|title=this link}}.<br />
<br />
[http://bugs.contribs.org/buglist.cgi?query_format=advanced&bug_status=UNCONFIRMED&bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&value0-0-0=Open&component=smeserver-zarafa&product=SME%20Contribs Search open bugs] for smeserver-zarafa at bugs.contribs.org<br />
<br />
Zarafa: use their forum for zarafa specific bug reporting, http://forums.zarafa.com/<br />
<br />
{{#bugzilla:columns=id,product,version,status,summary |sort=id|order=desc |component=smeserver-zarafa|noresultsmessage="No open bugs found."}}</div>SchulzStefan