« April 2009 | Main | May 2010 »

November 15, 2009

Mysql from Jaunty to Karmic

Apparently, when moving from Ubuntu 9.04 to 9.10 it upgrades mysql from 5.0 to 5.1 and it fails to do it right.

I get tons of these kinds of errors in these kinds of errors in /var/log/messages
Nov 15 21:12:00 moggio kernel: [50185.649110] type=1502 audit(1258337520.364:209): operation="open" pid=6906 parent=6905 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"

and trying to start mysql fails miserably.

I solved this by going into the /etc/mysql/my.cnf and commenting out the skip-bdb line.

After that mysql would start successfully and let me log in and it seems fine. Just need to test it with the stereo netbook running Amarok.

Actually I commented out "myisam-recover = BACKUP", too but I don't think that had any effect and I put it back on the next restart.

Posted by Matt at 09:13 PM | Comments (0)