I have been receiving the following email report:
/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
Most recommendations to fix this problem suggest updating the debian-sys-maint password for the MySQL server to match the one in /etc/mysql/debian.cnf.
This will not fix the problem if MySQL is not logging. Check if logging is turned on in /etc/mysql/my.cnf.
If you choose only to log errors then remove /etc/logrotate.d/mysql-server.
You should no longer get this error!! This was done on Ubuntu 10.04 Server.