Symptoms:
When installing DynaCenter on a fresh
installation of RedHat/CentOS, particularly when using a cloud-based template,
the DynaCenter installer fails to configure PostgreSQL and gives the following
output:
Creating database...
createdb: database creation failed:
ERROR: new encoding (UTF8) is incompatible with the encoding of the template
database (SQL_ASCII) HINT: Use the same encoding as in the template database,
or use template0 as template.
/opt/race/bin/racelogout:
ERROR: Racemi DB Error: ('FATAL',
'3D000', 'database "dynacenter" does not exist')
Use -h or --help for more details.
/opt/race/share/conf/prodData.sh
exited with status 1
dc-configure exited with error status.
Applies To:
DynaCenter 6.0 and later.
Background:
On a fresh installation of RedHat or
CentOS, the /etc/sysconfig/i18n
file may not be configured to set the default locale for the system, and, as a
result, PostgreSQL will configure itself to an ANSI locale, which is
incompatible with the en_US.UTF-8
setting used by the DynaCenter services.Resolution:
1. Open
(or create) the /etc/sysconfig/i18n
file and add the following lines:
LANG="en_US.UTF-8"
SUPPORTED="en_US.UTF-8:en_US:en"
SYSFONT="latarcyrheb-sun16"
2. Reboot
the system.
3. Remove
the /var/lib/pgsql/data
directory and then restart the DynaCenter installation:
# /opt/race/bin/dc-configure --install
--non-interactive