Cannot start thingworx 7.4; error with JDBC connection

[nsridhar-2]

Hello,

I have installed thingworx 7.4 (fresh installation) but its not UP and running. Below are the details of my environment,

Server : Windows Server 2012 R2 (VM)

thingworx 7.4

PostgreSQL 9.4.12

Apache Tomcat/8.0.38

Java 1.8 92 b14

Once installed and start the thingworx from Internet Explorer, it does not ask for any Log in, there is a blank page shown without any errors. Below is the screenshot.

The application log file from thingworxstorage

2017-05-26 11:43:58.019+0530 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-10] Could not handle request

2017-05-26 11:44:05.285+0530 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-11] Could not handle request

2017-05-26 11:44:06.082+0530 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-12] Could not handle request

2017-05-26 11:44:06.301+0530 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-13] Could not handle request

2017-05-26 11:44:06.488+0530 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-14] Could not handle request

2017-05-26 11:44:06.660+0530 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-15] Could not handle request

2017-05-26 11:44:06.848+0530 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-16] Could not handle request

2017-05-26 11:44:07.035+0530 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-7] Could not handle request

2017-05-26 11:44:07.207+0530 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-8] Could not handle request

2017-05-26 11:44:07.395+0530 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-9] Could not handle request

2017-05-26 11:44:07.551+0530 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-10] Could not handle request

2017-05-26 11:44:07.738+0530 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-11] Could not handle request

2017-05-26 11:52:36.581+0530 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-14] Could not handle request

Same application log file from yesterday is as below,

2017-05-25 20:06:35.100+0530 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] [message: Unable to initialize and start system: Connections could not be acquired from the underlying database!]

The entries from PostgreSQL log is as below.

2017-05-25 19:43:24 IST LOG:  database system was shut down at 2017-05-25 19:43:22 IST

2017-05-25 19:43:24 IST LOG:  MultiXact member wraparound protections are now enabled

2017-05-25 19:43:24 IST LOG:  database system is ready to accept connections

2017-05-25 19:43:24 IST LOG:  autovacuum launcher started

2017-05-25 19:48:53 IST FATAL:  password authentication failed for user "twadmin"

2017-05-25 19:48:53 IST DETAIL:  Connection matched pg_hba.conf line 80: "host    all             all             127.0.0.1/32            md5"

2017-05-25 19:48:53 IST FATAL:  password authentication failed for user "twadmin"

2017-05-25 19:48:53 IST DETAIL:  Connection matched pg_hba.conf line 80: "host    all             all             127.0.0.1/32            md5"

2017-05-25 19:48:53 IST FATAL:  password authentication failed for user "twadmin"

2017-05-25 19:48:53 IST DETAIL:  Connection matched pg_hba.conf line 80: "host    all             all             127.0.0.1/32            md5"

2017-05-25 19:48:53 IST FATAL:  password authentication failed for user "twadmin"

2017-05-25 19:48:53 IST DETAIL:  Connection matched pg_hba.conf line 80: "host    all             all             127.0.0.1/32            md5"

Below is the screenshot of the PostgreSQL,

All the thingworxstorage, thingworzbackstorage, thingworxplatform are all places directly under E:/ and it is shared with the all the users.

Any help is greatly appreciated.

Regards

Naveen

[AnnaAn]

Hi Naveen,

Could you share your platform-settings.json?

Does your PostgreSQL installed on same server to ThingWorx?

Br,

Anna

[rupadhyay-2]

Please check your password for db in platform-setting.json .

very clear in logs :

password authentication failed for user "twadmin"

[pagrawal-2]

Hi Anna An,

I am facing also same problem with MSSQL........

"https://community.thingworx.com/thread/41733?q=Thingworx%207.4"

Please once this page for my query.....

Thanks

[nsridhar-2]

Yes I have PostgreSQL installed on the same server.

Below is the content of the json file.

{

"PersistenceProviderPackageConfigs": {

  "PostgresPersistenceProviderPackage": {

   "ConnectionInformation": {

    "jdbcUrl": "jdbc:postgresql://localhost:5432/thingworx",

    "password": "twadmin",

    "username": "twadmin"

   }

  }

}

}

[rupadhyay-2]

Please check your password for db in platform-setting.json .

password authentication failed for user "twadmin"

[nsridhar-2]

Hi Ravi, password is the same. I have posted the contents for json file above. I just cant find any difference in the username and password.

Should we not keep the username and password same?

Regards

Naveen

[hzhaodong]

I also hava this error :

My platform-setting.json  is 

{

"PersistenceProviderPackageConfigs": {

"PostgresPersistenceProviderPackage": {

"ConnectionInformation": {

"driverClass": "org.postgresql.Driver",

"jdbcUrl": "jdbc:postgresql://localhost:5432/thingworx",

"password": "password",

"username": "twadmin"

}

}

}

}

error code :

java.lang.Exception: Unable to initialize and start system: Connections could not be acquired from the underlying database!

[supandey]

Hi Huang, is this a fresh installation of ThingWorx or was this working previously? Are you able to connect to ThingWorx database running on PostgreSQL via tool like PgAdmin III tool?

[hzhaodong]

yes I can connect to ThingWorx database running on PgAdmin tool.

[cmorfin]

Huang ZhaoDong

Can you check that the username and password you use to connect to postgres through pgAdmin are the same as in the paltform-setting.json, that is username twadmin, password: password ... if not please update the platform-settings.json

Kind regards

Christophe

[hzhaodong]

I check username and password is OK , but tomcat error JDBC connection.

[rsutherland]

I had this same problem.  Everything was setup correctly and the platform-settings.json file was perfect but I still got the message:  password authentication failed for user "twadmin".  The problem is it is not seeing the platform-settings.json file.  I set the THINGWORX_PLATFORM_SETTINGS environment variable to the correct folder, restarted Tomcat, and all worked correctly.   Errors were gone and I got the logon prompt.

I add this tidbit because no one else had mentioned it yet.

Good luck.  Robert.