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

[Sandro Knauß]

Control: notfound -1 1.1.5+dfsg.1-1~bpo8+1
Control: reassign -1 dbconfig-common 1.8.47+nmu3+deb8u1

Hey,

this is not an issue with roundcube, because we don't predefine any database. 
The problem is dbconfig itself, so pushing bug report over to them.

sandro

--
On Sonntag, 3. Juli 2016 14:07:00 CEST Mike Ashley wrote:
> 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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: This is a digitally signed message part.
URL: <http://lists.alioth.debian.org/pipermail/pkg-roundcube-maintainers/attachments/20170909/966e4425/attachment-0001.sig>