Hello,
When running the OpenNMS installer for the unstable version on Ubuntu 8.04 it fails and opennms will not start. This is my second installation of opennms, I have a working stable installation on a laptop running Ubunut 9.04 for testing which works fine and now that I'm attempting to build the production server the installation fails.
Any insite would be appreciated.
user@...:~$ sudo /usr/share/opennms/bin/install -dis
==============================================================================
OpenNMS Installer Version $Id: Installer.java 13609 2009-06-07 00:59:50Z rangerrick $
==============================================================================
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.14/jre/lib/i386/client/libjrrd.so: NO
- trying to load /usr/lib/jvm/java-6-sun-1.6.0.14/jre/lib/i386/libjrrd.so: NO
- trying to load /usr/lib/jvm/java-6-sun-1.6.0.14/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/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:
Jul 16, 2009 11:58:27 PM liquibase.database.template.JdbcTemplate comment
INFO: Lock Database
Jul 16, 2009 11:58:27 PM liquibase.lock.LockHandler acquireLock
INFO: Successfully acquired change log lock
Jul 16, 2009 11:58:31 PM liquibase.database.AbstractDatabase getRanChangeSetList
INFO: Reading from databasechangelog
Jul 16, 2009 11:58:57 PM liquibase.database.template.JdbcTemplate comment
INFO: Changeset stored-procedures/getManagePercentAvailIntfWindow.xml::getManagePercentAvailIntfWindow::rangerrick::(MD5Sum: ae6ef5514fb6bc147099ad82f796645)
Jul 16, 2009 11:58:57 PM liquibase.database.template.JdbcTemplate comment
INFO: Release Database Lock
Jul 16, 2009 11:58:57 PM liquibase.lock.LockHandler releaseLock
INFO: Successfully released change log lock
Exception in thread "main" org.opennms.core.schema.MigrationException: unable to update the database
at org.opennms.core.schema.Migrator.migrate(Migrator.java:290)
at org.opennms.install.Installer.install(Installer.java:282)
at org.opennms.install.Installer.main(Installer.java:858)
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
user@...:~$ sudo /etc/init.d/opennms start
Starting Open Network Management System: opennms/usr/sbin/opennms: OpenNMS not configured.
/usr/share/opennms/etc/configured does not exist.
_________________________________________________________________
Windows Live™: Keep your life in sync.
http://windowslive.com/explore?ocid=TXT_TAGLM_WL_BR_life_in_synch_062009
|