Re: install opennms in fedora10 (DJ Gregor)
"studyfordo" <[email protected]>
| Newsgroups | gmane.network.opennms.install |
|---|---|
| Message-ID | <000001cac5ae$0f648df0$2e2da9d0$@com> |
I have resolved problem. I get info from opennsm.org website as following: If you have an error durring the install process about language "plpgsql" does not exist, you can try : createlang -U postgres plpgsql opennms thanks DJ. -----Original Message----- From: studyfordo [mailto:[email protected]] Sent: Wednesday, March 17, 2010 8:14 AM To: '[email protected]' Subject: RE: install opennms in fedora10 (DJ Gregor) 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 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