Re: opennms-install Digest, Vol 103, Issue 8
Robert L Craig <[email protected]> Mon, 23 Mar 2015 21:04:14 +0000
| Newsgroups | gmane.network.opennms.install |
|---|---|
| Message-ID | <[email protected]> |
OK, that did it. I had to use the first method of dropping the old database and creating a new one, then run the install. Thanks for your help guys. Robert -----Original Message----- From: [email protected] [mailto:[email protected]] Sent: Monday, March 23, 2015 1:37 PM To: [email protected] Subject: opennms-install Digest, Vol 103, Issue 8 Send opennms-install mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit https://lists.sourceforge.net/lists/listinfo/opennms-install or, via email, send a message with subject or body 'help' to [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of opennms-install digest..." Today's Topics: 1. Re: Installation Error (Roskens, Ronald) ---------------------------------------------------------------------- Message: 1 Date: Mon, 23 Mar 2015 18:36:08 +0000 From: "Roskens, Ronald" <[email protected]> Subject: Re: [opennms-install] Installation Error To: 'Installation questions and help' <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain; charset="utf-8" You don?t need to do all that extra work of dropping template1 and re-creating it. Since you are doing a fresh install, this should work: # sudo -u postgres dropdb opennms # sudo -u postgres createdb -U postgres -E UNICODE opennms # /opt/opennms/bin/install -dis Ron From: Silvio Mink [mailto:[email protected]] Sent: Monday, March 23, 2015 12:55 PM To: Installation questions and help Subject: Re: [opennms-install] 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]<mailto:[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 This e-mail message is being sent solely for use by the intended recipient(s) and may contain confidential information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by phone or reply by e-mail, delete the original message and destroy all copies. Thank you. -------------- next part -------------- An HTML attachment was scrubbed... ------------------------------ ------------------------------------------------------------------------------ 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/ ------------------------------ _______________________________________________ opennms-install mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/opennms-install End of opennms-install Digest, Vol 103, Issue 8 *********************************************** ------------------------------------------------------------------------------ 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