NAGIOSQL LOGIN FAILED - NAGIOSXI upgrade to 5.2

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
ssa_nagios
Posts: 38
Joined: Fri Jun 13, 2014 12:52 pm

NAGIOSQL LOGIN FAILED - NAGIOSXI upgrade to 5.2

Post by ssa_nagios »

I'm having problems getting nagiosxi up and running again after attempt to upgrade to 5.2. Getting the following error

/usr/bin/wget --save-cookies nagiosql.cookies --keep-session-cookies http://localhost/nagiosxi/includes/components/ccm/ --no-check-certificate --post-data 'submit=Login&hidelog=true&loginSubmitted=true&username=XXXXXXXXX&password=XXXXXXXXX' -O nagiosql.login--2015-10-12 09:14:40-- http://localhost/nagiosxi/includes/components/ccm/
Resolving localhost... 127.0.0.1, ::1
Connecting to localhost|127.0.0.1|:80... connected.
HTTP request sent, awaiting response... 500 Internal Server Error
2015-10-12 09:14:40 ERROR 500: Internal Server Error.

I'm using the Nagiosxi Linux Source installer
Last edited by ssa_nagios on Mon Oct 12, 2015 8:20 am, edited 1 time in total.
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: NAGIOSQL LOGIN FAILED - NAGIOSXI upgrade to 5.2

Post by ssax »

What is the output of this command:

Code: Select all

ls -l /usr/local/nagiosxi/html/includes/components/ccm/
Also, please attach or PM your /etc/httpd/conf/httpd.conf file and your /etc/httpd/conf.d directory so that we can review them.
ssa_nagios
Posts: 38
Joined: Fri Jun 13, 2014 12:52 pm

Re: NAGIOSQL LOGIN FAILED - NAGIOSXI upgrade to 5.2

Post by ssa_nagios »

Code: Select all

ls -l /usr/local/nagiosxi/html/includes/components/ccm/
total 172
-rw-r-----. 1 nagios nagios 10317 Oct 13 07:22 ajax.php
-rw-r-----. 1 nagios nagios   623 Jul  2  2014 BUGS.txt
-rw-r-----. 1 nagios nagios 20085 Oct 13 07:22 ccm.inc.php
-rw-r-----. 1 nagios nagios 18505 Jul  2  2014 ccm.jpg
-rw-------. 1 nagios nagios 21912 Oct 13 07:22 ccm-splash.inc.php
-rw-r-----. 1 nagios nagios 10803 Oct 13 07:22 CHANGES.txt
drwxr-x---. 2 nagios nagios  4096 Jul  2  2014 classes
-rw-r-----. 1 nagios nagios  5180 Oct 13 07:22 command_test.php
-rw-r-----. 1 nagios nagios  1470 Oct 13 07:22 config.inc.php
drwxr-x---. 2 nagios nagios  4096 Aug  5  2014 css
-rw-r-----. 1 nagios nagios  4130 Oct 13 07:22 download.php
drwxr-x---. 2 nagios nagios  4096 Oct 13 07:22 images
drwxr-x---. 2 nagios nagios  4096 Oct 13 07:22 includes
-rw-r-----. 1 nagios nagios  3848 Oct 13 07:22 index.php
drwxr-x---. 2 nagios nagios  4096 Jul  2  2014 javascript
-rw-------. 1 nagios nagios  4128 Oct 13 07:22 LICENSE.txt
-rw-r-----. 1 nagios nagios    59 Jul  2  2014 NOTES.txt
drwxr-x---. 2 nagios nagios  4096 Sep  3  2014 page_templates
-rw-r-----. 1 nagios nagios  4577 Oct 13 07:22 sanity.sh
drwxr-x---. 3 nagios nagios  4096 Jul  2  2014 templates
-rw-r-----. 1 nagios nagios   413 Jul  2  2014 TODO.txt
-rw-r-----. 1 nagios nagios  1871 Oct 13 07:22 xi-index.php
You do not have the required permissions to view the files attached to this post.
User avatar
tgriep
Madmin
Posts: 9190
Joined: Thu Oct 30, 2014 9:02 am

Re: NAGIOSQL LOGIN FAILED - NAGIOSXI upgrade to 5.2

Post by tgriep »

Can you run this tail command, generate the error and post the output of the tail?

Code: Select all

tail -f /var/log/httpd/error_log
Thanks
Be sure to check out our Knowledgebase for helpful articles and solutions!
ssa_nagios
Posts: 38
Joined: Fri Jun 13, 2014 12:52 pm

Re: NAGIOSQL LOGIN FAILED - NAGIOSXI upgrade to 5.2

Post by ssa_nagios »

Here is the tail of the error_logs file

