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@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 -- To UNSUBSCRIBE, email to [email protected] with a subject of "unsubscribe". Trouble? Contact [email protected]
