Re: OpenNMS Distributed model

Hi,

I tried to below mentioned steps. But facing below mentioned error

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Error detail…

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


root@nsm:/etc/opennms# /usr/share/opennms/bin/install -dis

==============================================================================

OpenNMS Installer

==============================================================================

Configures PostgreSQL tables, users, and other miscellaneous settings.
- searching for jicmp:

  - trying to load /usr/lib/jni/libjicmp.so: OK

- searching for jrrd:

  - trying to load /usr/lib/jni/libjrrd.so: OK

- using SQL directory... /usr/share/opennms/etc

- using create.sql... /usr/share/opennms/etc/create.sql

* using 'postgres' as the PostgreSQL user for OpenNMS

* using 'opennms' as the PostgreSQL database name for OpenNMS

Exception in thread "main" org.opennms.core.schema.MigrationException: an
error occurred getting the version from the database

        at
org.opennms.core.schema.Migrator.createLangPlPgsql(Migrator.java:240)

        at
org.opennms.core.schema.Migrator.prepareDatabase(Migrator.java:374)

        at org.opennms.install.Installer.install(Installer.java:245)

        at org.opennms.install.Installer.main(Installer.java:931)

Caused by: org.postgresql.util.PSQLException: ERROR: permission denied for
language c

        at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)

        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)

        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)

        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)

        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)

        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)

        at
org.opennms.core.schema.Migrator.createLangPlPgsql(Migrator.java:223)

        ... 3 more

root@nsm:/etc/opennms#



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

My Web Server – Data Source File

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++



root@nsm:/etc/opennms# view opennms-datasources.xml



<?xml version="1.0" encoding="UTF-8"?>

<datasource-configuration xmlns:this="
http://xmlns.opennms.org/xsd/config/opennms-datasources"

  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

  xsi:schemaLocation="
http://xmlns.opennms.org/xsd/config/opennms-datasources


http://www.opennms.org/xsd/config/opennms-datasources.xsd ">

  <jdbc-data-source name="opennms"

                    database-name="opennms"

                    class-name="org.postgresql.Driver"

                    url="jdbc:postgresql://192.168.1.2:5432/opennms"

                    user-name="opennms"

                    password="opennms" />



  <jdbc-data-source name="opennms-admin"

                    database-name="template1"

                    class-name="org.postgresql.Driver"

                    url="jdbc:postgresql://192.168.1.2:5432/template1"

                    user-name="postgres"

                    password="" />

</datasource-configuration>

~



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

There is no UFW issue.....

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++



root@nsm:/etc/opennms# telnet 192.168.1.2  5432

Trying 192.168.1.2 ...

Connected to 192.168.1.2 .

Escape character is '^]'.







Please help to resolve this issue…





*Regards,*

*B~Mork*

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2d-oct

_______________________________________________
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