Forum Discussion
Gateway stopped working - SSL certificate error
- 1 year ago
Hello cgapmmg,
If you still face the issue then please consider raising a support ticket for further assistance.This will allow the engineering team to investigate the issue in detail and provide a resolution or guidance.
To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft LearnThankyou for your understanding.
- 1 year ago
I solved it by adding the parameter AllowSelfSignedServerCert = 1 to the microsoft.impalaodbc.ini file, and that fixed the issue.
I was getting the error:
ODBC: ERROR [HY000] [Microsoft][DriverSupport] (1100) SSL certificate verification failed because the certificate is missing or incorrect
This happened after a server update, which now uses a self-signed certificate. I found that unless AllowSelfSignedServerCert is explicitly set to 1 in the microsoft.impalaodbc.ini file, the Microsoft Impala ODBC driver assumes a default value of 0, which causes the SSL certificate verification to fail.Now my gateway is running fine.
Thanks to everyone who tried to help!
I solved it by adding the parameter AllowSelfSignedServerCert = 1 to the microsoft.impalaodbc.ini file, and that fixed the issue.
I was getting the error:
ODBC: ERROR [HY000] [Microsoft][DriverSupport] (1100) SSL certificate verification failed because the certificate is missing or incorrect
This happened after a server update, which now uses a self-signed certificate. I found that unless AllowSelfSignedServerCert is explicitly set to 1 in the microsoft.impalaodbc.ini file, the Microsoft Impala ODBC driver assumes a default value of 0, which causes the SSL certificate verification to fail.
Now my gateway is running fine.
Thanks to everyone who tried to help!