Nagios Support Forum

Hi,

I follow the step to upgrade from NAgios xi 5.11.2 to 2024R1.

```
Done!
INSTALL: Dashlets installed/updated OK.
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
```

I run the upgrade as root and root have access to the DB via my.cnf..

Any advice to finish the upgrade.

Thx!

Hi @bennyboy, thanks for reaching out.

Thank you for reporting your issue. I am sorry you are having issues with the upgrade. Please open a case with our support department at Nagios Answer Hub.

hi,

I have a similar issue, I'm trying upgrade to Nagios xi 5.11.3 to "2024R1 was released on December 6th."

but I have this message. I have database offloading




Done!
INSTALL: Dashlets installed/updated OK.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Hi @hdurans, thanks for reaching out.

Thank you for reporting your issue. I am sorry you are having issues with the upgrade. Our support team requests that you open a case Nagios Answer Hub, so this issue can be expedited.

The issue is that you guys changed the package name so yum update no longer will work... We need a fix for this ASAP!

i also had the same problem. Hopefully this error will be resolved soon
burrito craft

@hrosegripping and @mromans, thank you for reaching out.

Our support department is looking for more information so we can expedite the resolution of these issues. Please open a case with our support department at Nagios Answer Hub.

Having the same issue but don't have acces to the 'Answer hub' (yet). Seems to take a few days.

Is there an answer already to share in this post, so I can proceed with the upgrade?

I found what the problem is. In the upgrade script on line 2588 you see:

mysql -u root --password="$mysqlpass" < nagiosxi/nagiosxi-db/mods/mysql/schema_60000_root.sql

The variable $mysqlpass holds the (default?) password 'nagiosxi'. In our case it was changed to another one, so login to the database fails. Changing the line by setting the right value for the password results in a successful upgrade (in our case).

Where is this variable set and do we have to make a change, or is it a bug in the upgrade script? I would like to prevent the same problem from happening with a future upgrade.

Hi @espaanbroek,

Thank you for posting your findings. I have filed an bug report.

"mysqlpass" is set in /usr/local/nagiosxi/etc/xi-sys.cfg and /usr/local/nagiosxi/var/xi-sys.cfg. Please update both places, to prevent issues like this, in the future.