Forum Discussion

cgapmmg's avatar
cgapmmg
Frequent Visitor
1 year ago
Solved

Gateway stopped working - SSL certificate error

Hi, We were using the on-premises data gateway to refresh our dashboards, but in December 2024, it stopped working, and I haven't been able to make it work again. I use an Impala database, as I alw...
Need Help
  • v-sgandrathi's avatar
    v-sgandrathi
    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 Learn

     

    Thankyou for your understanding.

  • cgapmmg's avatar
    cgapmmg
    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!

v-sgandrathi's avatar
v-sgandrathi
Community Support
1 year ago

Hi cgapmmg,

 

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

 

Thanks for using Microsoft Fabric Community Forum.

v-sgandrathi's avatar
v-sgandrathi
Community Support
1 year ago

Hi cgapmmg,

 

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thanks for using Microsoft Fabric Community Forum.

  • v-sgandrathi's avatar
    v-sgandrathi
    Community Support
    1 year ago

    Hi cgapmmg,

     

    As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance.

    If the issue has been resolved, please mark the helpful reply as a "solution" to indicate that the question has been answered and to assist others in the community.

    Thank you for your cooperation. Have a great day.

    • cgapmmg's avatar
      cgapmmg
      Frequent Visitor
      1 year ago

      Sorry for not answering earlier. I still need help with this issue.