Package: dbconfig-common
Version: 1.8.52
Severity: wishlist

Dear Maintainer,

If connection to the database server fails on postinst of a
dbconfig-common package, it currently just prints an error. It would be
great if dbconfig-common could write out a SQL file with all the
commands it wanted to execute (including CREATE DATABASE / CREATE USER)
to a well-defined location so that the administrator may easily rerun
this once the database server is available again.

The error message shown should contain the path of the file and the
command the administrator should execute once the server is up.

Two use cases (as per our discussion at DebConf):

 - remote servers may be down during the installation of a
   dbconfig-common utilizing package - but the administrator might
   want to use dbconfig-common here to simplify the setup - and
   having to just run a simple command they can copy/paste from the
   error message once the server is up again would be simpler than
   manually configuring the package

 - provisioning of VMs/Containers: in some setups, containers/VMs can
   be provisioned automatically (via script) by debootstrap'ing into
   a chroot, then dropping a /usr/sbin/policy-rc.d there to disable
   service starts and then installing all packages. For the vast
   majority of packages this works, but obviously the database server
   won't be running in this case, so dbconfig-common won't work there.
   If dbconfig-common were to just put SQL files for all applications
   that use the database to some well-defined location, one could add
   support to the provisioning script to manually run them at a later
   point - so that installing everything there would still work
   automatically.

It would be great if dbconfig-common could support that.

If you have further questions, feel free to contact me.

Thank you very much,
Christian

-- System Information:
Debian Release: stretch/sid
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: amd64 (x86_64)

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

Versions of packages dbconfig-common depends on:
ii  debconf [debconf-2.0]  1.5.57
ii  ucf                    3.0030

dbconfig-common recommends no packages.

Versions of packages dbconfig-common suggests:
pn  virtual-mysql-client | mysql-client | postgresql-client  <none>

-- debconf information excluded

Attachment: signature.asc
Description: OpenPGP digital signature

Reply via email to