we installed the Mattermost Enterprise Edition and currently face a problem with the configuration of a secure database connection.
We want to use the MySQL-Server within our intranet as database for Mattermost and the database connection has to be encrypted with SSL/TLS. Our current SqlSettings look like this:
"DriverName": "mysql", "DataSource": "database_user:password@tcp(mysql.server:3306)/database_name?charset=utf8&timeout=90s&tls=true"
Do you have an advise how to configure the details for the database connection over SSL/TLS?
We tried the tls=custom url parameter in the DataSource string but couldn’t find a way to set the required TLSConfig object using the config files. With tls=true we get the following error:
Failed to ping db err:tls: either ServerName or InsecureSkipVerify must be specified in the tls.Config
Using the tls=skip-verify option works to establish an connection, but doesn’t meet our security requirements.
We would be grateful for a good hint.