Backup2l failing

Support
1

I seem to be getting the following when trying to run backup2l -b on my current boockworm build

ERROR 1045 (28000): Access denied for user ‘sympl’@‘localhost’ (using password: YES)
ERROR: == errorcode 1 ==
run-parts: /etc/sympl/backup.d/pre-backup.d//20-sympl-sqldump exited with return code 1
root@windsurf1:~# backup2l -b

2

How much free space is there?
sudo df -h

3

63gb and the backup should take 43 according to backup2l

4

Another bright idea bites the dust!

1 Like
5

Seems to be something to do with permissions on sql but not sure how to correct that

6

My first port of call would be
sudo sympl-filesystem-security
Might help!

7

Thanks tried that but still getting the message below which suggests it is a problem with the login to mysql. I am not sure where it is calling this from to correct.

Running pre-backup procedure…
=> Checking there is enough free space for a backup…

  • Free space on /var/backups/localhost: 61.9 GB
  • Estimated backup size: 42.9 GB

=> There is enough space to take a backup.

ERROR 1045 (28000): Access denied for user ‘sympl’@‘localhost’ (using password: YES)
ERROR: == errorcode 1 ==
run-parts: /etc/sympl/backup.d/pre-backup.d//20-sympl-sqldump exited with return code 1
root@myserver:~# Running pre-backup procedure…
=> Checking there is enough free space for a backup…

  • Free space on /var/backups/localhost: 61.9 GB
  • Estimated backup size: 42.9 GB

=> There is enough space to take a backup.

ERROR 1045 (28000): Access denied for user ‘sympl’@‘localhost’ (using password: YES)
ERROR: == errorcode 1 ==
run-parts: /etc/sympl/backup.d/pre-backup.d//20-sympl-sqldump exited with return code 1

8

You’ve managed to remove, change the password for or delete the Sympl users password in MySQL.

This is the user used by the Sympl CLI as well as things like backups to make SQL dumps.

You can find this in /home/sympl/.my.cnf - if you sudo mysql and log in as root, root, you can then change set the password back again to the info in the config file.

9

Hmm, I can still login to PHPmyadmin with the sympl username and password. I’ve just tried changing that and am still getting the same error. I have also rebooted the machine.

Running pre-backup procedure…
=> Checking there is enough free space for a backup…

  • Free space on /var/backups/localhost: 60.9 GB
  • Estimated backup size: 43.9 GB

=> There is enough space to take a backup.

ERROR 1045 (28000): Access denied for user ‘sympl’@‘localhost’ (using password: YES)
ERROR: == errorcode 1 ==
run-parts: /etc/sympl/backup.d/pre-backup.d//20-sympl-sqldump exited with return code 1