Cannot connect to Postgres11 in Thingworx 9
- July 26, 2020
- 3 replies
- 2346 views
Installed Thingworx, db, schema with Postgres11. Configured platform settings and launched Tomcat9.
The composer is not launched and error message in log is seen as
*****************************************************************************************************************************
2020-07-25 23:52:03.459+0530 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [P: ] [T: C3P0PooledConnectionPoolManager[identityToken->1hge0w8ab11ik8j81mfnmrx|32385e84]-HelperThread-#3] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@111aed00 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2020-07-25 23:52:03.459+0530 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] *** CRITICAL ERROR ON STARTUP: Connections could not be acquired from the underlying database!
*****************************************************************************************************************************
From Psql promt , was able to connect to db
*****************************************************************************************************************************
C:\tools\PostgreSQL\11\bin>psql --host=localhost --port=5432 --username=twadmin --password --dbname=thingworx
Password:
psql (11.8)
WARNING: Console code page (437) differs from Windows code page (1252)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for details.
Type "help" for help.
thingworx=>
*****************************************************************************************************************************
Platform settings file attached for reference.
Any inputs on what could be wrong in configuration of thingworx to postgresql.
Regards,
Hari