Re: install troubleshooting

Martin Ellis <[email protected]>
Newsgroups gmane.network.opennms.install
Message-ID <[email protected]> 
Hi,

See the online documentation for help on this:

http://www.opennms.org/wiki/QuickStart

Initialize OpenNMS and the Database

Next, you need to run the OpenNMS installer, which will initialize the OpenNMS database, and do some other basic setup. Upon upgrade, you should run this command again to make sure your database schema and other things required at startup are up-to-date.

In most cases, you can just run:

 $OPENNMS_HOME/bin/install -dis

Sometimes you may need to tell OpenNMS where to find libjicmp.so; in that case, you can use the -l option (OpenNMS 1.3.5 and higher):

 # i386 example

 $OPENNMS_HOME/bin/install -dis -l /usr/lib/jni:/usr/lib

 # x86_64 example

 $OPENNMS_HOME/bin/install -dis -l /usr/lib64/jni:/usr/lib64

If you have an error durring the install process about language "plpgsql" does not exist, you can try :

createlang -U postgres plpgsql opennms


Thanks

Martin

From: Fouëd BOUCHNAK [mailto:[email protected]]
Sent: 07 June 2010 15:46
To: [email protected]
Subject: [opennms-install] install troubleshooting

Anyone can help me please?

==================================================================
OpenNMS Installer Version $Id$

==================================================================
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: NO
- trying to load /usr/lib/jvm/java-6-sun-1.6.0.19/jre/lib/i386/server/libjrrd.so: NO
- trying to load /usr/lib/jvm/java-6-sun-1.6.0.19/jre/lib/i386/libjrrd.so: NO
- trying to load /usr/lib/jvm/java-6-sun-1.6.0.19/jre/../lib/i386/libjrrd.so: NO
- trying to load /libjrrd.so: NO
- trying to load /usr/share/opennms/lib/libjrrd.so: NO
- trying to load /usr/share/opennms/lib/linux32/libjrrd.so: NO
- trying to load /usr/java/packages/lib/i386/libjrrd.so: NO
- trying to load /lib/libjrrd.so: NO
- trying to load /usr/lib/libjrrd.so: NO
- trying to load /usr/lib/jni/libjrrd.so: NO
- trying to load /usr/lib/libjrrd.so: NO
- trying to load /usr/local/lib/libjrrd.so: NO
- trying to load /opt/NMSjicmp/lib/32/libjrrd.so: NO
- trying to load /opt/NMSjicmp/lib/64/libjrrd.so: NO
- Failed to load the optional jrrd library.
- This error is not fatal, since jrrd is only required for optional features.
- For more information, see http://www.opennms.org/index.php/jrrd
- 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 as the PostgreSQL password for OpenNMS

 *   using 'opennms' as the PostgreSQL database name for OpenNMS
- checking if database "opennms" is unicode... ALREADY UNICODE
- Checking for old import files in /usr/share/opennms/etc... DONE
- Migrating/creating database:
27 mai 2010 15:31:20 liquibase.database.template.JdbcTemplate comment
INFO: Lock Database
27 mai 2010 15:31:20 liquibase.lock.LockHandler acquireLock
INFO: Successfully acquired change log lock
27 mai 2010 15:31:26 liquibase.database.AbstractDatabase getRanChangeSetList
INFO: Reading from databasechangelog
27 mai 2010 15:31:51 liquibase.database.template.JdbcTemplate comment
INFO: Changeset stored-procedures/getManagePercentAvailIntfWindow.xml::getManagePercentAv ailIntfWindow::rangerrick::(MD5Sum: ae6ef5514fb6bc147099ad82f796645)
27 mai 2010 15:31:51 liquibase.database.template.JdbcTemplate comment
INFO: Release Database Lock
27 mai 2010 15:31:51 liquibase.lock.LockHandler releaseLock
INFO: Successfully released change log lock
Exception in thread "main" org.opennms.core.schema.MigrationException: unable to update t he database
at org.opennms.core.schema.Migrator.migrate(Migrator.java:290)
at org.opennms.install.Installer.install(Installer.java:281)
at org.opennms.install.Installer.main(Installer.java:857)
Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set stored-procedures/getManagePercentAvailIntfWindow.xml::getManagePercentAvailIntfWindow::rangerrick:
Reason: liquibase.exception.JDBCException: Error executing SQL CREATE OR REPLACE FUNCTION getManagePercentAvailIntfWindow(integer,varchar(16), timestamp without time zone, timestamp without time zone)
RETURNS float8 AS '
DECLARE
nid ALIAS FOR $1;
ipid ALIAS FOR $2;
xtime ALIAS FOR $3;
ytime ALIAS FOR $4;
downtime float8 := 0.0;
count integer := 0;
rollingWindow float := 0;
totalServiceTime float := 0;
BEGIN
IF xtime < ytime THEN
rollingWindow := EXTRACT (EPOCH FROM (ytime - xtime));
downtime := getManagedOutageForIntfInWindow(nid, ipid, ytime, xtime)/1000;
ELSE
rollingWindow := EXTRACT (EPOCH FROM (xtime - ytime));
downtime := getManagedOutageForIntfInWindow(nid, ipid, xtime, ytime)/1000;
END IF;
count := getManagedServiceCountForIntf(nid, ipid);
totalServiceTime := count * rollingWindow;



