[pkg-bacula-devel] Bug#1000174: bacula-director-pgsql: setup fails with "Unrecognized role option"

[Ross Boylan]

Package: bacula-director-pgsql
Version: 9.4.2-2+deb10u1
Severity: normal

Dear Maintainer,

I left the severity at normal because I suspect there is an easy
work-around; the problem actually leaves the package uninstalled or at
least not operable, and so it might be considered more serious.

   * What led up to the situation?
   Installing the bacula package onto a system with postgres already
   present, but no prior bacula installation.
   Opted for the PG based backend.
   Elected the default dbconfig controlled setup.
   Entered eiXu7Boo{z'a as the password for the database (twice)
   
   * What exactly did you do (or not do) that was effective (or
     ineffective)?
   I plan to retry with a password that does not include the ' character.

   * What was the outcome of the original actions?
   With the original password the installer (aptitude) showed the
   following:
   ERROR: unrecognized role option "a" LINE 1: CREATE USER "bacula"
   WITH PASSWORD 'eiXu7Boo{z\'a' ^ .  It offers several options for
   how to proceed, with the caution that some may leave bacula inoperable.

   * What outcome did you expect instead?
   That a PG account with the password I gave would be created.

My theory is that, despite the \ that was stuffed before it, the
second ' was parsed as ending the password and the a that followed it
was taken to be a role option.

The root cause may lie with another package, maybe dbconfig
or the PG client libs.  Feel free to reassign.

*** End of the template - remove these template lines ***


-- System Information:
Debian Release: 10.11
  APT prefers oldstable-updates
  APT policy: (500, 'oldstable-updates'), (500, 'oldstable')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 4.19.0-18-amd64 (SMP w/8 CPU cores)
Kernel taint flags: TAINT_PROPRIETARY_MODULE, TAINT_OOT_MODULE, TAINT_UNSIGNED_MODULE
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE= (charmap=UTF-8)
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages bacula-director-pgsql depends on:
iu  bacula-common-pgsql                       9.4.2-2+deb10u1
iu  dbconfig-pgsql                            2.0.11+deb10u1
ii  debconf [debconf-2.0]                     1.5.71+deb10u1
iu  postgresql-client                         11+200+deb10u4
ii  postgresql-client-11 [postgresql-client]  11.14-0+deb10u1

Versions of packages bacula-director-pgsql recommends:
ii  postgresql  11+200+deb10u4

Versions of packages bacula-director-pgsql suggests:
ii  gawk  1:4.2.1+dfsg-1

-- no debconf information