Nagios WebUI Update not working

[skostmayer]

I removed all of the log files from that directory and restarted Apache with the command provided.

Updates still shows the same page as my original post.

[dwhitfield]

What's the output of ll /var/cache/apache?

Can you PM me your Profile?
It probably won't turn up anything useful, but at this point we might as well take a look. You can download the profile by going to Admin > System Config > System Profile and click the ***Download Profile*** button towards the top. If for whatever reason you *cannot* download the profile, please put the output of View System Info (5.3.4+, Show Profile if older) in the thread (that will at least get us some info). This will give us access to many of the logs we would otherwise ask for individually. If security is a concern, you can unzip the profile take out what you like, and then zip it up again. We may end up needing something you remove, but we can ask for that specifically.

After you PM the profile, please update this thread. Updating this thread is the only way for it to show back up on our dashboard.

UPDATE: Profile received and shared with techs.

[skostmayer]

Thank you for the continued assistance. I have uploaded the profile as requested.

As far as the output of the ll command, it did not work. There is no folder under /var/cache called apache.

only the following:

total 28
drwxr-xr-x 2 root root 4096 Jun 14 2016 fontconfig
drwx------. 2 root root 4096 May 1 07:17 ldconfig
drwxr-xr-x 14 root root 4096 Jul 6 2016 man
drwx------ 2 apache apache 4096 May 11 2016 mod_proxy
drwx------ 2 apache root 4096 May 11 2016 mod_ssl
drwxr-xr-x 2 root root 4096 May 10 2016 php-pear
drwxr-xr-x. 3 root root 4096 May 11 2016 yum

[ssax]

Please send the output of these commands:

Code: Select all

echo "select * from xi_commands \G;" | mysql -uroot -pnagiosxi nagiosxi

Code: Select all

echo "select * from xi_options where keyname = 'last_update_status' OR keyname = 'last_update_message';" | mysql -uroot -pnagiosxi nagiosxi

Thank you

[skostmayer]

This is the first output:

Code: Select all

*************************** 1. row ***************************
        command_id: 603
          group_id: 0
      submitter_id: 1
    beneficiary_id: 0
           command: 1100
   submission_time: 2017-08-02 08:21:01
        event_time: 2017-08-02 08:21:00
    frequency_type: 0
   frequency_units: 0
frequency_interval: 0
   processing_time: 2017-08-02 08:21:01
       status_code: 2
       result_code: 0
      command_data:
            result:

The second output gave an error:

Code: Select all

ERROR 1054 (42S22) at line 1: Unknown column 'keyname' in 'where clause'

[ssax]

Sorry, try this one:

Code: Select all

echo "select * from xi_options where name = 'last_update_status' OR name = 'last_update_message';" | mysql -uroot -pnagiosxi nagiosxi

Thank you

[skostmayer]

Code: Select all

option_id       name    value
38      last_update_message     <strong>The update was completed successfully!</strong>
37      last_update_status      complete

[tgriep]

Those options look correct, lets reset the SQL option that says that the server checked for the update and see if this fixes the issue.
Run this as root.

Code: Select all

echo 'UPDATE xi_options SET value=1 WHERE name="last_update_check_succeeded";' |mysql -u root -pnagiosxi nagiosxi

Then restart Apache bu running

Code: Select all

service httpd restart

Log out of the GUI and then log back in and see if the status is correct.

[IMTECH]

It seems that I ran into the same issue on a quite fresh and empty installation.

I tried to upgrade from 5.4.7 to 5.4.8 through the website and it endet up stuck at " Update in progress. Please wait. Update may take a few minutes.".
In the meantime I was able to upgrade successfully from the command line - but update website is still stuck in progress.



When I tried the command you provided before (echo "select * from xi_options where name = 'last_update_status' OR name = 'last_update_message';" | mysql -uroot -pnagiosxi nagiosxi) - it shows that there is no entry with these two names so the next command you gave (echo 'UPDATE xi_options SET value=1 WHERE name="last_update_check_succeeded";' |mysql -u root -pnagiosxi nagiosxi) cant do anything.

Should I try to add this entry to xi_options?

Kind regards,
Gerhard

[tgriep]

Can you post the upgrade.log file so we can check it for any errors?

Code: Select all

/usr/local/nagiosxi/tmp/upgrade.log

Can you run the following commands as root and post the output?

Code: Select all

echo 'select * from  xi_options  WHERE name="last_update_check_succeeded";' |mysql -t -u root -pnagiosxi nagiosxi
echo 'desc  xi_options;' |mysql -t -u root -pnagiosxi nagiosxi