The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
Reconfigure Connections to Databases on the new AI Hub 9.7
Hello,
I recently upgraded RM Server to AI hub on 9.7. This implementation was done in Docker on a Windows Server 2019 environment.
I just realized that the current connections on the Server instance are not working anymore. In Studio everything has been tested successfully.
On AI Hub I get the following message:
The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "java.security.cert.CertificateException: Certificates do not conform to algorithm constraints". ClientConnectionId:78adaf2a-004a-40d8-b39e-bd04c119f578
We don't have SSL enabled on the AI Hub. This hasen't been an issue since the latest upgrade. I guess KeyCloak might have something to do with it!?
Thanks for your help. We depend on this for a couple of WebApps we have deployed.
I recently upgraded RM Server to AI hub on 9.7. This implementation was done in Docker on a Windows Server 2019 environment.
I just realized that the current connections on the Server instance are not working anymore. In Studio everything has been tested successfully.
On AI Hub I get the following message:
The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "java.security.cert.CertificateException: Certificates do not conform to algorithm constraints". ClientConnectionId:78adaf2a-004a-40d8-b39e-bd04c119f578
We don't have SSL enabled on the AI Hub. This hasen't been an issue since the latest upgrade. I guess KeyCloak might have something to do with it!?
Thanks for your help. We depend on this for a couple of WebApps we have deployed.
Tagged:
0
Best Answers
-
aschaferdiek
Employee-RapidMiner, Member Posts: 76 
RM Engineering
Hi. Is this a connection item within the repository or a project or is it the main connection to the DB of Server/AI Hub? Does changing the JDBC URL help by adding the following?jdbc:...../dbName;encrypt=false;trustServerCertificate=true
5 -
Biersepp
Member Posts: 14 
Contributor II
@aschaferdiek
Hi thank you for your answer. This helped a lot.
On a side note, I also had to additionally change the driver to Microsoft SQL Server to jdbc:jdts. But without the URL changes it would not have worked.
Thanks again!
0
Answers