Fwd: OpenNMS 1.8.0-2 Installation Fails in InstallerDb.databaseSetUser

Hi all,

We're running OpenNMS on RHEL 5.3 using the RPMs.
A few days ago yum upgraded to the latest 1.8.0-2 release over night.

When I run the installer ($OPENNMS_HOME/bin/install -l /usr/local/lib -dis)
to complete the upgrade, everything goes well until this line:
[...]
* using 'opennms' as the PostgreSQL database name for OpenNMS
- checking if database "opennms" is unicode... ALREADY UNICODE
- Checking for old import files in /opt/opennms/etc... DONE
Exception in thread "main" org.postgresql.util.PSQLException: ERROR: syntax
error at or near "$1"
  Position: 13
        at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:360)
        at
org.opennms.netmgt.dao.db.InstallerDb.databaseSetUser(InstallerDb.java:1940)
        at org.opennms.install.Installer.install(Installer.java:278)
        at org.opennms.install.Installer.main(Installer.java:859)

This is reproducible. It seems the error is caused
in org.opennms.netmgt.dao.db.InstallerDb.databaseSetUser.

>From what I saw in other installer logs on the web, the next step after
"Checking for old import files" is "Migrating/creating database". I
therefore suppose that this is what's failing. I cannot find a log file to
get any more details on this problem in the installation process.

Short of getting the source code and starting to debug this, do you have any
ideas what I can try to get the installer to go through and finish?

Regards,

Daniel

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