Upgrade to Nagios 2024R1.1.1 fails with SQL root password issue

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Post Reply
Psihawk
Posts: 31
Joined: Wed May 13, 2020 9:29 pm

Re: Upgrade to Nagios 2024R1.1.1 fails with SQL root password issue

Post by Psihawk »

There is no entry in that file for dbmaint_nagiosxi

Also this is how Nagios shows it
DBMaint.png
You do not have the required permissions to view the files attached to this post.
Top
KarenJ
Posts: 5
Joined: Thu Jul 26, 2018 12:36 pm

Re: Upgrade to Nagios 2024R1.1.1 fails with SQL root password issue

Post by KarenJ »

I'm having the same issue. Following.
Top
bbahn
Posts: 129
Joined: Thu Jan 12, 2023 5:42 pm

Re: Upgrade to Nagios 2024R1.1.1 fails with SQL root password issue

Post by bbahn »

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 xi-sys.cfg.
April: Actively advancing awesome answers with ardent alliteration, aptly addressing all ambiguities. Amplify your acumen and avail our amicable assistance. Eagerly awaiting your astute assessments of our advice.
Top
Psihawk
Posts: 31
Joined: Wed May 13, 2020 9:29 pm

Re: Upgrade to Nagios 2024R1.1.1 fails with SQL root password issue

Post by Psihawk »

bbahn wrote: ↑Fri May 10, 2024 11:26 am 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 xi-sys.cfg.
How do we get that if we can login to the mysql box? Is there a command we can use to extract or find it?
Top
Post Reply

Return to “Nagios XI”