https://bugzilla.novell.com/show_bug.cgi?id=763150 https://bugzilla.novell.com/show_bug.cgi?id=763150#c0 Summary: Last update of mysql broke logrotate Classification: openSUSE Product: openSUSE 11.4 Version: Final Platform: Other OS/Version: openSUSE 11.4 Status: NEW Severity: Normal Priority: P5 - None Component: Update Problems AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: carlos.e.r@opensuse.org QAContact: jsrain@suse.com Found By: --- Blocker: --- After last security update of mysql: mysql-community-server-5.1.62-52.1 2012-05-17T12:56:30 CEST mysql-community-server-client-5.1.62-52.1 2012-05-17T12:55:53 CEST libmysqlclient-devel-5.1.62-52.1 2012-05-17T12:55:52 CEST libmysqld0-5.1.62-52.1 2012-05-17T12:55:06 CEST mysql-community-server-tools-5.1.62-52.1 2012-05-17T12:55:05 CEST libmysqlclient16-5.1.62-52.1 2012-05-17T12:55:04 CEST libmysqlclient_r16-32bit-5.1.62-52.1 2012-05-17T12:55:03 CEST libmysqlclient_r16-5.1.62-52.1 2012-05-17T12:55:01 CEST logrotate failed - I get this in syslogs: <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 This question was asked here: <http://lists.opensuse.org/opensuse/2012-05/msg00694.html> The recommendation was to change ownerships: ···· try to change this to # chmod 750 /var/log/mysql/ and optional # chown mysql /var/log/mysql/ ···· This caused a new problem in logrotate, needing to add "su mysql mysql" to the profile (see email thread for details). -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.