I am trying to upgrade to 2024.R1.1.1 from 2024.R1.0.1 and 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 without the "-n" option.
Skipping updates to MySQL user permissions...
I have checked the file and see a password in there but I have no idea what the correct one is. Also not sure if it matters but I think our DB is a MariaDB. Is there a way to find this password it uses to connect to the SQL DB? We have a two system setup with the DB on another linux box.
Installed version
2024R1.0.1
OS - CentOS Linux 7
Kernel 3.10.0-1160.105.1.e17.x86_64
Thanks
Upgrade to Nagios 2024R1.1.1 fails with SQL root password issue
- jmichaelson
- Posts: 129
- Joined: Wed Aug 23, 2023 1:02 pm
Re: Upgrade to Nagios 2024R1.1.1 fails with SQL root password issue
The root password should be the mysqlpass value in the xi-sys.cfg file. MariaDB is a fork of MySQL and the two are often used interchangeably. For this purpose they're equivalent.
Try using that value to log in to the database both from the mysql client on the XI system and the Database. IF not, you can try following the MySQL/MariaDB Instructions for resetting your root password and then update the mysqlpass value to reflect that password.
Try using that value to log in to the database both from the mysql client on the XI system and the Database. IF not, you can try following the MySQL/MariaDB Instructions for resetting your root password and then update the mysqlpass value to reflect that password.
Please let us know if you have any other questions or concerns.
-Jason
-Jason
Re: Upgrade to Nagios 2024R1.1.1 fails with SQL root password issue
Thanks Jason. I do not see any instructions attached for resetting the password.
Also can you send instructions on how to log in via MYSQL client on the XI systems and the Database?
Also can you send instructions on how to log in via MYSQL client on the XI systems and the Database?
Re: Upgrade to Nagios 2024R1.1.1 fails with SQL root password issue
@Psihawk,
You can reset your root password with How to reset your MySQL or MariaDB root password or Reset MariaDB password
You can reset your root password with How to reset your MySQL or MariaDB root password or Reset MariaDB password
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.
Re: Upgrade to Nagios 2024R1.1.1 fails with SQL root password issue
OK so using the document you gave i am able to login to the MariaDB without issues as shown
Any thoughts on why I still get the SQL password issue when trying to upgrade?You do not have the required permissions to view the files attached to this post.
Re: Upgrade to Nagios 2024R1.1.1 fails with SQL root password issue
What is the error given when trying to upgrade? From another post I saw that you are running a two server setup with your db on a separate server, this may create complications so if we cant figure it out quickly here it may be best to open an Answer Hub ticket.
Re: Upgrade to Nagios 2024R1.1.1 fails with SQL root password issue
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 without the "-n" option.
Skipping updates to MySQL user permissions...
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 without the "-n" option.
Skipping updates to MySQL user permissions...
Re: Upgrade to Nagios 2024R1.1.1 fails with SQL root password issue
Ah have you tried the solutions in this post? I would rewrite it here however danderson and jsimon had a great write up on it already. Let us know if following those instructions fixes your issue.Psihawk wrote: ↑Mon Apr 15, 2024 5:42 pm 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 without the "-n" option.
Skipping updates to MySQL user permissions...
Re: Upgrade to Nagios 2024R1.1.1 fails with SQL root password issue
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?
MySQL dbmaint_nagiosxi password:
Its blank.. Do we know where I set this at? Which file?
Re: Upgrade to Nagios 2024R1.1.1 fails with SQL root password issue
That should be in /usr/local/nagiosxi/etc/xi-sys.cfg