Nagios Support Forum

This occurred right after the latest update we moved to 2024R1.0.1 DBMaintenance hasnt been green since. I looks like we are missing the entries for what is explained here from the other ticket "In MySQL, there should be an additional user named dbmaint_nagiosxi, and the nagiosxi user should no...

Yes the script fails. Also in the file you mentioned there is no section for DBMaint

If there is no password listed under dbmaint_nagiosxi in xi-sys.cfg and you can log into your mysql database, you can either take the existing mysql password for the dbmaint_nagiosxi user and set that in xi-sys.cfg or you can change the dbmaint_nagiosxi user's password to match whatever you put in ...

I am getting an error when I run the following command php /usr/local/nagiosxi/cron/dbmaint.php Error is below. How and where do I add the IDs this would need to complete? Can i just add them to a password file or will they need some kind of rights to the database itself? dnmainterror.png Cron job f...

There is no entry in that file for dbmaint_nagiosxi

Also this is how Nagios shows it

Hi Psihawk , I think you're onto something here. The next place I'd have you look is in /usr/local/nagiosxi/html/config.inc.php . Around line 45, you should see an array-of-arrays that has a dbserver entry. If that entry is blank or localhost, we might have trouble, but if it's that second linux bo...

I see the issue I think.. There is no password for this

MySQL dbmaint_nagiosxi password:

Its blank.. Do we know where I set this at? Which file?

That directory is empty

The certs directory \\etc\openldap\certs has what is in the attachment on here.

Any update to this?

I am getting this error Stored or entered MySQL root password does not work. Make sure the "mysqlpass" value in "/usr/local/nagiosxi/etc/xi-sys.cfg" and "/usr/local/nagiosxi/var/xi-sys.cfg" is up to date and accurate or enter in the up to date password when upgrading wi...