[debian-mysql] Bug#617448: mysql-server-5.1: it stopped working after upgrade from Lenny to Squeeze

[Mark Grieveson]

Package: mysql-server-5.1
Version: 5.1.49-3
Severity: normal

After upgrading, it stopped working.  I used it with the program anymeal, and this program no longer works.  When I tried to reinstall it, it gave the following message:
debian:/home/mark# apt-get --reinstall install mysql-server-5.1
Reading package lists... Done
Building dependency tree       
Reading state information... Done
0 upgraded, 0 newly installed, 1 reinstalled, 0 to remove and 31 not upgraded.
2 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Setting up mysql-server-5.1 (5.1.49-3) ...
 * Stopping MySQL database server mysqld                                 [ ok ] 
 * 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
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.1; however:
  Package mysql-server-5.1 is not configured yet.
dpkg: error processing mysql-server (--configure):
 dependency problems - leaving unconfigured
configured to not write apport reports
                                      configured to not write apport reports
                                                                            Errors were encountered while processing:
 mysql-server-5.1
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
debian:/home/mark# 

-- System Information:
Debian Release: 6.0
  APT prefers squeeze-updates
  APT policy: (500, 'squeeze-updates')
Architecture: i386 (i686)

Kernel: Linux 2.6.32-5-686 (SMP w/1 CPU core)
Locale: LANG=en_CA.UTF-8, LC_CTYPE=en_CA.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages mysql-server-5.1 depends on:
ii  adduser              3.112+nmu2          add and remove users and groups
ii  debconf [debconf-2.0 1.5.36.1            Debian configuration management sy
ii  libc6                2.11.2-10           Embedded GNU C Library: Shared lib
ii  libdbi-perl          1.612-1             Perl Database Interface (DBI)
ii  libgcc1              1:4.4.5-8           GCC support library
ii  libmysqlclient16     5.1.49-3            MySQL database client library
ii  libstdc++6           4.4.5-8             The GNU Standard C++ Library v3
ii  lsb-base             3.2-23.2squeeze1    Linux Standard Base 3.2 init scrip
ii  mysql-client-5.1     5.1.49-3            MySQL database client binaries
ii  mysql-common         5.1.49-3            MySQL database common files, e.g. 
ii  mysql-server-core-5. 5.1.49-3            MySQL database server binaries
ii  passwd               1:4.1.4.2+svn3283-2 change and administer password and
ii  perl                 5.10.1-17           Larry Wall's Practical Extraction 
ii  psmisc               22.11-1             utilities that use the proc file s
ii  zlib1g               1:1.2.3.4.dfsg-3    compression library - runtime

Versions of packages mysql-server-5.1 recommends:
ii  bsd-mailx [mailx]  8.1.2-0.20100314cvs-1 simple mail user agent
ii  heirloom-mailx [ma 12.4-2                feature-rich BSD mail(1)
ii  libhtml-template-p 2.9-2                 module for using HTML Templates wi
ii  mailx              1:20071201-3          Transitional package for mailx ren

Versions of packages mysql-server-5.1 suggests:
pn  tinyca                        <none>     (no description available)

-- Configuration Files:
/etc/logcheck/ignore.d.paranoid/mysql-server-5_1 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.paranoid/mysql-server-5_1'
/etc/logcheck/ignore.d.server/mysql-server-5_1 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.server/mysql-server-5_1'
/etc/logcheck/ignore.d.workstation/mysql-server-5_1 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.workstation/mysql-server-5_1'

-- debconf information:
  mysql-server-5.1/postrm_remove_databases: false
  mysql-server-5.1/really_downgrade: false
  mysql-server/error_setting_password:
  mysql-server-5.1/start_on_boot: true
  mysql-server-5.1/nis_warning:
  mysql-server/password_mismatch:
  mysql-server/no_upgrade_when_using_ndb: