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

You rule :-) Thanks Benjamin, you fixed it! 

I added all these lines to hosts (I was following an online instruction, if any of these lines does not have toe be added please let me know and I'll remove it):

127.0.0.1       localhost.localdomain localhost

::1             localhost.localdomain localhost

[My computer's IP]    localhost.localdomain localhost

As you suggested, I got rid of all those weird changes I made to the configuration, and everything is exactly just as stated in your manual posted on OpenNMS website. Except for pg_hba.conf fiel which I still had to add the subnet mask:
host     all         all         127.0.0.1      255.255.255.255          trust

For some reasons, it wouldn't work without that...

- Restarted the postmaster: sudo -u postgres pg_ctl -D /var/lib/pgsql/data restart

- /etc/init.d/postgresql restart

- Initialized OpenNMS": $OPENNMS_HOME/bin/install -dis  ------> Everything went well this time

- Started the OpenNMS: sudo /etc/init.d/opennms start

And finally http://localhost:8980/opennms/ is up and running! 

Thanks again for your help :-) Hopefully everything looks right this time...
Honia



 



> Date: Mon, 12 Jan 2009 11:20:36 -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:
> > 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 :-)
> 
> It means that your system, outside of OpenNMS and PostgreSQL is missing
> a host entry for "localhost" which will cause all kinds of unusual
> issues even if opennms and postgresql were not installed.
> 
> You should really fix your /etc/hosts file to have a localhost entry.
> Mine looks like this:
> 
> 127.0.0.1	localhost
> 
> Then you can undo all of the weird localhost-related changes you've
> made, and it will all work.  ;)
> 
> As an aside, this isn't really a development issue, it's a configuration
> issue, it would be more suited for the opennms-discuss list in the future.
> 
> -- 
> Benjamin Reed
> The OpenNMS Group
> http://www.opennms.org/
> 
> 

_________________________________________________________________
Windows Live™: Keep your life in sync. 
http://windowslive.com/explore?ocid=TXT_TAGLM_WL_t1_allup_explore_012009

------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword

_______________________________________________
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