Documentation issue with "Offloading MySQL to Remote Server"

[hbouma]

We have offloaded the MySQL to another server using the documentation in "https://assets.nagios.com/downloads/nag ... Server.pdf" and we have found a step missing.

When granting rights to nagios, nagiosxi and nagiosql, you also need to grant rights to root in order for the automysqlbackup script to complete properly. This was completed by running the line: GRANT ALL ON *.* TO root@'FQDN OF NAGIOS XI SERVER';

If we don't add this step, we get the error:

======================================================================
AutoMySQLBackup VER 2.5
http://sourceforge.net/projects/automysqlbackup/

Backup of Database Server - ***.***.***.*** ======================================================================
Backup Start Time Tue Jun 5 07:00:01 EDT 2018 ======================================================================
Backup End Tue Jun 5 07:00:02 EDT 2018
======================================================================
Total disk space used for backup storage..
Size - Location
708K /store/backups/mysql

======================================================================
If you find AutoMySQLBackup valuable please make a donation at
http://sourceforge.net/project/project_ ... _id=101066
======================================================================

###### WARNING ######
Errors reported during AutoMySQLBackup execution.. Backup failed Error log below..
ERROR 1045 (28000): Access denied for user 'root'@'FQDN of Nagios XI server' (using password: YES)

[lmiltchev]

In most cases it is not a good idea to open up root to a remote IP address. This is probably why, we didn't have anything about root grants in the document. You have a point though - it you want to use the "automysqlbackup" script (you don't need to - you could just schedule backups), but you don't make any mods to it (setting username, password, db host, etc.), and you don't grant permissions to root, the backup won't work with the offloaded db.

We will adjust the documentation by adding more detailed instructions about setting up the "automysqlbackup" script.

Thank you!