Error: mariadb-dump: Got error: 2026: "TLS/SSL error: SSL is required, but the server does not support it" when trying to connect

We recently added the ability to force or disable SSL when JetBackup 5 is generating the database auth conf files during a Database Dump. As a security best practice, we recommend keeping SSL enabled for mysqldump however there are MySQL or MariaDB configurations which may not support SSL or otherwise require it to be disabled. 

If you see the error, "Error: mariadb-dump: Got error: 2026: "TLS/SSL error: SSL is required, but the server does not support it" when trying to connect" - this means that SSL is being required during the mysqldump or mariadb-dump however the MySQL server configuration does not support it with options such as "skip-ssl" or "ssl=off" in the [mysql] option group. 

Symptoms:

[27/Aug/2025 22:25:26 +0000] [PID 2951439] - Database "account2_database"
[27/Aug/2025 22:25:26 +0000] [PID 2951439] [DEBUG] Database Dump CMD: mariadb-dump --defaults-file=/usr/local/jetapps/etc/jetbackup5/database_auth_h6749aRZT.cnf --force --opt --skip-lock-tables --default-character-set=utf8mb4 -R -E account2_database | gzip > /jetbackup5/workspace/backup/680218b9a393009b39055e92/account2_6819bffc897756d5040222d4/database/account2_database.sql.gz
[27/Aug/2025 22:25:26 +0000] [PID 2951439] [ERROR] Failed exporting database data. Database Handler Error: Failed export MySQL database “account2_database”. Error: mariadb-dump: Got error: 2026: "TLS/SSL error: SSL is required, but the server does not support it" when trying to connect

Resolution:

Option 1 - Recommended

If possible, we recommend removing any conflicting settings that force SSL to be disabled on the MySQL server level. Please refer to the MySQL or MariaDB documentation with the help of your server administrator. 

Option 2 - Turn off SSL for MariaDB/MySQL dump 

To resolve this issue without adjusting your MySQL or MariaDB Server settings, you will need to edit the client MySQL authentication file corresponding to the control panel you're using and add ssl=off to the file under the [client] group. 

Control Panel MySQL / MariaDB Panel Auth File
cPanel & WHM /root/.my.cnf
DirectAdmin /usr/local/directadmin/conf/my.cnf
Plesk (RHEL) /etc/my.cnf
Plesk (Ubuntu/Debian) /etc/mysql/my.cnf
No Panel  Refer to your MySQL or MariaDB Configuration

 

  • mariadb-dump, mysqldump
  • 0 Kunder som kunne bruge dette svar
Hjalp dette svar dig?

Relaterede artikler

Email Notifications Are Not Being Sent

JetBackup 5 uses Notification Integrations to send Notifications based on the configured...

What are the level of Alerts in JetBackup 5?

JetBackup 5 now has only 3 Alert levels compared to JetBackp 4. All 3 levels will appear on the...

Create Destination Error: This destination path is already owned by other destination

On JetBackup 5, you may notice the following error when creating a destination that uses the same...

Rsync Backing Up Account Fails - Error: overflow

There have been some reports of accounts failing to back up with errors similar to this:[ERROR]...

Common Backup Job Exclude List for DirectAdmin Accounts

Information regarding how to exclude certain files/folders from a backup in JetBackup 5 can be...