Am 18.05.2012 01:10, schrieb Carlos E. R.:
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?
maybe wrong permissions on /var/log/mysql/ directory. try to change this to # chmod 750 /var/log/mysql/ and optional # chown mysql /var/log/mysql/ ciao paolo
-- Cheers, Carlos E. R.
-- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org