Unable to connect to MySQL DB that requires SSL

Hello!

I am attempting to connect to a Azure Database for MySQL which requires a secure connection. Looking at the Diesel documentation, an SSL mode and cert can be specified in the connection string. However, given my configuration, I am unable to connect (details below).

Connection string:

DATABASE_URL=mysql://username:password@hostname:3306/dbname?ssl_mode=REQUIRED&ssl_ca=/mounted/path/to/cert/DigiCertGlobalRootG2.crt.pem

Upon starting the App Service, the following error appears:

Error creating database pool: DieselCon.
BadConnection("TLS/SSL error: self-signed certificate in certificate chain",)

I am not sure if I have misinterpreted the requirements of the connection string (their documentation has an asterisk * showing after SSL_MODE?), if the *.crt.pem file is in the right format for this use, or if this is a supported feature.

Any help here would be appreciated!

Try without the ssl_ca

Thanks @BlackDex, I tried this but got a new error.

New connection string:

DATABASE_URL=mysql://username:password@hostname:3306/dbname?ssl_mode=REQUIRED

New error:

BadConnection("Connections using insecure transport are prohibited while --require_secure_transport=ON.",)

Any hints on what else to try would be great.