Good Morning Folk,
I am trying to configure an instance of OSTicket in Azure App Service by using external Azure MySQL. I set up the DB to be accessed via SSL so I have downloaded my certificate (.PEM) and installed locally to connect a WorkBench client which work perfectly. Now I am tring to modifie the ost-config file by uncommenting the line:

-> define('DBSSLCERT','/ssl_my_cert/my_cert.crt');

The path is on my host and the certificate has bin converted from PEM to CRT via openssl:
-> openssl x509 -outform der -in .\my_pem_cert.crt.pem -out .\my_crt_cert.crt

Unfortunately once I continue with the setup I got the following error:
"Database connection information Unable to connect to MySQL server: SSL connection is required. Please specify SSL options and retry."

Do you have any clue or where am I wrong???

thank yoU!


  • Did you find the solution because I have exactly the same issue

    Thanks
    THierry

I've never tried to set up ssl to an Azure SQL instance before, so I'm not sure that I will be much assistance. If you can get any errors that PHP is logging it might help. Or from the Azure server error logs.

So I gave up to configure the SSL but I setup as best practice suggested in Azure the white list of the IPs delivered by MS during the deploy of the App Service 🙂

2 years later
a year later

thierry_verreyt I disabled the SSL. Currently I am migrating to 1.17 and FLexible server...let see...with OS ticket is a new journey every migration...

    Write a Reply...