Quantcast

OpenNMS upgradation issue from 15.0.1 to 19.0.1

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

OpenNMS upgradation issue from 15.0.1 to 19.0.1

k.nithyanandan

Hi Team,

 

I am newbie to this OpenNMS tool, I was trying to upgrade the OpenNMS tool from the version 15.0.1 to 19.0.1

Using rpm packages I tried to upgrade the version using the –nodeps because I am using Postgresql 9.3 in other server.

But after upgradation when I tried to start or check the status of OpenNMS I am getting this error mentioned below.

Can you please someone suggest me what should I do to resolve this issue?

 

opennms -v status

/opt/opennms/bin/opennms: OpenNMS not configured.

/opt/opennms/etc/configured does not exist.

 

You need to run the installer to set up the database.  In most

cases, it is enough to run:

 

  /opt/opennms/bin/install -dis

 

For details, see the install guide at:

 

http://www.opennms.org/index.php/QuickStart#Initialize_OpenNMS_and_the_Database

 

 

Regards,

Nithyanandan K

 




This message is for the designated recipient only and may contain privileged, proprietary, or otherwise confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the e-mail by you is prohibited. Where allowed by local law, electronic communications with Accenture and its affiliates, including e-mail and instant messaging (including content), may be scanned by our systems for the purposes of information security and assessment of internal compliance with Accenture policy.
______________________________________________________________________________________

www.accenture.com

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: OpenNMS upgradation issue from 15.0.1 to 19.0.1

Ronny Trommer-3
You need to run the installer to set up the database.  In most
cases, it is enough to run:
 
  /opt/opennms/bin/install -dis

Make sure you have backups and then basically the command mentioned in the text :)

On 14 Mar 2017, at 10:33, [hidden email] wrote:

Hi Team,
 
I am newbie to this OpenNMS tool, I was trying to upgrade the OpenNMS tool from the version 15.0.1 to 19.0.1
Using rpm packages I tried to upgrade the version using the –nodeps because I am using Postgresql 9.3 in other server.
But after upgradation when I tried to start or check the status of OpenNMS I am getting this error mentioned below.
Can you please someone suggest me what should I do to resolve this issue?
 
opennms -v status
/opt/opennms/bin/opennms: OpenNMS not configured.
/opt/opennms/etc/configured does not exist.
 
You need to run the installer to set up the database.  In most
cases, it is enough to run:
 
  /opt/opennms/bin/install -dis
 
For details, see the install guide at:
 
 
 
Regards,
Nithyanandan K
 



This message is for the designated recipient only and may contain privileged, proprietary, or otherwise confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the e-mail by you is prohibited. Where allowed by local law, electronic communications with Accenture and its affiliates, including e-mail and instant messaging (including content), may be scanned by our systems for the purposes of information security and assessment of internal compliance with Accenture policy. 
______________________________________________________________________________________

www.accenture.com
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

