Re: Reg:opennms install issue

Have you modified pg_hba.conf to use a trust rather than ident?

http://www.opennms.org/wiki/QuickStart#Edit_pg_hba.conf_to_Allow_postgres_to_Authenticate

On Jul 31, 2012, at 12:16 PM, saranya guna <[email protected]<mailto:[email protected]>> wrote:


Hi,

I started postgresql db by using the script in /etc/init.d. Now the postgresql db is started .

When I run the install script using  ./install -dis ,  I am getting the below error:

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: FATAL: no pg_hba.conf entry for host "10.212.96.35", user "postgres", database "template1", SSL off
        at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:291)
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:108)
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
        at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
        at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
        at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22)
        at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:30)
        at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.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:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:154)
        at org.opennms.netmgt.dao.db.SimpleDataSource.getConnection(SimpleDataSource.java:90)
        at org.opennms.core.schema.Migrator.getDatabaseVersion(Migrator.java:166)
        ... 3 more

 Please help in resolving this issue. ------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/_______________________________________________
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

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/

_______________________________________________
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