Unable to set ssl_mode on the dsn for mysql

[lchopfpt]

Describe the bug When adding ?ssl_mode=PREFERRED to a mysql DSN using the docker image, I get: MySQL client library does not support ssl_mode specification

Installation details

• operating system: CentOS 7.9
• query-exporter installation type:
  • docker image: docker

To Reproduce

If possible, please provide detailed steps to reproduce the behavior: MySQL configured with SSL. Local connections work, yet get Access Denied with query_exporter. So attempted to set ssl_mode=PREFERRED

1. Config file content (redacted of secrets if needed) databasenamehere: dsn: mysql://user:pass@<host>/<database>?ssl_mode=PREFERRED

2. Ran query-exporter with the following command line ... docker run -p 9560:9560/tcp -v "/etc/query_exporter.yaml:/config.yaml" --rm -it adonato/query-exporter:latest

3. Got the error when ... When attempting to do connections, see in the log: MySQL client library does not support ssl_mode specification