This is covered in several different places on the wiki.
Please review the Quick Start guide: http://www.opennms.org/wiki/QuickStart
<Exceprt>
....
Edit pg_hba.conf to Allow postgres to Authenticate
To allow the "postgres" user to connect, you will need to edit your database's
pg_hba.conf file, which is usually created on installation or the first startup
of PostgreSQL, depending on your distribution: By default, it will have
something like this at the bottom:
local all all ident sameuser
host all all 127.0.0.1/32 ident sameuser
host all all ::1/128 ident sameuser
You will need to change "ident sameuser" to "trust":
local all all trust
host all all 127.0.0.1/32 trust
host all all ::1/128 trust
</Excerpt>
Thanks,
Steve.
From: Dany Bensighar
Sent: Monday, August 24, 2009 4:10 AM
To: opennms-devel@lists.sourceforge.net
Subject: [opennms-devel] (no subject)
Hi Team,
Please find the errors while initalizing database
/opt/opennnms/bin/install -dis
- 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://localhost:5432/template1', driver
class='org.postgresql.Driver', properties: user='postgres', password=''].
Original error: org.postgresql.util.PSQLException: FATAL: Ident authentication
failed for user "postgres"
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: Ident authentication
failed for user "postgres"
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
The pg_hba.conf file is
# "local" is for Unix domain socket connections only
local all all ident sameuser
# IPv4 local connections:
host all all 127.0.0.1/32 ident sameuser
# IPv6 local connections:
host all all ::1/128 ident sameuser
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------------------------------------------------------------------------------
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
