please help

From: abdi indra <shafa_3(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: please help
Date: 2009-02-19 03:27:45
Message-ID: 822928.64538.qm@web50011.mail.re2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I
got following error, goggling hundreds of material and still no clue. Please help.

best regards,
abdi indra


#
$OPENNMS_HOME/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/lib/libjicmp.so: OK
-
searching for jrrd:
- trying to load /usr/lib/libjrrd.so: OK
-
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.110.133:5432/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



This
is pg_hba.conf

#
TYPE DATABASE USER CIDR-ADDRESS METHOD

#
"local" is for Unix domain socket connections only
local all all ident sameuser
local all all 192.168.110.133 trust
#
IPv4 local connections:
host all all 127.0.0.1/32 ident sameuser
host all all 192.168.110.133/32 trust
#
IPv6 local connections:
host all all ::1/128 ident sameuser
host all all 192.168.110.133/255.255.255.255 trust


this
is postgres.conf

listen_addresses
= '*' # what IP address(es)
to listen on;
#
comma-separated list of addresses;
#
defaults to 'localhost', '*' = all
port
= 5432
max_connections
= 100

Get your new Email address!
Grab the Email name you&#39;ve always wanted before someone else does!
http://mail.promotions.yahoo.com/newdomains/aa/

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2009-02-19 04:01:14 Re: Performance of jdbc insert statements and select nextval
Previous Message Dave Cramer 2009-02-18 17:29:39 Re: Performance of jdbc insert statements and select nextval