signature.asc (507 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: OpenNMS upgradation issue from 15.0.1 to 19.0.1

k.nithyanandan

Hi,

 

I tried this command but this also giving the error. Previously it was working fine with postgres but after upgradation I am not able to. I have the Postgresql in the other server not in the same server where OpenNMS is installed.

When I run this command I am getting the error.

 

./install -dis

==============================================================================

OpenNMS Installer

==============================================================================

 

Configures PostgreSQL tables, users, and other miscellaneous settings.

 

DEBUG: Platform is IPv6 ready: true

- searching for libjicmp.so:

  - trying to load /usr/lib64/libjicmp.so: NO

  - trying to load /usr/lib/oracle/11.2/client64/lib/libjicmp.so: NO

  - trying to load /opt/opennms/lib/libjicmp.so: NO

  - trying to load /opt/opennms/lib/linux64/libjicmp.so: NO

  - trying to load /usr/java/packages/lib/amd64/libjicmp.so: NO

  - trying to load /usr/lib64/libjicmp.so: NO

  - trying to load /lib64/libjicmp.so: NO

  - trying to load /lib/libjicmp.so: NO

  - trying to load /usr/lib/libjicmp.so: Java HotSpot(TM) 64-Bit Server VM warning: You have loaded library /usr/lib/libjicmp.so which might have disabled stack guard. The VM will try to fix the stack guard now.

It's highly recommended that you fix the library with 'execstack -c <libfile>', or link it with '-z noexecstack'.

NO

  - trying to load /usr/lib/jni/libjicmp.so: NO

  - trying to load /usr/lib/libjicmp.so: NO

  - trying to load /usr/local/lib/libjicmp.so: NO

  - trying to load /opt/NMSjicmp/lib/32/libjicmp.so: NO

  - trying to load /opt/NMSjicmp/lib/64/libjicmp.so: NO

  - trying to load /opt/NMSjicmp6/lib/32/libjicmp.so: NO

  - trying to load /opt/NMSjicmp6/lib/64/libjicmp.so: NO

- Failed to load the optional jicmp library.

  - This error is not fatal, since jicmp is only required for optional features.

  - For more information, see http://www.opennms.org/index.php/jicmp

- searching for libjicmp6.so:

  - trying to load /usr/lib64/libjicmp6.so: OK

- searching for libjrrd.so:

  - trying to load /usr/lib64/libjrrd.so: NO

  - trying to load /usr/lib/oracle/11.2/client64/lib/libjrrd.so: NO

  - trying to load /opt/opennms/lib/libjrrd.so: NO

  - trying to load /opt/opennms/lib/linux64/libjrrd.so: NO

  - trying to load /usr/java/packages/lib/amd64/libjrrd.so: NO

  - trying to load /usr/lib64/libjrrd.so: NO

  - trying to load /lib64/libjrrd.so: NO

  - trying to load /lib/libjrrd.so: NO

  - trying to load /usr/lib/libjrrd.so: NO

  - trying to load /usr/lib/jni/libjrrd.so: NO

  - trying to load /usr/lib/libjrrd.so: NO

  - trying to load /usr/local/lib/libjrrd.so: NO

  - trying to load /opt/NMSjicmp/lib/32/libjrrd.so: NO

  - trying to load /opt/NMSjicmp/lib/64/libjrrd.so: NO

 - trying to load /opt/NMSjicmp6/lib/32/libjrrd.so: NO

  - trying to load /opt/NMSjicmp6/lib/64/libjrrd.so: NO

- Failed to load the optional jrrd library.

  - This error is not fatal, since jrrd is only required for optional features.

  - For more information, see http://www.opennms.org/index.php/jrrd

- searching for libjrrd2.so:

  - trying to load /usr/lib64/libjrrd2.so: NO

  - trying to load /usr/lib/oracle/11.2/client64/lib/libjrrd2.so: NO

  - trying to load /opt/opennms/lib/libjrrd2.so: NO

  - trying to load /opt/opennms/lib/linux64/libjrrd2.so: NO

  - trying to load /usr/java/packages/lib/amd64/libjrrd2.so: NO

  - trying to load /usr/lib64/libjrrd2.so: NO

  - trying to load /lib64/libjrrd2.so: NO

  - trying to load /lib/libjrrd2.so: NO

  - trying to load /usr/lib/libjrrd2.so: NO

  - trying to load /usr/lib/jni/libjrrd2.so: NO

  - trying to load /usr/lib/libjrrd2.so: NO

  - trying to load /usr/local/lib/libjrrd2.so: NO

  - trying to load /opt/NMSjicmp/lib/32/libjrrd2.so: NO

  - trying to load /opt/NMSjicmp/lib/64/libjrrd2.so: NO

  - trying to load /opt/NMSjicmp6/lib/32/libjrrd2.so: NO

  - trying to load /opt/NMSjicmp6/lib/64/libjrrd2.so: NO

- Failed to load the optional jrrd2 library.

  - This error is not fatal, since jrrd2 is only required for optional features.

  - For more information, see http://www.opennms.org/index.php/jrrd2

16:37:53.502 [Main] WARN  org.opennms.install.Installer - Could not create file: /opt/opennms/etc/libraries.properties

- using SQL directory... /opt/opennms/etc

- using create.sql... /opt/opennms/etc/create.sql

16:37:53.527 [Main] INFO  org.opennms.core.schema.Migrator - validating database version

* using 'postgres' as the PostgreSQL user for OpenNMS

* using 'opennms' as the PostgreSQL database name for OpenNMS

16:37:53.736 [Main] INFO  org.opennms.core.schema.Migrator - validating database version

16:37:53.759 [Main] INFO  org.opennms.core.schema.Migrator - adding PL/PgSQL support to the database, if necessary

16:37:53.767 [Main] INFO  org.opennms.core.schema.Migrator - PL/PgSQL call handler exists

16:37:53.768 [Main] INFO  org.opennms.core.schema.Migrator - PL/PgSQL language exists

- checking if database "opennms" is unicode... ALREADY UNICODE

- Checking for old import files in /opt/opennms/etc... DONE

java.lang.reflect.InvocationTargetException

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:498)

        at org.opennms.bootstrap.Bootstrap$4.run(Bootstrap.java:464)

        at java.lang.Thread.run(Thread.java:745)

Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1"

  Position: 13

        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2458)

        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2158)

        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:291)

        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:432)

        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:358)

        at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:171)

        at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:160)

        at org.opennms.core.db.install.InstallerDb.databaseSetUser(InstallerDb.java:1647)

        at org.opennms.install.Installer.install(Installer.java:267)

        at org.opennms.install.Installer.main(Installer.java:989)

        ... 6 more

 

