Re: Error when installing OpeNMS

Hello Jens,

I thins your problem is that you (the script which runs) try to access the
database with a user but the script is issued in the name of other user, I
suppose its root, and these too user names do not match.
To resolve the problem, replace "ident sameuser" with "trust" in
/var/lib/pgsql/data/pg_hba.conf and restart postgres

I hope it helps.

Regards, Sandor


On Tue, Oct 9, 2012 at 11:41 AM, Jens Jönsson <[email protected]>wrote:

> Hi!
>
> I'm a newbie with Linux. I have tried installing OpenNMS to my Debian
> v6.3 64-bit box.
> I get the following error:
>
> Exception in thread "main" org.opennms.core.schema.MigrationException: an
> error occurred getting the version from the database
>         at
> org.opennms.core.schema.Migrator.getDatabaseVersion(Migrator.java:178)
>         at
> org.opennms.core.schema.Migrator.validateDatabaseVersion(Migrator.java:206)
>         at org.opennms.install.Installer.install(Installer.java:226)
>         at org.opennms.install.Installer.main(Installer.java:949)
> Caused by: org.postgresql.util.PSQLException: Connection refused. Check
> that the hostname and port are correct and that the postmaster is accepting
> TCP/IP connections.
>
> I have edited the /var/lib/pgsql/data/pg_hba.conf file and it looks lile
> below:
>
> # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
> # "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
> host    all         all         192.168.15.0/24       ident sameuser
> # IPv6 local connections:
> host    all         all         ::1/128               ident sameuser
> When I restart PostgreSQL service it fails:
>
> [root@opennms data]# /sbin/service postgresql restart
> Stopping postgresql service:                               [  OK  ]
> Starting postgresql service:                               [FAILED]
> It seems to me that IPTables are denying connections ? How do I open up
> localhost access to PostgreSQL on localhost ?
>
> Thanks in advance,
>
> :-) Jens
>
>
> ------------------------------------------------------------------------------
> Don't let slow site performance ruin your business. Deploy New Relic APM
> Deploy New Relic app performance management and know exactly
> what is happening inside your Ruby, Python, PHP, Java, and .NET app
> Try New Relic at no cost today and get our sweet Data Nerd shirt too!
> http://p.sf.net/sfu/newrelic-dev2dev
> _______________________________________________
> Please read the OpenNMS Mailing List FAQ:
> http://www.opennms.org/index.php/Mailing_List_FAQ
>
> opennms-install mailing list
>
> To *unsubscribe* or change your subscription options, see the bottom of
> this page:
> https://lists.sourceforge.net/lists/listinfo/opennms-install
>

------------------------------------------------------------------------------
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev

_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-install mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-install