Re: OpenNMS Distributed model

Bjorn Mork <bjron.mork <at> gmail.com> writes:

> 
> 
> Hi,
> 
> 
> 
> 
> 
> I tried to below mentioned steps. But facing below
> mentioned error 
> 
> 
> 
> 
> 
> 
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++
> Error detail…
> 
> 
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++
> 
> 
> root <at> 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
> 
>        


Hello,

I thought I would answer to this thread so the information 
is be available for anyone.  I faced the 
same problem and the issue is that only superusers in 
PostgreSQL can create functions in C.  

One possible solution is to execute in the db server 
"ALTER USER <opennms_user> WITH SUPERUSER;"
replacing the <opennms_user> for the correct one.  
The security implications that it might have are
up to your discretion.

Cheers,

Jorge


------------------------------------------------------------------------------
The best possible search technologies are now affordable for all companies.
Download your FREE open source Enterprise Search Engine today!
Our experts will assist you in its installation for $59/mo, no commitment.
Test it for FREE on our Cloud platform anytime!
http://pubads.g.doubleclick.net/gampad/clk?id=145328191&iu=/4140/ostg.clktrk
_______________________________________________
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