[Solved] Data backup failures

[paul_marwick]

@giacomo

@paul_marwick

The only thing I can see that I’ve not set up is a mount point on the local server, but I assume that should be done automatically by the backup routine?

Yes the mount point is automatic.

The log clearly states the error:

Apr 17 01:00:08 barracuda esmith::event[11359]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Apr 17 01:00:08 barracuda esmith::event[11359]: Action: /etc/e-smith/events/pre-backup-data/S50mysql-dump-tables FAILED: 

The mysqld root password has probably been changed.
You can verify it by executing mysql command which should give you direct access to the db.
If you did manual modification, you could try to fix it executing:

expand-template /root/.my.cnf

I saw the password error, but wasn’t sure, since the system seems to be doing the configuration backups successfully. Not to mention that I’ve not touched the mysql password. When I migrated the old system from SME, I carefully copied the Nethserver /root/.my.cnf to the migration directory to avoid password errors when the data was migrated.

Attempting to log into mysql from the command line fails, so something has certainly changed the password. Question now is how I return it to the original as stored in /root/.my.cnf

I found some directions for changing the mysql password here:

Accessing MySQL locally

Thank you giacomo… that was very helpful. Since it was a bit tricky getting MySQL root access I will list the steps I did here for anyone facing the same issue, please correct if I did something that doesn’t make sense, but it worked for me: MYSQL SET root PASSWORD STEPS: Passwords in these files should all match (in clear text): etc/my.pwd /root/.mycnf /var/lib/nethserver/secrets/mysql Use the following steps to reset the MySQL root password and grant ‘%’ access: ref: https://www.dig…

Unfortunately, they don’t work - if I attempt to use systemctl to stop mysql I get nothing at all.

Are there more up-to-date instructions on how to change the mysql password?