XI 2014: Cannot add new admins

[vmesquita]

If I try to add a new admin user from the scratch, after saving, the user doesn't appear. If I try to copy an existing admin user, I get this error message:

Code: Select all

No objects copied.
Error while inserting the data to the database:
Unknown column '' in 'field list'

We have upgrade to Nagios XI 2014R1.0, previously this was working. Can you please check?

[sreinhardt]

This is working on my 2014 machine. Could you attempt to do it again, then immidiately after run the following commands and send us back the results.

Code: Select all

tail -n 25 /var/log/httpd/error_log
tail -n 25 /var/log/httpd/access_log
tail -n 25 /var/log/mysqld.log

[vmesquita]

/var/log/httpd/error_log:

Code: Select all

[Tue May 27 14:13:58 2014] [error] [client 172.29.125.143] PHP Notice:  Undefined offset: 0 in /usr/local/nagiosxi/html/includes/components/ccm/classes/data_class.php on line 541, referer: http://nagios.selic.bc/nagiosxi//includes/components/ccm/?cmd=admin&type=user

access_log:

Code: Select all

::1 - - [27/May/2014:14:15:26 -0300] "POST /nagiosxi/backend/ HTTP/1.1" 200 1591 "-" "BinGet/1.00.A (http://www.bin-co.com/php/scripts/load/)"
172.27.15.56 - - [27/May/2014:14:15:23 -0300] "GET /nagiosxi/ajaxhelper.php?cmd=getxicoreajax&opts=%7B%22func%22%3A%22get_pagetop_alert_content_html%22%2C%22args%22%3A%22%22%7D&nsp=e2d287f99bad32756efcd09275b708d3 HTTP/1.1" 200 874 "http://nagios.selic.bc/nagiosxi/index.php?" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
172.27.15.56 - - [27/May/2014:14:15:23 -0300] "GET /nagiosxi/ajaxhelper.php?cmd=getxicoreajax&opts=%7B%22func%22%3A%22get_tray_alert_html%22%2C%22args%22%3A%22%22%7D&nsp=e2d287f99bad32756efcd09275b708d3 HTTP/1.1" 200 570 "http://nagios.selic.bc/nagiosxi/index.php?" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
172.27.15.57 - - [27/May/2014:14:15:28 -0300] "GET /nagiosxi/ajaxhelper.php?cmd=getxicoreajax&opts=%7B%22func%22%3A%22get_pagetop_alert_content_html%22%2C%22args%22%3A%22%22%7D&nsp=4e6ac60728df603ed5bb442a8d481f1c HTTP/1.1" 200 - "http://nagios/nagiosxi/index.php?" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0"
172.27.15.57 - - [27/May/2014:14:15:28 -0300] "GET /nagiosxi/ajaxhelper.php?cmd=getxicoreajax&opts=%7B%22func%22%3A%22get_tray_alert_html%22%2C%22args%22%3A%22%22%7D&nsp=4e6ac60728df603ed5bb442a8d481f1c HTTP/1.1" 200 - "http://nagios/nagiosxi/index.php?" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0"
::1 - - [27/May/2014:14:15:29 -0300] "POST /nagiosxi/backend/ HTTP/1.1" 200 1591 "-" "BinGet/1.00.A (http://www.bin-co.com/php/scripts/load/)"
172.29.125.143 - - [27/May/2014:14:15:29 -0300] "GET /nagiosxi/ajaxhelper.php?cmd=getxicoreajax&opts=%7B%22func%22%3A%22get_tray_alert_html%22%2C%22args%22%3A%22%22%7D&nsp=54fdb3fc6a08c9601773ae27568564ad HTTP/1.1" 200 570 "http://nagios.selic.bc/nagiosxi/includes/components/ccm/xi-index.php" "Mozilla/5.0 (Windows NT 6.1; rv:17.0) Gecko/20100101 Firefox/17.0"
::1 - - [27/May/2014:14:15:29 -0300] "POST /nagiosxi/backend/ HTTP/1.1" 200 1591 "-" "BinGet/1.00.A (http://www.bin-co.com/php/scripts/load/)"
172.29.125.143 - - [27/May/2014:14:15:29 -0300] "GET /nagiosxi/ajaxhelper.php?cmd=getxicoreajax&opts=%7B%22func%22%3A%22get_pagetop_alert_content_html%22%2C%22args%22%3A%22%22%7D&nsp=54fdb3fc6a08c9601773ae27568564ad HTTP/1.1" 200 1047 "http://nagios.selic.bc/nagiosxi/includes/components/ccm/xi-index.php" "Mozilla/5.0 (Windows NT 6.1; rv:17.0) Gecko/20100101 Firefox/17.0"
172.27.15.207 - - [27/May/2014:14:15:31 -0300] "GET /nagiosxi/ajaxhelper.php?cmd=getxicoreajax&opts=%7B%22func%22%3A%22get_pagetop_alert_content_html%22%2C%22args%22%3A%22%22%7D&nsp=290d394be91c4c8e6462007d97548b87 HTTP/1.1" 200 - "http://nagios.selic.bc/nagiosxi/index.php?" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; Media Center PC 6.0; .NET CLR 3.5.30729; .NET CLR 3.0.30729; .NET4.0C; .NET4.0E)"
172.27.15.207 - - [27/May/2014:14:15:31 -0300] "GET /nagiosxi/includes/components/nocscreen/nocscreenapi.php HTTP/1.1" 200 1221 "http://nagios.selic.bc/nagiosxi/includes/components/nocscreen/noc.php" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; Media Center PC 6.0; .NET CLR 3.5.30729; .NET CLR 3.0.30729; .NET4.0C; .NET4.0E)"
172.27.15.207 - - [27/May/2014:14:15:31 -0300] "GET /nagiosxi/includes/components/nocscreen/nocscreenapi.php?summary=true HTTP/1.1" 200 1463 "http://nagios.selic.bc/nagiosxi/includes/components/nocscreen/noc.php" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; Media Center PC 6.0; .NET CLR 3.5.30729; .NET CLR 3.0.30729; .NET4.0C; .NET4.0E)"
172.27.15.207 - - [27/May/2014:14:15:31 -0300] "GET /nagiosxi/ajaxhelper.php?cmd=getxicoreajax&opts=%7B%22func%22%3A%22get_tray_alert_html%22%2C%22args%22%3A%22%22%7D&nsp=290d394be91c4c8e6462007d97548b87 HTTP/1.1" 200 - "http://nagios.selic.bc/nagiosxi/index.php?" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; Media Center PC 6.0; .NET CLR 3.5.30729; .NET CLR 3.0.30729; .NET4.0C; .NET4.0E)"
172.27.15.56 - - [27/May/2014:14:15:32 -0300] "POST /nagiosxi//includes/components/birdseye/ajaxreqs.php HTTP/1.1" 200 1996 "http://nagios.selic.bc/nagiosxi/includes/components/birdseye/birdseye.php" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
172.27.15.33 - - [27/May/2014:14:15:33 -0300] "GET /nagiosxi/ajaxhelper.php?cmd=getxicoreajax&opts=%7B%22func%22%3A%22get_servicestatus_table%22%2C%22args%22%3A%7B%22host%22%3A%22%22%2C%22hostgroup%22%3A%22%22%2C%22servicegroup%22%3A%22%22%2C%22sortby%22%3A%22%22%2C%22sortorder%22%3A%22asc%22%2C%22records%22%3A%22100%22%2C%22page%22%3A%221%22%2C%22search%22%3A%22RSFN+L3+-+%22%2C%22hostattr%22%3A%220%22%2C%22serviceattr%22%3A%220%22%2C%22hoststatustypes%22%3A%220%22%2C%22servicestatustypes%22%3A%220%22%7D%7D&nsp=925d3729858f8e6ddb31122e32f929a3 HTTP/1.1" 200 17780 "http://nagios.selic.bc/nagiosxi/includes/components/xicore/status.php?show=services" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20100101 Firefox/17.0"
172.27.15.56 - - [27/May/2014:14:15:32 -0300] "GET /nagiosxi//includes/components/birdseye/ajaxreqs.php?mode=get_all_down HTTP/1.1" 200 1732 "http://nagios.selic.bc/nagiosxi/includes/components/birdseye/birdseye.php" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
172.27.15.207 - - [27/May/2014:14:15:37 -0300] "GET /nagiosxi/ajaxhelper.php?cmd=getxicoreajax&opts=%7B%22func%22%3A%22get_pagetop_alert_content_html%22%2C%22args%22%3A%22%22%7D&nsp=b4561dfeaacea66d0b18dcf67d8506ee HTTP/1.1" 200 - "http://nagios.selic.bc/nagiosxi/dashboards/" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0"
172.27.15.207 - - [27/May/2014:14:15:37 -0300] "GET /nagiosxi/ajaxhelper.php?cmd=getxicoreajax&opts=%7B%22func%22%3A%22get_tray_alert_html%22%2C%22args%22%3A%22%22%7D&nsp=b4561dfeaacea66d0b18dcf67d8506ee HTTP/1.1" 200 - "http://nagios.selic.bc/nagiosxi/dashboards/" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0"
172.27.15.37 - - [27/May/2014:14:15:37 -0300] "GET /nagiosxi/ajaxhelper.php?cmd=getxicoreajax&opts=%7B%22func%22%3A%22get_pagetop_alert_content_html%22%2C%22args%22%3A%22%22%7D&nsp=5cad8c9c7538f11b9815e5117ddb7a81 HTTP/1.1" 200 - "http://nagios/nagiosxi/" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Firefox/24.0"
172.27.15.37 - - [27/May/2014:14:15:37 -0300] "GET /nagiosxi/ajaxhelper.php?cmd=getxicoreajax&opts=%7B%22func%22%3A%22get_tray_alert_html%22%2C%22args%22%3A%22%22%7D&nsp=5cad8c9c7538f11b9815e5117ddb7a81 HTTP/1.1" 200 - "http://nagios/nagiosxi/" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Firefox/24.0"
172.27.15.207 - - [27/May/2014:14:15:38 -0300] "GET /nagiosxi/includes/components/graphexplorer/visApi.php?type=timeline&host=vx576.selic.bc&service=SPBOUT&div=perfgraph_hc_2smsen&filter=&subtitle=0&view=0&link=http%3A%2F%2Fnagios.selic.bc%2Fnagiosxi%2Fperfgraphs%2Findex.php%3Fsearch%3Dvx576.selic.bc%26host%3Dvx576.selic.bc&render_mode=&height=205&width=536 HTTP/1.1" 200 8896 "http://nagios.selic.bc/nagiosxi/dashboards/dashboard.php?&=" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0"
172.27.15.57 - - [27/May/2014:14:15:41 -0300] "GET /nagiosxi/includes/components/nocscreen/nocscreenapi.php HTTP/1.1" 200 1222 "http://nagios/nagiosxi/includes/components/nocscreen/noc.php" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0"
172.27.15.57 - - [27/May/2014:14:15:41 -0300] "GET /nagiosxi/includes/components/nocscreen/nocscreenapi.php?summary=true HTTP/1.1" 200 1463 "http://nagios/nagiosxi/includes/components/nocscreen/noc.php" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0"
172.27.15.56 - - [27/May/2014:14:15:42 -0300] "POST /nagiosxi//includes/components/birdseye/ajaxreqs.php HTTP/1.1" 200 1996 "http://nagios.selic.bc/nagiosxi/includes/components/birdseye/birdseye.php" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
::1 - - [27/May/2014:14:15:42 -0300] "POST /nagiosxi/backend/ HTTP/1.1" 200 810 "-" "BinGet/1.00.A (http://www.bin-co.com/php/scripts/load/)"

