Re: OpenNMS Distributed model

by chance u may not have created the user in the database prior to running nms installer script. 

Alan Tse  

On Oct 14, 2011, at 6:46 PM, Bjorn Mork <[email protected]> wrote:

> 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

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