Package: Backup Manager Version: 0.7.14 Context : Debian 10.4 mysql Ver 15.1 Distrib 10.3.22-MariaDB Backup Manager 0.7.14
The backup fail with the following error: mysqldump: Got error: 1045: "Access denied for user 'backupmanager'@'localhost' (using password: YES)" when trying to connect When I use mysql/mysqldump with -u and -p options, no issues all is fine The file /root/.backup-manager_my.cnf is present and with the correct permissions / password inside. I have another file /root/.my.cnf containing root user and password and I think this is the source of the issue ! When referring to https://mariadb.com/kb/en/configuring-mariadb-with-option-files/, it seems that the filed passed in the command line with —default-extra-file is overrides with the .my.cnf values if I manually update the commande issued by backup manager using « —default-file » instead of « —default-extra-file », it works sudo /usr/bin/mysqldump --defaults-file=/root/.backup-manager_my.cnf --opt -ubackupmanager -hlocalhost -P3306 mysql > mysql.sql Can you confirm the issue, please ? Any chance to have this fixed soon or I should « patch » https://salsa.debian.org/debian/backup-manager/-/blob/master/lib/backup-methods.sh#L1016 ? Maybe the most flexible way would be to be able to define the name of the parameter to be used (—default-file or —default-extra-file) in the config file. Cheers -sylvain
