How to get recoder working with mysql / mariadb with ssl enabled?

[MasterCATZ (Christopher Staples)]

for my external mariadb I have ssl on
/etc/mysql/mariadb.conf.d/50-server.cnf

ssl-ca = /var/lib/mysql/cert/ca.pem
ssl-cert = /var/lib/mysql/cert/server-cert.pem
ssl-key = /var/lib/mysql/cert/server-key.pem
require-secure-transport = on

this stops homeassistant connecting unless its turned off I just get auth errors , even tho every other client accessing connects just fine without any ssl tweaks, even kodi that’s using old legacy password methods

with configuration.yaml I have tried with

db_url: mysql://username:password@mariadb/homeassistant?charset=utf8mb4;ssl=true

and I threw in all the mariadb certs into HAOS /ssl

but still no dice , also if there is any syntax errors its just because I typed them out because copy paste does not work using HA’s terminal and could not be bothered to ssh in

[CM000n (Simon)]

Maybe the same issue as described here:

MySQL through an SSL connection

I sent in feedback for the documentation page for recorder as well, so hopefully it’ll be reviewed and updated but posting this here as well in case it helps anybody else solve my scenario. The documentation suggests that you use the following config line for an SSL protected database: mysql://user:password@SERVER_IP/DB_NAME?charset=utf8mb4;ssl=true However this seemed to constantly fail thinking that “;ssl=true” was part of the charset: Error during connection setup: (MySQLdb.OperationalErr…

Try to change your connection string accordingly.

[MasterCATZ (Christopher Staples)]

Thanks, confirming this was indeed the issue
&ssl=true