package phpmyadmin 4:3.3.1-1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 10

[jacob.g]

Binary package hint: phpmyadmin

on update with the update-manager phpmyadmin didn't update right
asked whether I would like to reinstall the DB tables
answered yes
install failed

ProblemType: Package
DistroRelease: Ubuntu 10.04
Package: phpmyadmin 4:3.3.1-1
ProcVersionSignature: Ubuntu 2.6.32-20.30-generic 2.6.32.11+drm33.2
Uname: Linux 2.6.32-20-generic i686
NonfreeKernelModules: nvidia
Architecture: i386
Date: Wed Apr 14 13:45:53 2010
ErrorMessage: subprocess installed post-installation script returned error exit status 10
InstallationMedia: Ubuntu 10.04 "Lucid Lynx" - Beta i386 (20100318)
PackageArchitecture: all
SourcePackage: phpmyadmin
Title: package phpmyadmin 4:3.3.1-1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 10

[Michal Čihař (nijel)]

Fixed in 4:3.3.2-2.

[Launchpad Janitor (janitor)]

This bug was fixed in the package phpmyadmin - 4:3.3.2-2

---------------
phpmyadmin (4:3.3.2-2) unstable; urgency=low

  * Add SQL to create tracking table on upgrade (LP: #565627).
  * Include SQL script to create table with fixed SQL comments (LP: #563256).
 -- Ubuntu Archive Auto-Sync <email address hidden> Sun, 09 May 2010 13:59:47 +0100

[John M. Rasor (jmrasor-donboscowest)]

I logged what I did yesterday to provoke this bug:

 Installed phpMyAdmin. mysql and php Apache mod came with it. [operator error: did not install mysql-server. See below.] Installation failed; did not accept any proposed password; suggested abort. Surf to http://elbereth/phpmyadmin: 404. [Elbereth is my workstation, the machine affected.] There's no myphpadmin stuff in /etc/apache2/conf.d; there is on testserver. [A test server running Lucid server edition 32-bit, LAMP, fully updated].
 Using package manager, re-install. Ended quietly, no password request. No http://elbereth/phpmyadmin, either. No /etc/apache2/conf.d/phpmyadmin.conf as there is on testserver. Copied /etc/phpmyadmin/apache.conf into /etc/apache2/conf.d: after restarting Apache, http://elbereth/phpmyadmin shows up. Can't log in.
 Re-do installation with sudo dpkg-reconfigure -plow phpmyadmin. This runs interactive setup script.
 Re-install database.
 Use local unix socket.
 Database administrator: root.
 His password: xxxxx.
 MySQL database owner: phpmyadmin.
 Name of MySQL database: phpmyadmin.
 Web server: apache2. Error 2002: bad socket /var/run/mysqld/mysqld.sock. Retry.
 Configure with dbconfig-common.
 tcp/ip socket.
 Host is localhost.
 Port number: leave blank.
 Database administrator: root.
 MySQL database owner: phpmyadmin.
 Name of MySQL database: phpmyadmin. That finished with warning about overlapping Alias in /etc/apache2/conf.d/phpmyadmin.conf at line 3. Restart Apache: same gripe. Can't log in to main or to setup page. Set $dbuser='phpmyadmin', $dbpass='xxxxx' in /etc/phpmyadmin/config-db.php: no help.
 Reboot: no help. Dpkg-reconfigure again.
 Re-install database.
 tcp/ip socket.
 Host is localhost.
 Default port.
 Database administrator: root. Password: xxxxx.
 Database owner: phpmyadmin.
 Database name:
 Web server: apache2.
 New /etc/phpmyadmin/config-db.php is available, but existing copy is locally modified. Install package maintainer's version. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock. There is no /var/run/mysqld. As root, make /var/run/mysqld and touch mysqld.sock in there. Retry (skip questions): overlapping Alias. Login fails with no message, just presents login dialog again. From command line, mysql: same bad socket message.
 Is mysql running? Try sudo /etc/init.d/mysql start: nope, no mysql script in there. It is running on testserver. That server has a serious-looking /etc/init.d/mysql. On Elbereth, mysqld –verbose –help: looks like it's not installed.
 Using package manager, completely remove mysql-client and phpmyadmin. Error: tried to erase existing database, failed. Install: mysql-client, mysql-server, phpmyadmin. Installed, twice asked for root mysql user's password, finished without a whimper. Mysql user root can log in with xxxxx.
 Create database “directory”. Create 5-field table on it. Add integer field “founded” at end. Populate with a couple of houses. http://elbereth/directory-database/show_houses.htm doesn't show them, because users are not set up.
 Switch to database mysql. Look at table “user”. Add one: public on localhost, with no password. Nope, “#1582 - Incorrect para...