ciphermethod.com

If you move a database to another server, you may need to reset the MySQL password for the debian-sys-maint user.

Error encountered:
/etc/cron.daily/logrotate:
error: error running shared postrotate script for ‘/var/log/mysql.log /var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log ‘
run-parts: /etc/cron.daily/logrotate exited with return code 1

Fix:

Set password for debian-sys-maint user to the one contained in the /etc/mysql/debian.cnf file.

# cat /etc/mysql/debian.cnf
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = debian-sys-maint
password = xxxxxx
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = localhost
user = debian-sys-maint
password = xxxxxx
socket = /var/run/mysqld/mysqld.sock
basedir = /usr

# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> UPDATE user SET Password = PASSWORD(‘xxxxxx’) WHERE User = ‘debian-sys-maint’ && Host = ‘localhost’;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> quit;
Bye

Issue:
warning: SASL authentication failure: cannot connect to saslauthd server: Too many levels of symbolic links

Fix:
rm -r /var/run/saslauthd/
mkdir -p /var/spool/postfix/var/run/saslauthd
ln -s /var/spool/postfix/var/run/saslauthd /var/run
chgrp sasl /var/spool/postfix/var/run/saslauthd

Problem:
An apt-get install is not replacing deleted config files…

Example:
Setting up dovecot-common (1:1.2.12-1ubuntu8.3) …
Not replacing deleted config file /etc/dovecot/dovecot.conf
Not replacing deleted config file /etc/dovecot/dovecot-ldap.conf
Not replacing deleted config file /etc/dovecot/dovecot-sql.conf
grep: /etc/dovecot/dovecot.conf: No such file or directory
grep: /etc/dovecot/dovecot.conf: No such file or directory

Solution:

apt-get --purge autoremove package