[Pkg-roundcube-maintainers] Bug#708339: roundcube-core: db upgrade issues going from squeeze to wheezy

[Frédéric Gobry]

Package: roundcube
Version: 0.7.2-9
Severity: important

Dear Maintainer,

I've upgraded my squeeze system to wheezy and faced problems during the roundcube mysql update.

Detailed sequence:

* The first upgrade failed because I had modified the mysql permissions of root at localhost. This is
not a bug in itself, I just let you know for the context:

Creating database backup in /var/cache/dbconfig-common/backups/roundcube_0.3.1-6.mysql.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO).
unable to connect to mysql server.
error encountered backing up the old database:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

* once I had modified the permissions back, I retried the upgrade (in "don't ask questions" mode)
but this failed again: 

creating database backup in /var/cache/dbconfig-common/backups/roundcube_0.3.1-6.mysql.
applying upgrade sql for 0.3.1-6 -> 0.5-1.
applying upgrade sql for 0.3.1-6 -> 0.6+dfsg-1.
applying upgrade sql for 0.3.1-6 -> 0.7-1.
applying upgrade sql for 0.3.1-6 -> 0.7.1-1.
dbconfig-common: flushing administrative password
applying upgrade sql for 0.3.1-6 -> 0.5-1.
error encountered processing /usr/share/dbconfig-common/data/roundcube/upgrade/mysql/0.5-1:
mysql said: ERROR 1146 (42S02) at line 5: Table 'roundcube.messages' doesn't exist

I'm surprised to see that the 0.3.1-6 - > 0.5-1 step took place twice. The failure is
caused by the "messages" table being dropped in the 0.3.1-6 -> 0.7-1 update.

I then started hacking my way through it, and noticed that the backup in /var/cache was
actually in a strange mixed state. Turns out that the backup is recreated at _every_
attempt. So, after the first failed attempt, the backup is replaced with a half-backed
one, which means that even if I had fixed the duplicate application of the update
script, I wouldn't have been able to go smoothly through the whole process.

Luckily I had another pristine backup, and used that to get out of it (along with changing
the upgrade script to succeeded). I didn't look into the reason why the script was applied
multiple times, but the last attempt looked like:

creating database backup in /var/cache/dbconfig-common/backups/roundcube_0.3.1-6.mysql.
applying upgrade sql for 0.3.1-6 -> 0.5-1.
applying upgrade sql for 0.3.1-6 -> 0.6+dfsg-1.
applying upgrade sql for 0.3.1-6 -> 0.7-1.
applying upgrade sql for 0.3.1-6 -> 0.7.1-1.
dbconfig-common: flushing administrative password
applying upgrade sql for 0.3.1-6 -> 0.7.1-1.
dbconfig-common: flushing administrative password
applying upgrade sql for 0.3.1-6 -> 0.7.1-1.
dbconfig-common: flushing administrative password

Let me know if there are additional bits of information you'd find useful.

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

Kernel: Linux 2.6.32.33-kvm-i386-20111128-dirty (SMP w/1 CPU core)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages roundcube-core depends on:
ii  apache2-mpm-prefork [httpd]  2.2.22-13
ii  dbconfig-common              1.8.47+nmu1
ii  debconf [debconf-2.0]        1.5.49
ii  libjs-jquery                 1.7.2+dfsg-1
ii  libjs-jquery-ui              1.8.ooops.21+dfsg-2
ii  libmagic1                    5.11-2
ii  php-auth                     1.6.2-1
ii  php-mail-mime                1.8.4-1
ii  php-mdb2                     2.5.0b3-2
ii  php-net-smtp                 1.6.1-1
ii  php-net-socket               1.0.9-2
ii  php5                         5.4.4-14
ii  php5-gd                      5.4.4-14
ii  php5-intl                    5.4.4-14
ii  php5-mcrypt                  5.4.4-14
ii  php5-pspell                  5.4.4-14
ii  roundcube-mysql              0.7.2-9
ii  tinymce                      3.4.8+dfsg0-1
ii  ucf                          3.0025+nmu3

roundcube-core recommends no packages.

Versions of packages roundcube-core suggests:
ii  php-auth-sasl      1.0.4-1
pn  php-crypt-gpg      <none>
pn  roundcube-plugins  <none>

roundcube depends on no packages.

-- debconf information:
  roundcube/dbconfig-install: true
  roundcube/db/dbname: roundcube
  roundcube/pgsql/authmethod-admin: ident
  roundcube/pgsql/admin-user: postgres
  roundcube/internal/skip-preseed: false
  roundcube/db/app-user: roundcube
  roundcube/dbconfig-reinstall: false
  roundcube/restart-webserver: true
  roundcube/dbconfig-upgrade: true
  roundcube/remote/port:
  roundcube/pgsql/no-empty-passwords:
  roundcube/passwords-do-not-match:
  roundcube/internal/reconfiguring: false
* roundcube/upgrade-error: retry (skip questions)
  roundcube/pgsql/authmethod-user: password
  roundcube/purge: false
  roundcube/language: en_US
  roundcube/remote/newhost:
  roundcube/pgsql/changeconf: false
  roundcube/upgrade-backup: true
  roundcube/install-error: abort
  roundcube/mysql/admin-user: root
  roundcube/hosts:
  roundcube/dbconfig-remove:
  roundcube/mysql/method: unix socket
  roundcube/remove-error: abort
  roundcube/pgsql/method: unix socket
  roundcube/pgsql/manualconf:
  roundcube/db/basepath:
  roundcube/reconfigure-webserver: apache2, lighttpd
  roundcube/database-type: mysql
  roundcube/remote/host:
  roundcube/missing-db-package-error: abort