[Pkg-roundcube-maintainers] Bug#829485: roundcube-core: noninteractive configuration fails when preseeding to use postgres

[Mike Ashley]

Package: roundcube
Version: 1.1.5+dfsg.1-1~bpo8+1
Severity: important
Tags: d-i

Dear Maintainer,

My goal is to install roundcube unattended using postgres as the backend.
Here is what I did to accomplish this.

  1. Install roundcube interactively and verify it is configured correctly.
     Packages to install: roundcube-pgsql, roundcube-plugins, roundcube-core,
     roundcube.
  2. Use `debconf-get-selections` to get the roundcube options.
  3. Remove and purge the packages installed in Step 1.
  4. Use `debconf-get-selections` to verify there are no roundcube options
     in the deconf database.
  5. Preseed the debconf database with the options recorded from Step 2.
  6. Install roundcube and the associated packages noninteractively.

When Step 6 runs, mysql is used for the backend instead of postgres.  After
Step 6, inspecting the option `roundcube/database-type` shows it was changed
from `pgsql` to `mysql`.  A few other options were changed also, all
related to db configuration.  Ultimately, I was left with a misconfigured
and malfunctioning install.

What I expected was roundcube-core to use the options in the preseeded debconf
database.

Perusing templates and source, I saw that dbconfig-common is used to configure
the backend.  I may be preseeding the debconf database incorrectly, but some
experiments preseeding dbconfig-common didn't change anything.

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

Kernel: Linux 4.5.5-x86_64-linode69 (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/dash
Init: systemd (via /run/systemd/system)

Versions of packages roundcube-core depends on:
ii  dbconfig-common        1.8.47+nmu3+deb8u1
ii  debconf [debconf-2.0]  1.5.56
ii  dpkg                   1.17.27
ii  libapache2-mod-php5    5.6.22+dfsg-0+deb8u1
ii  libmagic1              1:5.22+15-2+deb8u1
ii  php-auth-sasl          1.0.6-1+deb8u1
ii  php-mail-mime          1.8.9-1+deb8u1
ii  php-net-sieve          1.3.2-4
ii  php-net-smtp           1.6.2-2
ii  php-net-socket         1.0.14-1
ii  php-patchwork-utf8     1.1.25-1
ii  php-pear               5.6.22+dfsg-0+deb8u1
ii  php5                   5.6.22+dfsg-0+deb8u1
ii  php5-cli               5.6.22+dfsg-0+deb8u1
ii  php5-common            5.6.22+dfsg-0+deb8u1
ii  php5-intl              5.6.22+dfsg-0+deb8u1
ii  php5-json              1.3.6-1
ii  php5-mcrypt            5.6.22+dfsg-0+deb8u1
ii  roundcube-pgsql        1.1.5+dfsg.1-1~bpo8+1
ii  ucf                    3.0030

Versions of packages roundcube-core recommends:
ii  apache2 [httpd-cgi]  2.4.10-10+deb8u4
ii  php5-gd              5.6.22+dfsg-0+deb8u1
ii  php5-pspell          5.6.22+dfsg-0+deb8u1

Versions of packages roundcube-core suggests:
pn  php-crypt-gpg      <none>
pn  php-net-ldap2      <none>
pn  php-net-ldap3      <none>
ii  roundcube-plugins  1.1.5+dfsg.1-1~bpo8+1

Versions of packages roundcube depends on:
ii  dpkg  1.17.27

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