| SYSTEM INFORMATION | |
|---|---|
| OS type and version | AlmaLinux 9.7 |
| Virtualmin version | 8.1.0 Professional |
| Webmin version | 2.641 |
| MySQL version | 8.0.32 |
Issue:
When my scheduled backups run, they are consistently failing. The output from Virtualmin → Backup and Restore → Backup Logs shows the following error:
Dumping MySQL database testdbdev01 ..
.. dump failed : mysqldump: [ERROR] unknown option '--ssl'.
The MySQL user I have is using caching_sha2_password. The “/etc/webmin/mysql/config” has the following set:
ssl=1
ssl_ca=/var/spool/mysql/data_virtualmin/ca.pem
Another related issue is in: Webmin → Servers → MySQL Database Server
This only shows the following message:
The MySQL client program /usr/local/mysql_virtualmin/bin/mysql does not accept passwords passed using the MYSQL_PWD environment variable. To ensure that Webmin is able to fully communicate with MySQL, this option should be turned off on the module configuration page. Alternately, you can remove any password set in the root user’s .my.cnf file.
To bypass both of these issues, I updated this line in /usr/libexec/webmin/mysql/mysql-lib.pl:
($ssl ? " --ssl" : “”).
with
($ssl ? " --ssl-mode=REQUIRED" : “”).
Is this already a known issue and if so, are there any plans to provide a fix for this or is there something else I should be doing to have this working properly?