Failed to dist-upgrade mythtv-database

[Malcolm Parsons]

dist-upgrade from Dapper to Edgy

Setting up mythtv-database (0.20-0.2ubuntu2) ...
Failed to connect to database: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at -e line 5, <> line 1.
Failed to create database (incorrect admin username/password?)
If you supplied incorrect information, try:
dpkg-reconfigure --force mythtv-database
dpkg: error processing mythtv-database (--configure):
 subprocess post-installation script returned error exit status 1

The MySQL server is not running when mythtv-database tries to connect to it.

[Mario Limonciello (superm1)]

For mythtv-database to properly install, mysqld has to be running. Can you start it and attempt:

sudo apt-get -f install

[Malcolm Parsons (malcolm-parsons)]

As this is a dist-upgrade, both mysql-server and mythtv-database are upgraded at the same time.

From term.log:
Preparing to replace mysql-server-5.0 5.0.22-0ubuntu6.06.2 (using .../mysql-server-5.0_5.0.24a-9_amd64.deb) ...
Stopping MySQL database server: mysqld
Stopping MySQL database server: mysqld.
Stopping MySQL database server: mysqld
Unpacking replacement mysql-server-5.0 ...
Preparing to replace mythtv-database 0.18.1-5ubuntu3 (using .../mythtv-database_0.20-0.2ubuntu2_all.deb) ...
Unpacking replacement mythtv-database ...
...
Setting up mythtv-database (0.20-0.2ubuntu2) ...
dpkg: error processing mythtv-database (--configure):
...
Setting up mysql-server-5.0 (5.0.24a-9) ...
 * Stopping MySQL database server mysqld
 * Stopping MySQL database server mysqld [ ok ]
 * Starting MySQL database server mysqld
 * Starting MySQL database server mysqld [ ok ]

So the problem is the order in which the two packages are set up.
As mythtv-database does not depend on mysql-server, apt/dpkg sees no reason to set up mysql-server first.

Basically, this change doesn't work:

mythtv (0.20-0.0) unstable; urgency=low
...
  * mythtv-database should depends on mysql-client instead of mysql-server.
 -- Christian Marillat <email address hidden> Tue, 12 Sep 2006 08:46:02 +0200

From the last two lines of term.log you can see that mythtv-database did actually install in the end:
Setting up mythtv-database (0.20-0.2ubuntu2) ...
Setting up mythtv (0.20-0.2ubuntu2) ...

[Mario Limonciello (superm1)]

Mythtv related problem, not update-manager.