Page 2 of 2

Re: Upgrade Failing Primary DB Update

Posted: Thu Jun 23, 2016 2:31 pm
by ssax
Please post your full upgrade.log. Which version of NNA were you coming from? Going to?

Re: Upgrade Failing Primary DB Update

Posted: Thu Jun 23, 2016 2:52 pm
by tgriep
Can you also login to the NA server as root and run the following commands and post the output?

Code: Select all

cat /var/www/html/nagiosna/naversion
ls -l /var/www/html/nagiosna/application/helpers/licensing_helper.php

Re: Upgrade Failing Primary DB Update

Posted: Fri Jun 24, 2016 8:56 am
by CarlWedu
not sure where the upgrade.log is?

we are at 2014r1.9 going to 2.2.1

[root@nagiosna nagiosna]# cat /var/www/html/nagiosna/naversion
VERSION=21

[root@nagiosna nagiosna]# ls -l /var/www/html/nagiosna/application/helpers/licensing_helper.php
-rw-r--r--. 1 root root 133364 Jun 16 2014 /var/www/html/nagiosna/application/helpers/licensing_helper.php

Re: Upgrade Failing Primary DB Update

Posted: Fri Jun 24, 2016 9:20 am
by tgriep
It looks like the upgrade didn't happen as the info you posted shows the older version.
Can you run through the upgrade again and keep an eye on the screen for any errors when the process is running?
There isn't an upgrade.log file when NA is upgraded.

Re: Upgrade Failing Primary DB Update

Posted: Fri Jun 24, 2016 10:41 am
by CarlWedu
attached the output of executing the upgrade

Re: Upgrade Failing Primary DB Update

Posted: Fri Jun 24, 2016 10:56 am
by tgriep
Can you run the following in the NA server and post back the output?

Code: Select all

ls -l /usr/local/nagiosna/scripts/

Re: Upgrade Failing Primary DB Update

Posted: Fri Jun 24, 2016 12:51 pm
by CarlWedu
[root@nagiosna nagiosna]# ls -l /usr/local/nagiosna/scripts/
total 0

Re: Upgrade Failing Primary DB Update

Posted: Fri Jun 24, 2016 1:34 pm
by tgriep
The upgrade script is trying to change some permissions for some files that are not on your system.
To fix this, can you edit the upgrade script and comment out these lines, 110, 111, 113, 114 and run the upgrade.
If it does upgrade, run the following to set the permissions for the new files by running the following.

Code: Select all

chmod 0755 /usr/local/nagiosna/scripts/change_timezone.sh
chmod 0755 /usr/local/nagiosna/scripts/upgrade_to_latest.sh
chown root:nnacmd /usr/local/nagiosna/scripts/change_timezone.sh
chown root:nnacmd /usr/local/nagiosna/scripts/upgrade_to_latest.sh
Let us know how it works for you.

Re: Upgrade Failing Primary DB Update

Posted: Fri Jun 24, 2016 2:52 pm
by CarlWedu
Complete!
The database was migrated successfully.
NagiosNA backend stopped.
NagiosNA backend started...

Nagios Network Analyzer Upgrade Complete!


[root@nagiosna nagiosna]# cat /var/www/html/nagiosna/naversion
VERSION=202



thank you!!

/resolved

Re: Upgrade Failing Primary DB Update

Posted: Mon Jun 27, 2016 9:01 am
by mcapra
I'm glad you were able to find a solution! Marking this as resolved.