Re: Installation Error

I think you have to resolve this failure "ERROR: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)" in your postgres installation.

Maybe this link helps you
http://stackoverflow.com/questions/16736891/pgerror-error-new-encoding-utf8-is-incompatible

-
Silvio

> Am 23.03.2015 um 17:14 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
>  ​
> 
> ------------------------------------------------------------------------------
> 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

------------------------------------------------------------------------------
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