Since the fellas at the opennms list won't post my message, I'll ask you guys.


I’m installing OpenNMS but having an issue.
I’m following the directions on http://www.opennms.org/documentation/installguide.html#installing-opennms-install and where it says to execute the following:
# $OPENNMS_HOME/bin/install -l /usr/local/lib -dis

I get the following error. I have not had any errors until this point.

[root@nms ~]# $OPENNMS_HOME/bin/install -l /usr/local/lib -dis
==============================================================================
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/lib64/libjicmp.so: OK
- searching for jicmp6:
  - trying to load /usr/local/lib/libjicmp6.so: NO
  - trying to load /usr/lib64/libjicmp6.so: OK
- searching for jrrd:
  - trying to load /usr/local/lib/libjrrd.so: NO
  - trying to load /usr/lib64/libjrrd.so: NO
  - trying to load /usr/lib64/libjrrd.so: NO
  - trying to load /usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre/lib/amd64/server/libjrrd.so: NO
  - trying to load /usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre/lib/amd64/libjrrd.so: NO
  - trying to load /usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre/../lib/amd64/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
Exception in thread "main" org.opennms.core.schema.MigrationException: an error occurred getting the version from the database
        at org.opennms.core.schema.Migrator.getDatabaseVersion(Migrator.java:178)
        at org.opennms.core.schema.Migrator.validateDatabaseVersion(Migrator.java:206)
        at org.opennms.install.Installer.install(Installer.java:226)
        at org.opennms.install.Installer.main(Installer.java:950)
Caused by: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
        at org.postgresql.jdbc2.AbstractJdbc2Connection.(AbstractJdbc2Connection.java:125)
        at org.postgresql.jdbc3.AbstractJdbc3Connection.(AbstractJdbc3Connection.java:30)
        at org.postgresql.jdbc3.Jdbc3Connection.(Jdbc3Connection.java:24)
        at org.postgresql.Driver.makeConnection(Driver.java:393)
        at org.postgresql.Driver.connect(Driver.java:267)
        at java.sql.DriverManager.getConnection(DriverManager.java:620)
        at java.sql.DriverManager.getConnection(DriverManager.java:169)
        at org.opennms.netmgt.dao.db.SimpleDataSource.getConnection(SimpleDataSource.java:90)
        at org.opennms.core.schema.Migrator.getDatabaseVersion(Migrator.java:166)
        ... 3 more
Caused by: java.net.ConnectException: Connection refused
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:327)
        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:193)
        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:180)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:384)
        at java.net.Socket.connect(Socket.java:546)
        at java.net.Socket.connect(Socket.java:495)
        at java.net.Socket.(Socket.java:392)
        at java.net.Socket.(Socket.java:206)
        at org.postgresql.core.PGStream.(PGStream.java:62)
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76)
        ... 13 more
[root@nms ~]#

5/24/2012 1:16:26 PM

ok, so figured that for some reason, the 64 bit files aren't located where opennms thinks they are. So after creating some symlinks such as this:

[root@nms-guest ~]# locate libjrrd.so
/usr/lib/libjrrd.so
/usr/lib64/libjrrd.so
[root@nms-guest ~]# ln -s /usr/lib64/libjrrd.so /usr/local/lib/libjrrd.so
[root@nms-guest ~]#

[root@nms-guest ~]# $OPENNMS_HOME/bin/install -l /usr/local/lib -dis
==============================================================================
OpenNMS Installer
==============================================================================

Configures PostgreSQL tables, users, and other miscellaneous settings.

- searching for jicmp:
  - trying to load /usr/local/lib/libjicmp.so: OK
- searching for jicmp6:
  - trying to load /usr/local/lib/libjicmp6.so: OK
- searching for jrrd:
  - trying to load /usr/local/lib/libjrrd.so: OK
- using SQL directory... /opt/opennms/etc
- using create.sql... /opt/opennms/etc/create.sql
Exception in thread "main" org.opennms.core.schema.MigrationException: an error occurred getting the version from the database
        at org.opennms.core.schema.Migrator.getDatabaseVersion(Migrator.java:178)
        at org.opennms.core.schema.Migrator.validateDatabaseVersion(Migrator.java:206)
        at org.opennms.install.Installer.install(Installer.java:226)
        at org.opennms.install.Installer.main(Installer.java:950)
Caused by: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
        at org.postgresql.jdbc2.AbstractJdbc2Connection.(AbstractJdbc2Connection.java:125)
        at org.postgresql.jdbc3.AbstractJdbc3Connection.(AbstractJdbc3Connection.java:30)
        at org.postgresql.jdbc3.Jdbc3Connection.(Jdbc3Connection.java:24)
        at org.postgresql.Driver.makeConnection(Driver.java:393)
        at org.postgresql.Driver.connect(Driver.java:267)
        at java.sql.DriverManager.getConnection(DriverManager.java:620)
        at java.sql.DriverManager.getConnection(DriverManager.java:169)
        at org.opennms.netmgt.dao.db.SimpleDataSource.getConnection(SimpleDataSource.java:90)
        at org.opennms.core.schema.Migrator.getDatabaseVersion(Migrator.java:166)
        ... 3 more
Caused by: java.net.ConnectException: Connection refused
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:327)
        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:193)
        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:180)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:384)
        at java.net.Socket.connect(Socket.java:546)
        at java.net.Socket.connect(Socket.java:495)
        at java.net.Socket.(Socket.java:392)
        at java.net.Socket.(Socket.java:206)
        at org.postgresql.core.PGStream.(PGStream.java:62)
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76)
        ... 13 more
[root@nms-guest ~]#

5/24/2012 1:48:50 PM

http://issues.opennms.org/browse/NMS-3341

The issue isn't the same as yours, but in the comments one of the devs (I assume that's who it is) says "I changed the code to explicitly require 7.4, skip the language check, and handle connection exceptions explicitly. Now you should get a much more useful exception when the DB is down" and then he pastes almost the exact same error as yours.

So it sounds like a problem connecting to the postgreSQL database. Have you double checked that?

5/24/2012 6:12:31 PM

I haven't but I will. Thanks.

5/25/2012 8:48:15 AM