Upgrade Failing Primary DB Update

[ssax]

Please post your full upgrade.log. Which version of NNA were you coming from? Going to?

[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

[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

[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.

[CarlWedu]

attached the output of executing the upgrade

[tgriep]

Can you run the following in the NA server and post back the output?

Code: Select all

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

[CarlWedu]

[root@nagiosna nagiosna]# ls -l /usr/local/nagiosna/scripts/
total 0

[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.

[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

[mcapra]

I'm glad you were able to find a solution! Marking this as resolved.