cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Thingworx 6.6 Postgresql not starting

Highlighted
Newbie

Thingworx 6.6 Postgresql not starting

I've followed the instruction how to setup Thingworx 6.6 Postgresql on Ubuntu 14.04. In modelproviderconfig.json

"username": {  "baseType": "STRING",  "description": "",  "name": "username",

                  "aspects": {

                     "friendlyName": "Username",

                     "defaultValue": "twadmin"

                  },  "ordinal": 1 },

               "password": {

                  "baseType": "PASSWORD",      "description": "",      "name": "password",

                  "aspects": {

                     "friendlyName": "Password",

                     "defaultValue": "xxxx"

                  },

When I use command  "psql -U twadmin -d thingworx" and type the password "xxxx" then I can login, but Thingworx platform is not starting ... see the following exception

05-Jan-2016 17:14:44.925 SEVERE [http-nio-8080-exec-29] org.apache.catalina.loader.WebappClassLoaderBase.checkThreadLocalMapForLeaks The web application [Thingworx] created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@dc6eaa]) and a value of type [java.util.Stack] (value [[SuperUser:User]]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.

java.lang.IllegalArgumentException: Improper value found for model provider configuration password, system cannot start without valid password

        at com.thingworx.persistence.postgres.PostgresDatasource.verifyLegalPasswordValue(PostgresDatasource.java:240)

        at com.thingworx.persistence.postgres.PostgresDatasource.createDataSource(PostgresDatasource.java:115)

        at com.thingworx.persistence.postgres.PostgresDatasource.connect(PostgresDatasource.java:72)

        at com.thingworx.system.ThingWorxPersistenceHandler.initializePersistenceProvider(ThingWorxPersistenceHandler.java:158)

        at com.thingworx.system.ThingWorxServer.loadModel(ThingWorxServer.java:305)

        at com.thingworx.system.ThingWorxServer.doHA(ThingWorxServer.java:135)

        at com.thingworx.system.ThingWorxBootstrapper.contextInitialized(ThingWorxBootstrapper.java:127)

2 REPLIES 2
Highlighted

Re: Thingworx 6.6 Postgresql not starting

For me it looks as you edited the wrong section of the modelproviderconfig.json file.

There should be some “rows” object where you actually add the right values. The snipped you send is the property definition of username and password properties.​

Highlighted

Re: Thingworx 6.6 Postgresql not starting

There's another place where you provide username and password:

"rows": [

            {

              "jdbcUrl": "jdbc:postgresql://localhost:5432/<database>?currentSchema=<schema>",

              "username": "<usename>",

              "password": "<password>",

Did you check that ?

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum!