-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 05/17/2012 06:10 PM, Carlos E. R. wrote:
I get this in the log:
<9.4> 2012-05-17 22:19:14 Telcontar logrotate - - - ALERT exited abnormally with [1] <9.4> 2012-05-17 22:19:14 Telcontar logrotate - - - #007/usr/bin/mysqladmin: refresh failed; error: 'Unknown error' <9.4> 2012-05-17 22:19:14 Telcontar logrotate - - - /etc/logrotate.d/mysql failed, probably because <9.4> 2012-05-17 22:19:14 Telcontar logrotate - - - the root acount is protected by password. <9.4> 2012-05-17 22:19:14 Telcontar logrotate - - - See comments in /etc/logrotate.d/mysql on how to fix this <9.4> 2012-05-17 22:19:14 Telcontar logrotate - - - error: error running non-shared postrotate script for /var/log/mysql/mysqld.log of '/var/log/mysql/mysqld.log ' <9.4> 2012-05-17 22:19:14 Telcontar logrotate - - - Reload syslog service..done
Those comments say:
# If the root user has a password you have to create a # /root/.my.cnf configuration file with the following # content: # # [mysqladmin] # password = <secret> # user= root # # where "<secret>" is the password. # # ATTENTION: This /root/.my.cnf should be readable ONLY # for root !
And I do have that file with the right permissions:
Telcontar:~ # l .my.cnf -rw------- 1 root root 202 Mar 27 2011 .my.cnf
and they have the specified contents:
[mysqladmin] password = mypassword user= root
So, what happens? This has started right after the last mysql upgrade. Another bug?
-- Cheers, Carlos E. R.
Must be... I can confirm on 11.4 and I too have the proper .my.cnf entries and settings: [18:56 alchemy:~] # cat .my.cnf [mysqladmin] password = mypasswd user = root [mysqldump] password = mypasswd user = root [mysql] password = mypasswd user = root [mysqlcheck] password = mypasswd user = root I don't even have a guess as to why this started failing. The logrotate script is trying to run under mysqladmin, so your entry and the first entry above should be sufficient -- it has been for the last "how many?" years? This seems to be opensuse specific. With mysql 5.5.24-1, I do not see the same issue on Arch. - -- David C. Rankin, J.D.,P.E. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org