[Bug 448656] Re: CPU information is inaccessible for MySQL
*** This bug is a duplicate of bug 79 *** https://bugs.launchpad.net/bugs/79 Howdy, and thank you for taking the time to report this bug and helping to make Ubuntu better. This particular bug has already been reported and appears to be a duplicate, so it is being marked as such. Please look at the other bug report to see if there is any missing information that you can provide, or to see if there is a workaround for the bug. Additionally, any further discussion regarding the bug should occur in the other report. Please feel free to continue to report any other bugs you may find. ** Changed in: mysql-dfsg-5.1 (Ubuntu) Importance: Low => Medium ** Changed in: mysql-dfsg-5.1 (Ubuntu) Status: Confirmed => Triaged ** This bug has been marked a duplicate of bug 79 missing apparmor access rule -- CPU information is inaccessible for MySQL https://bugs.launchpad.net/bugs/448656 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 448656] Re: CPU information is inaccessible for MySQL
That is upgrade related issue as well, usually they both come hand in hand (adding apparmor permission and commenting skip-bdb). I was referring to this in my earlier post. Glad you got it working now. -- CPU information is inaccessible for MySQL https://bugs.launchpad.net/bugs/448656 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 448656] Re: CPU information is inaccessible for MySQL
following the thread at: http://ubuntuforums.org/archive/index.php/t-1305921.html I also solved the issue by commenting the following line: skip-bdb in /etc/mysql/my.cnf long life toUbuntu! :) -- CPU information is inaccessible for MySQL https://bugs.launchpad.net/bugs/448656 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 448656] Re: CPU information is inaccessible for MySQL
The following worked for me 1. Edit /etc/apparmor.d/usr.sbin.mysqld and add the line /sys/devices/system/cpu/ r, 2. Restart apparmor (as root): /etc/init.d/apparmor restart -- CPU information is inaccessible for MySQL https://bugs.launchpad.net/bugs/448656 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 448656] Re: CPU information is inaccessible for MySQL
Disabling AppArmor may not be desirable solution, but as you see there could be error in apparmor's mysql configuration and then in configuration of mysql itself. When you disable apparmor for debugging you are one step ahead because mysql now actually produces some logs why it can't start (eg in my case some option that just needed to be commented. I doubt that mysqld would run with proper mysql conf and misconfigured apparmor). -- CPU information is inaccessible for MySQL https://bugs.launchpad.net/bugs/448656 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 448656] Re: CPU information is inaccessible for MySQL
So, disabling AppArmor is not a proper solution, while MySQL may be misconfigured. -- CPU information is inaccessible for MySQL https://bugs.launchpad.net/bugs/448656 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 448656] Re: CPU information is inaccessible for MySQL
Suggestion: Add line /sys/devices/system/* r, to your /etc/apparmor.d/usr.sbin.mysqld Then check your syslog/mysql-log again if there is something else e.g. i personnaly had problem with package in kubuntu. After adding rule I saw error in log complaining about bdb something. I opened /etc/mysql/my.cnf and commented the line with bdb option and it runs now. HTH, Regards, Marek -- CPU information is inaccessible for MySQL https://bugs.launchpad.net/bugs/448656 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 448656] Re: CPU information is inaccessible for MySQL
This is caused by AppArmor, if you stop AppArmor via /etc/init.d/apparmor stop start Mysql via /etc/init.d/mysql start My Sql will run and you can now restart apparmor via /etc/init.d/apparmor start Now I try to find the necessary setting for the apparmor profile. Cheers, Ihon -- CPU information is inaccessible for MySQL https://bugs.launchpad.net/bugs/448656 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 448656] Re: CPU information is inaccessible for MySQL
Confirmed on fresh Kubuntu 9.10: after calling /etc/init.d/mysql script server fails to start an dmesg shows following: 17672.383215] type=1503 audit(1257090344.464:108): operation="open" pid=23872 parent=23871 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/ -- CPU information is inaccessible for MySQL https://bugs.launchpad.net/bugs/448656 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 448656] Re: CPU information is inaccessible for MySQL
2JBB: No, using only default values from package. Data folders have right permissions, and as I suppose it really shouldn't depend on it. vitaly:/var/lib$ ls -l mysql total 28764 -rw-r--r-- 1 mysql mysql0 2009-10-08 12:18 debian-5.1.flag -rw-rw 1 mysql mysql 18874368 2009-11-01 03:17 ibdata1 -rw-rw 1 mysql mysql 5242880 2009-11-01 11:15 ib_logfile0 -rw-rw 1 mysql mysql 5242880 2009-05-31 14:32 ib_logfile1 drwx-- 2 mysql mysql12288 2009-08-18 20:34 kvop drwxr-xr-x 2 mysql mysql 4096 2009-10-08 12:18 mysql -rw--- 1 mysql mysql6 2009-08-18 20:34 mysql_upgrade_info drwx-- 2 mysql mysql12288 2009-11-01 00:43 photohost drwx-- 2 mysql mysql 4096 2009-05-31 14:40 phpmyadmin drwx-- 2 mysql mysql 4096 2009-09-07 00:45 ramdim drwx-- 2 mysql mysql 4096 2009-07-31 01:34 ravall_uckov -- CPU information is inaccessible for MySQL https://bugs.launchpad.net/bugs/448656 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 448656] Re: CPU information is inaccessible for MySQL
You may have a permission issue. Did you change the directories mysql is accessing. For me, this was resolved by granting the mysql user under which mysql runs access to the relevant directories (/log/mysql /lib/mysql /etc/mysql). i.e., chown -R mysql:mysql -- CPU information is inaccessible for MySQL https://bugs.launchpad.net/bugs/448656 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 448656] Re: CPU information is inaccessible for MySQL
I got the same errors in syslog, added /sys/devices/system/cpu/ r, and /sys/devices/system/* r, to the apparmor config for mysql, but no go. upgraded 9.04 to 9.10, i have my database in a non standard folder, mentioned in the apparmor file since 9.04. -- CPU information is inaccessible for MySQL https://bugs.launchpad.net/bugs/448656 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 448656] Re: CPU information is inaccessible for MySQL
This also happens when you try and reinstall mysql-server [ 634.638825] type=1503 audit(1256857087.602:77): operation="open" pid=4201 parent=4200 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/" Error message in window: E: mysql-server-5.1: subprocess installed post-installation script returned error exit status 1 E: mysql-server: dependency problems - leaving unconfigured -- CPU information is inaccessible for MySQL https://bugs.launchpad.net/bugs/448656 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 448656] Re: CPU information is inaccessible for MySQL
Same goes here. [ 634.638825] type=1503 audit(1256857087.602:77): operation="open" pid=4201 parent=4200 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/" -- CPU information is inaccessible for MySQL https://bugs.launchpad.net/bugs/448656 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 448656] Re: CPU information is inaccessible for MySQL
** Changed in: mysql-dfsg-5.1 (Ubuntu) Status: Incomplete => Confirmed -- CPU information is inaccessible for MySQL https://bugs.launchpad.net/bugs/448656 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 448656] Re: CPU information is inaccessible for MySQL
For me, yes it does. -- CPU information is inaccessible for MySQL https://bugs.launchpad.net/bugs/448656 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 448656] Re: CPU information is inaccessible for MySQL
Thank you for taking the time to report this bug and helping to make Ubuntu better. Does this prevent mysql from starting correclty? ** Changed in: mysql-dfsg-5.1 (Ubuntu) Importance: Undecided => Low ** Changed in: mysql-dfsg-5.1 (Ubuntu) Status: New => Incomplete -- CPU information is inaccessible for MySQL https://bugs.launchpad.net/bugs/448656 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs