Difference between revisions of "Talk:Zarafa"

From SME Server
Jump to navigationJump to search
m (Added information on updating php-mapi if upgraded php to version 5.3)
 
(40 intermediate revisions by 8 users not shown)
Line 1: Line 1:
 +
=== Zarafa7 on SME8 ===
 +
If you want to test the new Zarafa 7 version on SME8b6: install as described [[Zarafa | here]], download the needed files from [[bugzilla:5789]] => Comment#5 and extract as described, make the following symbolic links and restart apache:
 +
ln -s /lib/libcrypto.so.0.9.8e /usr/lib/libcrypto.so.0.9.8
 +
ln -s /lib/libssl.so.0.9.8e /usr/lib/libssl.so.0.9.8
 +
sv t httpd-e-smith
 +
 +
=== Dependancies ===
 +
 +
Here are links to all the dependencies that I used for version 7.0.1.28479 (free):
 +
libicu - ftp://ftp.pbone.net/mirror/ftp.centos.org/5.7/os/i386/CentOS/libicu-3.6-5.16.i386.rpm
 +
poppler-utils - ftp://ftp.pbone.net/mirror/ftp.centos.org/5.7/os/i386/CentOS/poppler-utils-0.5.4-4.4.el5_6.17.i386.rpm
 +
poppler - ftp://ftp.pbone.net/mirror/ftp.centos.org/5.7/os/i386/CentOS/poppler-0.5.4-4.4.el5_6.17.i386.rpm
 +
hicolor-icon-theme - ftp://ftp.pbone.net/mirror/ftp.centos.org/5.7/os/i386/CentOS/hicolor-icon-theme-0.9-2.1.noarch.rpm
 +
bitstream-vera-fonts - ftp://ftp.pbone.net/mirror/ftp.centos.org/5.7/os/i386/CentOS/bitstream-vera-fonts-1.10-7.noarch.rpm
 +
w3m - ftp://ftp.pbone.net/mirror/ftp.centos.org/5.7/os/i386/CentOS/w3m-0.5.1-18.el5.i386.rpm
 +
 +
If you are upgrading from version 6 you will also need these dependencies:
 +
MySQL-python - ftp://ftp.pbone.net/mirror/ftp.centos.org/5.7/os/i386/CentOS/MySQL-python-1.2.1-1.i386.rpm
 +
mx - http://mirror.centos.org/centos/5/os/i386/CentOS/mx-2.0.6-2.2.2.i386.rpm
 +
 +
- Garth Kirkwood (girkers)
 +
 +
=== Installation ===
 +
 +
To make things a bit more easy for non Zarafa experts, I used this procedure for a clean install.
 +
Get zcp 7.01, unpack, remove the devel packages and install all rpm's:
 +
yum localinstall *.rpm
 +
All packages have dependencies that cannot be resolved if you install only part of the rpm's (as suggested installation instruction for zcp 6.40).
 +
 +
Then install smeserver-zarafa. I could not retrieve this file from the smevdev repository (sme8 uses another one?).
 +
Get it manually and install:
 +
wget http://ftp.nluug.nl/os/Linux/distr/smeserver/releases/7/smedev/i386/RPMS/smeserver-zarafa-0.9.0-53.el4.sme.noarch.rpm
 +
yum localinstall smeserver-zarafa-0.9.0-53.el4.sme.noarch.rpm
 +
 +
/etc/e-smith/events/actions/zarafa-install
 +
 +
expand the php-mapi patch patch and and the symbolic links (see first text block above: Zarafa7 on SME8).
 +
 +
If you use webaccess mobile, change 86ZarafaAlias template [[bugzilla:6552]]
 +
 +
If you use z-push, download and install (see [[Zarafa | here]] mobile synchronization).
 +
You have to change the name of the installation folder from z-push<version #> to z-push, because this is expected by the smeserver-zarafa package.
 +
The download extracts correctly but leaves the file and group ownership to some unknown user 33. I changed that (might not be necessary, I consider it a small security risk).
 +
chown -R root:root /var/www/html/z-push
 +
 +
Then post-upgrade and restart.
 +
 +
