DB Connection Failed SQLSTATE[HY000] [2002]

Question

Hello All,

We have azure web app with Linux OS, php 7.4 stack, publish mode is code and we are using default domain over the same. We are trying to connect the same with MYsql flexible server (Business Critical, E2ads_v5, 2 vCores, 16 GiB RAM, 100 GiB storage). We have specify necessary coonection setup over web app environment variable like ssl config & DB connection string. Once we are trying to connect the same we are getting below error.

Error:- DB Connection Failed SQLSTATE[HY000] [2002]

Web App:- In tenant A

Database:- In tenant B

Mode of connectivity:- Vnet Peering & Express route

Connectivity working fine and checked with telnet(kudo console) over port 3306 & tcpping

Looking for urgent support at your end.

Answer 1

Hi Saurabh,

I had a similar error with my website and moving to a new flexible server from a single server. We had a configuration file that was pointing to a certificate which works with the old single server. In the azure portal for the flexible server is a section to download the latest root cert. Once I did this and repointed it in my web app, it was able to connect without issue.

Videsh