[Bug 880339] Re: AppArmor profile needs update
Hi Andres. It's funny, but my amarok is not using its own instance, nor storing its files elswhere: sudo ls -alh /var/lib/mysql/ totaal 21M drwx-- 4 mysql mysql 4.0K 2012-03-12 19:39 . drwxr-xr-x 76 root root 4.0K 2011-10-21 22:10 .. drwx-- 2 mysql mysql 4.0K 2012-03-10 19:07 amarokdb -rw-r--r-- 1 root root 0 2011-10-18 19:16 debian-5.1.flag -rw-rw 1 mysql mysql 10M 2012-03-12 19:38 ibdata1 -rw-rw 1 mysql mysql 5.0M 2012-03-12 19:39 ib_logfile0 -rw-rw 1 mysql mysql 5.0M 2011-10-18 19:16 ib_logfile1 drwx-- 2 mysql root 4.0K 2011-10-18 19:17 mysql -rw-rw 1 root root 6 2011-10-18 19:17 mysql_upgrade_info So I don't understand why for you it gives no problems, and for me it did. -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/880339 Title: AppArmor profile needs update To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/880339/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 880339] Re: AppArmor profile needs update
Hi Jürgen, So I have tried to reproduce this bug again but have been unable to. However, the only thing that comes to my mind is that maybe amarok is probably installing a the datadir in a different path from the location that is usually used (./var/lib/mysql) or maybe trying to spawn its own mysql instances, and of course, apparmor prevents doing either of those. Could you verify the settings that amarok is using for mysql, and find out whether amarok is trying to use its own instance of mysql, or installing the databases in a different location. Cheers. -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/880339 Title: AppArmor profile needs update To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/880339/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 880339] Re: AppArmor profile needs update
** Changed in: mysql-5.1 (Ubuntu) Milestone: ubuntu-12.04-beta-1 = ubuntu-12.04-beta-2 -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/880339 Title: AppArmor profile needs update To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/880339/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 880339] Re: AppArmor profile needs update
** Tags added: rls-p-tracking -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/880339 Title: AppArmor profile needs update To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/880339/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 880339] Re: AppArmor profile needs update
** Changed in: mysql-5.1 (Ubuntu Precise) Milestone: precise-alpha-1 = ubuntu-12.04-beta-1 -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/880339 Title: AppArmor profile needs update To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/880339/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 880339] Re: AppArmor profile needs update
I was unable to reproduce it again, but looking into a bit more closely. Once more data is gathered I'll provide an update. ** Changed in: mysql-5.1 (Ubuntu Precise) Status: Confirmed = Incomplete -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/880339 Title: AppArmor profile needs update To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/880339/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 880339] Re: AppArmor profile needs update
Hi guys, I'll do another clean install and test whether a see this or not. Cheers. -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/880339 Title: AppArmor profile needs update To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/880339/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 880339] Re: AppArmor profile needs update
Sorry Andres for forgetting to reply to #3, but no, I have only one database on that PC, and that's Amarok's DB, in default location. My home PC sleeps right now apparently; if you still need it, please let me know, and I'll send you my apparmor profile. -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/880339 Title: AppArmor profile needs update To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/880339/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 880339] Re: AppArmor profile needs update
I have the same issue. Is there a resolution yet? I've already checked for unmerged configuration files and there are none. My dmesg contains a bunch of these: [611629.676337] init: mysql main process (20978) terminated with status 1 [611629.676358] init: mysql main process ended, respawning [611657.973001] init: mysql post-start process (20979) terminated with status 1 [611657.975861] type=1400 audit(1328627557.750:40441): apparmor=STATUS operation=profile_replace name=/usr/sbin/mysqld pid=21102 comm=apparmor_parser [611659.185792] type=1400 audit(1328627558.966:40442): apparmor=DENIED operation=mknod parent=1 profile=/usr/sbin/mysqld name=/run/mysqld/mysqld.sock pid=21106 comm=mysqld requested_mask=c denied_mask=c fsuid=116 ouid=116 ** Changed in: mysql-5.1 (Ubuntu Precise) Status: Invalid = Confirmed -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/880339 Title: AppArmor profile needs update To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/880339/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 880339] Re: AppArmor profile needs update
Funny, because I did a clean install too. I cannot give you more info then what I gave you before, as far as I know. Presently, apparmor is disabled on mysql. Anything more I can do for you? -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/880339 Title: AppArmor profile needs update To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/880339/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 880339] Re: AppArmor profile needs update
Hi Jurgen, Have you installed any databases in a different location than the default one? Cause I've seen issues like yours but only when changing the location of the databases. Other than that, I have re-tested this in another clean install without any issues. Could you please attach the apparmor profile file? Install log: roaksoax@pursue:~$ sudo apt-get install mysql-server Reading package lists... Done Building dependency tree Reading state information... Done The following extra packages will be installed: libdbd-mysql-perl mysql-client-5.1 mysql-client-core-5.1 mysql-server-5.1 mysql-server-core-5.1 Suggested packages: tinyca The following NEW packages will be installed: libdbd-mysql-perl mysql-client-5.1 mysql-client-core-5.1 mysql-server mysql-server-5.1 mysql-server-core-5.1 0 upgraded, 6 newly installed, 0 to remove and 0 not upgraded. Need to get 0 B/20.9 MB of archives. After this operation, 53.6 MB of additional disk space will be used. Do you want to continue [Y/n]? y Preconfiguring packages ... Selecting previously deselected package libdbd-mysql-perl. (Reading database ... 232434 files and directories currently installed.) Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.019-1_amd64.deb) ... Selecting previously deselected package mysql-client-core-5.1. Unpacking mysql-client-core-5.1 (from .../mysql-client-core-5.1_5.1.58-1ubuntu1_amd64.deb) ... Selecting previously deselected package mysql-client-5.1. Unpacking mysql-client-5.1 (from .../mysql-client-5.1_5.1.58-1ubuntu1_amd64.deb) ... Selecting previously deselected package mysql-server-core-5.1. Unpacking mysql-server-core-5.1 (from .../mysql-server-core-5.1_5.1.58-1ubuntu1_amd64.deb) ... Selecting previously deselected package mysql-server-5.1. Unpacking mysql-server-5.1 (from .../mysql-server-5.1_5.1.58-1ubuntu1_amd64.deb) ... Selecting previously deselected package mysql-server. Unpacking mysql-server (from .../mysql-server_5.1.58-1ubuntu1_all.deb) ... Processing triggers for man-db ... Processing triggers for ureadahead ... Setting up libdbd-mysql-perl (4.019-1) ... Setting up mysql-client-core-5.1 (5.1.58-1ubuntu1) ... Setting up mysql-client-5.1 (5.1.58-1ubuntu1) ... Setting up mysql-server-core-5.1 (5.1.58-1ubuntu1) ... Setting up mysql-server-5.1 (5.1.58-1ubuntu1) ... mysql start/running, process 24002 Setting up mysql-server (5.1.58-1ubuntu1) ... Syslog: Nov 15 11:30:42 pursue mysqld[23794]: Nov 15 11:30:42 pursue mysqld[23794]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! Nov 15 11:30:42 pursue mysqld[23794]: To do so, start the server, then issue the following commands: Nov 15 11:30:42 pursue mysqld[23794]: Nov 15 11:30:42 pursue mysqld[23794]: /usr/bin/mysqladmin -u root password 'new-password' Nov 15 11:30:42 pursue mysqld[23794]: /usr/bin/mysqladmin -u root -h pursue password 'new-password' Nov 15 11:30:42 pursue mysqld[23794]: Nov 15 11:30:42 pursue mysqld[23794]: Alternatively you can run: Nov 15 11:30:42 pursue mysqld[23794]: /usr/bin/mysql_secure_installation Nov 15 11:30:42 pursue mysqld[23794]: Nov 15 11:30:42 pursue mysqld[23794]: which will also give you the option of removing the test Nov 15 11:30:42 pursue mysqld[23794]: databases and anonymous user created by default. This is Nov 15 11:30:42 pursue mysqld[23794]: strongly recommended for production servers. Nov 15 11:30:42 pursue mysqld[23794]: Nov 15 11:30:42 pursue mysqld[23794]: See the manual for more instructions. Nov 15 11:30:42 pursue mysqld[23794]: Nov 15 11:30:42 pursue mysqld[23794]: Please report any problems with the /usr/scripts/mysqlbug script! Nov 15 11:30:42 pursue mysqld[23794]: Nov 15 11:31:09 pursue kernel: [ 5635.540221] type=1400 audit(1321374669.381:26): apparmor=STATUS operation=profile_load name=/usr/sbin/mysqld pid=23974 comm=apparmor_parser Nov 15 11:31:09 pursue kernel: [ 5635.566068] type=1400 audit(1321374669.409:27): apparmor=STATUS operation=profile_replace name=/usr/sbin/mysqld pid=23998 comm=apparmor_parser Nov 15 11:31:10 pursue /etc/mysql/debian-start[24023]: Upgrading MySQL tables if necessary. Nov 15 11:31:10 pursue /etc/mysql/debian-start[24027]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored Nov 15 11:31:10 pursue /etc/mysql/debian-start[24027]: Looking for 'mysql' as: /usr/bin/mysql Nov 15 11:31:10 pursue /etc/mysql/debian-start[24027]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Nov 15 11:31:10 pursue /etc/mysql/debian-start[24027]: This installation of MySQL is already upgraded to 5.1.58, use --force if you still need to run mysql_upgrade Nov 15 11:31:10 pursue /etc/mysql/debian-start[24034]: Checking for insecure root accounts. Nov 15 11:31:10 pursue /etc/mysql/debian-start[24038]: Triggering myisam-recover for all MyISAM tables For this reason, I'm marking this bug as invalid as I'm unable to reproduce it. If you still experience this issue and you believe this bug should remain open, please feel free to re-open this
[Bug 880339] Re: AppArmor profile needs update
Hi Jurgen, Thank you for taking the time to report bugs and trying to make Ubuntu Server better. Unfortunately, I have been unable to reproduce this bug report in oneiric. I have installed mysql-server in a clean ubuntu installation and I have not received the apparmor errors and mysql server is working as expected. Logs of apparmor show: Nov 10 13:12:04 * kernel: [11190.491403] type=1400 audit(1320948724.601:31): apparmor=STATUS operation=profile_replace name=/usr/sbin/mysqld pid=1056 comm=apparmor_parser Nov 10 13:12:04 * kernel: [11190.518857] type=1400 audit(1320948724.629:32): apparmor=STATUS operation=profile_replace name=/usr/sbin/mysqld pid=1087 comm=apparmor_parser Are you still experiencing this issue? For now, I'll mark this bug as incomplete until further confirmation of the bug report is received. ** Changed in: mysql-5.1 (Ubuntu Oneiric) Status: New = Incomplete ** Changed in: mysql-5.1 (Ubuntu Precise) Status: New = Incomplete -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/880339 Title: AppArmor profile needs update To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/880339/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 880339] Re: AppArmor profile needs update
** Changed in: mysql-5.1 (Ubuntu Precise) Assignee: (unassigned) = Andres Rodriguez (andreserl) -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/880339 Title: AppArmor profile needs update To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/880339/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 880339] Re: AppArmor profile needs update
** Also affects: mysql-5.1 (Ubuntu Oneiric) Importance: Undecided Status: New ** Also affects: mysql-5.1 (Ubuntu Precise) Importance: Undecided Status: New ** Changed in: mysql-5.1 (Ubuntu Precise) Milestone: None = precise-alpha-1 ** Changed in: mysql-5.1 (Ubuntu Oneiric) Milestone: None = oneiric-updates ** Changed in: mysql-5.1 (Ubuntu Oneiric) Importance: Undecided = Medium ** Changed in: mysql-5.1 (Ubuntu Precise) Importance: Undecided = Medium -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/880339 Title: AppArmor profile needs update To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/880339/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