For upgrades (tested with 6.40.2): zarafa-server does not start, there is an  error message in the /var/log/zarafa/zarafa-server.log file which tells you to update the database first. A python script is provided to do just that. See also [[http://doc.zarafa.com/7.0/Administrator_Manual/en-US/html/upgrading.html zarafa administration manual]]!
 +
Stop running zarafa services, make sure a backup of the zarafa mysql database exists, install MySQL-python, run update script.
 +
 +
yum install MySQL-python
 +
 +
python /usr/share/doc/zarafa/zarafa7-upgrade
 +
 +
Reports the script failes with wrong inno_db settings for mysql are on the zarafa forums. So verify your local MySQL innodb settings match the required values [[http://doc.zarafa.com/7.0/Administrator_Manual/en-US/html/_memory_usage_setup.html zarafa administration manual]]). 
 +
 +
===Sogo===
 +
 +
FYI, I'm now using [[Sogo]] instead of zarafa, hence I have stopped work on smeserver-zarafa.
 +
 +
Sogo may not be as complete as zarafa, but is simpler to intergrate/maintain and will likely have a wider usage.
 +
 +
[[User:Snoble|Snoble]] 01:59, 14 March 2010 (UTC)
 +
 +
I will mantain it for now, Paul Floor
 +
 +
=== Suggestions===
 
If you can advise on standard configuration, please make it a bug so it is added to the rpm
 
If you can advise on standard configuration, please make it a bug so it is added to the rpm
  
 
[[User:Snoble|Snoble]] 07:32, 22 December 2008 (UTC)
 
[[User:Snoble|Snoble]] 07:32, 22 December 2008 (UTC)
  
−
----
 
  
−
Is this interesting enough to incorporate, or make it a separate wiki entry and reference to it ?!
+
=== smeserver-zarafa-0.9-48===
 +
 
 +
/etc/e-smith/events/actions/zarafa-services-stop has been removed
 +
 
 +
/etc/e-smith/events/actions/zarafa-services
 +
Usage: start|stop|restart|enabled|disabled
 +
 +
start services
 +
stop services
 +
restart services
 +
enabled - set db values to enabled, zarafa will start on reboot
 +
disabled - set db values to disabled, zarafa won't start on reboot
 +
 
 +
 
 +
InnoDB support is enabled automatically, we need to add this note later
 +
 
 +
{{Note box| InnoDB support in MySql has been enabled in order to get zarafa-server running, for details see [[MySQL#Enable_InnoDB_engine]]}}
  
−
--[[User:Jester|jester]] 22:25, 21 February 2009 (UTC)
+
=== zarafa-6.40 ===
  
 +
yum localinstall libvmime-0*.rpm libical-0*.rpm zarafa-*.rpm catdoc-*.rpm
  
−
=== SpamAssasin Bayesian learning for Zarafa ===
+
==== indexing service ====
  
−
The DMZS script (LGPL) works over IMAP. It reads the mail from two folders (LearnAsSpam and LearnAsHam) and feeds it to SpamAssasin's sa-learn. This script is implemented here in a way that it makes use of public folders in Zarafa.
+
The catdoc-rpm is needed for the new [http://www.zarafa.com/news/26-jan-zarafa-releases-community-version-its-collaboration-platform-640 indexing service] that is introduced with Zarafa 6.40... but the indexing-service is not yet handled by smeserver-zarafa. --[[User:Jester|jester]] 15:42, 13 February 2010 (UTC)
  
−
==== Installation ====
+
the catdoc rpm has un meet dependencies on SME 7 so it's only listed on discussion not the main page,
−
  wget http://www.dmzs.com/tools/files/spam/DMZS-sa-learn.pl
 
−
  mv DMZS-sa-learn.pl /usr/bin/
 
  
−
Create a user-account in Zarafa for reading the public spam-folders. Replace the <MyPassword> with a proper strong password.
+
yes it's not implemented yet, it'll only be implemented in sme8 unless others find the dependencies
−
  zarafa-admin -c 'SpamAdmin' -p '<MyPassword>' -f 'Spam Administration Account' -e root@localhost
 
  
−
Now we'll edit the script and replace the Server, User and Password values. We will also have to replace two folder names throughout the script:
+
[[User:Snoble|Snoble]] 01:13, 20 February 2010 (UTC)
−
  pico /usr/bin/DMZS-sa-learn.pl
 
  
−
Replace the values so it looks like below, replace <MyPassword> for the password you have chosen in a previous step:
+
Dependencies are poppler and poppler-utils.  Available here:
  
−
  my $imap = Mail::IMAPClient->new( Server=> '127.0.0.1:8143',
+
ftp://ftp.pbone.net/mirror/apt.kde-redhat.org/kde-redhat/redhat/4/i386/RPMS.stable/poppler-0.5.4-0.3.el4.i386.rpm
−
                                    User => 'SpamAdmin',
 
−
                                    Password => '<MyPassword>',
 
−
                                    Debug => $debug);
 
  
−
Throughout the script (be aware of the quotes):
+
ftp://ftp.pbone.net/mirror/apt.kde-redhat.org/kde-redhat/redhat/4/i386/RPMS.stable/poppler-utils-0.5.4-0.3.el4.i386.rpm
−
  replace: 'spam'  ->  with: 'Public folders/LearnAsSpam'
 
−
  replace: 'not-spam'  ->  with: 'Public folders/LearnAsHam'
 
−
  remove: --showdots
 
  
−
Set proper rights on the script:
+
NOTE: Some poppler versions have been identified with security issues.  I didn't have time to look into this version.
−
  chmod 550 /usr/bin/DMZS-sa-learn.pl
 
  
−
Login to Zarafa with an account that has admin rights and make two new folders LearnAsSpam and LearnAsHam under: Public folder > Public folders.
+
Paul Floor.
−
Set the permissions (right-click folder > Properties > Permission-tab) on both these new folders to:
 
−
  Spam administration account
 
−
  * Folder visible
 
−
  * Read items
 
−
  * Edit items: all
 
−
  * Delete items: all
 
−
 
 
−
  Everyone (and/or other users/groups you've added at least need:)
 
−
  * Folder visible
 
−
  * Create items
 
−
  * Edit items: none
 
−
  * Delete items: none
 
−
{{Note box| Dropping mail in the public 'LearnAsHam' folder may pose a privacy problem if permissions are set less restrictive as shown above!}}
 
  
−
Create a new crontab fragment:
+
=== SME 8 beta ===
−
  pico /etc/e-smith/templates/etc/crontab/91_SpamAssasinLearn
 
  
−
Add the following to the template (change the execution times to your own likings):
+
==== php 5.2.10 ====
−
  # Running the Spamassasin Bayesian SPAM learning script every hour from 8:00 to 22:00 during weekdays
 
−
  * 8-22 * * 1-5 root /usr/bin/DMZS-sa-learn.pl
 
  
−
Make the new fragment active by expanding the template:
+
The php mapi files zarafa uses are compiled against 5.1.6, if sme 8 uses 5.2.10 we have a problem
−
  expand-template /etc/crontab
 
  
−
==== Configuration ====
+
here is one workaround http://forums.zarafa.com/viewtopic.php?f=9&t=3263&p=18753#p18753
−
Bayesian learning has to be enabled and configured in SME, you can read how to do this in: [[Email#Setup_Blacklists_.26_Bayesian_Autolearning | E-mail - Bayesian Autolearning]]
 
  
−
==== Usage ====
+
I found with the mapi error that I was getting was caused by my upgrade, PHP wouldn't start as the file libvmime.so.0 was missing or something rather (log no longer has the message). How I fixed my issue was I deleted the symlink in the /usr/lib/libvmime.so.0 which pointed to ...libvmime.0.7.1.so which is deleted when you upgrade the packages for version 7. I then "reinstalled" libvmime-0.9.2+... and restarted the httpd damaen and all was right with the world. -- girkers
−
{{Warning box| All mail dropped in the LearnAsSpam and LearnAsHam folders will be automatically deleted !!}}
 
  
−
* Move/copy spam messages that are delivered to your Inbox to the public LearnAsSpam folder.
+
==== php 5.3 ====
−
* COPY regular messages that end up in your Junk E-mail folder to the public LearnAsHam folder.
+
If you update your system against the testing repo, it will update php to version 5.3 and thus break things again. To fix the mapi error this time, I uninstalled php-mapi that was included with zarafa (I was using 7.0.1.28479 that was included with zarafa) and this also removes the two dependencies of zarafa-webaccess and zarafa-webaccess-mobile (if they are installed). I then downloaded an updated php-mapi, installed it and then reinstalled the webaccess rpms and restarted the httpd and all good again. - Girkers
  
−
After the messages have been processed they will be deleted to save your valuable space.
+
The steps I did were:
 +
cd /tmp
 +
wget ftp://ftp.pbone.net/mirror/download.fedora.redhat.com/pub/fedora/epel/5/i386/php53-mapi-7.0.1-1.el5.i386.rpm
 +
yum erase php-mapi
 +
yum localinstall php53-mapi-7.0.1-1.el5.i386.rpm
 +
cd zcp-[your version of zarafa]
 +
yum localinstall zarafa-webaccess-*
 +
sv t httpd-e-smith

Latest revision as of 07:26, 4 October 2011

Zarafa7 on SME8

If you want to test the new Zarafa 7 version on SME8b6: install as described here, download the needed files from bugzilla:5789 => Comment#5 and extract as described, make the following symbolic links and restart apache: 

ln -s /lib/libcrypto.so.0.9.8e /usr/lib/libcrypto.so.0.9.8
ln -s /lib/libssl.so.0.9.8e /usr/lib/libssl.so.0.9.8
sv t httpd-e-smith

Dependancies

Here are links to all the dependencies that I used for version 7.0.1.28479 (free): 

libicu - ftp://ftp.pbone.net/mirror/ftp.centos.org/5.7/os/i386/CentOS/libicu-3.6-5.16.i386.rpm
poppler-utils - ftp://ftp.pbone.net/mirror/ftp.centos.org/5.7/os/i386/CentOS/poppler-utils-0.5.4-4.4.el5_6.17.i386.rpm
poppler - ftp://ftp.pbone.net/mirror/ftp.centos.org/5.7/os/i386/CentOS/poppler-0.5.4-4.4.el5_6.17.i386.rpm
hicolor-icon-theme - ftp://ftp.pbone.net/mirror/ftp.centos.org/5.7/os/i386/CentOS/hicolor-icon-theme-0.9-2.1.noarch.rpm
bitstream-vera-fonts - ftp://ftp.pbone.net/mirror/ftp.centos.org/5.7/os/i386/CentOS/bitstream-vera-fonts-1.10-7.noarch.rpm
w3m - ftp://ftp.pbone.net/mirror/ftp.centos.org/5.7/os/i386/CentOS/w3m-0.5.1-18.el5.i386.rpm

If you are upgrading from version 6 you will also need these dependencies: 

MySQL-python - ftp://ftp.pbone.net/mirror/ftp.centos.org/5.7/os/i386/CentOS/MySQL-python-1.2.1-1.i386.rpm
mx - http://mirror.centos.org/centos/5/os/i386/CentOS/mx-2.0.6-2.2.2.i386.rpm

- Garth Kirkwood (girkers)

Installation

To make things a bit more easy for non Zarafa experts, I used this procedure for a clean install. Get zcp 7.01, unpack, remove the devel packages and install all rpm's: 

yum localinstall *.rpm

All packages have dependencies that cannot be resolved if you install only part of the rpm's (as suggested installation instruction for zcp 6.40).

Then install smeserver-zarafa. I could not retrieve this file from the smevdev repository (sme8 uses another one?). Get it manually and install: 

wget http://ftp.nluug.nl/os/Linux/distr/smeserver/releases/7/smedev/i386/RPMS/smeserver-zarafa-0.9.0-53.el4.sme.noarch.rpm
yum localinstall smeserver-zarafa-0.9.0-53.el4.sme.noarch.rpm

/etc/e-smith/events/actions/zarafa-install

expand the php-mapi patch patch and and the symbolic links (see first text block above: Zarafa7 on SME8).

If you use webaccess mobile, change 86ZarafaAlias template bugzilla:6552

If you use z-push, download and install (see here mobile synchronization). You have to change the name of the installation folder from z-push<version #> to z-push, because this is expected by the smeserver-zarafa package. The download extracts correctly but leaves the file and group ownership to some unknown user 33. I changed that (might not be necessary, I consider it a small security risk). 

chown -R root:root /var/www/html/z-push

Then post-upgrade and restart.

For upgrades (tested with 6.40.2): zarafa-server does not start, there is an error message in the /var/log/zarafa/zarafa-server.log file which tells you to update the database first. A python script is provided to do just that. See also [zarafa administration manual]! Stop running zarafa services, make sure a backup of the zarafa mysql database exists, install MySQL-python, run update script. 

yum install MySQL-python

python /usr/share/doc/zarafa/zarafa7-upgrade

Reports the script failes with wrong inno_db settings for mysql are on the zarafa forums. So verify your local MySQL innodb settings match the required values [zarafa administration manual]).

Sogo

FYI, I'm now using Sogo instead of zarafa, hence I have stopped work on smeserver-zarafa.

Sogo may not be as complete as zarafa, but is simpler to intergrate/maintain and will likely have a wider usage.

Snoble 01:59, 14 March 2010 (UTC)

I will mantain it for now, Paul Floor

Suggestions

If you can advise on standard configuration, please make it a bug so it is added to the rpm

Snoble 07:32, 22 December 2008 (UTC)


smeserver-zarafa-0.9-48

/etc/e-smith/events/actions/zarafa-services-stop has been removed 

/etc/e-smith/events/actions/zarafa-services
Usage: start|stop|restart|enabled|disabled

start services
stop services
restart services
enabled - set db values to enabled, zarafa will start on reboot
disabled - set db values to disabled, zarafa won't start on reboot


InnoDB support is enabled automatically, we need to add this note later


Important.png Note:
InnoDB support in MySql has been enabled in order to get zarafa-server running, for details see MySQL#Enable_InnoDB_engine


zarafa-6.40

yum localinstall libvmime-0*.rpm libical-0*.rpm zarafa-*.rpm catdoc-*.rpm

indexing service

The catdoc-rpm is needed for the new indexing service that is introduced with Zarafa 6.40... but the indexing-service is not yet handled by smeserver-zarafa. --jester 15:42, 13 February 2010 (UTC)

the catdoc rpm has un meet dependencies on SME 7 so it's only listed on discussion not the main page,

yes it's not implemented yet, it'll only be implemented in sme8 unless others find the dependencies

Snoble 01:13, 20 February 2010 (UTC)

Dependencies are poppler and poppler-utils. Available here:

ftp://ftp.pbone.net/mirror/apt.kde-redhat.org/kde-redhat/redhat/4/i386/RPMS.stable/poppler-0.5.4-0.3.el4.i386.rpm

ftp://ftp.pbone.net/mirror/apt.kde-redhat.org/kde-redhat/redhat/4/i386/RPMS.stable/poppler-utils-0.5.4-0.3.el4.i386.rpm

NOTE: Some poppler versions have been identified with security issues. I didn't have time to look into this version.

Paul Floor.

SME 8 beta

php 5.2.10

The php mapi files zarafa uses are compiled against 5.1.6, if sme 8 uses 5.2.10 we have a problem

here is one workaround http://forums.zarafa.com/viewtopic.php?f=9&t=3263&p=18753#p18753

I found with the mapi error that I was getting was caused by my upgrade, PHP wouldn't start as the file libvmime.so.0 was missing or something rather (log no longer has the message). How I fixed my issue was I deleted the symlink in the /usr/lib/libvmime.so.0 which pointed to ...libvmime.0.7.1.so which is deleted when you upgrade the packages for version 7. I then "reinstalled" libvmime-0.9.2+... and restarted the httpd damaen and all was right with the world. -- girkers

php 5.3

If you update your system against the testing repo, it will update php to version 5.3 and thus break things again. To fix the mapi error this time, I uninstalled php-mapi that was included with zarafa (I was using 7.0.1.28479 that was included with zarafa) and this also removes the two dependencies of zarafa-webaccess and zarafa-webaccess-mobile (if they are installed). I then downloaded an updated php-mapi, installed it and then reinstalled the webaccess rpms and restarted the httpd and all good again. - Girkers

The steps I did were: 

cd /tmp
wget ftp://ftp.pbone.net/mirror/download.fedora.redhat.com/pub/fedora/epel/5/i386/php53-mapi-7.0.1-1.el5.i386.rpm
yum erase php-mapi
yum localinstall php53-mapi-7.0.1-1.el5.i386.rpm
cd zcp-[your version of zarafa]
yum localinstall zarafa-webaccess-*
sv t httpd-e-smith
Retrieved from "https://wiki.koozali.org/index.php?title=Talk:Zarafa&oldid=15895"