[Bug 563084] [NEW] bacula-director-pgsql does not install cleanly with db-config

[Jakub Witkowski]

Public bug reported:

Binary package hint: bacula-director-pgsql

The package postinst script (through db-config) does not set template
database properly and thus the database creation fails:

Creating config file /etc/dbconfig-common/bacula-director-pgsql.conf with new version
creating postgres user bacula:  success.
verifying creation of user: success.
creating database bacula: failed.
error encountered creating database:
ERROR: new encoding (SQL_ASCII) is incompatible with the encoding of the template database (UTF8) HINT: Use the same encoding as in the template database, or use template0 as template.
dbconfig-common: bacula-director-pgsql configure: ignoring errors from here forwards

The bacula database should be set to SQL_ASCII, as evidenced here:
http://www.bacula.org/5.0.x-manuals/en/main/main/Installing_Configuring_Post.html#SECTION004220000000000000000

Steps to repeat:

1. Install postrgesql server
2. Install bacula-director-pgsql
3. Select configure the database via dbconfig

This is Ubuntu 10.04 (up to date as of 14.04.2010)
Package bacula-director-pgsql 5.0.1-1ubuntu1

ProblemType: Bug
DistroRelease: Ubuntu 10.04
Package: bacula-director-pgsql 5.0.1-1ubuntu1
ProcVersionSignature: Ubuntu 2.6.32-20.30-generic 2.6.32.11+drm33.2
Uname: Linux 2.6.32-20-generic x86_64
NonfreeKernelModules: openafs nvidia
Architecture: amd64
Date: Wed Apr 14 16:30:52 2010
EcryptfsInUse: Yes
InstallationMedia: Ubuntu 10.04 "Lucid Lynx" - Beta amd64 (20100316)
ProcEnviron:
 PATH=(custom, no user)
 LANG=pl_PL.UTF-8
 SHELL=/bin/bash
SourcePackage: bacula

** Affects: bacula (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: amd64 apport-bug lucid

-- 
bacula-director-pgsql does not install cleanly with db-config
https://bugs.launchpad.net/bugs/563084
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to bacula in ubuntu.