From: Ronny Trommer [mailto:[hidden email]]
Sent: Tuesday, March 14, 2017 4:36 PM
To: General OpenNMS Discussion <[hidden email]>
Subject: Re: [opennms-discuss] OpenNMS upgradation issue from 15.0.1 to 19.0.1

 

You need to run the installer to set up the database.  In most

cases, it is enough to run:

 

  /opt/opennms/bin/install -dis

 

Make sure you have backups and then basically the command mentioned in the text :)

 

On 14 Mar 2017, at 10:33, [hidden email] wrote:

 

Hi Team,

 

I am newbie to this OpenNMS tool, I was trying to upgrade the OpenNMS tool from the version 15.0.1 to 19.0.1

Using rpm packages I tried to upgrade the version using the –nodeps because I am using Postgresql 9.3 in other server.

But after upgradation when I tried to start or check the status of OpenNMS I am getting this error mentioned below.

Can you please someone suggest me what should I do to resolve this issue?

 

opennms -v status

/opt/opennms/bin/opennms: OpenNMS not configured.

/opt/opennms/etc/configured does not exist.

 

You need to run the installer to set up the database.  In most

cases, it is enough to run:

 

  /opt/opennms/bin/install -dis

 

For details, see the install guide at:

 

 

 

Regards,

Nithyanandan K

 

 



This message is for the designated recipient only and may contain privileged, proprietary, or otherwise confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the e-mail by you is prohibited. Where allowed by local law, electronic communications with Accenture and its affiliates, including e-mail and instant messaging (including content), may be scanned by our systems for the purposes of information security and assessment of internal compliance with Accenture policy. 
______________________________________________________________________________________

www.accenture.com
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, 
Slashdot.org! http://sdm.link/slashdot_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

 


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: OpenNMS upgradation issue from 15.0.1 to 19.0.1

Dan Stevenson

Possibly a Java issue? You could try updating your Java then running:



Then run the installer again.

On 3/14/2017 7:14 AM, [hidden email] wrote:

Hi,

 

I tried this command but this also giving the error. Previously it was working fine with postgres but after upgradation I am not able to. I have the Postgresql in the other server not in the same server where OpenNMS is installed.

When I run this command I am getting the error.

 

./install -dis

==============================================================================

