I just updated to Ubuntu 11.10 “Oneiric” on one of my desktops and I ran into an issue with MariaDB.

It’s not an issue with MariaDB itself, more in how the MariaDB “Natty” .deb packages are configured. We haven’t released .deb packages for Ubuntu 11.10 “Oneiric”, but the Natty packages work fine, apart from this one configuration issue (and when we do release “Oneiric” packages, they will work out-of-the-box).

The main problem is that some things have moved around in “Oneiric” and Apparmor doesn’t like the MariaDB “Natty” Apparmor defaults file because it doesn’t account for some of the new destinations. Specifically, /var/run has been moved to /run (a discussion of the rationale behind the move can be found here). Other things have been moved too, but the /var/run to /run move is the one that is causing trouble.

I searched launchpad and found bug #810270 which talks about the move and some of the packages, including MySQL, which needed to be updated. So for the version of MySQL in the official Ubuntu repositories, things are fixed. To fix things on my local machine I took a look at Ubuntu’s MySQL apparmor-profile file and saw four differences between it and my local /etc/apparmor.d/usr.sbin.mysqld file:

  1. /etc/mysql/my.cnf r,” was changed to “/etc/mysql/*.cnf r,
  2. /var/run/mysqld/mysqld.pid w,” was changed to “/{,var/}run/mysqld/mysqld.pid w,
  3. /var/run/mysqld/mysqld.sock w,” was changed to “/{,var/}run/mysqld/mysqld.sock w,
  4. /usr/lib/mysql/plugin/ r,” was added

After making the above changes everything appears to be OK. Official MariaDB .deb packages for Ubuntu 11.10 “Oneiric” are coming, but until they arrive, I can at least continue to use the old MariaDB “Natty” packages.

Let me know in the comments if you’ve run into any other issues trying to run, install, or upgrade the MariaDB “Natty” packages on “Oneiric”. Thanks!

P.S. I don’t think I will ever get used to writing “Oneiric”. It’s just such an awkward word. Whatever happened to ‘i’ before ‘e’ except after ‘c’?

**Update 2 Nov 2011** We’ve updated our MariaDB 5.2.9 packages with a fix for the Oneiric upgrade issue (and we have added real Oneiric packages). What we’ve decided to do is remove the apparmor profile we ship with MariaDB. If you’ve customized your profile like above, when you update to the new version (the only change is to the apparmor profile) you will be prompted to keep your existing profile our use our (empty) profile. It is safe to use our empty profile. If you haven’t customized your profile then the update will remove the old apparmor profile.

  • André

    Hi,

    I added Maria into my sources as per your site instructions for NATTY.
    Then it failed to complete installation of Server+Client as expected.
    I applied your changes to apparmor file and chose reinstall : it works.
    Nothing new for you….but thank you for your post

    • André

      Hi,
      I replaced my mariadb.list sources with the ones of 5.3.3 rc and I get a failure on setting up mariadb-server, complaining about mariadb-server-5.3 that produces an error 1 on post setup (–configure).
      Any advise?
      Thanks.

      • André

        But phpmyadmin shows version 5.3.3-MariaDB-rc-mariadb108~oneiric-log…

      • http://daniel-bartholomew.com Daniel Bartholomew

        Can you submit a bug report? There are full instructions on submitting bug reports at http://kb.askmonty.org/en/reporting-bugs but the basic instructions are to go to https://launchpad.net/maria , click on “Report a bug”, and follow the prompts.

        The developers also hang out in #maria on Freenode IRC (see: http://kb.askmonty.org/en/irc for help with IRC), so you can ask there.

  • André

    One question though, shouldn’t the socket be in /run/mysql…. instead of /var/run/mysql…
    Will that be case in the future as per FHS new structure?
    Thanks

  • David

    @Andre

    I think you will find the /{.var/} will check both places. The result is probably dependant on how you orriginally installed MySQL / Maria.

    Thanks to Daniel for this posting.

    My migration from MySQL to Maria on my personal system seems to have gone without a problem, initially I was concerned I may loose all my data tables, but the repository seemed to keep everything in place…. now to change my table to the maria engine.

  • Pingback: MariaDB | Marco Ordoñez