Re: Installation Error

Markus Neumann <[email protected]> Mon, 23 Mar 2015 17:50:02 +0100
Newsgroups gmane.network.opennms.install
Message-ID <20150323175002.08224da4@Tak-ThinkPad-X220>
Am Mon, 23 Mar 2015 16:14:29 +0000
schrieb Robert L Craig <[email protected]>:

> Trying to install the latest version on Centos 7 with Java 7u75. I’ve
> tried it with multiple guides on the NET and I keep getting the below
> error. Any ideas?
> 
> 
> [root@chicago1 /]# /opt/opennms/bin/install -dis
> ==============================================================================
> OpenNMS Installer
> ==============================================================================
> 
> Configures PostgreSQL tables, users, and other miscellaneous settings.
> 
> DEBUG: Platform is IPv6 ready: true
> - searching for libjicmp.so:
>   - trying to load /usr/lib64/libjicmp.so: OK
> - searching for libjicmp6.so:
>   - trying to load /usr/lib64/libjicmp6.so: OK
> - searching for libjrrd.so:
>   - trying to load /usr/lib64/libjrrd.so: NO
>   - trying to load /usr/lib64/libjrrd.so: NO
>   - trying to load /libjrrd.so: NO
>   - trying to load /opt/opennms/lib/libjrrd.so: NO
>   - trying to load /opt/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
> 15:31:15.841 [Main] WARN  org.opennms.install.Installer - Could not
> create file: /opt/opennms/etc/libraries.properties
> - using SQL directory... /opt/opennms/etc
> - using create.sql... /opt/opennms/etc/create.sql
> 15:31:15.845 [Main] INFO  org.opennms.core.schema.Migrator -
> validating database version
> * using 'postgres' as the PostgreSQL user for OpenNMS
> * using 'opennms' as the PostgreSQL database name for OpenNMS
> 15:31:15.930 [Main] INFO  org.opennms.core.schema.Migrator -
> validating database version 15:31:15.936 [Main] INFO
> org.opennms.core.schema.Migrator - creating OpenNMS user, if
> necessary 15:31:15.944 [Main] INFO  org.opennms.core.schema.Migrator
> - creating OpenNMS database, if necessary
> java.lang.reflect.InvocationTargetException at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606) at
> org.opennms.bootstrap.Bootstrap$3.run(Bootstrap.java:366) at
> java.lang.Thread.run(Thread.java:745) Caused by:
> org.opennms.core.schema.MigrationException: an error occurred
> creating the OpenNMS database at
> org.opennms.core.schema.Migrator.createDatabase(Migrator.java:433) at
> org.opennms.core.schema.Migrator.prepareDatabase(Migrator.java:449)
> at org.opennms.install.Installer.install(Installer.java:241) at
> org.opennms.install.Installer.main(Installer.java:967) ... 6 more
> Caused by: org.postgresql.util.PSQLException: 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. at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395)
> at
> org.opennms.core.schema.Migrator.createDatabase(Migrator.java:430) ...
> 9 more
> 
> Robert
>  ?
> 

Hey Robert,

looks like your database as the wrong encoding (wrong - SQL_ASCII).
Right would be UTF8. The log indicates that with this line:
Caused by: org.postgresql.util.PSQLException: ERROR: new encoding
(UTF8) is incompatible with the encoding of the template database
(SQL_ASCII)

cu

Markus

------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-install mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-install