OpenNMS error

3 messages

OpenNMS error

Reply Threaded

Hi All,

Please find the below mentioned error

[root@opennms-hyderabad data]# /opt/opennms/bin/install -dis
==============================================================================
OpenNMS Installer Version $Id: Installer.java 11800 2009-01-11 23:04:48Z dhustace $
==============================================================================

Configures PostgreSQL tables, users, and other miscellaneous settings.

- searching for jicmp:
- trying to load /usr/local/lib/libjicmp.so: OK
- searching for jrrd:
- trying to load /usr/local/lib/libjrrd.so: NO
- trying to load /root/jdk1.6.0_16/jre/lib/amd64/server/libjrrd.so: NO
- trying to load /root/jdk1.6.0_16/jre/lib/amd64/libjrrd.so: NO
- trying to load /root/jdk1.6.0_16/jre/../lib/amd64/libjrrd.so: NO
- trying to load /libjrrd.so: NO
- trying to load /opt/opennms/lib/libjrrd.so: NO
- trying to load /usr/java/packages/lib/amd64/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
- 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
- checking database version... Exception in thread "main" java.sql.SQLException: Could not get an administrative connection to the database. Is the database running, listening for TCP connections, and allowing us to connect and authenticate from localhost? Tried connecting to database specified by data source SimpleDataSource[URL='jdbc:postgresql://192.168.12.124/template1', driver class='org.postgresql.Driver', properties: user='postgres', password='']. Original error: org.postgresql.util.PSQLException: FATAL: missing or erroneous pg_hba.conf file
        at org.opennms.netmgt.dao.db.InstallerDb.rethrowDatabaseConnectionException(InstallerDb.java:2214)
        at org.opennms.netmgt.dao.db.InstallerDb.initializeAdminConnection(InstallerDb.java:2191)
        at org.opennms.netmgt.dao.db.InstallerDb.getAdminConnection(InstallerDb.java:2180)
        at org.opennms.netmgt.dao.db.InstallerDb.databaseCheckVersion(InstallerDb.java:1526)
        at org.opennms.install.Installer.install(Installer.java:194)
        at org.opennms.install.Installer.main(Installer.java:778)
Caused by: org.postgresql.util.PSQLException: FATAL: missing or erroneous pg_hba.conf file
        at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:275)
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:94)
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
        at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:116)
        at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
        at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
        at org.postgresql.Driver.makeConnection(Driver.java:369)
        at org.postgresql.Driver.connect(Driver.java:245)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:154)
        at org.opennms.netmgt.dao.db.SimpleDataSource.getConnection(SimpleDataSource.java:79)
        at org.opennms.netmgt.dao.db.InstallerDb.initializeAdminConnection(InstallerDb.java:2189)
        ... 4 more

Please help me to solve this error

Thanks & Regards,
G.Dany Sahaya Bensighar,
Sr.Systems Engineer,
Gemini Communications Ltd,
Mumbai.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-devel mailing list

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

Steve Hillier

Re: OpenNMS error

Reply Threaded

Some javascript/style in this post has been disabled (why?)

The error is in the message:

[URL='jdbc:postgresql://192.168.12.124/template1', driver class='org.postgresql.Driver', properties: user='postgres', password='']. Original error: org.postgresql.util.PSQLException:

FATAL: missing or erroneous pg_hba.conf file

IT looks like a problem with the jdbc url or the backend postgres DB. OpenNMS is simply complaining it can't get a connection to the database using the specified information. It's suggesting that you check the pg_hba.conf file (postges config file).

Steve.

From: [hidden email]

Sent: Saturday, August 22, 2009 2:14 AM

To: [hidden email]

Subject: [opennms-devel] OpenNMS error

Configures PostgreSQL tables, users, and other miscellaneous settings.

_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-devel mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-devel
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-devel mailing list

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

Les Mikesell

Re: OpenNMS error

Reply Threaded

In reply to this post by Dany Bensighar

Dany Bensighar wrote:

> Hi All,
>
> Please find the below mentioned error
>
> - checking database version... Exception in thread "main"
> java.sql.SQLException: Could not get an administrative connection to the
> database. Is the database running, listening for TCP connections, and
> allowing us to connect and authenticate from localhost? Tried
> connecting to database specified by data source
> SimpleDataSource[URL='jdbc:postgresql://192.168.12.124/template1',
> driver class='org.postgresql.Driver', properties: user='postgres',
> password='']. Original error: org.postgresql.util.PSQLException: FATAL:
> missing or erroneous pg_hba.conf file

> Please help me to solve this error

Have you started postgresql and done the initial initdb? If you used a
postgresql installation that is part of an OS distribution, the script that
starts it may do the initdb for you, but you still have to permit access over
tcp from the local host as described under 'Customizing the pg_hba.conf file'
here: http://www.opennms.org/wiki/Building_OpenNMS.

--
Les Mikesell
[hidden email]

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-devel mailing list

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