[Pkg-roundcube-maintainers] Bug#700833: roundcube-core: fails to upgrade from squeeze-backports to wheezy

[Vincent Bernat]

reassign 700833 dbconfig-common
severity 700833 normal
retitle 700833 Error on backup when changing database type during upgrades
thanks

 ❦ 18 février 2013 06:48 CET, Andreas Beckmann <anbe at debian.org> :

> Package: roundcube-core
> Version: 0.7.2-5
> Severity: important
> User: debian-qa at lists.debian.org
> Usertags: piuparts
> Control: affects -1 + roundcube-plugins
>
> Hi,
>
> during a test with piuparts I noticed your package fails to upgrade from
> 'squeeze-backports'.
> It installed fine in 'squeeze-bpo', then the upgrade to 'wheezy'
> fails.

Hi Andreas!

Thanks for the report. The problem arises when upgrading from a sqlite
database to a mysql database. There is currently no upgrade path (there
is another bug against roundcube for this). Moreover dbconfig-common
does not handle a change in the backend like in your non interactive
upgrade which leads to this error:

>   Setting up roundcube-core (0.7.2-5) ...
>   Installing new version of config file /etc/logrotate.d/roundcube-core ...
>   dbconfig-common: writing config to /etc/dbconfig-common/roundcube.conf
>   Replacing config file /etc/dbconfig-common/roundcube.conf with new version
>   Replacing config file /etc/roundcube/debian-db.php with new version
>   creating database backup in /var/cache/dbconfig-common/backups/roundcube_0.7.1-1~bpo60+1.mysql.
>   error encountered backing up the old database:
>   mysqldump: Got error: 1049: Unknown database 'roundcube' when selecting the database
>   dbconfig-common: roundcube configure: aborted.
>   dbconfig-common: flushing administrative password
>   dpkg: error processing roundcube-core (--configure):
>    subprocess installed post-installation script returned error exit
>   status 1

I suppose that dbconfig-common should backup the database using the
previous database (sqlite) and install the new database (mysql). I think
this is something pretty complicated to do. I reassign to
dbconfig-common and downgrade the severity.
-- 
#if 0
	2.2.16 /usr/src/linux/fs/buffer.c
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 835 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-roundcube-maintainers/attachments/20130218/859db10c/attachment.pgp>