Nagios Support Forum

Any idea why we're having this Cron Job Failure?


ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
======================================================================
AutoMySQLBackup VER 2.5
http://sourceforge.net/projects/automysqlbackup/
Backup of Database Server - mlwnag20.corp.footlocker.net
======================================================================
Backup Start Time Sun Oct 1 07:00:01 EDT 2017
======================================================================
Backup End Sun Oct 1 07:00:01 EDT 2017
======================================================================
Total disk space used for backup storage..
Size - Location
8.0K /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'@'localhost' (using password: YES)

Is your MySQL local or remote? Are you seeing any problems in XI, or just this backup issue? Are your XI backups workings (if there was actually a problem with MySQL, I'd expect not)?

Can you PM me your Profile? You can download it by going to Admin > System Config > System Profile and click the ***Download Profile*** button towards the top. If for whatever reason you *cannot* download the profile, please put the output of View System Info (5.3.4+, Show Profile if older) in the thread (that will at least get us some info). This will give us access to many of the logs we would otherwise ask for individually. If security is a concern, you can unzip the profile take out what you like, and then zip it up again. We may end up needing something you remove, but we can ask for that specifically.

You can also generate a profile manually using the script at /usr/local/nagiosxi/html/includes/components/profile/getprofile.sh

That should generate a profile in /usr/local/nagiosxi/var/components/ which you can get off the server with an application such as FileZilla.

After you PM the profile, please update this thread. Updating this thread is the only way for it to show back up on our dashboard.

The only issue I am aware of is the backup is not working and yes the mariadb is local (on the same machine) to nagios xi.

Admin > System Config > System Profile and click the ***Download Profile*** button towards the top
PROFILE BUILD FAILED
Array
(
)

It's possible these issues are related. Please see https://support.nagios.com/kb/article.p ... ategory=44

Also, what's the output of sestatus? Please put the output in a code block. The "Code" button is the fifth from the left on the post input screen (between Quote and List).

Lastly, are you able to log in to mysql from the command line. mysql -uroot -pnagiosxi...change the password as necessary.

UPDATE: Profile shared with techs

Here is some information and I'll PM you the profile.

It seems the profile issue is resolved. Did that resolve the mysql backup issue?

I would really anticipate more issues if this were the case, but what's the output of chage nagios -l?

Issue resolved.... backups are working. Thanks for the help.

I'll be closing this thread now, but feel free to open another if you need anything in the future!