mysqld.log:

Code: Select all

140324 15:51:53 [Note] /usr/libexec/mysqld: Shutdown complete

140324 15:51:53 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140324 15:51:55 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140324 15:51:55  InnoDB: Initializing buffer pool, size = 8.0M
140324 15:51:55  InnoDB: Completed initialization of buffer pool
140324 15:51:55  InnoDB: Started; log sequence number 0 44233
140324 15:51:55 [Note] Event Scheduler: Loaded 0 events
140324 15:51:55 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
140402 22:26:23 [Note] /usr/libexec/mysqld: Normal shutdown

140402 22:26:23 [Note] Event Scheduler: Purging the queue. 0 events
140402 22:26:25  InnoDB: Starting shutdown...
140402 22:26:28  InnoDB: Shutdown completed; log sequence number 0 44233
140402 22:26:28 [Note] /usr/libexec/mysqld: Shutdown complete

140402 22:26:28 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140402 22:29:47 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140402 22:29:47  InnoDB: Initializing buffer pool, size = 8.0M
140402 22:29:47  InnoDB: Completed initialization of buffer pool
140402 22:29:47  InnoDB: Started; log sequence number 0 44233
140402 22:29:47 [Note] Event Scheduler: Loaded 0 events
140402 22:29:47 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

[lmiltchev]

We are aware of this issue - we have an internal bug report filed in regards to this problem (Task ID = 2926). I expect this to be fixed in the text XI release.