#41 Can't configure. It shows SSL errors.

[Saju A P]

WARNING

Errors reported during AutoMySQLBackup execution.. Backup failed
Error log below..
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2026 (HY000): SSL connection error: SSL is required but the server doesn't support it
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: Got error: 2026: SSL connection error: SSL is required but the server doesn't support it when trying to connect
mysqlshow: [Warning] Using a password on the command line interface can be insecure.
mysqlshow: SSL connection error: SSL is required but the server doesn't support it
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: Got error: 2026: SSL connection error: SSL is required but the server doesn't support it when trying to connect

[Thomas]

Got the same Error. Does anyone have a solution yet?

[Thomas]

Change config file: /etc/automysqlbackup/automysqlbackup.conf

Use ssl encryption with mysqldump?
CONFIG_mysql_dump_usessl='no'

**

[Paul]

also gives warning:

WARNING: --ssl is deprecated and will be removed in a future version. Use --ssl-mode instead

[Mike Bobbitt]

Update as follows:

[[ "${CONFIG_mysql_dump_usessl}" = "yes" ]]                 && {
      opt=( "${opt[@]}" '--ssl-mode=REQUIRED' )
      mysql_opt=( "${mysql_opt[@]}" '--ssl-mode=REQUIRED' )
      opt_fullschema=( "${opt_fullschema[@]}" '--ssl-mode=REQUIRED' )
      opt_dbstatus=( "${opt_dbstatus[@]}" '--ssl-mode=REQUIRED' )
}

[Orakler]

Soluce from Mike Bobbitt works, the code must be added to the automysqlbackup script in my case in /usr/local/bin/automysqlbackup
Thanks for the solution Mike :-)