IF totalServiceTime > 0 THEN
RETURN 100 * (1 - (downtime / totalServiceTime));
ELSE
IF totalServiceTime = 0 THEN
RETURN 100;
ELSE
RETURN -1;
END IF;
END IF;
END;
' LANGUAGE 'plpgsql';:
Caused By: Error executing SQL CREATE OR REPLACE FUNCTION getManagePercentAvailIntfWindow(integer,varchar(16), timestamp without time zone, timestamp without time zone)
RETURNS float8 AS '
DECLARE
nid ALIAS FOR $1;
ipid ALIAS FOR $2;
xtime ALIAS FOR $3;
ytime ALIAS FOR $4;
downtime float8 := 0.0;
count integer := 0;
rollingWindow float := 0;
totalServiceTime float := 0;
BEGIN
IF xtime < ytime THEN
rollingWindow := EXTRACT (EPOCH FROM (ytime - xtime));
downtime := getManagedOutageForIntfInWindow(nid, ipid, ytime, xtime)/1000;
ELSE
rollingWindow := EXTRACT (EPOCH FROM (xtime - ytime));
downtime := getManagedOutageForIntfInWindow(nid, ipid, xtime, ytime)/1000;
END IF;
count := getManagedServiceCountForIntf(nid, ipid);
totalServiceTime := count * rollingWindow;



IF totalServiceTime > 0 THEN
RETURN 100 * (1 - (downtime / totalServiceTime));
ELSE
IF totalServiceTime = 0 THEN
RETURN 100;
ELSE
RETURN -1;
END IF;
END IF;
END;
' LANGUAGE 'plpgsql';:
Caused By: ERROR: language "plpgsql" does not exist
at liquibase.ChangeSet.execute(ChangeSet.java:238)
at liquibase.parser.visitor.UpdateVisitor.visit(UpdateVisitor.java:26)
at liquibase.parser.ChangeLogIterator.run(ChangeLogIterator.java:41)
at liquibase.Liquibase.update(Liquibase.java:112)
at org.opennms.core.schema.Migrator.migrate(Migrator.java:287)
... 2 more
Caused by: liquibase.exception.JDBCException: Error executing SQL CREATE OR REPLACE FUNCTION getManagePercentAvailIntfWindow(integer,varchar(16), timestamp without time zone, timestamp without time zone)
RETURNS float8 AS '
DECLARE
nid ALIAS FOR $1;
ipid ALIAS FOR $2;
xtime ALIAS FOR $3;
ytime ALIAS FOR $4;
downtime float8 := 0.0;
count integer := 0;
rollingWindow float := 0;
totalServiceTime float := 0;
BEGIN
IF xtime < ytime THEN
rollingWindow := EXTRACT (EPOCH FROM (ytime - xtime));
downtime := getManagedOutageForIntfInWindow(nid, ipid, ytime, xtime)/1000;
ELSE
rollingWindow := EXTRACT (EPOCH FROM (xtime - ytime));
downtime := getManagedOutageForIntfInWindow(nid, ipid, xtime, ytime)/1000;
END IF;
count := getManagedServiceCountForIntf(nid, ipid);
totalServiceTime := count * rollingWindow;



IF totalServiceTime > 0 THEN
RETURN 100 * (1 - (downtime / totalServiceTime));
ELSE
IF totalServiceTime = 0 THEN
RETURN 100;
ELSE
RETURN -1;
END IF;
END IF;
END;
' LANGUAGE 'plpgsql';
at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:56)
at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:87)
at liquibase.change.AbstractChange.execute(AbstractChange.java:251)
at liquibase.change.AbstractChange.executeStatements(AbstractChange.java:97)
at liquibase.ChangeSet.execute(ChangeSet.java:214)
... 6 more
Caused by: org.postgresql.util.PSQLException: ERROR: language "plpgsql" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:332)
at liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:79)
at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:49)
... 10 more

=
</pre>
________________________________
De nouvelles Emoticones sur Messenger ? Téléchargez les Emoticones pâte à modeler !<http://www.ilovemessenger.fr/emoticones/emoticones-pate-a-modeler.aspx>

------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo

_______________________________________________
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.