Page 2 of 2

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

Posted: Wed May 08, 2024 12:27 pm
by Psihawk
There is no entry in that file for dbmaint_nagiosxi

Also this is how Nagios shows it
DBMaint.png

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

Posted: Fri May 10, 2024 9:15 am
by KarenJ
I'm having the same issue. Following.

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

Posted: Fri May 10, 2024 11:26 am
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.

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

Posted: Fri May 10, 2024 11:49 am
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?