source: npl/mailserver/transparantspam/dspam_clean

#!/bin/bash

(
syn3-state dspam_clean OK "Bezig met het opschonen van het spamfilter. Ontvangen en versturen van email zal uitgeschakeld zijn tijdens deze actie."

echo "Dspam clean gestart..."

svcstop /service/qmail-send2

abort()
{
        svcreset /service/qmail-send2
        echo "Dspam clean mislukt!"
        syn3-state dspam_clean CAUTION "Opschonen spamfilter mislukt!"
        exit 1
}


#prevent that error log gets too big
rm /home/system/dspam/log/sql.errors 2>/dev/null


#Only do mysql stuff is mysql is running and accesible
PASSWD="`cat /etc/my.passwd`"
if mysqlshow --password="$PASSWD" &>/dev/null; then
    #check and repair database
    mysqlcheck --password="$PASSWD" -r dspamdb || abort

    #cleanup database
    mysql --password="$PASSWD" dspamdb < /home/system/dspam/cleanup.sql || abort
fi

#roteer logfiles
if [ "`find /home/system/dspam/ -name '*.log'`" != "" ]; then
        su - nobody -c "/usr/bin/dspam_logrotate -v -a 30 -d /home/system/dspam" || abort 
fi

#roteer mailboxen
find /home/system/dspam/data -name '*.mbox'|
while read MBOX; do
        DAYS=30
        if [ -e $MBOX.conf ]; then
                source $MBOX.conf
        fi
        su - nobody -c "TMP=/home/system/tmp archivemail -d $DAYS '$MBOX'" || abort
done  || abort



svcreset /service/qmail-send2

syn3-state dspam_clean OK "Opschonen spamfilter is gelukt."

echo "Dspam clean succesvol beeindigd."


) 2>&1 | logger -p cron.info