Please find below instructions for installing Zarafa-7 on ClearOS Enterprise 5.2.
The old Zarafa 6 (long) thread can be found HERE which contains a lot of useful information and guidance.
The full installation howto for Zarafa is HERE. This is considerd to be the main howto, and will be revised to use version 7 in due course. To install Zarafa-7 see the revised install section below. (ClearOS Enterprise 6.1.0 when available will also contain a Zarafa module)
Update: Zarafa 7.0.5-1 is available in the timb-testing repo. 6.40.9 has been pushed to the timb repo.I anticipate this to be the last release for 6.40.x
Warning - upgrades from 6.40.x require manual Mysql intervention, to optimise it for the new version - the database will grow by up to 20% in size. The process is not reversible.
Refer to the release docs here:-
http://doc.zarafa.com/7.0/Release_Notes/en-US/pdf/Zarafa_Collaboration_Platform-7.0-Release_Notes-en-US.pdf
There are many changes HERE
Install
Refer to original docs for completing the install
Upgrading
WAIT! don't end the script or you risk breaking your system, completed in 5-10 minutes for a small database. You should see something like:-
# Assuming everything went OK, restart the services and monitor the logs
Outlook support
Zarafa offer a free community edition with 3 free Outlook connectors, so that it will connect in a manner similar to Exchange
You can download the relevant version from ftp://timburgess.net/zarafa/
Install with:-
Z-Push
Z-push which offers ActiveSync support for remote devices is available as an rpm
Webaccess Speed
For large numbers of users the default webconfig settings can result in slow performance. Please see the post here if you need to optimise its performance! Thanks to Peter for posting
http://www.clearfoundation.com/component/option,com_kunena/Itemid,232/catid,40/func,view/id,30195/limit,10/limitstart,290/#37403
Mysql Tuning
For tuning of the Mysql backend (required for large mail databases!) see the following post. Please note the instructions apply to the default Mysql instance not the "System Mysql", however they can be successfully be applied to both.
http://www.zarafa.com/wiki/index.php/MySQL_tuning
Enjoy feedback welcome!
The old Zarafa 6 (long) thread can be found HERE which contains a lot of useful information and guidance.
The full installation howto for Zarafa is HERE. This is considerd to be the main howto, and will be revised to use version 7 in due course. To install Zarafa-7 see the revised install section below. (ClearOS Enterprise 6.1.0 when available will also contain a Zarafa module)
Update: Zarafa 7.0.5-1 is available in the timb-testing repo. 6.40.9 has been pushed to the timb repo.I anticipate this to be the last release for 6.40.x
Warning - upgrades from 6.40.x require manual Mysql intervention, to optimise it for the new version - the database will grow by up to 20% in size. The process is not reversible.
Refer to the release docs here:-
http://doc.zarafa.com/7.0/Release_Notes/en-US/pdf/Zarafa_Collaboration_Platform-7.0-Release_Notes-en-US.pdf
There are many changes HERE
Install
yum --enablerepo=timb-testing install zarafa zarafa-webaccess
yum --enablerepo=timb install app-zarafa
Refer to original docs for completing the install
Upgrading
yum --enablerepo=timb-testing upgrade zarafa zarafa-webaccess
#important! to fix issues with libvmime upgrade please run:-
ldconfig
service zarafa-server start
# review server.log - zarafa-server will stop after initial restart stating that you need to run the upgrade script
tail -f /var/log/zarafa/server.log
yum install MySQL-python
# Dump your existing database as a backup!
# For system-mysql (find your system password in /etc/system/databases)
/usr/share/system-mysql/usr/bin/mysqldump -uroot -pPASSWORD -v --quick --single-transaction zarafa | \
gzip > /var/tmp/zarafa-mysql-dump.gz
# For Mysql
/usr/bin/mysqldump -uroot -pPASSWORD -v --quick --single-transaction zarafa | \
gzip > /var/tmp/zarafa-mysql-dump.gz
# run the upgrade script, note may take substantial time
python /usr/share/zarafa/zarafa7-upgrade
WAIT! don't end the script or you risk breaking your system, completed in 5-10 minutes for a small database. You should see something like:-
Converting database to Unicode: 4 / 4 (100%)
Update stores table usernames: 2 / 2 (100%)
Converting rules to Unicode: 2 / 2 (100%)
Converting search folders to Unicode: 7 / 7 (100%)
Converting properties for IO performance: 26872 / 26872 (100%)
Creating counters for IO performance: 16 / 16 (100%)
Creating common properties for IO performance: 4 / 4 (100%)
Creating message attachment properties for IO performance: 2 / 2 (100%)
Creating tproperties for IO performance: 26871 / 26871 (100%)
Converting hierarchy for IO performance: 26871 / 26871 (100%)
Creating deferred table for IO performance: 1 / 1 (100%)
Converting changes for IO performance: 55839 / 55839 (100%)
Converting names table to Unicode: 1 / 1 (100%)
# Assuming everything went OK, restart the services and monitor the logs
service zarafa-server start
service webconfig restart
Outlook support
Zarafa offer a free community edition with 3 free Outlook connectors, so that it will connect in a manner similar to Exchange
You can download the relevant version from ftp://timburgess.net/zarafa/
Install with:-
rpm -Uvh zarafa-licensed-7.0.5-31880.i386.rpm --nodeps
Z-Push
Z-push which offers ActiveSync support for remote devices is available as an rpm
yum --enablerepo=timb-testing install zarafa-z-push
service httpd restart
service webconfig restart
vi /etc/zarafa/z-push/searchldap.php
#change LDAP_BIND_USER,LDAP_BIND_PASSWORD and LDAP_SEARCH_BASE to values from the webconfig LDAP
Webaccess Speed
For large numbers of users the default webconfig settings can result in slow performance. Please see the post here if you need to optimise its performance! Thanks to Peter for posting
http://www.clearfoundation.com/component/option,com_kunena/Itemid,232/catid,40/func,view/id,30195/limit,10/limitstart,290/#37403
Mysql Tuning
For tuning of the Mysql backend (required for large mail databases!) see the following post. Please note the instructions apply to the default Mysql instance not the "System Mysql", however they can be successfully be applied to both.
http://www.zarafa.com/wiki/index.php/MySQL_tuning
Enjoy feedback welcome!
Share this post:
Responses (795)
-
Accepted Answer
I've found a simple script which can be used as a backup tool for the attachements.
It can be found here : Title
A script which has both option together will be nices, but it works. -
Accepted Answer
Patrick de Brabander wrote:
James Joseph wrote:
[quote]Patrick de Brabander wrote:
James,
Is the backup script also making a backup of the attachements ?
Only if you configured attachments to be in the database (by default it's set to be in files which is actually better for the database).
I recommend backing those up by either by rsync or rdiff-backup. I just do rdiff-backup for ONSITE backups as it backups up the whole server and that includes /var/lib/zarafa however if you just want to backup just the database and attachments maybe a zip or a tar.gz of the folder that's compressed to another location or backup drive.
Would be great is this was incorperated in the autobackup script [/quote]
This is just a standard mysql backup script but I'm sure you could probably add into it to do that for you, I'm personally learning bash myself (my boss does all of our scripts) so maybe one day I might piece together my own. -
Accepted Answer
Patrick de Brabander wrote:
James Joseph wrote:
[quote]Patrick de Brabander wrote:
James,
Is the backup script also making a backup of the attachements ?
Only if you configured attachments to be in the database (by default it's set to be in files which is actually better for the database).
I recommend backing those up by either by rsync or rdiff-backup. I just do rdiff-backup for ONSITE backups as it backups up the whole server and that includes /var/lib/zarafa however if you just want to backup just the database and attachments maybe a zip or a tar.gz of the folder that's compressed to another location or backup drive.
Would be great is this was incorperated in the autobackup script [/quote]
This is just a standard mysql backup script but I'm sure you could probably add into it to do that for you, I'm personally learning bash myself (my boss does all of our scripts) so maybe one day I might piece together my own. -
Accepted Answer
James Joseph wrote:
Patrick de Brabander wrote:
James,
Is the backup script also making a backup of the attachements ?
Only if you configured attachments to be in the database (by default it's set to be in files which is actually better for the database).
I recommend backing those up by either by rsync or rdiff-backup. I just do rdiff-backup for ONSITE backups as it backups up the whole server and that includes /var/lib/zarafa however if you just want to backup just the database and attachments maybe a zip or a tar.gz of the folder that's compressed to another location or backup drive.
Would be great is this was incorperated in the autobackup script -
Accepted Answer
Patrick de Brabander wrote:
James,
Is the backup script also making a backup of the attachements ?
Only if you configured attachments to be in the database (by default it's set to be in files which is actually better for the database).
I recommend backing those up by either by rsync or rdiff-backup. I just do rdiff-backup for ONSITE backups as it backups up the whole server and that includes /var/lib/zarafa however if you just want to backup just the database and attachments maybe a zip or a tar.gz of the folder that's compressed to another location or backup drive. -
Accepted Answer
-
Accepted Answer
James Joseph wrote:
IIRC system-mysql is not on the standard mysql port it is on 3308 instead you can check this by doing lsof -i:3308 or netstat -l -n -t |grep 3308
In the conf file you'll see this line: #CONFIG_mysql_dump_port=3306
un comment it and change the dump port to 3308 instead that should back up the zarafa database.
Found it:
You need to check the setting in /etc/zarafa/server.cfg
##############################################################
# MYSQL SETTINGS (for database_engine = mysql)
# MySQL hostname to connect to for database access
mysql_host = 127.0.0.1
# MySQL port to connect with (usually 3306)
mysql_port = 3308
# The user under which we connect with MySQL
mysql_user = zarafa
# The password for the user (leave empty for no password)
mysql_password = xxxxxxxxxxxxxxxxxxxxxxxxxxx
Thanks for you help James !! -
Accepted Answer
Patrick de Brabander wrote:
The configuration file is working, but not backing up my Zarafa.
I've check in phpmyadmin and there are 2 databases: 'Main Database' and 'System Database'
Zarafa is stored in the 'System Database'.
/usr/local/bin/automysqlbackup
Invoking backup method.
Parsed config file "/etc/automysqlbackup/automysqlbackup.conf"
# Checking for permissions to write to folders:
base folder /tmp ... exists ... ok.
backup folder /tmp/db ... exists ... writable? yes. Proceeding.
checking directory "/tmp/db/daily" ... creating ... success.
checking directory "/tmp/db/weekly" ... creating ... success.
checking directory "/tmp/db/monthly" ... creating ... success.
checking directory "/tmp/db/latest" ... creating ... success.
checking directory "/tmp/db/tmp" ... creating ... success.
checking directory "/tmp/db/fullschema" ... creating ... success.
checking directory "/tmp/db/status" ... creating ... success.
# Testing for installed programs
mysql ... found.
mysqldump ... found.
# Parsing databases ... done.
======================================================================
AutoMySQLBackup version 3.0
http://sourceforge.net/projects/automysqlbackup/
Backup of Database Server - 127.0.0.1
Databases - information_schema,mysql,performance_schema,spotweb,test
Databases (monthly) - information_schema,mysql,performance_schema,spotweb,test
The script is now only backing up the 'Main Database'
How to backupo the system-database ?
IIRC system-mysql is not on the standard mysql port it is on 3308 instead you can check this by doing lsof -i:3308 or netstat -l -n -t |grep 3308
In the conf file you'll see this line: #CONFIG_mysql_dump_port=3306
un comment it and change the dump port to 3308 instead that should back up the zarafa database. -
Accepted Answer
The configuration file is working, but not backing up my Zarafa.
I've check in phpmyadmin and there are 2 databases: 'Main Database' and 'System Database'
Zarafa is stored in the 'System Database'.
/usr/local/bin/automysqlbackup
Invoking backup method.
Parsed config file "/etc/automysqlbackup/automysqlbackup.conf"
# Checking for permissions to write to folders:
base folder /tmp ... exists ... ok.
backup folder /tmp/db ... exists ... writable? yes. Proceeding.
checking directory "/tmp/db/daily" ... creating ... success.
checking directory "/tmp/db/weekly" ... creating ... success.
checking directory "/tmp/db/monthly" ... creating ... success.
checking directory "/tmp/db/latest" ... creating ... success.
checking directory "/tmp/db/tmp" ... creating ... success.
checking directory "/tmp/db/fullschema" ... creating ... success.
checking directory "/tmp/db/status" ... creating ... success.
# Testing for installed programs
mysql ... found.
mysqldump ... found.
# Parsing databases ... done.
======================================================================
AutoMySQLBackup version 3.0
http://sourceforge.net/projects/automysqlbackup/
Backup of Database Server - 127.0.0.1
Databases - information_schema,mysql,performance_schema,spotweb,test
Databases (monthly) - information_schema,mysql,performance_schema,spotweb,test
The script is now only backing up the 'Main Database'
How to backupo the system-database ? -
Accepted Answer
Patrick de Brabander wrote:
James Joseph wrote:
You didn't put in the location of your sandbox mysql also as I stated make sure you do this in path:
PATH=${PATH}:/var/lib/system-mysql:/usr/clearos/sandbox/usr/bin/mysqldump
Also did you link the mysql.conf file to the automysql backup script?
Sorry. I've copied the wrong config output.
PATH=${PATH}:/var/lib/system-mysql:/usr/clearos/sandbox/usr/bin/mysqldump
# Testing for installed programs
WARNING: Turning off multicore support, since pigz isn't there.
mysql ... found.
mysqldump ... found.
How do you link mysql.conf to the autobackupscript ?
At the top of the first script it should tell you about the .conf file location either put it in /etc/ where it tells you to or you might be able to change the location of where it should be. -
Accepted Answer
Patrick de Brabander wrote:
James Joseph wrote:
You didn't put in the location of your sandbox mysql also as I stated make sure you do this in path:
PATH=${PATH}:/var/lib/system-mysql:/usr/clearos/sandbox/usr/bin/mysqldump
Also did you link the mysql.conf file to the automysql backup script?
Sorry. I've copied the wrong config output.
PATH=${PATH}:/var/lib/system-mysql:/usr/clearos/sandbox/usr/bin/mysqldump
# Testing for installed programs
WARNING: Turning off multicore support, since pigz isn't there.
mysql ... found.
mysqldump ... found.
How do you link mysql.conf to the autobackupscript ?
At the top of the first script it should tell you about the .conf file location either put it in /etc/ where it tells you to or you might be able to change the location of where it should be. -
Accepted Answer
James Joseph wrote:
You didn't put in the location of your sandbox mysql also as I stated make sure you do this in path:
PATH=${PATH}:/var/lib/system-mysql:/usr/clearos/sandbox/usr/bin/mysqldump
Also did you link the mysql.conf file to the automysql backup script?
Sorry. I've copied the wrong config output.
PATH=${PATH}:/var/lib/system-mysql:/usr/clearos/sandbox/usr/bin/mysqldump
# Testing for installed programs
WARNING: Turning off multicore support, since pigz isn't there.
mysql ... found.
mysqldump ... found.
How do you link mysql.conf to the autobackupscript ? -
Accepted Answer
Patrick de Brabander wrote:
Somehow the autobackup script is not working with Zarafa.
Backing up the other database is not working.
/usr/local/bin/automysqlbackup /etc/automysqlbackup/myser ver.conf
# Checking for permissions to write to folders:
base folder /tmp ... exists ... ok.
backup folder /tmp/db ... exists ... writable? yes. Proceeding.
checking directory "/tmp/db/daily" ... exists.
checking directory "/tmp/db/weekly" ... exists.
checking directory "/tmp/db/monthly" ... exists.
checking directory "/tmp/db/latest" ... exists.
checking directory "/tmp/db/tmp" ... exists.
checking directory "/tmp/db/fullschema" ... exists.
checking directory "/tmp/db/status" ... exists.
# Testing for installed programs
WARNING: Turning off multicore support, since pigz isn't there.
mysql ... found.
mysqldump ... found.
# Parsing databases ... Note: Parsed config file /etc/automysqlbackup/myserver.c onf.
Note: /etc/automysqlbackup/automysqlbackup.conf was not found - no global config file.
Error: The mysql server is empty, i.e. no databases found. Check if something is wrong. Exiting.
###### WARNING ######
Errors reported during AutoMySQLBackup execution.. Backup failed
Error log below..
ERROR 1045 (28000): Access denied for user 'zarafa'@'localhost' (using password: YES)
#version=3.0_rc2
# DONT'T REMOVE THE PREVIOUS VERSION LINE!
#
# Uncomment to change the default values (shown after =)
# WARNING:
# This is not true for UMASK, CONFIG_prebackup and CONFIG_postbackup!!!
#
# Default values are stored in the script itself. Declarations in
# /etc/automysqlbackup/automysqlbackup.conf will overwrite them. The
# declarations in here will supersede all other.
# Edit $PATH if mysql and mysqldump are not located in /usr/local/bin:/usr/bin:/bin:/usr/local/mysql/bin
#PATH=${PATH}:FULL_PATH_TO_YOUR_DIR_CONTAINING_MYSQL:FULL_PATH_TO_YOUR_DIR_CONTAINING_MYSQLDUMP
PATH=${PATH}:/usr/clearos/sandbox/usr/bin/mysqldump
# Basic Settings
# Username to access the MySQL server e.g. dbuser
CONFIG_mysql_dump_username='zarafa'
# Password to access the MySQL server e.g. password
CONFIG_mysql_dump_password='ZARAFA_PASSWORD'
# Host name (or IP address) of MySQL server e.g localhost
#CONFIG_mysql_dump_host='127.0.0.1'
# "Friendly" host name of MySQL server to be used in email log
# if unset or empty (default) will use CONFIG_mysql_dump_host instead
#CONFIG_mysql_dump_host_friendly=''
# Backup directory location e.g /backups
#CONFIG_backup_dir='/var/backup/db'
CONFIG_backup_dir='/tmp/db'
# This is practically a moot point, since there is a fallback to the compression
# functions without multicore support in the case that the multicore versions aren't
# present in the system. Of course, if you have the latter installed, but don't want
# to use them, just choose no here.
#pigz -> gzip
# pbzip2 -> bzip2
#CONFIG_multicore='yes'
# Number of threads (= occupied cores) you want to use. You should - for the sake
# of the stability of your system - not choose more than (#number of cores - 1).
# Especially if the script is run in background by cron and the rest of your system
# has already heavy load, setting this too high, might crash your system. Assuming
# all systems have at least some sort of HyperThreading, the default is 2 threads.
# If you wish to let pigz and pbzip2 autodetect or use their standards, set it to
# 'auto'.
#CONFIG_multicore_threads=2
# Databases to backup
# List of databases for Daily/Weekly Backup e.g. ( 'DB1' 'DB2' 'DB3' ... )
# set to (), i.e. empty, if you want to backup all databases
CONFIG_db_names=()
# You can use
#declare -a MDBNAMES=( "${DBNAMES[@]}" 'added entry1' 'added entry2' ... )
# INSTEAD to copy the contents of $DBNAMES and add further entries (optional).
Backup with standard command is working
/usr/clearos/sandbox/usr/bin/mysqldump -u zarafa -pXXXXXXXXX --single-transaction zarafa | gzip > /var/tmp/zarafadump.sql.gz
You didn't put in the location of your sandbox mysql also as I stated make sure you do this in path:
PATH=${PATH}:/var/lib/system-mysql:/usr/clearos/sandbox/usr/bin/mysqldump
Also did you link the mysql.conf file to the automysql backup script? -
Accepted Answer
Somehow the autobackup script is not working with Zarafa.
Backing up the other database is not working.
/usr/local/bin/automysqlbackup /etc/automysqlbackup/myser ver.conf
# Checking for permissions to write to folders:
base folder /tmp ... exists ... ok.
backup folder /tmp/db ... exists ... writable? yes. Proceeding.
checking directory "/tmp/db/daily" ... exists.
checking directory "/tmp/db/weekly" ... exists.
checking directory "/tmp/db/monthly" ... exists.
checking directory "/tmp/db/latest" ... exists.
checking directory "/tmp/db/tmp" ... exists.
checking directory "/tmp/db/fullschema" ... exists.
checking directory "/tmp/db/status" ... exists.
# Testing for installed programs
WARNING: Turning off multicore support, since pigz isn't there.
mysql ... found.
mysqldump ... found.
# Parsing databases ... Note: Parsed config file /etc/automysqlbackup/myserver.c onf.
Note: /etc/automysqlbackup/automysqlbackup.conf was not found - no global config file.
Error: The mysql server is empty, i.e. no databases found. Check if something is wrong. Exiting.
###### WARNING ######
Errors reported during AutoMySQLBackup execution.. Backup failed
Error log below..
ERROR 1045 (28000): Access denied for user 'zarafa'@'localhost' (using password: YES)
#version=3.0_rc2
# DONT'T REMOVE THE PREVIOUS VERSION LINE!
#
# Uncomment to change the default values (shown after =)
# WARNING:
# This is not true for UMASK, CONFIG_prebackup and CONFIG_postbackup!!!
#
# Default values are stored in the script itself. Declarations in
# /etc/automysqlbackup/automysqlbackup.conf will overwrite them. The
# declarations in here will supersede all other.
# Edit $PATH if mysql and mysqldump are not located in /usr/local/bin:/usr/bin:/bin:/usr/local/mysql/bin
#PATH=${PATH}:FULL_PATH_TO_YOUR_DIR_CONTAINING_MYSQL:FULL_PATH_TO_YOUR_DIR_CONTAINING_MYSQLDUMP
PATH=${PATH}:/usr/clearos/sandbox/usr/bin/mysqldump
# Basic Settings
# Username to access the MySQL server e.g. dbuser
CONFIG_mysql_dump_username='zarafa'
# Password to access the MySQL server e.g. password
CONFIG_mysql_dump_password='ZARAFA_PASSWORD'
# Host name (or IP address) of MySQL server e.g localhost
#CONFIG_mysql_dump_host='127.0.0.1'
# "Friendly" host name of MySQL server to be used in email log
# if unset or empty (default) will use CONFIG_mysql_dump_host instead
#CONFIG_mysql_dump_host_friendly=''
# Backup directory location e.g /backups
#CONFIG_backup_dir='/var/backup/db'
CONFIG_backup_dir='/tmp/db'
# This is practically a moot point, since there is a fallback to the compression
# functions without multicore support in the case that the multicore versions aren't
# present in the system. Of course, if you have the latter installed, but don't want
# to use them, just choose no here.
#pigz -> gzip
# pbzip2 -> bzip2
#CONFIG_multicore='yes'
# Number of threads (= occupied cores) you want to use. You should - for the sake
# of the stability of your system - not choose more than (#number of cores - 1).
# Especially if the script is run in background by cron and the rest of your system
# has already heavy load, setting this too high, might crash your system. Assuming
# all systems have at least some sort of HyperThreading, the default is 2 threads.
# If you wish to let pigz and pbzip2 autodetect or use their standards, set it to
# 'auto'.
#CONFIG_multicore_threads=2
# Databases to backup
# List of databases for Daily/Weekly Backup e.g. ( 'DB1' 'DB2' 'DB3' ... )
# set to (), i.e. empty, if you want to backup all databases
CONFIG_db_names=()
# You can use
#declare -a MDBNAMES=( "${DBNAMES[@]}" 'added entry1' 'added entry2' ... )
# INSTEAD to copy the contents of $DBNAMES and add further entries (optional).
Backup with standard command is working
/usr/clearos/sandbox/usr/bin/mysqldump -u zarafa -pXXXXXXXXX --single-transaction zarafa | gzip > /var/tmp/zarafadump.sql.gz
-
Accepted Answer
Patrick de Brabander wrote:
James Joseph wrote:
[quote]Patrick de Brabander wrote:
i've managed to change de LDAP settings with ApacheDirectoryStudio.
Thanks James.
Now trying to get the migration-tool working.
Glad it's working, if you ever get time I'd consider testing backing up and restoring with mysql instead of PST files. This is the backup script I use for mysql: http://sourceforge.net/projects/automysqlbackup/
It's much easier then you think it is and for an administrator and company it saves an massive amount of downtime especially if something bad goes wrong it pays to have backups of the database for things like this .
Hope your migration goes well.
Thanks for your help.
Unfortunately the migration-tool is not working. Can not comnect to the server.
The user has zarafa admin rights...... beats me...
The backup script looks goods and i will definitely install it shortly
Does this work directly with the zarafa database or do i need to change a lot of parameters ?[/quote]
Sorry for the late reply, it depends on what mysql you're using.
If you're using the standard mysql from the repos then all you need to do is:
* put in either the root mysql username and pass or the zarafa mysql user and pass and select the database of zarafa or you can get backups of all databases by selecting all.
If you are using the clearos system-mysql then you will need to change a few things...
There's a conf file that comes with this script you'll see this:
# Edit $PATH if mysql and mysqldump are not located in /usr/local/bin:/usr/bin:/bin:/usr/local/mysql/bin
#PATH=${PATH}:FULL_PATH_TO_YOUR_DIR_CONTAINING_MYSQL:FULL_PATH_TO_YOUR_DIR_CONTAINING_MYSQLDUMP
You'll need to change it to:
PATH=${PATH}:/var/lib/system-mysql:/usr/clearos/sandbox/usr/bin/mysqldump
Then in the conf put in the zarafa mysql user and password and the name of the zarafa database in the databases you want to backup.
Try to see if that works when backing up it should. Then once you backup you simply need to import the database just follow that link that Ben posted for restoring the database onto the new server. -
Accepted Answer
James Joseph wrote:
Patrick de Brabander wrote:
i've managed to change de LDAP settings with ApacheDirectoryStudio.
Thanks James.
Now trying to get the migration-tool working.
Glad it's working, if you ever get time I'd consider testing backing up and restoring with mysql instead of PST files. This is the backup script I use for mysql: http://sourceforge.net/projects/automysqlbackup/
It's much easier then you think it is and for an administrator and company it saves an massive amount of downtime especially if something bad goes wrong it pays to have backups of the database for things like this .
Hope your migration goes well.
Thanks for your help.
Unfortunately the migration-tool is not working. Can not comnect to the server.
The user has zarafa admin rights...... beats me...
The backup script looks goods and i will definitely install it shortly
Does this work directly with the zarafa database or do i need to change a lot of parameters ? -
Accepted Answer
Patrick de Brabander wrote:
i've managed to change de LDAP settings with ApacheDirectoryStudio.
Thanks James.
Now trying to get the migration-tool working.
Glad it's working, if you ever get time I'd consider testing backing up and restoring with mysql instead of PST files. This is the backup script I use for mysql: http://sourceforge.net/projects/automysqlbackup/
It's much easier then you think it is and for an administrator and company it saves an massive amount of downtime especially if something bad goes wrong it pays to have backups of the database for things like this .
Hope your migration goes well. -
Accepted Answer
-
Accepted Answer
This kb may be of some interest.
https://www.clearos.com/resources/documentation/clearos/content:en_us:kb_howtos_upgrading_zarafa_6_to_7 -
Accepted Answer
James Joseph wrote:
Is this from zarafa to a zarafa server?
If it is why don't you do a mysqlpdump of the database import the database and rsync the attachments to the /var/lib/zarafa/attachments folder?
That should work perfectly fine and it's what I've used to move zarafa from one server to another.
If this is from a differen't e-mail server all together and not zarafa I use apache directory studio to access ldap on the server: https://directory.apache.org/studio/
do a ssh tunnel of secure ldap to your localhost :
ssh -vv -L 6366:127.0.0.1:636 root@server.domain.com
Then open up apache directory studio create a new ldap connection.
The server is: localhost
Connection security: SSL
port is: 636
Put in your bind username and then password, your clearos home should have those details in the directory information, click on test connection. Accept untrusted certificates and you should be connected. Click on finish and you'll have access to your ldap server.
Then go to your user account you want to enable zarafa admin rights to right click on a field and add attribute and search something like zarafaAdmin or something like that.
Set the value to: 1
Restart zarafa server and when you check out the details of the user:
zarafa-admin --details user
You should get an output like this
Administrator: yes
Hope this helps. However I would strongly recommend doing the mysql dump and import and syncing the attachments folder if it is an zarafa server you are moving from it's the quickest and painless migration you will do.
You may need to unhook and re-hook mailboxes though as they may not be attached to the right users.
For that problem I simply go onto the old server and do zarafa-admin --details user and make sure it's the right size.
Hello James,
Yes. It is from Zarafa to Zarafa (ClearOS 6.7 to ClearOS7.1)
Working with the database dump looks complicated ;-) and i've backup up all the mail boxes using .pst
(i still have a copy of the complete server on a spare HDD)
But, eventually it should be possible to use Zarafa-Admin (why not directly out-of-the-box)
So basicly, i need to get access to my LDAP and try to get a user setup as administrator.
Are there any other possibilties ?
Tried with ApacheDirectoryStudio, but i can not access the server.
found it.
You need to change in Directory Server - Policies (in the Webconfig menu)
Publish policy - Local Network
Account Access - Anonymous -
Accepted Answer
Nick Howitt wrote:
In your phpldapadmin.conf try changing your "Allow from 127.0.0.1" to "Allow from 127.0.0.1, your_LAN_subnet". Mine is "Allow from 127.0.0.1, 172.17.2.100/24". I think I also had to fiddle with /etc/phpldapadmin/config.php. Note I am still on 6.x so I don't know if 7.x is different.
Hello Nick,
Ive tried all different options in phpldapadmin.conf.
Even the option Allow All. Somehow it is not working.
Searched the Internet, but not coming to a solution.
Patrick -
Accepted Answer
-
Accepted Answer
Patrick de Brabander wrote:
Well, i've installed ClearOS 7 and purchased the Zarafa Home edition.
All is working, but importing the old-emails back in to the zarafa server is a bit difficult.
Since MAPI is not supported in the home edition (my mistake to choose this version) and copying the emails back form the .pst files using IMAP or EAS does not work properly.
All the mails form local users are misformed in the email address. for example john@mail.com (John Doe) is now in JohnDoe als email address.
Now i'm trying to use the migration-tool, but i don't have a user who is an Admin.
After spending hours getting this to work, i've found out that you need to install LDAPADMIN.
I've install LDAPADMIN, but when i'm trying to access this, i het the following error:
Forbidden
You don't have permission to access /phpldapadmin on this server.
made some changes to phpldapadmin.conf
#
# Web-based tool for managing LDAP servers
#
Alias /phpldapadmin /usr/share/phpldapadmin/htdocs
Alias /ldapadmin /usr/share/phpldapadmin/htdocs
<Directory /usr/share/phpldapadmin/htdocs>
<IfModule mod_authz_core.c>
# Apache 2.4
Require local
</IfModule>
<IfModule !mod_authz_core.c>
# Apache 2.2
Order Deny,Allow
Deny from all
Allow from 127.0.0.1
Allow from ::1
</IfModule>
</Directory>
and changed Deny from All in to Allow from All, etc...
Still no access
Who can help me to give a user admin privileges
Is this from zarafa to a zarafa server?
If it is why don't you do a mysqlpdump of the database import the database and rsync the attachments to the /var/lib/zarafa/attachments folder?
That should work perfectly fine and it's what I've used to move zarafa from one server to another.
If this is from a differen't e-mail server all together and not zarafa I use apache directory studio to access ldap on the server: https://directory.apache.org/studio/
do a ssh tunnel of secure ldap to your localhost :
ssh -vv -L 6366:127.0.0.1:636 root@server.domain.com
Then open up apache directory studio create a new ldap connection.
The server is: localhost
Connection security: SSL
port is: 636
Put in your bind username and then password, your clearos home should have those details in the directory information, click on test connection. Accept untrusted certificates and you should be connected. Click on finish and you'll have access to your ldap server.
Then go to your user account you want to enable zarafa admin rights to right click on a field and add attribute and search something like zarafaAdmin or something like that.
Set the value to: 1
Restart zarafa server and when you check out the details of the user:
zarafa-admin --details user
You should get an output like this
Administrator: yes
Hope this helps. However I would strongly recommend doing the mysql dump and import and syncing the attachments folder if it is an zarafa server you are moving from it's the quickest and painless migration you will do.
You may need to unhook and re-hook mailboxes though as they may not be attached to the right users.
For that problem I simply go onto the old server and do zarafa-admin --details user and make sure it's the right size. -
Accepted Answer
Well, i've installed ClearOS 7 and purchased the Zarafa Home edition.
All is working, but importing the old-emails back in to the zarafa server is a bit difficult.
Since MAPI is not supported in the home edition (my mistake to choose this version) and copying the emails back form the .pst files using IMAP or EAS does not work properly.
All the mails form local users are misformed in the email address. for example john@mail.com (John Doe) is now in JohnDoe als email address.
Now i'm trying to use the migration-tool, but i don't have a user who is an Admin.
After spending hours getting this to work, i've found out that you need to install LDAPADMIN.
I've install LDAPADMIN, but when i'm trying to access this, i het the following error:
Forbidden
You don't have permission to access /phpldapadmin on this server.
made some changes to phpldapadmin.conf
#
# Web-based tool for managing LDAP servers
#
Alias /phpldapadmin /usr/share/phpldapadmin/htdocs
Alias /ldapadmin /usr/share/phpldapadmin/htdocs
<Directory /usr/share/phpldapadmin/htdocs>
<IfModule mod_authz_core.c>
# Apache 2.4
Require local
</IfModule>
<IfModule !mod_authz_core.c>
# Apache 2.2
Order Deny,Allow
Deny from all
Allow from 127.0.0.1
Allow from ::1
</IfModule>
</Directory>
and changed Deny from All in to Allow from All, etc...
Still no access
Who can help me to give a user admin privileges -
Accepted Answer
Patrick de Brabander wrote:
James Joseph wrote:
[quote]Patrick de Brabander wrote:
I've tried yesterday to install the new ClearOS 7.1 on my test server and found out that you need pay for Zarafa yearly.
Does this mean that the payment i've alredy made for the previous version of zarafa expired ?
I thought this was one time payment for community users.
When I asked this in another thread it's a new change for ClearOS you need to pay a yearly fee even if you already have a subscription to Zarafa on clearos 6.
However you can still keep your version of zarafa and it won't stop working if you don't elect to pay, I assume it just means you will no longer get updates?
Personally we are a re-seller for zarafa so we only used the clearos version as it provided a nice app plugin and we updated zarafa ourselves manually. I'm happy for there to be a one off version which just does the initial install and configures the app in the web interface personally without having any further updates.
How did you install Zarafa within ClearOS 7 ?
In the marketplace you can add Zarafa to your installation, but i expect you have pay before installation.
I don't mind to pay for an app, but €50,00/year is a lot for a community package.
Also what are getting for this money.[/quote]
I've tried both options installing zarafa manually using packages and installing using the app. I've elected to go install using the app as it's less fiddly and I don't need to use an ldap browser to manually configure things like enabling users in zarafa etc and setting quotas for e-mail accounts.
I don't plan to renew the app after the year expires as I'll update zarafa myself. Yes you do have to pay for the app before downloading it onto your system.
The yearly cost covers getting the latest versions of zarafa, last year Zarafa announced they no longer plan to provide quality tested binaries for non paying customers and anyone using the community version will need to build from source they are currently still providing packages at the moment but I think they plan to provide only source code soon and let the OS maintainers provide the packages themselves: https://community.zarafa.com/pg/blog/read/28386/the-important-role-of-the-zarafa-community-in-zarafas-business-model
To be fair I think it's a reasonable cost considering it most likely will take a considerable amount of time and effort to re-compile from source into binaries for them to deploy to the clearOS community but as I can get the paid binaries I don't really need that kind of service. -
Accepted Answer
James Joseph wrote:
Patrick de Brabander wrote:
I've tried yesterday to install the new ClearOS 7.1 on my test server and found out that you need pay for Zarafa yearly.
Does this mean that the payment i've alredy made for the previous version of zarafa expired ?
I thought this was one time payment for community users.
When I asked this in another thread it's a new change for ClearOS you need to pay a yearly fee even if you already have a subscription to Zarafa on clearos 6.
However you can still keep your version of zarafa and it won't stop working if you don't elect to pay, I assume it just means you will no longer get updates?
Personally we are a re-seller for zarafa so we only used the clearos version as it provided a nice app plugin and we updated zarafa ourselves manually. I'm happy for there to be a one off version which just does the initial install and configures the app in the web interface personally without having any further updates.
How did you install Zarafa within ClearOS 7 ?
In the marketplace you can add Zarafa to your installation, but i expect you have pay before installation.
I don't mind to pay for an app, but €50,00/year is a lot for a community package.
Also what are getting for this money. -
Accepted Answer
Patrick de Brabander wrote:
I've tried yesterday to install the new ClearOS 7.1 on my test server and found out that you need pay for Zarafa yearly.
Does this mean that the payment i've alredy made for the previous version of zarafa expired ?
I thought this was one time payment for community users.
When I asked this in another thread it's a new change for ClearOS you need to pay a yearly fee even if you already have a subscription to Zarafa on clearos 6.
However you can still keep your version of zarafa and it won't stop working if you don't elect to pay, I assume it just means you will no longer get updates?
Personally we are a re-seller for zarafa so we only used the clearos version as it provided a nice app plugin and we updated zarafa ourselves manually. I'm happy for there to be a one off version which just does the initial install and configures the app in the web interface personally without having any further updates. -
Accepted Answer
-
Accepted Answer
This could be a bug but when I had to re-install webapp for some testing it removed the app-zarafa and when I re-installed it all of a sudden e-mails were gone I was about to re-store my backup from yesterday when I noticed the server.cfg file got re-written over from the app-zarafa I re-installed.
Tim, could you configure app-zarafa to make the previous server.cfg file server.cfg.old or something like that? I had to get my old config file from a backup, just encase this happens to someone else. -
Accepted Answer
Tim,
I don't know if you've had a chance to test this or not but I've currently installed 7.2 on a test clearos server and I've gotten weird issues with Webapp when I log in with an account on my test server in the loading webapp I get http 500 error message each time I login.
Have you encountered this at all if you've installed it on any test server you have?
*edit*
Solved the issue it was due to problems with plugins that I've installed that aren't in use. -
Accepted Answer
-
Accepted Answer
-
Accepted Answer
I got it to work by creating a website for autodiscover.domain.com on the webserver app. Then I pointed the SSL certificates in the flexshare-443.conf in conf.d to my self signed certificates.
I am currently having issues with it pulling in the username and password properly but that's more of a zarafa thing then clearos so glad I got that working. -
Accepted Answer
-
Accepted Answer
Hi James, assuming ClearOS is your network DNS servier you can setup an alias in the webconfig Network -> Settings -> Local DNS server for autodiscover.yourdomain.com pointing to your ClearOS box?
Perhaps there is a wider issue with the SSL certs if they don't work when using your server domain name?
FYI you can edit the Z-push alias settings here
/etc/httpd/conf.d/zarafa-z-push.conf
or SSL settings here
/etc/httpd/conf.d/ssl.conf -
Accepted Answer
Tim,
I've recently installed the new z-push 2.2 on my server it needs DNS to point to autodiscover.domainname.com
I have SSL certificates I've purchased and installed on our server but they won't work if I don't use the name of the server for clearos even though I have a multi server SSL certificate for autodiscover.
Where can I go in apache to add an alias for autodiscover so when I do https://autodiscover.domain.com I won't get an SSL warning? -
Accepted Answer
-
Accepted Answer
it said it was already installed so i did a remove and now it shows that zarafa community is not there and i lost the selection in the webconfig. i re-installed zpush and it appears to be working but still shows that the zarafa community is gone. i did a httpd restart as well as a webconfig. nothing. i can still get into zarafa and send mail but the selection is still gone and the marketplace shows it not installed. how do i fix this without totally breaking box. i have not rebooted. -
Accepted Answer
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »