(This post was updated on )
Hello!
There is extreme need to monitor non-ip Frame Relay ports (ifAdminStatus / ifOperStatus) with SNMP Service Poller, which as I know is implemented only in branch 1.7.x.
But upgrade to 1.7.x is impossible due to the bug that appeares in both ONMS 1.7.5 and 1.7.6 (since Liquibase probably). Installer dies with exception related to PostgreSQL interaction. Previous installation/upgrade of ONMS from 1.5.91 to 1.7.0 was completely successful with the same server configuration (FreeBSD 6.0, JDK 1.6, PostgreSQL 8.2.7). I would rather use 1.7.0 but it hasn't working map links that is another problem.
The question is for developers, will this be improved and how soon the improvement comes?
-------------------------------------
OpenNMS 1.7.5, 1.7.6 Installation Log
-------------------------------------
root@myhost# /usr/local/opennms/bin/install -disU
==============================================================================
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/local/lib/libjicmp.so: OK
- searching for jrrd:
- trying to load /usr/local/lib/libjrrd.so: OK
- using SQL directory... /usr/local/opennms/etc
- using create.sql... /usr/local/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/local/opennms/etc... DONE
Exception in thread "main" org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1"
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:354)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:347)
at org.opennms.netmgt.dao.db.InstallerDb.databaseSetUser(InstallerDb.java:1935)
at org.opennms.install.Installer.install(Installer.java:279)
at org.opennms.install.Installer.main(Installer.java:858)
--------------
PostgreSQL Log
--------------
Aug 6 16:18:13 myhost postgres[33286]: [1-1] ERROR: relation "bogus_table_1249564693338" does not exist
Aug 6 16:18:13 myhost postgres[33286]: [1-2] STATEMENT: SELECT bogus_column_1249564693338 FROM bogus_table_1249564693338 WHERE another_bogus_column_1249564693338 IS NULL
Aug 6 16:18:13 myhost postgres[33292]: [1-1] WARNING: nonstandard use of \\ in a string literal at character 99
Aug 6 16:18:13 myhost postgres[33292]: [1-2] HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
Aug 6 16:18:13 myhost postgres[33292]: [2-1] ERROR: syntax error at or near "$1" at character 13
Aug 6 16:18:13 myhost postgres[33292]: [2-2] STATEMENT: ALTER TABLE $1 OWNER TO $2
Aug 6 16:18:13 myhost postgres[33292]: [3-1] LOG: unexpected EOF on client connection