OpenNMS Installer

==============================================================================

 

Configures PostgreSQL tables, users, and other miscellaneous settings.

 

DEBUG: Platform is IPv6 ready: true

- searching for libjicmp.so:

  - trying to load /usr/lib64/libjicmp.so: NO

  - trying to load /usr/lib/oracle/11.2/client64/lib/libjicmp.so: NO

  - trying to load /opt/opennms/lib/libjicmp.so: NO

  - trying to load /opt/opennms/lib/linux64/libjicmp.so: NO

  - trying to load /usr/java/packages/lib/amd64/libjicmp.so: NO

  - trying to load /usr/lib64/libjicmp.so: NO

  - trying to load /lib64/libjicmp.so: NO

  - trying to load /lib/libjicmp.so: NO

  - trying to load /usr/lib/libjicmp.so: Java HotSpot(TM) 64-Bit Server VM warning: You have loaded library /usr/lib/libjicmp.so which might have disabled stack guard. The VM will try to fix the stack guard now.

It's highly recommended that you fix the library with 'execstack -c <libfile>', or link it with '-z noexecstack'.

NO

  - trying to load /usr/lib/jni/libjicmp.so: NO

  - trying to load /usr/lib/libjicmp.so: NO

  - trying to load /usr/local/lib/libjicmp.so: NO

  - trying to load /opt/NMSjicmp/lib/32/libjicmp.so: NO

  - trying to load /opt/NMSjicmp/lib/64/libjicmp.so: NO

  - trying to load /opt/NMSjicmp6/lib/32/libjicmp.so: NO

  - trying to load /opt/NMSjicmp6/lib/64/libjicmp.so: NO

- Failed to load the optional jicmp library.

  - This error is not fatal, since jicmp is only required for optional features.

  - For more information, see http://www.opennms.org/index.php/jicmp

- searching for libjicmp6.so:

  - trying to load /usr/lib64/libjicmp6.so: OK

- searching for libjrrd.so:

  - trying to load /usr/lib64/libjrrd.so: NO

  - trying to load /usr/lib/oracle/11.2/client64/lib/libjrrd.so: NO

  - trying to load /opt/opennms/lib/libjrrd.so: NO

  - trying to load /opt/opennms/lib/linux64/libjrrd.so: NO

  - trying to load /usr/java/packages/lib/amd64/libjrrd.so: NO

  - trying to load /usr/lib64/libjrrd.so: NO

  - trying to load /lib64/libjrrd.so: NO

  - trying to load /lib/libjrrd.so: NO

  - trying to load /usr/lib/libjrrd.so: NO

  - trying to load /usr/lib/jni/libjrrd.so: NO

  - trying to load /usr/lib/libjrrd.so: NO

  - trying to load /usr/local/lib/libjrrd.so: NO

  - trying to load /opt/NMSjicmp/lib/32/libjrrd.so: NO

  - trying to load /opt/NMSjicmp/lib/64/libjrrd.so: NO

 - trying to load /opt/NMSjicmp6/lib/32/libjrrd.so: NO

  - trying to load /opt/NMSjicmp6/lib/64/libjrrd.so: NO

- Failed to load the optional jrrd library.

  - This error is not fatal, since jrrd is only required for optional features.

  - For more information, see http://www.opennms.org/index.php/jrrd

- searching for libjrrd2.so:

  - trying to load /usr/lib64/libjrrd2.so: NO

  - trying to load /usr/lib/oracle/11.2/client64/lib/libjrrd2.so: NO

  - trying to load /opt/opennms/lib/libjrrd2.so: NO

  - trying to load /opt/opennms/lib/linux64/libjrrd2.so: NO

  - trying to load /usr/java/packages/lib/amd64/libjrrd2.so: NO

  - trying to load /usr/lib64/libjrrd2.so: NO

  - trying to load /lib64/libjrrd2.so: NO

  - trying to load /lib/libjrrd2.so: NO

  - trying to load /usr/lib/libjrrd2.so: NO

  - trying to load /usr/lib/jni/libjrrd2.so: NO

  - trying to load /usr/lib/libjrrd2.so: NO

  - trying to load /usr/local/lib/libjrrd2.so: NO

  - trying to load /opt/NMSjicmp/lib/32/libjrrd2.so: NO

  - trying to load /opt/NMSjicmp/lib/64/libjrrd2.so: NO

  - trying to load /opt/NMSjicmp6/lib/32/libjrrd2.so: NO

  - trying to load /opt/NMSjicmp6/lib/64/libjrrd2.so: NO

