Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X
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
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