#!/bin/sh
#
# Clean up the mysql databases

DSPAMCONF=/etc/dspam/dspam.conf
MYSQLCONF=/etc/dspam/dspam.d/mysql.conf
PURGE=/usr/share/doc/libdspam7-drv-mysql/purge-4.1.sql
MYSQLCONF_PASSWD=/var/run/libdspam7-drv-mysql.cron.passwd

if grep -q "^StorageDriver.*mysql_drv.so" $DSPAMCONF; then
  if [ -x /usr/bin/mysql ]; then
    MYSQL_USER="`grep "^MySQLUser" $MYSQLCONF | awk '{print $2}'`"
    MYSQL_PASS="`grep "^MySQLPass" $MYSQLCONF | awk '{print $2}'`"
    MYSQL_DB="`grep "^MySQLDb" $MYSQLCONF | awk '{print $2}'`"

    UMASK_OLD="`umask`"
    umask 077
    [ -e "$MYSQLCONF_PASSWD" ] && rm "$MYSQLCONF_PASSWD"
    printf "[client]\npassword=$MYSQL_PASS" > "$MYSQLCONF_PASSWD"
    umask "$UMASK_OLD"

    /usr/bin/mysql --defaults-file=$MYSQLCONF_PASSWD --user=$MYSQL_USER $MYSQL_DB < $PURGE

    rm "$MYSQLCONF_PASSWD"
  fi
fi

exit 0

