Connecting to MySQL on Azure with SSL in PHP

Okay. Removed https, now getting the following errors. I tried both Verify SSL on and off. Do I need to supply the SSL CA Certificate?

Well it seems you need to enable SSL and specify CA certificate:

@George I don’t understand. I’m able to connect from MySQL Workbench without any pem files or anything like that.

You’re saying that connecting in Wappler is different?

Hi @George,

Thanks for posting the document.

You don’t need the pem file when using MySQL Workbench.

image

Please confirm you are saying to connect with Wappler, a pem file is required per the instructions.

So, I’ve found an issue that seems to cause this problem.

In the MacOS version of this app in the Flows->Add DB Connection, I’m able to properly connect to Azure with the “Use SSL” on and the Default Profile. I’m also able to create the same DB in DB Manager (using SSL and default profile.

The problem is in windows. On the Flows->Add DB Connection, the old DB setting UI is presented with the SSL cert.

No matter what I use for the SSL CA Cert, I cannot get it to work. But, on Mac, I don’t get that interface. So it works on Mac, not on Windows.

I’m using the latest version on my Windows 10 and MBP. Mac shown below:

What ended up working was to put the CA cert into the root dir of the website and then use the linux absolute path to that file and place that in the SSL CA Certificate field as well as turn on Verify SSL Certificate and that emulated the MySQL “sslmode=requrired” that I was expecting.

See below