install troubleshooting

Fouëd BOUCHNAK <[email protected]>
Newsgroups gmane.network.opennms.install
Message-ID <[email protected]> 
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> 
 		 	   		  
_________________________________________________________________
Découvrez Windows Phone 7 : Une nouvelle ère de téléphones !
http://www.microsoft.com/windowsmobile/fr-fr/cmpn1/windowsphone7series/default.mspx

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