- Failed to load the optional jrrd2 library.

  - This error is not fatal, since jrrd2 is only required for optional features.

  - For more information, see http://www.opennms.org/index.php/jrrd2

16:37:53.502 [Main] WARN  org.opennms.install.Installer - Could not create file: /opt/opennms/etc/libraries.properties

- using SQL directory... /opt/opennms/etc

- using create.sql... /opt/opennms/etc/create.sql

16:37:53.527 [Main] INFO  org.opennms.core.schema.Migrator - validating database version

* using 'postgres' as the PostgreSQL user for OpenNMS

* using 'opennms' as the PostgreSQL database name for OpenNMS

16:37:53.736 [Main] INFO  org.opennms.core.schema.Migrator - validating database version

16:37:53.759 [Main] INFO  org.opennms.core.schema.Migrator - adding PL/PgSQL support to the database, if necessary

16:37:53.767 [Main] INFO  org.opennms.core.schema.Migrator - PL/PgSQL call handler exists

16:37:53.768 [Main] INFO  org.opennms.core.schema.Migrator - PL/PgSQL language exists

- checking if database "opennms" is unicode... ALREADY UNICODE

- Checking for old import files in /opt/opennms/etc... DONE

java.lang.reflect.InvocationTargetException

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:498)

        at org.opennms.bootstrap.Bootstrap$4.run(Bootstrap.java:464)

        at java.lang.Thread.run(Thread.java:745)

Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1"

  Position: 13

        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2458)

        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2158)

        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:291)

        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:432)

        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:358)

        at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:171)

        at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:160)

        at org.opennms.core.db.install.InstallerDb.databaseSetUser(InstallerDb.java:1647)

        at org.opennms.install.Installer.install(Installer.java:267)

        at org.opennms.install.Installer.main(Installer.java:989)

        ... 6 more

 

From: Ronny Trommer [[hidden email]]
Sent: Tuesday, March 14, 2017 4:36 PM
To: General OpenNMS Discussion [hidden email]
Subject: Re: [opennms-discuss] OpenNMS upgradation issue from 15.0.1 to 19.0.1

 

You need to run the installer to set up the database.  In most

cases, it is enough to run:

 

  /opt/opennms/bin/install -dis

 

Make sure you have backups and then basically the command mentioned in the text :)

 

On 14 Mar 2017, at 10:33, [hidden email] wrote:

 

Hi Team,

 

I am newbie to this OpenNMS tool, I was trying to upgrade the OpenNMS tool from the version 15.0.1 to 19.0.1

Using rpm packages I tried to upgrade the version using the –nodeps because I am using Postgresql 9.3 in other server.

But after upgradation when I tried to start or check the status of OpenNMS I am getting this error mentioned below.

Can you please someone suggest me what should I do to resolve this issue?

 

opennms -v status

/opt/opennms/bin/opennms: OpenNMS not configured.

/opt/opennms/etc/configured does not exist.

 

You need to run the installer to set up the database.  In most

cases, it is enough to run:

 

  /opt/opennms/bin/install -dis

 

For details, see the install guide at:

 

 

 

Regards,

Nithyanandan K

 

 



This message is for the designated recipient only and may contain privileged, proprietary, or otherwise confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the e-mail by you is prohibited. Where allowed by local law, electronic communications with Accenture and its affiliates, including e-mail and instant messaging (including content), may be scanned by our systems for the purposes of information security and assessment of internal compliance with Accenture policy. 
______________________________________________________________________________________

