This is a question aimed at the SQL gurus in the Nethserver community:
I’m getting alerts telling me of data backup failures. The alerts tell me:
Backup started at 2019-02-21 00:15:02
Event pre-backup-data: FAIL
Backup status: FAIL
so it looks like its not getting as far as backup, its a problem with pre-backup-data
so I looked in /var/log/messages and I see this:
Feb 17 15:30:09 bastion esmith::event: Action: /etc/e-smith/events/pre-backup-data/S20nethserver-backup-config-predatabackup SUCCESS [6.842668]
Feb 17 15:30:27 bastion esmith::event: Requested path not found
Feb 17 15:30:27 bastion esmith::event: Action: /etc/e-smith/events/pre-backup-data/S20nethserver-restore-data-duc-index SUCCESS [18.072748]
Feb 17 15:30:27 bastion esmith::event: ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)
Feb 17 15:30:27 bastion esmith::event: Action: /etc/e-smith/events/pre-backup-data/S50mysql-dump-tables FAILED: 1 [0.295991]
So it fails when root tries to login, so my guess is that there is something wrong with root@localhost’s access to SQL.
If this was a vanilla installation, I’d have some options to reset passwords, etc, according to Google, but this is a bit of a mixed install…I’m running Nethserver for many
functions, but the same platform is running phpBB3, using the MariaDB (SQL) that came with Nethserver, so I’m being careful 'cos I know nothing about SQL!
Has anyone any suggestions? I’d like to understand what I have to do so that I don’t blow up the phpBB3 unwittingly, and I emphasize the “understand” bit in case this happens again and I can fix it myself