ludes/components/bbbmap/
[Wed Oct 14 15:46:53 2015] [error] [client xx.xx.xx.xx] PHP Notice: Undefined offset: 0 in /usr/local/nagiosxi/html/includes/components/bbbmap/bbbmap.inc.php on line 232, referer: http://nsc-prd-nagiosxi-006.ba.ssa.gov/ ... ts/bbbmap/
[Wed Oct 14 15:47:23 2015] [error] [client xx.xx.xx.xx] PHP Notice: Undefined offset: 0 in /usr/local/nagiosxi/html/includes/components/bbbmap/bbbmap.inc.php on line 232, referer: http://nsc-prd-nagiosxi-006.ba.ssa.gov/ ... ts/bbbmap/
[Wed Oct 14 15:47:53 2015] [error] [client xx.xx.xx.xx] PHP Notice: Undefined offset: 0 in /usr/local/nagiosxi/html/includes/components/bbbmap/bbbmap.inc.php on line 232, referer: http://nsc-prd-nagiosxi-006.ba.ssa.gov/ ... ts/bbbmap/
[Wed Oct 14 15:48:23 2015] [error] [client xx.xx.xx.xx] PHP Notice: Undefined offset: 0 in /usr/local/nagiosxi/html/includes/components/bbbmap/bbbmap.inc.php on line 232, referer: http://nsc-prd-nagiosxi-006.ba.ssa.gov/ ... ts/bbbmap/
[Wed Oct 14 15:48:53 2015] [error] [client xx.xx.xx.xx] PHP Notice: Undefined offset: 0 in /usr/local/nagiosxi/html/includes/components/bbbmap/bbbmap.inc.php on line 232, referer: http://nsc-prd-nagiosxi-006.ba.ssa.gov/ ... ts/bbbmap/
[Wed Oct 14 15:49:23 2015] [error] [client xx.xx.xx.xx] PHP Notice: Undefined offset: 0 in /usr/local/nagiosxi/html/includes/components/bbbmap/bbbmap.inc.php on line 232, referer: http://nsc-prd-nagiosxi-006.ba.ssa.gov/ ... ts/bbbmap/
[Wed Oct 14 15:49:53 2015] [error] [client xx.xx.xx.xx] PHP Notice: Undefined offset: 0 in /usr/local/nagiosxi/html/includes/components/bbbmap/bbbmap.inc.php on line 232, referer: http://nsc-prd-nagiosxi-006.ba.ssa.gov/ ... ts/bbbmap/
[Wed Oct 14 15:50:23 2015] [error] [client xx.xx.xx.xx] PHP Notice: Undefined offset: 0 in /usr/local/nagiosxi/html/includes/components/bbbmap/bbbmap.inc.php on line 232, referer: http://nsc-prd-nagiosxi-006.ba.ssa.gov/ ... ts/bbbmap/
[Wed Oct 14 15:51:02 2015] [error] [client 127.0.0.1] PHP Notice: Use of undefined constant COMPONENT_REQUIRES_VERSION - assumed 'COMPONENT_REQUIRES_VERSION' in /usr/local/nagiosxi/html/includes/components/actions/actions.inc.php on line 33
[Wed Oct 14 15:51:02 2015] [error] [client 127.0.0.1] PHP Notice: Use of undefined constant COMPONENT_REQUIRES_VERSION - assumed 'COMPONENT_REQUIRES_VERSION' in /usr/local/nagiosxi/html/includes/components/alertstream/alertstream.inc.php on line 33
[Wed Oct 14 15:51:08 2015] [notice] caught SIGTERM, shutting down
[Wed Oct 14 15:51:09 2015] [notice] SELinux policy enabled; httpd running as context unconfined_u:system_r:httpd_t:s0
[Wed Oct 14 15:51:09 2015] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Wed Oct 14 15:51:09 2015] [notice] Digest: generating secret for digest authentication ...
[Wed Oct 14 15:51:09 2015] [notice] Digest: done
[Wed Oct 14 15:51:10 2015] [notice] Apache/2.2.15 (Unix) DAV/2 PHP/5.3.3 mod_ssl/2.2.15 OpenSSL/1.0.1e-fips configured -- resuming normal operations
[/etc/httpd/logs]#
User avatar
Box293
Too Basu
Posts: 5126
Joined: Sun Feb 07, 2010 10:55 pm
Location: Deniliquin, Australia
Contact:

Re: NAGIOSQL LOGIN FAILED - NAGIOSXI upgrade to 5.2

Post by Box293 »

ssa_nagios wrote:[Wed Oct 14 15:51:09 2015] [notice] SELinux policy enabled; httpd running as context unconfined_u:system_r:httpd_t:s0
It looks like SELinux is enabled which can cause problems.

Ruin these commands to make it permissive:

Code: Select all

sed -i 's/SELINUX=enforcing/SELINUX=permissive/g' /etc/selinux/config
setenforce 0
Does this help?
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
ssa_nagios
Posts: 38
Joined: Fri Jun 13, 2014 12:52 pm

Re: NAGIOSQL LOGIN FAILED - NAGIOSXI upgrade to 5.2

Post by ssa_nagios »

Box293 wrote:
ssa_nagios wrote:[Wed Oct 14 15:51:09 2015] [notice] SELinux policy enabled; httpd running as context unconfined_u:system_r:httpd_t:s0
It looks like SELinux is enabled which can cause problems.

Ruin these commands to make it permissive:

Code: Select all

sed -i 's/SELINUX=enforcing/SELINUX=permissive/g' /etc/selinux/config
setenforce 0
Does this help?

This didn't work as selinux was already set to permissive.
tmcdonald
Posts: 9117
Joined: Mon Sep 23, 2013 8:40 am

Re: NAGIOSQL LOGIN FAILED - NAGIOSXI upgrade to 5.2

Post by tmcdonald »

What directory are you running the upgrade from? There should be an upgrade.log file there, please post or PM it.

Update: File received and placed in shared directory.
Former Nagios employee
ssa_nagios
Posts: 38
Joined: Fri Jun 13, 2014 12:52 pm

Re: NAGIOSQL LOGIN FAILED - NAGIOSXI upgrade to 5.2

Post by ssa_nagios »

tmcdonald wrote:What directory are you running the upgrade from? There should be an upgrade.log file there, please post or PM it.
upgrade.log file sent to tmcdonald via PM
User avatar
tgriep
Madmin
Posts: 9190
Joined: Thu Oct 30, 2014 9:02 am

Re: NAGIOSQL LOGIN FAILED - NAGIOSXI upgrade to 5.2

Post by tgriep »

Do you have a proxy server setup on the system?
Be sure to check out our Knowledgebase for helpful articles and solutions!
Locked