Mysql with TLS/SSL

Install/Maintain/Configure
1

Keep getting a The database settings are invalid: Error 1045: Access without SSL denied when trying to set up using mysql with self signed TLS/SSL.

I’ve tried setting SSL_MODE to skip-verify and true per the docs but continue to get this error. It almost seems like this setting is being ignored as I have other applications connecting to the DB via SSL with no issues and even connecting with mysql --ssl -h mariadb.lan -u gitea -p works successfully.

I’ve tested with both the binary and the official docker image on centos7 and get the same thing either way.

Am I missing something or has anyone else managed to configure this successfully?

database portion of app.ini

[database]
DB_TYPE = mysql
HOST    = mariadb.lan:3306
NAME    = gitea
USER    = gitea
PASSWD  = passwd
SSL_MODE = skip-verify
CHARSET = utf8mb4
LOG_SQL = true
2

I have the same problem here. When setting up the database like this it works fine :

SET old_passwords=0;

CREATE USER 'gitea'@'localhost' IDENTIFIED BY 'PASSWORD......';

CREATE DATABASE giteadb CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci';

GRANT ALL PRIVILEGES ON giteadb.* TO 'gitea'@'localhost' with grant option;

FLUSH PRIVILEGES;

EXIT;

but if I require ssl like this :

CREATE USER 'gitea'@'localhost' IDENTIFIED BY 'PASSWORD......' require ssl; I get Error 1045 when installing for the first time.