source: npl/mailserver/kopano_conf/root/etc/cron.weekly/kopano_clean

#!/bin/bash

if [ `cat /var/lib/mon/alerts/kopano/state` == "ALERT" ]; then
        echo "Something is wrong with kopano..not doing anything"
        exit 1
fi

abort()
{
        syn3-state kopano CAUTION "Kopano onderhoud gaf een probleem: $1"
        exit 1
}

TXT="Kopano onderhoud gestart, uw server kan iets langzamer zijn tijdens dit process:"

#sql fix for kopano upgrade: http://doc.kopano.com/7.0/Release_Notes/en-US/html-single/
if ! [ -e /var/lib/kopano/kopano_upgrade_fix ]; then
        syn3-state kopano OK "$TXT kopano 7 upgrade bugfix aan het uitvoeren (eenmalig)" 
        mysql -p`cat /etc/my.passwd` zarafa -e "
                begin;
                truncate table tproperties;
                alter table tproperties drop primary key, add primary key (folderid, tag,hierarchyid,type);
                INSERT IGNORE INTO deferredupdate (hierarchyid, folderid) SELECT c.id,c.parent FROM hierarchy AS c JOIN hierarchy AS p ON c.parent = p.id AND p.type=3;
                commit;" || abort "upgrade fix mislukt"
        touch /var/lib/kopano/kopano_upgrade_fix
fi

syn3-state kopano OK "$TXT purge deferred aan het uitvoeren" 
kopano-admin --purge-deferred
# always exitcode 1?
# || abort "purge deferred mislukt"

syn3-state kopano OK "$TXT softdelete aan het uitvoeren"
kopano-admin --purge-softdelete 30 || abort "softdelete mislukt"

syn3-state kopano OK "$TXT database optimalisatie"
mysqlcheck --optimize -p`cat /etc/my.passwd` zarafa || abort "database optimalisatie mislukt"

syn3-state kopano OK "$TXT kopano search xapian compact"
svcstop /service/kopano-search/
setuidgid kopano kopano-search-xapian-compact.py || abort "kopano search xapian compact mislukt"
svcreset /service/kopano-search/


syn3-state kopano OK "$TXT z-push cleanup"
z-push-admin -a fixstates || abort "z-push cleanup mislukt"

syn3-state kopano OK "Kopano onderhoud succesvol voltooid."

exit 0