[Bug 763150] New: Last update of mysql broke logrotate
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.
https://bugzilla.novell.com/show_bug.cgi?id=763150 https://bugzilla.novell.com/show_bug.cgi?id=763150#c1 Lars Müller <lmuelle@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- AssignedTo|bnc-team-screening@forge.pr |mhrusecky@suse.com |ovo.novell.com | --- Comment #1 from Lars Müller <lmuelle@suse.com> 2012-05-20 09:54:23 CEST --- A call to osc bugowner server:database:STABLE mysql-community-server -e leads to the correct bug owner. I don't know why bugzilla can't get this information automatically. -- 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.
https://bugzilla.novell.com/show_bug.cgi?id=763150 https://bugzilla.novell.com/show_bug.cgi?id=763150#c2 Carl Hartung <carlh@cehartung.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |carlh@cehartung.com --- Comment #2 from Carl Hartung <carlh@cehartung.com> 2012-07-07 22:53:00 UTC --- ~ #> cat /etc/logrotate.d/mysql # This logname can be set in /etc/my.cnf # by setting the variable "err-log" # in the [safe_mysqld] section as follows: # # [safe_mysqld] # err-log=/var/log/mysqld.log - - - - - 8< snip >8 - - - - - ~ #> cat /etc/my.cnf - - - - - 8< snip >8 - - - - - # The safe_mysqld script [safe_mysqld] log-error = /var/log/mysql/mysqld.log socket = /var/run/mysql/mysql.sock - - - - - 8< snip >8 - - - - - I suspected the problem was a transposition of the variable 'err-log' in /etc/my.cnf with the the mysql cli flag '--log-error' Early yesterday, I changed the line in /etc/my.cnf from: log-error = /var/log/mysql/mysqld.log to: err-log = /var/log/mysql/mysqld.log and I've just discovered a newly compressed log file accompanied by a long string of uncompressed log files. The uncompressed files correspond to logrotate errors in /etc/warn. Looks like a typo (variable name transposed with a cli argument) inserted by an update after May 14: -rw-rw---- 1 mysql mysql 389 May 13 20:29 mysqld.log-20120514.bz2 -rw-rw---- 1 mysql mysql 1414 May 18 11:44 mysqld.log-20120515 -rw-rw---- 1 mysql mysql 739 May 20 20:14 mysqld.log-20120519 -rw-rw---- 1 mysql mysql 794 May 22 09:21 mysqld.log-20120521 -rw-rw---- 1 mysql mysql 739 May 26 14:03 mysqld.log-20120523 -rw-rw---- 1 mysql mysql 658 May 28 08:23 mysqld.log-20120527 -rw-rw---- 1 mysql mysql 658 May 31 09:24 mysqld.log-20120529 -rw-rw---- 1 mysql mysql 794 Jun 4 06:32 mysqld.log-20120601 -rw-rw---- 1 mysql mysql 739 Jun 7 21:10 mysqld.log-20120605 -rw-rw---- 1 mysql mysql 794 Jun 9 09:49 mysqld.log-20120608 -rw-rw---- 1 mysql mysql 739 Jun 10 06:44 mysqld.log-20120610 -rw-rw---- 1 mysql mysql 794 Jun 15 08:27 mysqld.log-20120611 -rw-rw---- 1 mysql mysql 739 Jun 17 06:55 mysqld.log-20120616 -rw-rw---- 1 mysql mysql 794 Jun 21 05:04 mysqld.log-20120618 -rw-rw---- 1 mysql mysql 739 Jun 23 17:49 mysqld.log-20120622 -rw-rw---- 1 mysql mysql 658 Jun 25 16:26 mysqld.log-20120624 -rw-rw---- 1 mysql mysql 794 Jul 1 03:56 mysqld.log-20120626 -rw-rw---- 1 mysql mysql 1994 Jul 4 08:41 mysqld.log-20120702 -rw-rw---- 1 mysql mysql 794 Jul 6 05:04 mysqld.log-20120705 -rw-rw---- 1 mysql mysql 104 Jul 6 05:04 mysqld.log-20120707.bz2 regards, Carl -- 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.
https://bugzilla.novell.com/show_bug.cgi?id=763150 https://bugzilla.novell.com/show_bug.cgi?id=763150#c3 Björn Voigt <bjoernv@arcor.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |bjoernv@arcor.de --- Comment #3 from Björn Voigt <bjoernv@arcor.de> 2012-09-04 10:49:18 UTC --- The commands # chmod 770 /var/log/mysql/ # chown mysql:mysql /var/log/my and adding the line "su mysql mysql" in /etc/logrotate.d/mysql solved the issue for me: # mysqladmin refresh # logrotate /etc/logrotate.d/mysql -- 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.
https://bugzilla.novell.com/show_bug.cgi?id=763150 https://bugzilla.novell.com/show_bug.cgi?id=763150#c4 Dino E <vy@samiznaetekogo.net> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |vy@samiznaetekogo.net AssignedTo|mhrusecky@suse.com |bnc-team-screening@forge.pr | |ovo.novell.com --- Comment #4 from Dino E <vy@samiznaetekogo.net> 2012-11-15 10:09:31 UTC --- It's still not fixed in 12.2. Should I open a new bugreport? -- 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.
https://bugzilla.novell.com/show_bug.cgi?id=763150 https://bugzilla.novell.com/show_bug.cgi?id=763150#c5 Christian Boltz <suse-beta@cboltz.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |suse-beta@cboltz.de Component|Update Problems |Update Problems AssignedTo|bnc-team-screening@forge.pr |mhrusecky@suse.com |ovo.novell.com | Product|openSUSE 11.4 |openSUSE 12.2 --- Comment #5 from Christian Boltz <suse-beta@cboltz.de> 2012-11-15 11:56:00 CET --- (In reply to comment #4)
It's still not fixed in 12.2. Should I open a new bugreport?
Just change the "Product" field to 12.2 (I did it now). Also, resetting the assignee does more harm than good... (fixed again) -- 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.
https://bugzilla.novell.com/show_bug.cgi?id=763150 https://bugzilla.novell.com/show_bug.cgi?id=763150#c6 Archie Cobbs <archie@dellroad.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |archie@dellroad.org --- Comment #6 from Archie Cobbs <archie@dellroad.org> 2013-04-23 13:32:04 UTC --- According to this thread: http://opensuse.14.x6.nabble.com/Logrotate-fails-for-mysql-td4965072.html The fix is add "su mysql mysql" to /etc/logrotate.d/mysql. Also this may be required: "chmod 775 /var/log/mysql". -- 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.
https://bugzilla.novell.com/show_bug.cgi?id=763150 https://bugzilla.novell.com/show_bug.cgi?id=763150#c7 Thomas Wagner <wagner-thomas@gmx.at> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |wagner-thomas@gmx.at Component|Update Problems |Basesystem AssignedTo|mhrusecky@suse.com |bnc-team-screening@forge.pr | |ovo.novell.com Product|openSUSE 12.2 |openSUSE 12.3 Target Milestone|--- |Final QAContact|jsrain@suse.com |qa-bugs@suse.de --- Comment #7 from Thomas Wagner <wagner-thomas@gmx.at> 2013-05-12 20:34:06 UTC --- This bug seems to occur still on openSuSe 12.3. Simply chown mysql /var/log/mysql chmod 750 /var/log/mysql will fix it. -- 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.
https://bugzilla.novell.com/show_bug.cgi?id=763150 https://bugzilla.novell.com/show_bug.cgi?id=763150#c Ye Yuan <yyuan@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |yyuan@suse.com AssignedTo|bnc-team-screening@forge.pr |mhrusecky@suse.com |ovo.novell.com | -- 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.
https://bugzilla.novell.com/show_bug.cgi?id=763150 https://bugzilla.novell.com/show_bug.cgi?id=763150#c8 Michal Hrusecky <mhrusecky@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |DUPLICATE --- Comment #8 from Michal Hrusecky <mhrusecky@suse.com> 2013-07-26 11:20:00 UTC --- Same cause, will be fixed together. *** This bug has been marked as a duplicate of bug 792332 *** http://bugzilla.novell.com/show_bug.cgi?id=792332 -- 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.
https://bugzilla.novell.com/show_bug.cgi?id=763150 https://bugzilla.novell.com/show_bug.cgi?id=763150#c9 --- Comment #9 from Bernhard Wiedemann <bwiedemann@suse.com> 2013-07-31 14:00:24 CEST --- This is an autogenerated message for OBS integration: This bug (763150) was mentioned in https://build.opensuse.org/request/show/185084 Factory / mariadb -- 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.
https://bugzilla.novell.com/show_bug.cgi?id=763150 https://bugzilla.novell.com/show_bug.cgi?id=763150#c10 --- Comment #10 from Bernhard Wiedemann <bwiedemann@suse.com> 2013-07-31 18:00:37 CEST --- This is an autogenerated message for OBS integration: This bug (763150) was mentioned in https://build.opensuse.org/request/show/185268 Factory / mysql-community-server -- 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.
https://bugzilla.novell.com/show_bug.cgi?id=763150 https://bugzilla.novell.com/show_bug.cgi?id=763150#c11 --- Comment #11 from Bernhard Wiedemann <bwiedemann@suse.com> 2013-08-12 17:00:21 CEST --- This is an autogenerated message for OBS integration: This bug (763150) was mentioned in https://build.opensuse.org/request/show/186764 Factory / mariadb -- 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.
https://bugzilla.novell.com/show_bug.cgi?id=763150 https://bugzilla.novell.com/show_bug.cgi?id=763150#c Bernhard Wiedemann <bwiedemann@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |CLOSED -- 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.
participants (1)
-
bugzilla_noreply＠novell.com