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

Are there valid jdbc-data-source entries for opennms & opennms-admin in
etc/opennms-datasources.xml?


________________________________

	From: Daniel Geske [mailto:[email protected]] 
	Sent: Thursday, June 17, 2010 3:39 PM
	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(QueryExecu
torImpl.java:2062)
	        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp
l.java:1795)
	        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
257)
	        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:479)
	        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb
c2Statement.java:367)
	        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:360)
	        at
org.opennms.netmgt.dao.db.InstallerDb.databaseSetUser(InstallerDb.java:1
940)
	        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


This e-mail message is being sent solely for use by the intended recipient(s) and may contain confidential information.  Any unauthorized review, use, disclosure or distribution is prohibited.  If you are not the intended recipient, please contact the sender by phone or reply by e-mail, delete the original message and destroy all copies. Thank you.

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