Re: [opensuse] Logrotate fails for mysql



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@xxxxxxxxxxxx
To contact the owner, e-mail: opensuse+owner@xxxxxxxxxxxx