Re: Issue with brand new install

That did it. I did see an error still about jrrd so I did a 'yum install jrrd'. What do I need to do so that jrrd is loaded when needed?


Robert 



The template database (template1) appears to be using ASCII encoding rather than UTF-8. When the opennms database is created off this template, it fails.

If you do an internet search for ?postgresql change template1 encoding? there are instructions on how to recreate the template1 db with UTF8 encoding. That should cause the installer to work.

Ron

On Feb 23, 2014, at 12:14 PM, Robert L Craig <[email protected]> wrote:

> I?m trying to follow the guide on the OpenNMS wiki, but I?m running into errors on the last part. Anyone have any idea of what I need to do to get past the below error? Thanks for any help.
>  
> /opt/opennms/bin/install -dis
> ======================================================================
> ========
> OpenNMS Installer
> ======================================================================
> ========
>  
> Configures PostgreSQL tables, users, and other miscellaneous settings.
>  
> - 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
> - using SQL directory... /opt/opennms/etc
> - using create.sql... /opt/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:429)
>         at org.opennms.core.schema.Migrator.prepareDatabase(Migrator.java:445)
>         at org.opennms.install.Installer.install(Installer.java:237)
>         at org.opennms.install.Installer.main(Installer.java:960)
> 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: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:426)
>         ... 3 more
>  
>  
> Robert
>  
> ----------------------------------------------------------------------
> -------- Managing the Performance of Cloud-Based Applications Take 
> advantage of what the Cloud has to offer - Avoid Common Pitfalls.
> Read the Whitepaper.
> http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.
> clktrk_______________________________________________
> 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

-------------- next part --------------
An HTML attachment was scrubbed...

------------------------------

------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk

------------------------------

_______________________________________________
opennms-install mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/opennms-install


End of opennms-install Digest, Vol 91, Issue 1
**********************************************

------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk
_______________________________________________
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