[Bug 834967] New: after update to mysql-community-server 5.5.32 chown mysql:mysql run over /usr/bin and make system unusable
https://bugzilla.novell.com/show_bug.cgi?id=834967 https://bugzilla.novell.com/show_bug.cgi?id=834967#c0 Summary: after update to mysql-community-server 5.5.32 chown mysql:mysql run over /usr/bin and make system unusable Classification: openSUSE Product: openSUSE 12.3 Version: Final Platform: 32bit OS/Version: openSUSE 12.3 Status: NEW Severity: Critical Priority: P5 - None Component: Other AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: ctype@mail.ru QAContact: qa-bugs@suse.de Found By: --- Blocker: --- User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:22.0) Gecko/20100101 Firefox/22.0 AlexaToolbar/alxf-2.18 after update to mysql-community-server 5.5.32 system become unstable and after reboot can be accessed only via console by root Reproducible: Always Steps to Reproduce: 1.automatic update has installed update of mysql Actual Results: files in /usr/bin become owned by mysql: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=834967 https://bugzilla.novell.com/show_bug.cgi?id=834967#c1 --- Comment #1 from Alex Prudkiy <ctype@mail.ru> 2013-08-15 01:04:03 UTC --- the bug happen on update from mysql-community-server 5.5.30-1.1.1 to mysql-community-server 5.5.32-1.4.2 when I tried to "recover" and found problem with /usr/bin (all files owned by mysql, /usr/bin bin by self doesn't allow to browse inside ) I tried to reboot and found hdd very busy just after xdm failed to start ps aux shows "chown mysql:mysql ." started by /etc/init.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=834967 https://bugzilla.novell.com/show_bug.cgi?id=834967#c2 --- Comment #2 from Alex Prudkiy <ctype@mail.ru> 2013-08-15 01:27:09 UTC --- Recovery (probably partial - disable mysql and restore permissions): service mysql stop chkconfig mysql off chown root:root -R /usr/ chmod o+rx /usr chmod u+s /usr/bin/sudo chmod u+s /usr/bin/at chmod u+s /usr/bin/chage chmod u+s /usr/bin/chfn chmod u+s /usr/bin/chsh chmod u+s /usr/bin/crontab chmod u+s /usr/bin/eject chmod u+s /usr/bin/expiry chmod u+s /usr/bin/fusermount chmod u+s /usr/bin/gpasswd chmod u+s /usr/bin/mount chmod u+s /usr/bin/newgrp chmod u+s /usr/bin/passwd chmod u+s /usr/bin/ping chmod u+s /usr/bin/ping6 chmod u+s /usr/bin/pkexec chmod u+s /usr/bin/su chmod u+s /usr/bin/sudo chmod u+s /usr/bin/umount -- 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=834967 https://bugzilla.novell.com/show_bug.cgi?id=834967#c3 --- Comment #3 from Alex Prudkiy <ctype@mail.ru> 2013-08-15 02:21:28 UTC --- additional note: my /var/lib/mysql pointed to other directory/hdd via soft link ( /data/mysql ) so this may cause such error -- 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=834967 https://bugzilla.novell.com/show_bug.cgi?id=834967#c Marcus Meissner <meissner@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- 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=834967 https://bugzilla.novell.com/show_bug.cgi?id=834967#c4 Marcus Meissner <meissner@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |meissner@suse.com --- Comment #4 from Marcus Meissner <meissner@suse.com> 2013-08-15 06:34:33 UTC --- This is the likely candidate for this problem, yes. the recursive chown should be made safer , perhaps dont follow symlinks at all -- 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=834967 https://bugzilla.novell.com/show_bug.cgi?id=834967#c Swamp Workflow Management <swamp@suse.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status Whiteboard| |maint:running:53652:importa | |nt -- 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=834967 https://bugzilla.novell.com/show_bug.cgi?id=834967#c7 Dirk Weißnich <regi.hops@gmx.net> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |regi.hops@gmx.net --- Comment #7 from Dirk Weißnich <regi.hops@gmx.net> 2013-08-21 22:18:53 UTC --- Same with openSUSE 12.2 / 12.3 (64 & 32 bit) In my.cnf I configured datadir=/srv/mysql/data, after the upgrade to 5.5.32, the whole /usr directory was owned by mysql:mysql. Also MariaDB is affected. -- 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=834967 https://bugzilla.novell.com/show_bug.cgi?id=834967#c8 --- Comment #8 from Swamp Workflow Management <swamp@suse.de> 2013-08-23 13:04:49 UTC --- openSUSE-RU-2013:1376-1: An update that has three recommended fixes can now be installed. Category: recommended (moderate) Bug References: 734436,834028,834967 CVE References: Sources used: openSUSE 12.3 (src): mariadb-5.5.32-1.8.1, mysql-community-server-5.5.32-1.8.1 openSUSE 12.2 (src): mariadb-5.5.32-1.12.1, mysql-community-server-5.5.32-1.12.1 -- 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=834967 https://bugzilla.novell.com/show_bug.cgi?id=834967#c9 --- Comment #9 from Alex Prudkiy <ctype@mail.ru> 2013-08-24 18:25:31 UTC --- (In reply to comment #8)
openSUSE-RU-2013:1376-1: An update that has three recommended fixes can now be installed.
Category: recommended (moderate) Bug References: 734436,834028,834967 CVE References: Sources used: openSUSE 12.3 (src): mariadb-5.5.32-1.8.1, mysql-community-server-5.5.32-1.8.1
I've tested new update and bug is still there. -- 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=834967 https://bugzilla.novell.com/show_bug.cgi?id=834967#c10 --- Comment #10 from Marcus Meissner <meissner@suse.com> 2013-08-29 16:10:09 UTC --- Hmm. Michal? -- 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=834967 https://bugzilla.novell.com/show_bug.cgi?id=834967#c11 Swamp Workflow Management <swamp@suse.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status Whiteboard|maint:running:53652:importa |maint:running:53652:importa |nt |nt | |maint:released:sle11-sp3:54 | |090 --- Comment #11 from Swamp Workflow Management <swamp@suse.de> 2013-08-29 18:56:28 UTC --- Update released for: libmysql55client18, libmysql55client18-32bit, libmysql55client18-x86, libmysql55client_r18, libmysql55client_r18-32bit, libmysql55client_r18-x86, libmysqlclient-devel, libmysqlclient15, libmysqlclient15-32bit, libmysqlclient15-x86, libmysqlclient_r15, libmysqlclient_r15-32bit, libmysqlclient_r15-x86, mysql, mysql-Max, mysql-bench, mysql-client, mysql-debug, mysql-debug-version, mysql-debuginfo, mysql-debugsource, mysql-test, mysql-tools Products: SLE-DEBUGINFO 11-SP3 (i386, ia64, ppc64, s390x, x86_64) SLE-DESKTOP 11-SP3 (i386, x86_64) SLE-SDK 11-SP3 (i386, ia64, ppc64, s390x, x86_64) SLE-SERVER 11-SP3 (i386, ia64, ppc64, s390x, x86_64) SLES4VMWARE 11-SP3 (i386, x86_64) -- 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=834967 https://bugzilla.novell.com/show_bug.cgi?id=834967#c Swamp Workflow Management <swamp@suse.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status Whiteboard|maint:running:53652:importa |maint:running:53652:importa |nt |nt |maint:released:sle11-sp3:54 |maint:released:sle11-sp3:54 |090 |090 | |maint:running:54320:importa | |nt -- 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=834967 https://bugzilla.novell.com/show_bug.cgi?id=834967#c12 --- Comment #12 from Alex Prudkiy <ctype@mail.ru> 2013-10-04 08:22:26 UTC --- Unfortunately I've tested this issue again on other pc (forget about bug and updated mysql :( ) bug is still there mysql-community-server-5.5.33-1.13.1 I made some simple debugging, I hope this will help. 1. added echo instead of chmod/chown into /etc/init.d/mysql line 327: # Creating parent directories for logs for i in "$log_upgrade" "$log_query" "$log_error"; do log_dir="`dirname "$i"`" if [ \! -d "$log_dir" ]; then mkdir -p "$log_dir" fi echo 1 chmod 770 "$log_dir" echo 2 chown -R --no-dereference mysql:mysql "$log_dir" done 2. service mysql restart 3./var/log/messages Starting LSB: Start the MySQL database server... 1 chmod 770 /var/log/mysql 2 chown -R --no-dereference mysql:mysql /var/log/mysql 1 chmod 770 /var/log/mysql 2 chown -R --no-dereference mysql:mysql /var/log/mysql 1 chmod 770 . 2 chown -R --no-dereference mysql:mysql . Starting service MySQL ..done -- 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=834967 https://bugzilla.novell.com/show_bug.cgi?id=834967#c13 --- Comment #13 from Marcus Meissner <meissner@suse.com> 2013-10-07 14:42:42 UTC --- so not fixed yet if it chmod/chowns . ... -- 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=834967 https://bugzilla.novell.com/show_bug.cgi?id=834967#c14 Swamp Workflow Management <swamp@suse.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status Whiteboard|maint:running:53652:importa |maint:running:53652:importa |nt |nt |maint:released:sle11-sp3:54 |maint:released:sle11-sp3:54 |090 |090 |maint:running:54320:importa |maint:running:54320:importa |nt |nt | |maint:released:sle11-sp3:54 | |511 --- Comment #14 from Swamp Workflow Management <swamp@suse.de> 2013-10-07 16:55:38 UTC --- Update released for: libmysql55client18, libmysql55client18-32bit, libmysql55client18-x86, libmysql55client_r18, libmysql55client_r18-32bit, libmysql55client_r18-x86, libmysqlclient-devel, libmysqlclient15, libmysqlclient15-32bit, libmysqlclient15-x86, libmysqlclient_r15, libmysqlclient_r15-32bit, libmysqlclient_r15-x86, mysql, mysql-Max, mysql-bench, mysql-client, mysql-debug, mysql-debug-version, mysql-debuginfo, mysql-debugsource, mysql-test, mysql-tools Products: SLE-DEBUGINFO 11-SP3 (i386, ia64, ppc64, s390x, x86_64) SLE-DESKTOP 11-SP3 (i386, x86_64) SLE-SDK 11-SP3 (ia64, ppc64, s390x, x86_64) SLE-SERVER 11-SP3 (i386, ia64, ppc64, s390x, x86_64) SLES4VMWARE 11-SP3 (i386, x86_64) -- 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=834967 https://bugzilla.novell.com/show_bug.cgi?id=834967#c Swamp Workflow Management <swamp@suse.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status Whiteboard|maint:running:53652:importa |maint:running:53652:importa |nt |nt |maint:released:sle11-sp3:54 |maint:released:sle11-sp3:54 |090 |090 |maint:running:54320:importa |maint:released:sle11-sp3:54 |nt |511 |maint:released:sle11-sp3:54 | |511 | -- 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=834967 https://bugzilla.novell.com/show_bug.cgi?id=834967#c15 Michal Hrusecky <mhrusecky@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO CC| |draht@suse.com InfoProvider| |ctype@mail.ru --- Comment #15 from Michal Hrusecky <mhrusecky@suse.com> 2013-11-06 10:04:24 UTC --- That is definitely strange. Can you figure out why is your $log_error set to '.'? That shouldn't be the case and as far as I can see in init script default is /var/log/mysql/mysqld.log My guess would be that it is in my.cnf as that should be only place able to override it... Otherwise this bug should be fixed, as we no longer dereference symlinks... -- 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=834967 https://bugzilla.novell.com/show_bug.cgi?id=834967#c16 Michal Hrusecky <mhrusecky@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |RESOLVED InfoProvider|ctype@mail.ru | Resolution| |DUPLICATE --- Comment #16 from Michal Hrusecky <mhrusecky@suse.com> 2013-11-06 10:14:32 UTC --- Found the root cause in different bug report :-) *** This bug has been marked as a duplicate of bug 842264 *** http://bugzilla.novell.com/show_bug.cgi?id=842264 -- 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