5.2.9 > 5.3.0 upgrade - duplicate api_key error

[gwakem]

Hey all, I have a 5.2.9 install upgrading to 5.3.0 on RHEL7.3 from the shell. I had the limits.conf error and commented out line 834 to bypass that script, which worked. After that point,however, I am running into the below error. This is a test server, and immediately prior to the upgrade attempt, I generated a manual backup of our prod server and copied it over to this dev server, where I restored it. I changed several configs via the web interface that got carried over, such as email address, server URL, etc, and saved, then running the upgrade.

Code: Select all

rss_dashlet
DASHLET NAME: rss_dashlet
CMD=grep register_dashlet /usr/local/nagiosxi/tmp/4du30/rss_dashlet/rss_dashlet.inc.php | wc -l
1
OUT=1
Dashlet looks ok...
CMD: cp -rf /usr/local/nagiosxi/tmp/4du30/rss_dashlet /usr/local/nagiosxi/html/includes/dashlets/
CMD: rm -rf /usr/local/nagiosxi/tmp/4du30
CMD: . /usr/local/nagiosxi/var/xi-sys.cfg && chown -R $nagiosuser /usr/local/nagiosxi/html/includes/dashlets/rss_dashlet


Done!
Dashlets installed/updated OK
ERROR 1060 (42S21) at line 5: Duplicate column name 'api_key'

Any assistance in pointing me to where I can look or how I can troubleshoot would be appreciated.

[jomann]

Hello,

Since you've ran the upgrade before, and it didn't work - you'll also need to comment out the MySQL additions before the ulimit changes - lines 820-828. If you've never ran the upgrade yet, then you only would need to comment out line 834.

We're working on a solution for the next releases to hopefully keep these MySQL errors from happening, so that the upgrade can be run a second time without this kind of manual change.

[gwakem]

Ok, thanks! I commented out the lines you mentioned, which got me through that issue. I ran into another error with being unable to login to the nagiosql database due to an error 500: internal server error. I reloaded to the last good backup and tried the upgrade again, this time commenting out line 834 before starting, and errored out at the same spot. The default password has not changed here, and the database is local to the box.

Code: Select all

Installing new XI templates...
URL: http://localhost/nagiosxi/includes/components/ccm/
CMDLINE
/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=nagiosxi&password=XXXXXX' -O nagiosql.login--2016-10-06 13:03:42--  http://localhost/nagiosxi/includes/components/ccm/
Resolving localhost (localhost)... 127.0.0.1, ::1
Connecting to localhost (localhost)|127.0.0.1|:80... connected.
HTTP request sent, awaiting response... 500 Internal Server Error
2016-10-06 13:03:42 ERROR 500: Internal Server Error.

NAGIOSQL LOGIN FAILED!

[lmiltchev]

Can you show us the tail of the apache error log?

Code: Select all

tail -100 /var/log/httpd/error_log

[gwakem]

I was actually in the process of pasting that in here when you asked for them. The last lines of this log were after I restored from a backup again and everything went back into a good, pre-upgrade state.

Code: Select all

