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

Thanks Benjamin, I really have no clue what the problem is with localhost...

OK, I made it to the step where I run sudo /etc/init.d/opennms start command but it fails, here's part of the log:

Caused by: java.lang.reflect.UndeclaredThrowableException: Could not lookup the host name for the local host machine: java.net.UnknownHostException: localhost: localhost

Does this mean I have to change the lookup value in poller-configuration.xml so instead of localhost it points to the IP address?

Please help :-)

Thanks!







 



> Date: Fri, 9 Jan 2009 15:23:11 -0500
> From: [email protected]
> To: [email protected]
> Subject: 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/
> 
> 

_________________________________________________________________
Windows Live™ Hotmail®: Chat. Store. Share. Do more with mail. 
http://windowslive.com/explore?ocid=TXT_TAGLM_WL_t1_hm_justgotbetter_explore_012009

------------------------------------------------------------------------------
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