[Pkg-roundcube-maintainers] Bug#898040: roundcube-core installation configuration fails in lighttpd+sqlite3 scenario

[Stephan Gerth]

Package: roundcube
Version: 1.2.3+dfsg.1-4+deb9u2
Severity: important

Dear Maintainer,

   * What led up to the situation?

Fresh installation of Debian Stretch (Basic Installation + SSH). Goal was to setup roundcube with sqlite3 and lighttpd:

- apt-get install lighttpd php-cgi php (Order of PHP packages seems relevant to avoid apache dependency)
- apt-get install dbconfig-sqlite3 roundcube-core roundcube-sqlite3

The last command results in the following which leaves roundcube-core unconfigured:

Setting up roundcube-core (1.2.3+dfsg.1-4+deb9u2) ...
dbconfig-common: writing config to /etc/dbconfig-common/roundcube.conf


Creating config file /etc/dbconfig-common/roundcube.conf with new version

Creating config file /etc/roundcube/debian-db.php with new version
creating database roundcube: success.
verifying database roundcube exists: success.
populating database via sql...  done.
Enabling roundcube: ok
Enabling fastcgi: ok
Met dependency: fastcgi
Enabling fastcgi-php: ok
already enabled
Run "service lighttpd force-reload" to enable changes
dpkg: error processing package roundcube-core (--configure):
 subprocess installed post-installation script returned error exit status 2
Setting up php7.0-gd (7.0.27-0+deb9u1) ...

Creating config file /etc/php/7.0/mods-available/gd.ini with new version
Setting up php-gd (1:7.0+49) ...
Processing triggers for libc-bin (2.24-11+deb9u3) ...
Errors were encountered while processing:
 roundcube-core
E: Sub-process /usr/bin/dpkg returned an error code (1)


   * What exactly did you do (or not do) that was effective (or
     ineffective)?

Tried to run "apt-get install roundcube-core" again which presented me with a dialog message titled
"An error occurred while installing the database". I choose "retry" and used the default value each time.

   * What was the outcome of this action?

Many messages about already existing database entries:
Reading package lists... Done
Building dependency tree
Reading state information... Done
roundcube-core is already the newest version (1.2.3+dfsg.1-4+deb9u2).
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n]
Setting up roundcube-core (1.2.3+dfsg.1-4+deb9u2) ...
dbconfig-common: writing config to /etc/dbconfig-common/roundcube.conf
creating database roundcube: already exists.
populating database via sql...  Error: near line 7: table contacts already exists
Error: near line 20: index ix_contacts_user_id already exists

<similar lines about exiting entries>

error encountered populating database:

dbconfig-common: roundcube configure: aborted.
dpkg: error processing package roundcube-core (--configure):
 subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
 roundcube-core
E: Sub-process /usr/bin/dpkg returned an error code (1)


Best regards,
Stephan


-- System Information:
Debian Release: 9.4
  APT prefers stable-updates
  APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 4.9.0-6-amd64 (SMP w/1 CPU core)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8), LANGUAGE=de_DE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages roundcube-core depends on:
ii  dbconfig-common             2.0.8
ii  debconf [debconf-2.0]       1.5.61
ii  dpkg                        1.18.24
ii  libmagic1                   1:5.30-1+deb9u1
ii  php                         1:7.0+49
ii  php-auth-sasl               1.0.6-3
ii  php-common                  1:49
ii  php-intl                    1:7.0+49
ii  php-mail-mime               1.10.0-2
ii  php-mcrypt                  1:7.0+49
ii  php-net-smtp                1.7.1-2
ii  php-net-socket              1.0.14-2
ii  php-pear                    1:1.10.1+submodules+notgz-9
ii  php7.0 [php]                7.0.27-0+deb9u1
ii  php7.0-cli [php-cli]        7.0.27-0+deb9u1
ii  php7.0-intl [php-intl]      7.0.27-0+deb9u1
ii  php7.0-json [php-json]      7.0.27-0+deb9u1
ii  php7.0-mcrypt [php-mcrypt]  7.0.27-0+deb9u1
ii  roundcube-sqlite3           1.2.3+dfsg.1-4+deb9u2
ii  ucf                         3.0036

Versions of packages roundcube-core recommends:
ii  lighttpd [httpd-cgi]        1.4.45-1
ii  php-gd                      1:7.0+49
ii  php-pspell                  1:7.0+49
ii  php7.0-gd [php-gd]          7.0.27-0+deb9u1
ii  php7.0-pspell [php-pspell]  7.0.27-0+deb9u1
ii  spawn-fcgi                  1.6.4-1+b1

Versions of packages roundcube-core suggests:
pn  php-crypt-gpg      <none>
pn  php-net-ldap2      <none>
pn  php-net-ldap3      <none>
pn  roundcube-plugins  <none>

-- debconf information:
  roundcube/reconfigure-webserver: apache2, lighttpd
  roundcube/missing-db-package-error: abort
  roundcube/remove-error: abort
  roundcube/language: en_US
  roundcube/dbconfig-upgrade: true
  roundcube/restart-webserver: true
  roundcube/internal/skip-preseed: false
  roundcube/install-error: abort
  roundcube/upgrade-backup: true
  roundcube/dbconfig-remove: true
  roundcube/upgrade-error: abort
  roundcube/passwords-do-not-match:
  roundcube/db/dbname: roundcube
  roundcube/db/basepath: /var/lib/dbconfig-common/sqlite3/roundcube
  roundcube/dbconfig-reinstall: false
* roundcube/database-type: sqlite3
  roundcube/purge: false
* roundcube/dbconfig-install: true
  roundcube/internal/reconfiguring: false
  roundcube/hosts: