Regression: "mariadb-dump: "TLS/SSL error: SSL is required, but the server does not support it" when trying to connect" after update to 1.9.5

[PyroDevil]

I am using the borgmatic container to backup a mailcow setup, and the update from 1.9.4 to 1.9.5 broke backup of the mariadb database.

It works fine with the 1.9.4 version of the borgmatic docker container, but the identical configuration fails with 1.9.5 with this error:

mariadb-dump: Got error: 2026: "TLS/SSL error: SSL is required, but the server does not support it" when trying to connect
storagebox: Error running actions for repository
Command 'mariadb-dump --default-character-set=utf8mb4 --add-drop-database --user mailcow --databases mailcow --result-file /tmp/borgmatic-e7_6n_70/./borgmatic/mariadb_databases/localhost/mailcow' returned non-zero exit status 2.

MariaDB parts of the borgmatic configuration:

mariadb_databases:
    - name: ${DBNAME}
      username: ${DBUSER}
      password: ${DBPASS}
      options: --default-character-set=utf8mb4

Only the update of the container image to 1.9.5 triggers this, all other containers and configuration stay the same. And I could not find any documentation about what configuration option has changed.

[grantbevis]

A quick google of your error led me to this page and answer grokability/snipe-it#15364 (comment) - add "--skip-ssl" to your flags

[PyroDevil]

I found --skip-ssl as well, but that was only about the mariadb/mysql client and neither mariadb-dump --help nor the reference documentation mentioned that parameter, so I haven't tested this.

However adding --skip-ssl to the options above seems to have fixed this 🤷.

I am a bit surprised that this issue was closed this fast, but if requiring (undocumented) changes to the configuration files between minor release updates is not considered a regression, that is in your decision.

[IsusVonBier]

Adding "--skip-ssl" doesn't solve this issue for me.

[efc-mw]

For me neither, I got then:

(mariadb-dump.exe: Got error: 1045: "Access denied for user 'xxxxx' (using password: YES)" when trying to connect)
Seems SSL is disabled, but login with password is not allowed without SSL ;-(

[lgwapnitsky]

Sorry to reopen this, but I'm now experiencing this on 1.9.14. Adding to options doesn't seem to do anything

ssh://borg@borg/./backup: Error running actions for repository
ssh://borg@borg/./backup: Command '('mysql', '--defaults-extra-file=/dev/fd/4', '--host', 'localhost', '--port', '3306', '--protocol', 'tcp', '--skip-column-names', '--batch', '--execute', 'show schemas')' returned non-zero exit status 1.
/etc/borgmatic/config.yaml: No commands to run for on-error hook