www.accenture.com
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, 
Slashdot.org! http://sdm.link/slashdot_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

 



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot


_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: OpenNMS upgradation issue from 15.0.1 to 19.0.1

David Hustace
In reply to this post by k.nithyanandan

On Mar 14, 2017, at 4:14 AM, [hidden email] wrote:

Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1"
  Position: 13
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2458)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2158)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:291)
        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:432)
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:358)
        at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:171)
        at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:160)
        at org.opennms.core.db.install.InstallerDb.databaseSetUser(InstallerDb.java:1647)
        at org.opennms.install.Installer.install(Installer.java:267)
        at org.opennms.install.Installer.main(Installer.java:989)
        ... 6 more

That’s an interesting error and strange that we’ve not seen it before.  What version of PostgreSQL is running on the other server?

Have you verified that your opennms-datasources.xml file refers to this other server?

If so, could you try creating an empty database and trying it again? (substitute 10.1.1.1 for your other server’s IP)


$ export otherserver=10.1.1.1
$ export dbuser=opennms
$ createdb --host=$otherserver --username=$dbuser opennms_test



opennms-datasources.xml:

  <jdbc-data-source name="opennms"
                    database-name="opennms"
                    class-name="org.postgresql.Driver"
                    url="jdbc:postgresql://10.1.1.1:5432/opennms_test"
                    user-name="opennms"
                    password="opennms" />


$ sudo /opt/opennms/bin/install -dis

If that works, verify that opennms_test DB has the OpenNMS schema.

$ psql --host=$otherserver --username=$dbuser --command="\d" opennms_test


If there is a schema, we’ll need to do a little more digging into your DB.


David Hustace
The OpenNMS Group, Inc.

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: OpenNMS upgradation issue from 15.0.1 to 19.0.1

Roskens, Ronald-2

The installer is trying to change the owner for all the tables in the opennms database to the opennms user. (ALTER TABLE ? OWNER TO ?)

 

Perhaps the admin user doesn't really have permissions to do this work?

 

Ron

 

From: David Hustace [mailto:[hidden email]]
Sent: Tuesday, March 14, 2017 12:11 PM
To: DiscussionList List
Subject: Re: [opennms-discuss] OpenNMS upgradation issue from 15.0.1 to 19.0.1

 



On Mar 14, 2017, at 4:14 AM, [hidden email] wrote:

Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1"
  Position: 13
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2458)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2158)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:291)
        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:432)
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:358)
        at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:171)
        at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:160)
        at org.opennms.core.db.install.InstallerDb.databaseSetUser(InstallerDb.java:1647)
        at org.opennms.install.Installer.install(Installer.java:267)
        at org.opennms.install.Installer.main(Installer.java:989)
        ... 6 more

 

That’s an interesting error and strange that we’ve not seen it before.  What version of PostgreSQL is running on the other server?

 

Have you verified that your opennms-datasources.xml file refers to this other server?

 

If so, could you try creating an empty database and trying it again? (substitute 10.1.1.1 for your other server’s IP)

 

 

$ export otherserver=10.1.1.1

$ export dbuser=opennms

$ createdb --host=$otherserver --username=$dbuser opennms_test

 

 

 

opennms-datasources.xml:

 

  <jdbc-data-source name="opennms"
                    database-name="opennms"
                    class-name="org.postgresql.Driver"
                    url="jdbc:postgresql://10.1.1.1:5432/opennms_test"
                    user-name="opennms"
                    password="opennms" />

 

 

$ sudo /opt/opennms/bin/install -dis

 

If that works, verify that opennms_test DB has the OpenNMS schema.

 

$ psql --host=$otherserver --username=$dbuser --command="\d" opennms_test

 

 

If there is a schema, we’ll need to do a little more digging into your DB.

 

 

David Hustace

The OpenNMS Group, Inc.


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.

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss
Loading...