# tail -100 /var/log/httpd/error_log
[Thu Oct 06 13:40:28.098588 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  Unknown: open(/var/lib/php/session/sess_dh49k8p1ld5dagovh6i0q2je03, O_RDWR) failed: Permission denied (13) in Unknown on line 0, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:28.098604 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/lib/php/session) in Unknown on line 0, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:31.076751 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  file_put_contents(/usr/local/nagiosxi/etc/components/ccm_config.inc.php): failed to open stream: Permission denied in /usr/local/nagiosxi/html/includes/components/ccm/ccm.inc.php on line 156, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:31.123995 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  session_start(): open(/var/lib/php/session/sess_dh49k8p1ld5dagovh6i0q2je03, O_RDWR) failed: Permission denied (13) in /usr/local/nagiosxi/html/includes/utils.inc.php on line 92, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:31.134651 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  session_start(): open(/var/lib/php/session/sess_dh49k8p1ld5dagovh6i0q2je03, O_RDWR) failed: Permission denied (13) in /usr/local/nagiosxi/html/includes/utils.inc.php on line 92, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:31.159216 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  Unknown: open(/var/lib/php/session/sess_dh49k8p1ld5dagovh6i0q2je03, O_RDWR) failed: Permission denied (13) in Unknown on line 0, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:31.159238 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/lib/php/session) in Unknown on line 0, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:31.223376 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  file_put_contents(/usr/local/nagiosxi/etc/components/ccm_config.inc.php): failed to open stream: Permission denied in /usr/local/nagiosxi/html/includes/components/ccm/ccm.inc.php on line 156, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:31.267237 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  session_start(): open(/var/lib/php/session/sess_dh49k8p1ld5dagovh6i0q2je03, O_RDWR) failed: Permission denied (13) in /usr/local/nagiosxi/html/includes/utils.inc.php on line 92, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:31.273456 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  Unknown: open(/var/lib/php/session/sess_dh49k8p1ld5dagovh6i0q2je03, O_RDWR) failed: Permission denied (13) in Unknown on line 0, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:31.273489 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/lib/php/session) in Unknown on line 0, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:31.331671 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  file_put_contents(/usr/local/nagiosxi/etc/components/ccm_config.inc.php): failed to open stream: Permission denied in /usr/local/nagiosxi/html/includes/components/ccm/ccm.inc.php on line 156, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:31.413586 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  session_start(): open(/var/lib/php/session/sess_dh49k8p1ld5dagovh6i0q2je03, O_RDWR) failed: Permission denied (13) in /usr/local/nagiosxi/html/includes/utils.inc.php on line 92, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:31.420783 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  Unknown: open(/var/lib/php/session/sess_dh49k8p1ld5dagovh6i0q2je03, O_RDWR) failed: Permission denied (13) in Unknown on line 0, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:31.420808 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/lib/php/session) in Unknown on line 0, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:31.482847 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  file_put_contents(/usr/local/nagiosxi/etc/components/ccm_config.inc.php): failed to open stream: Permission denied in /usr/local/nagiosxi/html/includes/components/ccm/ccm.inc.php on line 156, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:31.532049 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  session_start(): open(/var/lib/php/session/sess_dh49k8p1ld5dagovh6i0q2je03, O_RDWR) failed: Permission denied (13) in /usr/local/nagiosxi/html/includes/utils.inc.php on line 92, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:31.545399 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  Unknown: open(/var/lib/php/session/sess_dh49k8p1ld5dagovh6i0q2je03, O_RDWR) failed: Permission denied (13) in Unknown on line 0, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:31.545426 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/lib/php/session) in Unknown on line 0, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:32.065776 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  file_put_contents(/usr/local/nagiosxi/etc/components/ccm_config.inc.php): failed to open stream: Permission denied in /usr/local/nagiosxi/html/includes/components/ccm/ccm.inc.php on line 156, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:32.110640 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  session_start(): open(/var/lib/php/session/sess_dh49k8p1ld5dagovh6i0q2je03, O_RDWR) failed: Permission denied (13) in /usr/local/nagiosxi/html/includes/utils.inc.php on line 92, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:32.117257 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  Unknown: open(/var/lib/php/session/sess_dh49k8p1ld5dagovh6i0q2je03, O_RDWR) failed: Permission denied (13) in Unknown on line 0, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:32.117273 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/lib/php/session) in Unknown on line 0, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:32.292377 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  file_put_contents(/usr/local/nagiosxi/etc/components/ccm_config.inc.php): failed to open stream: Permission denied in /usr/local/nagiosxi/html/includes/components/ccm/ccm.inc.php on line 156, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:32.338022 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  session_start(): open(/var/lib/php/session/sess_dh49k8p1ld5dagovh6i0q2je03, O_RDWR) failed: Permission denied (13) in /usr/local/nagiosxi/html/includes/utils.inc.php on line 92, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:32.344526 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  Unknown: open(/var/lib/php/session/sess_dh49k8p1ld5dagovh6i0q2je03, O_RDWR) failed: Permission denied (13) in Unknown on line 0, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:32.344544 2016] [:error] [pid 23008] [client 172.26.11.105:59912] PHP Warning:  Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/lib/php/session) in Unknown on line 0, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:42.493620 2016] [:error] [pid 23010] [client 127.0.0.1:52381] PHP Warning:  file_put_contents(/usr/local/nagiosxi/etc/components/ccm_config.inc.php): failed to open stream: Permission denied in /usr/local/nagiosxi/html/includes/components/ccm/ccm.inc.php on line 156
[Thu Oct 06 13:40:42.537595 2016] [:error] [pid 23010] [client 127.0.0.1:52381] PHP Warning:  session_start(): open(/var/lib/php/session/sess_3jhrmsluohh1sq58k59ohni2p2, O_RDWR) failed: Permission denied (13) in /usr/local/nagiosxi/html/includes/utils.inc.php on line 92
[Thu Oct 06 13:40:42.539633 2016] [:error] [pid 23010] [client 127.0.0.1:52381] PHP Warning:  Unknown: open(/var/lib/php/session/sess_3jhrmsluohh1sq58k59ohni2p2, O_RDWR) failed: Permission denied (13) in Unknown on line 0
[Thu Oct 06 13:40:42.539648 2016] [:error] [pid 23010] [client 127.0.0.1:52381] PHP Warning:  Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/lib/php/session) in Unknown on line 0
[Thu Oct 06 13:40:45.517904 2016] [mpm_prefork:notice] [pid 22723] AH00170: caught SIGWINCH, shutting down gracefully
[Thu Oct 06 13:40:46.585191 2016] [suexec:notice] [pid 23809] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Thu Oct 06 13:40:46.606243 2016] [auth_digest:notice] [pid 23809] AH01757: generating secret for digest authentication ...
[Thu Oct 06 13:40:46.606746 2016] [lbmethod_heartbeat:notice] [pid 23809] AH02282: No slotmem from mod_heartmonitor
[Thu Oct 06 13:40:46.642679 2016] [mpm_prefork:notice] [pid 23809] AH00163: Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.1e-fips PHP/5.4.16 configured -- resuming normal operations
[Thu Oct 06 13:40:46.642700 2016] [core:notice] [pid 23809] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Thu Oct 06 13:40:49.708744 2016] [:error] [pid 23816] [client 172.26.11.105:59922] PHP Warning:  require_once(/usr/local/nagiosxi/html/includes/utils-rrdexport.inc.php): failed to open stream: Permission denied in /usr/local/nagiosxi/html/includes/utils.inc.php on line 38, referer: http://xi-test.ingles-markets.com/nagiosxi/login.php?redirect=/nagiosxi/index.php%3f&noauth=1
[Thu Oct 06 13:40:55.113780 2016] [:error] [pid 23817] [client 172.26.11.105:59924] PHP Warning:  require_once(/usr/local/nagiosxi/html/includes/utils-rrdexport.inc.php): failed to open stream: Permission denied in /usr/local/nagiosxi/html/includes/utils.inc.php on line 38
[Thu Oct 06 13:41:01.300338 2016] [:error] [pid 23815] [client 127.0.0.1:52548] PHP Warning:  require_once(/usr/local/nagiosxi/html/includes/utils-rrdexport.inc.php): failed to open stream: Permission denied in /usr/local/nagiosxi/html/includes/utils.inc.php on line 38
[Thu Oct 06 13:41:11.331171 2016] [mpm_prefork:notice] [pid 23809] AH00170: caught SIGWINCH, shutting down gracefully
[Thu Oct 06 13:41:25.721974 2016] [suexec:notice] [pid 24811] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Thu Oct 06 13:41:25.743779 2016] [auth_digest:notice] [pid 24811] AH01757: generating secret for digest authentication ...
[Thu Oct 06 13:41:25.744279 2016] [lbmethod_heartbeat:notice] [pid 24811] AH02282: No slotmem from mod_heartmonitor
[Thu Oct 06 13:41:25.781095 2016] [mpm_prefork:notice] [pid 24811] AH00163: Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.1e-fips PHP/5.4.16 configured -- resuming normal operations
[Thu Oct 06 13:41:25.781115 2016] [core:notice] [pid 24811] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Thu Oct 06 13:41:29.222823 2016] [:error] [pid 24818] [client 172.26.11.105:59950] PHP Warning:  require_once(/usr/local/nagiosxi/html/includes/utils-rrdexport.inc.php): failed to open stream: Permission denied in /usr/local/nagiosxi/html/includes/utils.inc.php on line 38
[Thu Oct 06 13:41:41.575480 2016] [:error] [pid 24821] [client 127.0.0.1:52884] PHP Warning:  require_once(/usr/local/nagiosxi/html/includes/utils-rrdexport.inc.php): failed to open stream: Permission denied in /usr/local/nagiosxi/html/includes/utils.inc.php on line 38
[Thu Oct 06 13:42:01.789129 2016] [:error] [pid 24819] [client 127.0.0.1:53037] PHP Warning:  require_once(/usr/local/nagiosxi/html/includes/utils-rrdexport.inc.php): failed to open stream: Permission denied in /usr/local/nagiosxi/html/includes/utils.inc.php on line 38
[Thu Oct 06 13:42:21.929801 2016] [:error] [pid 24820] [client 127.0.0.1:53202] PHP Warning:  require_once(/usr/local/nagiosxi/html/includes/utils-rrdexport.inc.php): failed to open stream: Permission denied in /usr/local/nagiosxi/html/includes/utils.inc.php on line 38
[Thu Oct 06 13:42:42.081041 2016] [:error] [pid 24817] [client 127.0.0.1:53375] PHP Warning:  require_once(/usr/local/nagiosxi/html/includes/utils-rrdexport.inc.php): failed to open stream: Permission denied in /usr/local/nagiosxi/html/includes/utils.inc.php on line 38
[Thu Oct 06 13:43:02.536564 2016] [:error] [pid 24818] [client 127.0.0.1:53388] PHP Warning:  require_once(/usr/local/nagiosxi/html/includes/utils-rrdexport.inc.php): failed to open stream: Permission denied in /usr/local/nagiosxi/html/includes/utils.inc.php on line 38
[Thu Oct 06 13:43:47.076991 2016] [:error] [pid 24820] [client 172.26.11.105:59970] PHP Notice:  Undefined index: min_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 118, referer: http://xi-test.ingles-markets.com/nagiosxi/
[Thu Oct 06 13:43:47.077633 2016] [:error] [pid 24820] [client 172.26.11.105:59970] PHP Notice:  Undefined index: max_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 119, referer: http://xi-test.ingles-markets.com/nagiosxi/
[Thu Oct 06 13:43:47.077642 2016] [:error] [pid 24820] [client 172.26.11.105:59970] PHP Notice:  Undefined index: avg_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 120, referer: http://xi-test.ingles-markets.com/nagiosxi/
[Thu Oct 06 13:43:47.077645 2016] [:error] [pid 24820] [client 172.26.11.105:59970] PHP Notice:  Undefined index: min_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 121, referer: http://xi-test.ingles-markets.com/nagiosxi/
[Thu Oct 06 13:43:47.077651 2016] [:error] [pid 24820] [client 172.26.11.105:59970] PHP Notice:  Undefined index: max_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 122, referer: http://xi-test.ingles-markets.com/nagiosxi/
[Thu Oct 06 13:43:47.077654 2016] [:error] [pid 24820] [client 172.26.11.105:59970] PHP Notice:  Undefined index: avg_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 123, referer: http://xi-test.ingles-markets.com/nagiosxi/
[Thu Oct 06 13:43:47.083822 2016] [:error] [pid 24817] [client 172.26.11.105:59972] PHP Notice:  Undefined index: min_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 118, referer: http://xi-test.ingles-markets.com/nagiosxi/
[Thu Oct 06 13:43:47.083839 2016] [:error] [pid 24817] [client 172.26.11.105:59972] PHP Notice:  Undefined index: max_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 119, referer: http://xi-test.ingles-markets.com/nagiosxi/
[Thu Oct 06 13:43:47.083842 2016] [:error] [pid 24817] [client 172.26.11.105:59972] PHP Notice:  Undefined index: avg_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 120, referer: http://xi-test.ingles-markets.com/nagiosxi/
[Thu Oct 06 13:43:47.083845 2016] [:error] [pid 24817] [client 172.26.11.105:59972] PHP Notice:  Undefined index: min_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 121, referer: http://xi-test.ingles-markets.com/nagiosxi/
[Thu Oct 06 13:43:47.083847 2016] [:error] [pid 24817] [client 172.26.11.105:59972] PHP Notice:  Undefined index: max_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 122, referer: http://xi-test.ingles-markets.com/nagiosxi/
[Thu Oct 06 13:43:47.083849 2016] [:error] [pid 24817] [client 172.26.11.105:59972] PHP Notice:  Undefined index: avg_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 123, referer: http://xi-test.ingles-markets.com/nagiosxi/
[Thu Oct 06 13:43:47.622480 2016] [:error] [pid 24820] [client 172.26.11.105:59970] PHP Notice:  Undefined index: min_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 118, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:47.622498 2016] [:error] [pid 24820] [client 172.26.11.105:59970] PHP Notice:  Undefined index: max_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 119, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:47.622501 2016] [:error] [pid 24820] [client 172.26.11.105:59970] PHP Notice:  Undefined index: avg_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 120, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:47.622504 2016] [:error] [pid 24820] [client 172.26.11.105:59970] PHP Notice:  Undefined index: min_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 121, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:47.622506 2016] [:error] [pid 24820] [client 172.26.11.105:59970] PHP Notice:  Undefined index: max_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 122, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:47.622509 2016] [:error] [pid 24820] [client 172.26.11.105:59970] PHP Notice:  Undefined index: avg_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 123, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:47.679790 2016] [:error] [pid 27039] [client 172.26.11.105:59978] PHP Notice:  Undefined index: min_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 118, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:47.679823 2016] [:error] [pid 27039] [client 172.26.11.105:59978] PHP Notice:  Undefined index: max_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 119, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:47.679827 2016] [:error] [pid 27039] [client 172.26.11.105:59978] PHP Notice:  Undefined index: avg_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 120, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:47.679830 2016] [:error] [pid 27039] [client 172.26.11.105:59978] PHP Notice:  Undefined index: min_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 121, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:47.679832 2016] [:error] [pid 27039] [client 172.26.11.105:59978] PHP Notice:  Undefined index: max_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 122, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:47.679835 2016] [:error] [pid 27039] [client 172.26.11.105:59978] PHP Notice:  Undefined index: avg_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 123, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:47.685990 2016] [:error] [pid 24819] [client 172.26.11.105:59976] PHP Notice:  Undefined index: min_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 118, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:47.686004 2016] [:error] [pid 24819] [client 172.26.11.105:59976] PHP Notice:  Undefined index: max_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 119, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:47.686007 2016] [:error] [pid 24819] [client 172.26.11.105:59976] PHP Notice:  Undefined index: avg_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 120, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:47.686009 2016] [:error] [pid 24819] [client 172.26.11.105:59976] PHP Notice:  Undefined index: min_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 121, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:47.686012 2016] [:error] [pid 24819] [client 172.26.11.105:59976] PHP Notice:  Undefined index: max_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 122, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:47.686014 2016] [:error] [pid 24819] [client 172.26.11.105:59976] PHP Notice:  Undefined index: avg_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 123, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:47.761345 2016] [:error] [pid 24817] [client 172.26.11.105:59972] PHP Notice:  Undefined index: min_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 118, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:47.761362 2016] [:error] [pid 24817] [client 172.26.11.105:59972] PHP Notice:  Undefined index: max_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 119, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:47.761376 2016] [:error] [pid 24817] [client 172.26.11.105:59972] PHP Notice:  Undefined index: avg_latency in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 120, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:47.761383 2016] [:error] [pid 24817] [client 172.26.11.105:59972] PHP Notice:  Undefined index: min_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 121, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:47.761385 2016] [:error] [pid 24817] [client 172.26.11.105:59972] PHP Notice:  Undefined index: max_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 122, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:47.761387 2016] [:error] [pid 24817] [client 172.26.11.105:59972] PHP Notice:  Undefined index: avg_execution_time in /usr/local/nagiosxi/html/includes/utils-xmlsysstat.inc.php on line 123, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:54.561038 2016] [:error] [pid 27039] [client 172.26.11.105:59978] PHP Warning:  mysql_pconnect(): Link to server lost, unable to reconnect in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:54.561148 2016] [:error] [pid 27039] [client 172.26.11.105:59978] PHP Notice:  Undefined variable: result in /usr/local/nagiosxi/html/includes/db.inc.php on line 249, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:54.575605 2016] [:error] [pid 27039] [client 172.26.11.105:59978] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:54.575649 2016] [:error] [pid 27039] [client 172.26.11.105:59978] PHP Notice:  Undefined variable: result in /usr/local/nagiosxi/html/includes/db.inc.php on line 249, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:54.604092 2016] [:error] [pid 27039] [client 172.26.11.105:59978] PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:54.604157 2016] [:error] [pid 27039] [client 172.26.11.105:59978] PHP Notice:  Undefined variable: result in /usr/local/nagiosxi/html/includes/db.inc.php on line 249, referer: http://xi-test.ingles-markets.com/nagiosxi//includes/page-home-main.php?&=
[Thu Oct 06 13:43:55.880797 2016] [mpm_prefork:notice] [pid 24811] AH00170: caught SIGWINCH, shutting down gracefully
[Thu Oct 06 13:43:57.996694 2016] [suexec:notice] [pid 27341] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Thu Oct 06 13:43:58.029269 2016] [auth_digest:notice] [pid 27341] AH01757: generating secret for digest authentication ...
[Thu Oct 06 13:43:58.029766 2016] [lbmethod_heartbeat:notice] [pid 27341] AH02282: No slotmem from mod_heartmonitor
[Thu Oct 06 13:43:58.065529 2016] [mpm_prefork:notice] [pid 27341] AH00163: Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.1e-fips PHP/5.4.16 configured -- resuming normal operations
[Thu Oct 06 13:43:58.065549 2016] [core:notice] [pid 27341] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'

[dwhitfield]

Can you please attach your /tmp/nagiosxi/upgrade.log?

[gwakem]

Please see the attached. Thanks!

[dwhitfield]

Can you log in to MySQL and show us the output of echo "show grants for 'nagiosql'@'<nagios xi ip address>';"?

NAGIOSQL LOGIN FAILED!

is the part that looks suspicious to me.

[gwakem]

Log in as nagiosql? In both my prod and test environments, I get ERROR 1141 (42000): There is no such grant defined for user 'nagiosql' on host 'X.X.X.X'

[dwhitfield]

Please login using mysql -u root -p 'mypassword'.

Then run GRANT ALL ON nagiosql.* TO nagiosql@'<IP_OF_NAGIOS_XI_SERVER>' IDENTIFIED BY 'nagiosql';

quit with exit.

Then, try the upgrade again and see if you have the same errors.