upgraded to 1.12.3

Hello 

I just upgraded to 1.12.3 and I am getting this error: 



# /opt/opennms/bin/install -dis 
============================================================================== 
OpenNMS Installer 
============================================================================== 

Configures PostgreSQL tables, users, and other miscellaneous settings. 

- searching for libjicmp.so: 
- trying to load /usr/lib64/libjicmp.so: OK 
- searching for libjicmp6.so: 
- trying to load /usr/lib64/libjicmp6.so: OK 
- searching for libjrrd.so: 
- trying to load /usr/lib64/libjrrd.so: OK 
- using SQL directory... /opt/opennms/etc 
- using create.sql... /opt/opennms/etc/create.sql 
* using 'postgres' as the PostgreSQL user 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 /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:2102) 
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) 
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) 
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) 
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) 
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381) 
at org.opennms.core.db.install.InstallerDb.databaseSetUser(InstallerDb.java:2020) 
at org.opennms.install.Installer.install(Installer.java:250) 
at org.opennms.install.Installer.main(Installer.java:960) 




I turned on postgresql logging and this is what I see in the log: 

LOG: execute <unnamed>: SELECT version() 
LOG: execute <unnamed>: SELECT usename FROM pg_user WHERE usename = 'opennms' 
LOG: execute <unnamed>: SELECT datname from pg_database WHERE datname = 'opennms' 
LOG: execute <unnamed>: SELECT oid FROM pg_proc WHERE proname='plpgsql_call_handler' AND proargtypes = '' 
LOG: execute <unnamed>: SELECT pg_language.oid FROM pg_language, pg_proc WHERE pg_proc.proname='plpgsql_call_handler' AND pg_proc.proargtypes = '' AND pg_proc.oid = pg_language.lanplcallfoid AND pg_language.lanname = 'plpgsql' 
LOG: execute <unnamed>: SELECT encoding FROM pg_database WHERE LOWER(datname)='opennms' 
LOG: execute <unnamed>: SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname='pg_catalog') WHERE c.relnamespace = n.oid AND n.nspname LIKE 'public' AND c.relname LIKE '%' ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME 
ERROR: syntax error at or near "$1" at character 13 
STATEMENT: ALTER TABLE $1 OWNER TO $2 
LOG: unexpected EOF on client connection 

How can I get my opennms back? 




Pablo

------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT 
organizations don't have a clear picture of how application performance 
affects their revenue. With AppDynamics, you get 100% visibility into your 
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk

_______________________________________________
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