Licensing Expired Prematurely

[kporta]

I have a valid license and getting the following error during upgrade

Checking required prereqs...
Please wait...

[Upgrade Cancelled]

An upgrade is not possible because your maintenance for this license has expired.
Visit https://go.nagios.com/nagiosxi to renew your license and re-instate upgrade benefits

Have also tried upgrading from the UI. Admin--> check for updates and never returns.

License information shows:
Maintenance Status: Current (Expires in 80 days on 2021-01-10) - Renew Now

I have checked to insure the server time is set proper
I have checked to insure I can ping google.com

Thanks,
Kurt

[cdienger]

Please send me the last 6 characters of your license in a private message.

Please also run the upgrade script like this and provide the output:

Code: Select all

bash -x upgrade.sh

[kporta]

*** My Database Engine and Monitoring Engine are both Down ***

Currently, my UI is now displaying the following message

SQL Error [nagiosxi] : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE user_id = 1' at line 3

[kporta]

Additional information

Not able to log into the UI now - Invalid username/Password

Looking into another post, have done the following to troubleshoot further, executing this command while attempting login

tail -Fn0 /var/log/httpd/error_log /var/log/httpd/ssl_error_log /usr/local/nagiosxi/var/cmdsubsys.log /usr/local/nagiosxi/var/eventman.log
==> /var/log/httpd/ssl_error_log <==
[Mon Oct 26 13:50:00.677629 2020] [:error] [pid 19187] [client 50.17.179.54:55193] PHP Notice: Undefined index: cmp_favorites in /usr/local/nagiosxi/html/includes/components/favorites/favorites.inc.php on line 75

==> /usr/local/nagiosxi/var/cmdsubsys.log <==
..
==> /var/log/httpd/ssl_error_log <==
[Mon Oct 26 13:50:02.953938 2020] [:error] [pid 19165] [client 50.17.179.54:55194] PHP Notice: Undefined index: cmp_favorites in /usr/local/nagiosxi/html/includes/components/favorites/favorites.inc.php on line 75, referer: https://nagios.blazenthosting.com/nagiosxi/login.php

==> /usr/local/nagiosxi/var/cmdsubsys.log <==

[cdienger]

What does the disk usage look like if you run "df -h"?

Please PM me a profile. The profile can be generated under Admin > System Config > System Profile > Download Profile, or from the command line with:

Code: Select all

/usr/local/nagiosxi/scripts/components/getprofile.sh 60514

The profile is then saved to /usr/local/nagiosxi/var/components/profile.zip

[kporta]

Drive space looks to be fine

[kporta@nagios ~]$ df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 3.8G 0 3.8G 0% /dev
tmpfs 3.8G 60K 3.8G 1% /dev/shm
tmpfs 3.8G 17M 3.8G 1% /run
tmpfs 3.8G 0 3.8G 0% /sys/fs/cgroup
/dev/nvme0n1p1 99G 12G 88G 12% /
tmpfs 772M 0 772M 0% /run/user/1002
tmpfs 772M 0 772M 0% /run/user/1004

[cdienger]

I've attached a sql file here that will update the database schema. It looks like this didn't get executed for some reason. Run it with:

Code: Select all

mysql -uroot -pnagiosxi -Dnagiosxi < schema_5700.sql

Please provide a fresh profile if problems continue as well as a copy of the nagiosxi database which can be gathered with:

Code: Select all

mysqldump -uroot -pnagiosxi nagiosxi > nagiosxi.sql

[kporta]

Thank you - that has solved the issue and I was able to update to the latest release.

[benjaminsmith]

Thank you - that has solved the issue and I was able to update to the latest release.

Excellent. Thanks for the update.

We'll close this thread, but feel free to open another if you have any new questions.