Databases
StackOverflow2013
Postsdbo
POencoding UTF8 does not match locale en_US; the chosen LC_CTYPE setting requires encoding LATIN1
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POencoding UTF8 does not match locale en_US; the chosen LC_CTYPE setting requires encoding LATIN1
    text
    copied!<p>While trying to install opennms :</p> <pre><code>/usr/share/opennms/bin/install -l /usr/local/lib -dis </code></pre> <p>I get the error:</p> <blockquote> <p>ERROR: encoding UTF8 does not match locale en_US Detail: The chosen LC_CTYPE setting requires encoding LATIN1.</p> </blockquote> <p>and I'm not sure how to proceed, as I've tried creating the DB several different ways (see below).</p> <p>Full log:</p> <pre><code>============================================================================== OpenNMS Installer ============================================================================== Configures PostgreSQL tables, users, and other miscellaneous settings. - searching for jicmp: - trying to load /usr/local/lib/libjicmp.so: NO - trying to load /usr/lib/jni/libjicmp.so: OK - searching for jicmp6: - trying to load /usr/local/lib/libjicmp6.so: NO - trying to load /usr/lib/jni/libjicmp6.so: OK - searching for jrrd: - trying to load /usr/local/lib/libjrrd.so: NO - trying to load /usr/lib/jni/libjrrd.so: NO - trying to load /usr/lib/jni/libjrrd.so: NO - trying to load /usr/lib/jvm/jdk1.6.0_34/jre/lib/amd64/server/libjrrd.so: NO - trying to load /usr/lib/jvm/jdk1.6.0_34/jre/lib/amd64/libjrrd.so: NO - trying to load /usr/lib/jvm/jdk1.6.0_34/jre/../lib/amd64/libjrrd.so: NO - trying to load /libjrrd.so: NO - trying to load /usr/share/opennms/lib/libjrrd.so: NO - trying to load /usr/share/opennms/lib/linux64/libjrrd.so: NO - trying to load /usr/java/packages/lib/amd64/libjrrd.so: NO - trying to load /usr/lib64/libjrrd.so: NO - trying to load /lib64/libjrrd.so: NO - trying to load /lib/libjrrd.so: NO - trying to load /usr/lib/libjrrd.so: NO - trying to load /usr/lib/jni/libjrrd.so: NO - trying to load /usr/lib/libjrrd.so: NO - trying to load /usr/local/lib/libjrrd.so: NO - trying to load /opt/NMSjicmp/lib/32/libjrrd.so: NO - trying to load /opt/NMSjicmp/lib/64/libjrrd.so: NO - trying to load /opt/NMSjicmp6/lib/32/libjrrd.so: NO - trying to load /opt/NMSjicmp6/lib/64/libjrrd.so: NO - Failed to load the optional jrrd library. - This error is not fatal, since jrrd is only required for optional features. - For more information, see http://www.opennms.org/index.php/jrrd - using SQL directory... /usr/share/opennms/etc - using create.sql... /usr/share/opennms/etc/create.sql * using 'postgres' as the PostgreSQL user for OpenNMS * using 'opennms' as the PostgreSQL database name for OpenNMS Exception in thread "main" org.opennms.core.schema.MigrationException: an error occurred creating the OpenNMS database at org.opennms.core.schema.Migrator.createDatabase(Migrator.java:428) at org.opennms.core.schema.Migrator.prepareDatabase(Migrator.java:444) at org.opennms.install.Installer.install(Installer.java:236) at org.opennms.install.Installer.main(Installer.java:949) Caused by: org.postgresql.util.PSQLException: ERROR: encoding UTF8 does not match locale en_US Detail: The chosen LC_CTYPE setting requires encoding LATIN1. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366) at org.opennms.core.schema.Migrator.createDatabase(Migrator.java:425) ... 3 more </code></pre> <p>List of databases:</p> <pre><code> Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+----------+----------+---------+-------+----------------------- postgres | postgres | LATIN1 | en_US | en_US | rhq | rhqadmin | LATIN1 | en_US | en_US | template0 | postgres | LATIN1 | en_US | en_US | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | LATIN1 | en_US | en_US | =c/postgres + | | | | | postgres=CTc/postgres (4 rows) </code></pre> <p>I have used the following 3 initdb options but none of them work</p> <pre><code>/usr/local/pgsql/bin/initdb -E UTF-8 --pgdata=/usr/local/pgsql/data /usr/local/pgsql/bin/initdb -E LATIN1 --pgdata=/usr/local/pgsql/data /usr/local/pgsql/bin/initdb -E en_US.UTF8 --pgdata=/usr/local/pgsql/data </code></pre> <p>Also, do i need to delete all data in <code>/usr/local/pgsql/data</code> before i use <code>initdb</code> ?</p> <p>appending locale command stdout:</p> <p>$locale</p> <pre><code>LANG=en_US LANGUAGE=en_US: LC_CTYPE="en_US" LC_NUMERIC="en_US" LC_TIME="en_US" LC_COLLATE="en_US" LC_MONETARY="en_US" LC_MESSAGES="en_US" LC_PAPER="en_US" LC_NAME="en_US" LC_ADDRESS="en_US" LC_TELEPHONE="en_US" LC_MEASUREMENT="en_US" LC_IDENTIFICATION="en_US" LC_ALL= </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload