DynaCenter installation fails with encoding error on new RedHat/CentOS server
Reference Number: AA-00263 Views: 3855 Created: 04-07-2015 11:00 Last Updated: 06-26-2015 11:05

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