Problems connecting Thingworx & InfluxDB via HTTPS

[benjaminlhind]

Hi everybody!

We have the following setup:

- running Thingworx Instance with MS SQL DB at Version 8.4

- running Influx DB at Version 1.7.8 -> listening on http with port 8086

- Both running on the same machine e.g. hostname: mythingworx.local

- Influx added as successfully as Persistance Provider in Thingworx -> everything fine

What we want:

- Secure connection between Thingworx and InfluxDB with HTTPS

Problem:

- InfluxDB runs fine on HTTPS at Port 8086

- We have corporate generated SSL certifcates 

- We can execute Queries via HTTPS with postman

- We changed the url to Influx in Thingworx to https

- but: Thingworx only says: unable to update persistance provider 

- Thingworx is no longer able to connect to InfluxDB

Logoutput in Application Log:

[message: Import Failed: Unable to update PersistenceProvider: Unable to connect to the PersistenceProvider: InfluxDB]

Unable to process import: Unable to update PersistenceProvider: Unable to connect to the PersistenceProvider: InfluxDB

*** Unable to connect to the PersistenceProvider: InfluxDB ***.

We can't find any helpful logfiles. We also tried to import the complete certificate Trustchain Java /lib/security/cacerts file.

Do somebody of you have an idea for us? We even can't find any documentation about Thingworx and Influx via SSL.

Thanks in advance.

Best,

Benjamin

[tmisner]

Hello Benjamin,

Thank you for reaching out on the ThingWorx Developers Community. I do apologize for the delay in reply on this topic.

We definitely want to take a closer look at the error you see in the ApplicationLog. As you had noted the error itself is not very helpful.

What we can do to get some extra logging is enable log stack tracing in the ErrorLog file. In order to do this navigate to Subsystems > LoggingSubsystem > Configuration and check "Enable Stack Tracing". This will provide us with the full error stacks for a considerable amount of errors that may occur on the Platform. Hopefully the "Unable To Update Persistence Provider" error is expanded upon in these logs and we are provided with further details regarding the connection issue.

Regards,

Tyler Misner

ThingWorx Technical Support  Engineer