Functioning, fully updated 9.04 server running MySQL out of the box (presumably MySQL 5.0).
Apparently painless upgrade to 9.10. Everything I've tested so far works perfectly, except for MySQL, which refuses to start. This seems to be because of a failed script during the conversion process -- see below for output from manual attempt to install MySQL 5.1.
I've tried everything I can think of (back to 5.0 and back again, tweaking permissions on the socket directory, etc. Same result, and 5.0 doesn't work now either, so something important has been changed.
Any ideas or suggestions? Inasmuch as this was a plain vanilla setup that was working perfectly, I assume this might be a problem I'm not alone in experiencing.
------------------
$ sudo aptitude install mysql-server-5.1
Reading package lists... Done
Building dependency tree
Reading state information... Done
Reading extended state information
Initializing package states... Done
The following NEW packages will be installed:
libdbd-mysql-perl{a} libdbi-perl{a} libhtml-template-perl{a}
libnet-daemon-perl{a} libplrpc-perl{a} mysql-client-5.1{a}
mysql-server-5.1 mysql-server-core-5.1{a}
0 packages upgraded, 8 newly installed, 0 to remove and 0 not upgraded.
Need to get 0B/20,3MB of archives. After unpacking 48,7MB will be used.
Do you want to continue? [Y/n/?] y
Writing extended state information... Done
Preconfiguring packages ...
Selecting previously deselected package libnet-daemon-perl.
(Reading database ... 50271 files and directories currently installed.)
Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.43-1_all.deb) ...
Selecting previously deselected package libplrpc-perl.
Unpacking libplrpc-perl (from .../libplrpc-perl_0.2020-2_all.deb) ...
Selecting previously deselected package libdbi-perl.
Unpacking libdbi-perl (from .../libdbi-perl_1.609-1_i386.deb) ...
Selecting previously deselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.011-1ubuntu1_i386.deb) ...
Selecting previously deselected package mysql-client-5.1.
Unpacking mysql-client-5.1 (from .../mysql-client-5.1_5.1.37-1ubuntu5_i386.deb) ...
Selecting previously deselected package mysql-server-core-5.1.
Unpacking mysql-server-core-5.1 (from .../mysql-server-core-5.1_5.1.37-1ubuntu5_ i386.deb) ...
Selecting previously deselected package mysql-server-5.1.
Unpacking mysql-server-5.1 (from .../mysql-server-5.1_5.1.37-1ubuntu5_i386.deb) ...
* Stopping MySQL database server mysqld [ OK ]
Selecting previously deselected package libhtml-template-perl.
Unpacking libhtml-template-perl (from .../libhtml-template-perl_2.9-1_all.deb) . ..
Processing triggers for man-db ...
Setting up libnet-daemon-perl (0.43-1) ...
Setting up libplrpc-perl (0.2020-2) ...
Setting up libdbi-perl (1.609-1) ...
Setting up libdbd-mysql-perl (4.011-1ubuntu1) ...
Setting up mysql-client-5.1 (5.1.37-1ubuntu5) ...
Setting up mysql-server-core-5.1 (5.1.37-1ubuntu5) ...
Setting up mysql-server-5.1 (5.1.37-1ubuntu5) ...
* Stopping MySQL database server mysqld [ OK ]
091030 11:37:05 [Note] Plugin 'FEDERATED' is disabled.
091030 11:37:05 InnoDB: Started; log sequence number 0 43655
091030 11:37:05 [ERROR] /usr/sbin/mysqld: unknown option '--skip-bdb'
091030 11:37:05 [ERROR] Aborting
091030 11:37:05 InnoDB: Starting shutdown...
091030 11:37:06 InnoDB: Shutdown completed; log sequence number 0 43655
091030 11:37:06 [Warning] Forcing shutdown of 1 plugins
091030 11:37:06 [Note] /usr/sbin/mysqld: Shutdown complete
Warning: found usr.sbin.mysqld in /etc/apparmor.d/force-complain, forcing compla in mode
* Starting MySQL database server mysqld [fail]
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.1 (--configure):
subprocess installed post-installation script returned error exit status 1
Setting up libhtml-template-perl (2.9-1) ...
Errors were encountered while processing:
mysql-server-5.1
E: Sub-process /usr/bin/dpkg returned an error code (1)
A package failed to install. Trying to recover:
Setting up mysql-server-5.1 (5.1.37-1ubuntu5) ...
* Stopping MySQL database server mysqld [ OK ]
Warning: found usr.sbin.mysqld in /etc/apparmor.d/force-complain, forcing compla in mode
* Starting MySQL database server mysqld [fail]
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.1 (--configure):
subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
mysql-server-5.1
Reading package lists... Done
Building dependency tree
Reading state information... Done
Reading extended state information
Initializing package states... Done
Writing extended state information... Done
>>> Syslog:
Oct 30 11:41:09 nlhserver kernel: [ 6617.956712] __ratelimit: 6 callbacks suppressed
Oct 30 11:41:09 nlhserver kernel: [ 6617.956716] type=1502 audit(1256899269.707:664): operation="open" pid=8494 parent=8493 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:09 nlhserver kernel: [ 6617.956737] type=1502 audit(1256899269.707:665): operation="file_perm" pid=8494 parent=8493 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:09 nlhserver kernel: [ 6617.956758] type=1502 audit(1256899269.707:666): operation="file_perm" pid=8494 parent=8493 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:09 nlhserver kernel: [ 6617.986200] type=1502 audit(1256899269.735:667): operation="open" pid=8514 parent=8513 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:09 nlhserver kernel: [ 6617.986222] type=1502 audit(1256899269.735:668): operation="file_perm" pid=8514 parent=8513 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:09 nlhserver kernel: [ 6617.986243] type=1502 audit(1256899269.735:669): operation="file_perm" pid=8514 parent=8513 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:09 nlhserver mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Oct 30 11:41:09 nlhserver kernel: [ 6618.090559] type=1502 audit(1256899269.839:670): operation="open" pid=8634 parent=8520 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:09 nlhserver kernel: [ 6618.090581] type=1502 audit(1256899269.839:671): operation="file_perm" pid=8634 parent=8520 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:09 nlhserver kernel: [ 6618.090603] type=1502 audit(1256899269.839:672): operation="file_perm" pid=8634 parent=8520 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:09 nlhserver mysqld: 091030 11:41:09 [Note] Plugin 'FEDERATED' is disabled.
Oct 30 11:41:09 nlhserver mysqld: /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
Oct 30 11:41:09 nlhserver mysqld: 091030 11:41:09 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
Oct 30 11:41:09 nlhserver mysqld: 091030 11:41:09 InnoDB: Started; log sequence number 0 43655
Oct 30 11:41:09 nlhserver mysqld: 091030 11:41:09 [ERROR] /usr/sbin/mysqld: unknown option '--skip-bdb'
Oct 30 11:41:09 nlhserver mysqld: 091030 11:41:09 [ERROR] Aborting
Oct 30 11:41:09 nlhserver mysqld:
Oct 30 11:41:09 nlhserver mysqld: 091030 11:41:09 InnoDB: Starting shutdown...
Oct 30 11:41:10 nlhserver kernel: [ 6619.002058] type=1502 audit(1256899270.751:673): operation="open" pid=8648 parent=8647 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:11 nlhserver mysqld: 091030 11:41:11 InnoDB: Shutdown completed; log sequence number 0 43655
Oct 30 11:41:11 nlhserver mysqld: 091030 11:41:11 [Warning] Forcing shutdown of 1 plugins
Oct 30 11:41:11 nlhserver mysqld: 091030 11:41:11 [Note] /usr/sbin/mysqld: Shutdown complete
Oct 30 11:41:11 nlhserver mysqld:
Oct 30 11:41:11 nlhserver mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Oct 30 11:41:14 nlhserver kernel: [ 6623.064383] __ratelimit: 33 callbacks suppressed
Oct 30 11:41:14 nlhserver kernel: [ 6623.064386] type=1502 audit(1256899274.815:685): operation="open" pid=8690 parent=8689 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:14 nlhserver kernel: [ 6623.064408] type=1502 audit(1256899274.815:686): operation="file_perm" pid=8690 parent=8689 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:14 nlhserver kernel: [ 6623.064430] type=1502 audit(1256899274.815:687): operation="file_perm" pid=8690 parent=8689 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:15 nlhserver kernel: [ 6624.081069] type=1502 audit(1256899275.831:688): operation="open" pid=8700 parent=8699 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:15 nlhserver kernel: [ 6624.081092] type=1502 audit(1256899275.831:689): operation="file_perm" pid=8700 parent=8699 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:15 nlhserver kernel: [ 6624.081114] type=1502 audit(1256899275.831:690): operation="file_perm" pid=8700 parent=8699 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:16 nlhserver kernel: [ 6625.096187] type=1502 audit(1256899276.847:691): operation="open" pid=8710 parent=8709 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:16 nlhserver kernel: [ 6625.096208] type=1502 audit(1256899276.847:692): operation="file_perm" pid=8710 parent=8709 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:16 nlhserver kernel: [ 6625.096228] type=1502 audit(1256899276.847:693): operation="file_perm" pid=8710 parent=8709 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:17 nlhserver kernel: [ 6626.110232] type=1502 audit(1256899277.859:694): operation="open" pid=8720 parent=8719 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:19 nlhserver kernel: [ 6628.140422] __ratelimit: 15 callbacks suppressed
Oct 30 11:41:19 nlhserver kernel: [ 6628.140426] type=1502 audit(1256899279.891:700): operation="open" pid=8740 parent=8739 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:19 nlhserver kernel: [ 6628.140444] type=1502 audit(1256899279.891:701): operation="file_perm" pid=8740 parent=8739 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:19 nlhserver kernel: [ 6628.140464] type=1502 audit(1256899279.891:702): operation="file_perm" pid=8740 parent=8739 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:20 nlhserver kernel: [ 6629.154392] type=1502 audit(1256899280.903:703): operation="open" pid=8750 parent=8749 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:20 nlhserver kernel: [ 6629.154414] type=1502 audit(1256899280.903:704): operation="file_perm" pid=8750 parent=8749 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:20 nlhserver kernel: [ 6629.154436] type=1502 audit(1256899280.903:705): operation="file_perm" pid=8750 parent=8749 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:21 nlhserver kernel: [ 6630.169725] type=1502 audit(1256899281.919:706): operation="open" pid=8760 parent=8759 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:21 nlhserver kernel: [ 6630.169746] type=1502 audit(1256899281.919:707): operation="file_perm" pid=8760 parent=8759 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:21 nlhserver kernel: [ 6630.169767] type=1502 audit(1256899281.919:708): operation="file_perm" pid=8760 parent=8759 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:22 nlhserver kernel: [ 6631.185737] type=1502 audit(1256899282.935:709): operation="open" pid=8770 parent=8769 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
Oct 30 11:41:23 nlhserver /etc/init.d/mysql[8796]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Oct 30 11:41:23 nlhserver /etc/init.d/mysql[8796]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Oct 30 11:41:23 nlhserver /etc/init.d/mysql[8796]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Oct 30 11:41:23 nlhserver /etc/init.d/mysql[8796]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Oct 30 11:41:23 nlhserver /etc/init.d/mysql[8796]:
Bookmarks