Re: Fwd: OpenNMS 1.8.0-2 Installation Fails inInstallerDb.databaseSetUser

I don't want to drop the tables, because I need to keep the historic data.
Any other ideas?

Daniel

On Fri, Jun 18, 2010 at 08:58, Liang, Guohua <[email protected]
> wrote:

>  I had the same problem. But I went through it by empting the database,
> i.e., drop all the tables and sequences. I was able to initialize the
> database and start opennms 1.8.0.
> Guohua
>
>  ------------------------------
> *From:* Daniel Geske [mailto:[email protected]]
> *Sent:* June 17, 2010 16:39
>
> *To:* [email protected]
> *Subject:* [opennms-install] Fwd: OpenNMS 1.8.0-2 Installation Fails
> inInstallerDb.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
>



-- 
Daniel Geske
Technology Director
Horn Group -- Digital Communications for Technology Companies
www.horngroup.com
(O) 646.202.9762
[email protected]

Awards - www.horngroup.com/company-awards
Brass Tacks Blog - horngroup.blogs.com
Twitter - twitter.com/horngroup

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