Dear Zhang,
I'm pretty sure I read that wheezy is now the only supported Debian where it was written that support for OpenSUSE and Gentoo are dropped, though I seem unable to locate this page again at the moment.
Anyway, I'd much appreciate a guide from policyd to cluebringer.
Besides the dovecot upgrading which was a hard one at first, we now did the iRedAdmin-Pro-upgrade too and now these things happen:
/bin/bash /var/vmail/backup/backup_mysql.sh complains about two issues:
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
bzip2: Output file /var/vmail/backup/mysql/2013/12/31/mysql-2013.12.31.03.30.01.sql.bz2 already exists.
bzip2: Output file /var/vmail/backup/mysql/2013/12/31/vmail-2013.12.31.03.30.01.sql.bz2 already exists.
and the log shows:
* File size:
----
35M /var/vmail/backup/mysql/2013/12/31/amavisd-2013.12.31.03.30.01.sql.bz2
8.0K /var/vmail/backup/mysql/2013/12/31/iredadmin-2013.12.31.03.30.01.sql.bz2
520K /var/vmail/backup/mysql/2013/12/31/mysql-2013.12.31.03.30.01.sql
104K /var/vmail/backup/mysql/2013/12/31/mysql-2013.12.31.03.30.01.sql.bz2
20K /var/vmail/backup/mysql/2013/12/31/postfixpolicyd-2013.12.31.03.30.01.sql.bz2
20K /var/vmail/backup/mysql/2013/12/31/roundcubemail-2013.12.31.03.30.01.sql.bz2
60K /var/vmail/backup/mysql/2013/12/31/vmail-2013.12.31.03.30.01.sql
12K /var/vmail/backup/mysql/2013/12/31/vmail-2013.12.31.03.30.01.sql.bz2
indeed in the filesystem there are two files:
-rw-r--r-- 1 root root 530180 Dec 31 03:30 mysql-2013.12.31.03.30.01.sql
-rw-r--r-- 1 root root 102520 Dec 31 03:30 mysql-2013.12.31.03.30.01.sql.bz2
-rw-r--r-- 1 root root 59239 Dec 31 03:30 vmail-2013.12.31.03.30.01.sql
-rw-r--r-- 1 root root 9250 Dec 31 03:30 vmail-2013.12.31.03.30.01.sql.bz2
which I guess is kind of a bug.
I fixed the events issue in /var/vmail/backup/backup_mysql.sh like this:
# Dump
${CMD_MYSQLDUMP} \
-u"${MYSQL_USER}" \
-p"${MYSQL_PASSWD}" \
--events \
--default-character-set=${DB_CHARACTER_SET} \
${db} > ${output_sql}
# hk@ 20131231 "--events" added above
for the issue with compressed and uncompressed files for mysql and vmail I have no clue what's going wrong.
regards,
hk
