Azure MySQL flexible server integration with ApacheDevlake helm chart

[nishasati6oct]

I am using sops secret for the below values

MYSQL_USER MYSQL_PASSWORD MYSQL_DATABASE DB_URL

and in the helm chart using the below section for mysql mysql:

if use external mysql server, please set true

  # by default using false, chart will create a single mysql instance
  useExternal: true
  # the external mysql server address
  externalServer: xxxxxx.mysql.database.azure.com/ (we are using MySQL 8.0)
  # external mysql port
  externalPort: 3306

Error:
panic: Error 3159 (HY000): Connections using insecure transport are prohibited while --require_secure_transport=ON. Wraps: (2) Error 3159 (HY000): Connections using insecure transport are prohibited while --require_secure_transport=ON. Error types: (1) hintdetail.withDetail (2) mysql.MySQLError

How can I mount the secret for DigiCertGlobalRootCA.crt.pem certificate path to be used in the DevLake Helm chart???

[dosubot[bot]]

Hey @nishasati6oct! I'm here to help you with any bugs or questions you have while waiting for a human maintainer. Let's tackle this issue together!

You can specify the path to the DigiCertGlobalRootCA.crt.pem certificate in the lake.dotenv parameter of the DevLake Helm chart. This parameter allows you to inject initial configurations into the lake's .env file.

Here is an example of how you can set this parameter during the Helm installation:

helm install devlake devlake/devlake --set lake.dotenv="SSL_CERT_FILE=/path/to/DigiCertGlobalRootCA.crt.pem"

This command sets the SSL_CERT_FILE environment variable to the path of your certificate file ^[1].

To continue talking to Dosu, mention @dosu.