Re: [opennms-devel] PostgreSQL problem - Could not get an administrative connection to the database

Honia A wrote:

> 1) Made some changes to opennms-datasource.xml:
> 
> Replaced localhost in jdbc:postgresql://localhost:5432/ with the actual IP
> 
> 2) In postgresql.conf, replace "localhost" in listen_addresses =
> 'localhost' to "*"
> Also, commented in the line where reads port=5432
> 
> 3) In pg_hba.conf, added a new line which reads:
> host    all         all         [machine's IP]  
> 255.255.255.255          trust
> 
> 4) Running su postgres command, I realized the owner of OpenNMS database
> is postgres so I didn't make any changes to the username and password
> used by jdbc connection...
> 
> 5) sudo -u postgres pg_ctl -D /var/lib/pgsql/data restart
> 
> 6) Now I could run $OPENNMS_HOME/bin/install -dis with no problem :-)
> 
> Will report back if something else happens during the process.

Sounds like something is very wrong with host name resolution on your
system if it won't respond properly to the name 'localhost' -- you might
want to investigate why that is the case.  That is likely the root
cause, if changing 'localhost' to the host's IP address fixes it.


-- 
Benjamin Reed
The OpenNMS Group
http://www.opennms.org/

------------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It is the best place to buy or sell services for
just about anything Open Source.
http://p.sf.net/sfu/Xq1LFB

_______________________________________________
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

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJZ7IwUu+jZtP2Zf4RAlJaAJ42Vx0ff0mAu7twkdH8HO0yD1PvqwCeKjoC
oPc/lU9TG38t+/NQlEwSBew=
=UlqO
-----END PGP SIGNATURE-----