Thingworx 6.6 PostgreSQL connection error

[avladescu]

Anyone struggled with "Connections could not be acquired from the underlying database!" error after installing postgreSQL and trying to access Thingworx?

[avladescu]

Changed a bit modelproviderconfig.json and now the error is "Improper value found for model provider configuration password, system cannot start without valid password"

[avladescu · Accepted solution]

Removed "defaultValue": "twadmin" for the password element of the modelproviderconfig.json file which seems to have caused the error above and the access to Thingworx Composer was possible.

Full json file attached to the case http://internal.ptc.com/salesforce/attachments/cases/12/87/18/89/modelproviderconfig.json

[jkrumm]

Can you give me the right modelproviderconfig.json version?

i can not use thingworx backend with postgres at the moment....

2016-01-22 17:57:35.072+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ========================================

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ThingWorx Version Information

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ========================================

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] majorVersion = 6

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] minorVersion = 6

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] revision = 2

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] build = b148

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] schemaVersion = 809

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ========================================

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ========================================

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ThingWorx System Environment Settings

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ========================================

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] OS: Linux

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] OS arch: amd64

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] OS version: 3.10.0-327.4.4.el7.x86_64

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Total Processors: 2

2016-01-22 17:57:35.074+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Default encoding: UTF-8

2016-01-22 17:57:35.074+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] JAVA vendor: Oracle Corporation

2016-01-22 17:57:35.074+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] JAVA version: 1.8.0_60

2016-01-22 17:57:35.074+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] JAVA install location: /usr/java/jdk1.8.0_60/jre

2016-01-22 17:57:35.074+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] JVM Max Memory: 411 (MB)

2016-01-22 17:57:35.074+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ========================================

2016-01-22 17:57:35.074+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] WebApp starting...

2016-01-22 17:57:40.661+0100 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] HA not configured. Initializing in standalone mode.

2016-01-22 17:57:40.661+0100 [L: INFO] [O: c.t.s.ThingWorxPersistenceHandler] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Default Persistence Provider Name = ThingworxPersistenceProvider

2016-01-22 17:57:40.661+0100 [L: INFO] [O: c.t.s.ThingWorxPersistenceHandler] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Default Persistence Provider Package Name = PostgresPersistenceProviderPackage

2016-01-22 17:57:40.682+0100 [L: INFO] [O: c.t.p.p.PostgresDatasource] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Reading configuration from configTableCol

2016-01-22 17:57:40.782+0100 [L: ERROR] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] [message: Improper value found for model provider configuration password, system cannot start without valid password]

2016-01-22 17:57:40.782+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Datastore database...INITIALIZED

[Aanjan]

Jörg, the modelproviderconfig.json provided with the ThinWorx download should work without any changes if you used default values (like twadmin; password etc) throughout. Just make sure it is placed in your root drive under ThingworxPlatform folder.

[qn]

There are 2 places for password, "default value" and when the postgre url is declared. You can try to edit these two.

[spatel-21]

hi,

I'm unable to view your link. It seems to be blocked in my network.

Can you please post the details over here?

- Siddharth