Re: install opennms in fedora10 (DJ Gregor)
"studyfordo" <[email protected]>
| Newsgroups | gmane.network.opennms.install |
|---|---|
| Message-ID | <000301cac566$cef26a90$6cd73fb0$@com> |
Hi,DJ
I have changed "lc_messages = 'C'" in postgresql.conf file and restart db.
Run command $OPENNMS_HOME/bin/install -dis again.
And occur the following error messages. Pls give some advice to me.thanks
信息: Marking ChangeSet:
1.6.0/tables/atinterface.xml::1.6.0-recreate-hash-index::rangerrick::(MD5Sum
: cda8ae7c6c1efacb5f55b9a5b4876cc1) ran due to precondition failure:
Index atinterface_nodeid_idx does not exist
信息: Marking ChangeSet:
1.7.4/changelog.xml::1.7.4-categories-fix-missing-data::rangerrick::(MD5Sum:
a01ad7492f6cae9e4085cc7f843d3ef8) ran due to precondition failure:
SQL Precondition failed. Expected '0' got '6'
信息: Release Database Lock
2010-3-16 15:21:32 liquibase.lock.LockHandler releaseLock
信息: 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:281)
at org.opennms.install.Installer.main(Installer.java:857)
Caused by: liquibase.exception.MigrationFailedException: Migration failed
for change set
stored-procedures/getManagePercentAvailIntfWindow.xml::getManagePercentAvail
IntfWindow::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 '
' 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(QueryExecutorI
mpl.java:1525)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.ja
va:1309)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
ava:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2St
atement.java:340)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
ava:332)
at
liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInState
ment(JdbcTemplate.java:79)
at
liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:49)
... 10 more
' 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;
-----Original Message-----
----------------------------------------------------------------------
Message: 2
Date: Sat, 13 Mar 2010 13:38:40 -0500
From: "DJ Gregor" <[email protected]>
Subject: Re: [opennms-install] install opennms in fedora10
To: "Installation questions and help"
<[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset="UTF-8"
> Pls give some advice.thanks
Reading the error message thoroughly is usually a good start. ;-)
Particularly this part:
> The database server's
> error
> messages are not in English, however the installer requires them to be in
> English when using PostgreSQL earlier than 7.4. You either need to set
> "lc_messages = 'C'" in your postgresql.conf file and restart PostgreSQL
> or
> upgrade to PostgreSQL 7.4 or later. The installer executed the query
> "SELECT bogus_column_1268273987612 FROM bogus_table_1268273987612 WHERE
> another_bogus_column_1268273987612 IS NULL" and expected "does not exist"
> in
> the error message, but this exception was received instead:
> org.postgresql.util.PSQLException: ??: ?? "bogus_table_1268273987612" ?
> ??
It gave you the solution in the error message. Actually, it gave you
TWO solutions--you get to chose which one you want to implement. :-)
- djg
On Thu, 11 Mar 2010 10:22 +0800, "studyfordo" <[email protected]>
wrote:
> When I instll opennms in fedora10 , refer to
> http://www.opennms.org/wiki/Installation:Yum
>
>
>
> I excute the following command $OPENNMS_HOME/bin/install -dis ,
> occurring
> the following error.
>
> root@tomatoegg sbin]# $OPENNMS_HOME/bin/install -dis
>
>
============================================================================
> ==
>
> OpenNMS Installer Version $Id$
>
>
============================================================================
> ==
>
>
>
> Configures PostgreSQL tables, users, and other miscellaneous settings.
>
>
>
> - searching for jicmp:
>
> - trying to load /usr/lib/libjicmp.so: OK
>
> - searching for jrrd:
>
> - trying to load /usr/lib/libjrrd.so: OK
>
> - using SQL directory... /opt/opennms/etc
>
> - using create.sql... /opt/opennms/etc/create.sql
>
> Exception in thread "main" java.lang.Exception: The database server's
> error
> messages are not in English, however the installer requires them to be in
> English when using PostgreSQL earlier than 7.4. You either need to set
> "lc_messages = 'C'" in your postgresql.conf file and restart PostgreSQL
> or
> upgrade to PostgreSQL 7.4 or later. The installer executed the query
> "SELECT bogus_column_1268273987612 FROM bogus_table_1268273987612 WHERE
> another_bogus_column_1268273987612 IS NULL" and expected "does not exist"
> in
> the error message, but this exception was received instead:
> org.postgresql.util.PSQLException: ??: ?? "bogus_table_1268273987612" ?
> ??
>
> at
>
org.opennms.netmgt.dao.db.InstallerDb.databaseCheckLanguage(InstallerDb.java
> :1610)
>
> at org.opennms.install.Installer.install(Installer.java:225)
>
> at org.opennms.install.Installer.main(Installer.java:857)
>
> Caused by: org.postgresql.util.PSQLException: ??: ??
> "bogus_table_1268273987612" ???
>
> at
>
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorI
> mpl.java:1525)
>
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.
ja
> va:1309)
>
> at
>
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
>
> at
>
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
> ava:452)
>
> at
>
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2St
> atement.java:340)
>
> at
>
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statem
> ent.java:239)
>
> at
>
org.opennms.netmgt.dao.db.InstallerDb.databaseCheckLanguage(InstallerDb.java
> :1600)
>
> ... 2 more
>
>
>
> Pls give some advice.thanks
>
>
----------------------------------------------------------------------------
--
> Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> 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
------------------------------
Message: 3
Date: Mon, 15 Mar 2010 11:57:20 -0500
From: "Steven Lamczyk" <[email protected]>
Subject: [opennms-install] Integration with Hyperic
To: <[email protected]>
Message-ID:
<F10C48C25E4B854AB61F1888F840438102DDEC84@us-ex02.Corp.Exlibrisgroup.com>
Content-Type: text/plain; charset="us-ascii"
I am having a ton of problems trying to integrate the two, basically I
went through the PDF and did everything I can think of there, and now
when I go into admin in opennms, and choose provisioning groups, it
bombs with an error. Am I missing some changes in the xml files that I
need to make, or what exactly could I be missing?
Thank you,
Steven Lamczyk
Hosting Systems Admin
Ex Libris (USA) Inc.
1350 E. Touhy Ave. Suite 200 East
Des Plaines, IL 60018
Office: 847-227-2642
Work Cell: 815-217-4262
Follow Ex Libris on Twitter: @exlibrisgroup
<http://twitter.com/ExLibrisGroup>
Try bX <http://www.exlibrisgroup.com/category/bXOverview> our NEW
scholarly article recommender service!
-------------- next part --------------
An HTML attachment was scrubbed...
------------------------------
Message: 4
Date: Mon, 15 Mar 2010 14:51:15 -0500
From: "Steven Lamczyk" <[email protected]>
Subject: [opennms-install] Help
To: <[email protected]>
Message-ID:
<F10C48C25E4B854AB61F1888F840438102DDEC8A@us-ex02.Corp.Exlibrisgroup.com>
Content-Type: text/plain; charset="us-ascii"
Is anyone out there who can help me?
Steven Lamczyk
Hosting Systems Admin
Ex Libris (USA) Inc.
1350 E. Touhy Ave. Suite 200 East
Des Plaines, IL 60018
Office: 847-227-2642
Work Cell: 815-217-4262
Follow Ex Libris on Twitter: @exlibrisgroup
<http://twitter.com/ExLibrisGroup>
Try bX <http://www.exlibrisgroup.com/category/bXOverview> our NEW
scholarly article recommender service!
-------------- next part --------------
An HTML attachment was scrubbed...
------------------------------
Message: 5
Date: Mon, 15 Mar 2010 16:19:34 -0400
From: DJ Gregor <[email protected]>
Subject: Re: [opennms-install] Integration with Hyperic
To: Installation questions and help
<[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset="us-ascii"
You need to be more specific in stating your problem. Your stated
problem is effectively: "I did something big and complex, and now when
I do X, it breaks." That's not enough detail for us to help you,
unless you are lucky enough for someone who has seen that exact
problem to read your email.
It sounds like OpenNMS gave you a specific error--that would be an
extremely good thing to share. Also, knowing what steps you took up
to this point would be good, particularly what config files you
changed ("diff -u" is your friend). Here are some good guidelines
when asking for help:
http://catb.org/~esr/faqs/smart-questions.html#beprecise
On Mar 15, 2010, at 12:57 PM, "Steven Lamczyk"
<[email protected]
> wrote:
> I am having a ton of problems trying to integrate the two, basically
> I went through the PDF and did everything I can think of there, and
> now when I go into admin in opennms, and choose provisioning groups,
> it bombs with an error. Am I missing some changes in the xml files
> that I need to make, or what exactly could I be missing?
>
>
>
> Thank you,
>
>
>
> Steven Lamczyk
>
> Hosting Systems Admin
> Ex Libris (USA) Inc.
> 1350 E. Touhy Ave. Suite 200 East
> Des Plaines, IL 60018
> Office: 847-227-2642
>
> Work Cell: 815-217-4262
>
>
>
> Follow Ex Libris on Twitter: @exlibrisgroup
>
> Try bX our NEW scholarly article recommender service!
>
>
>
> ---
> ---
> ---
> ---------------------------------------------------------------------
> Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
------------------------------
----------------------------------------------------------------------------
--
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
------------------------------
_______________________________________________
opennms-install mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/opennms-install
End of opennms-install Digest, Vol 46, Issue 5
**********************************************
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
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