Operations Center not displaying information.

[TBT]

I tried four(4) different accounts on the Fusion server, same result. Both Tactical Overview and Summary display the data, Operations Center and aforementioned Dashlets do not..

SELINUX=disabled

[lmiltchev]

Run the following commands, and show the output:

Code: Select all

ll /usr/local/nagiosfusion/html/includes/components/nocscreen
tail /usr/local/nagiosfusion/var/components/noc.log
tail /var/log/cron

[TBT]

Code: Select all

# ll /usr/local/nagiosfusion/html/includes/components/nocscreen
total 92
-rwxr-xr-x 1 nagios users 22882 Oct 30 16:20 host.png
-rwxr-xr-x 1 nagios users    84 Oct 30 16:20 install.sh
-rwxr-xr-x 1 nagios users  5748 Oct 30 16:20 nocfetch.php
-rwxr-xr-x 1 nagios users  3501 Oct 30 16:20 noc.php
-rwxr-xr-x 1 nagios users 17966 Oct 30 16:20 nocscreen.inc.php
-rwxr-xr-x 1 nagios users 18457 Oct 30 16:20 service.png
-rwxr-xr-x 1 nagios users  8755 Oct 30 16:20 summary.png

Code: Select all

# tail /usr/local/nagiosfusion/var/components/noc.log
Network Applications:NOC Service Data retrieved in 0.2274 seconds.
0 unhandled problems saved to DB
Development Environment: NOC Host Data retrieved in 0.1258 seconds.
1 unhandled problems saved to DB
Development Environment:NOC Service Data retrieved in 0.1582 seconds.
        SQL: INSERT INTO fusion_noc
                (server_sid,type,host,service,status_update_time,status,output)
                VALUES ('chgjdf',1,'bladecentre1.nagios','SNMP Traps','2013-01-23 15:35:41','1','System Alert: Remote Login Date(m/d/y)=01/18/13, Time(h:m:s)=16:31:07 BladeCenter Advanced Management Module BladeCenter1 39E15E44A02E47CC8E51D1C640367B4D YK14817AN1B9 30 4 Remote logoff successful for user &apos;user1&apos; from Web at IP xxx.xxx.xxx Int')     SQL Error [nagiosfusion] :</b> ERROR:  value too long for type character varying(255)   SQL: INSERT INTO fusion_noc
                (server_sid,type,host,service,status_update_time,status,output)
                VALUES ('chgjdf',1,'bladecentre2.nagios','SNMP Traps','2013-01-23 15:35:41','1','System Alert: Remote Login Date(m/d/y)=12/14/12, Time(h:m:s)=16:26:39 BladeCenter Advanced Management Module BladeCenter2 4D3DC8382288445E8EC76D746838C2E1 YK14817AN27B 30 4 Remote logoff successful for user &apos;user2&apos; from Web at IP xxx.xxx.xxx Internet')     SQL Error [nagiosfusion] :</b> ERROR:  value too long for type character varying(255)30 unhandled problems saved to DB

IP Addresses & UID removed.

Code: Select all

# tail /var/log/cron
Oct 31 16:01:01 monitor run-parts(/etc/cron.hourly)[15363]: finished 0anacron
Oct 31 16:02:01 monitor CROND[15544]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosfusion/cron/cmdsubsys.php > /usr/local/nagiosfusion/var/cmdsubsys.log 2>&1)
Oct 31 16:02:01 monitor CROND[15543]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosfusion/cron/eventman.php > /usr/local/nagiosfusion/var/eventman.log 2>&1)
Oct 31 16:02:01 monitor CROND[15545]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosfusion/cron/sysstat.php > /usr/local/nagiosfusion/var/sysstat.log 2>&1)
Oct 31 16:03:01 monitor CROND[15731]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosfusion/cron/sysstat.php > /usr/local/nagiosfusion/var/sysstat.log 2>&1)
Oct 31 16:03:01 monitor CROND[15732]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosfusion/cron/cmdsubsys.php > /usr/local/nagiosfusion/var/cmdsubsys.log 2>&1)
Oct 31 16:03:01 monitor CROND[15733]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosfusion/cron/eventman.php > /usr/local/nagiosfusion/var/eventman.log 2>&1)
Oct 31 16:04:01 monitor CROND[15948]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosfusion/cron/cmdsubsys.php > /usr/local/nagiosfusion/var/cmdsubsys.log 2>&1)
Oct 31 16:04:01 monitor CROND[15949]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosfusion/cron/eventman.php > /usr/local/nagiosfusion/var/eventman.log 2>&1)
Oct 31 16:04:01 monitor CROND[15952]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosfusion/cron/sysstat.php > /usr/local/nagiosfusion/var/sysstat.log 2>&1)

[scottwilkerson]

Lets run the following to increase the column size:

Code: Select all

psql nagiosfusion nagiosfusion
ALTER TABLE fusion_noc ALTER COLUMN output TYPE character varying(2000);
\q

This will increase the size to 2000 from 255

[TBT]

Lets run the following to increase the column size:

Code: Select all

psql nagiosfusion nagiosfusion
ALTER TABLE fusion_noc ALTER COLUMN output TYPE character varying(2000);
\q

This will increase the size to 2000 from 255

Ran, results were the same.

[lmiltchev]

Strange - this was the only error in the log... Can you run again the same command and see if any new errors showed up in the log?

Code: Select all

tail /usr/local/nagiosfusion/var/components/noc.log

[TBT]

Code: Select all

]# tail /usr/local/nagiosfusion/var/components/noc.log
Network Applications:NOC Service Data retrieved in 0.2274 seconds.
0 unhandled problems saved to DB
Development Environment: NOC Host Data retrieved in 0.1258 seconds.
1 unhandled problems saved to DB
Development Environment:NOC Service Data retrieved in 0.1582 seconds.
        SQL: INSERT INTO fusion_noc
                (server_sid,type,host,service,status_update_time,status,output)
                VALUES ('chgjdf',1,'bladecentre1.nagios','SNMP Traps','2013-01-23 15:35:41','1','System Alert: Remote Login Date(m/d/y)=01/18/13, Time(h:m:s)=16:31:07 BladeCenter Advanced Management Module BladeCenter1 39E15E44A02E47CC8E51D1C640367B4D YK14817AN1B9 30 4 Remote logoff successful for user &apos;user1&apos; from Web at IP xxx.xxx.xxx Int')     SQL Error [nagiosfusion] :</b> ERROR:  value too long for type character varying(255)   SQL: INSERT INTO fusion_noc
                (server_sid,type,host,service,status_update_time,status,output)
                VALUES ('chgjdf',1,'bladecentre2.nagios','SNMP Traps','2013-01-23 15:35:41','1','System Alert: Remote Login Date(m/d/y)=12/14/12, Time(h:m:s)=16:26:39 BladeCenter Advanced Management Module BladeCenter2 4D3DC8382288445E8EC76D746838C2E1 YK14817AN27B 30 4 Remote logoff successful for user &apos;user2&apos; from Web at IP xxx.xxx.xxx Internet')     SQL Error [nagiosfusion] :</b> ERROR:  value too long for type character varying(255)30 unhandled problems saved to DB

[scottwilkerson]

Lets run the following to increase the column size:

Code: Select all

psql nagiosfusion nagiosfusion
ALTER TABLE fusion_noc ALTER COLUMN output TYPE character varying(2000);
\q

This will increase the size to 2000 from 255

Ran, results were the same.

When you ran the above did you get an error?

Can you run the following and display the results, because it doesn't appear that the column changed size

Code: Select all

psql nagiosfusion nagiosfusion
\d+ fusion_noc

if you display

Code: Select all

...
 output             | character varying(255)     |                                                         | extended |
...

Then the command didn't run properly, and you should run

Code: Select all

ALTER TABLE fusion_noc ALTER COLUMN output TYPE character varying(2000);

[TBT]

It was successful and returned:

Code: Select all

ALTER TABLE

Confirmed to be 2000, shown below:

Code: Select all

 output             | character varying(2000)     |                                                         | extended |

[abrist]

Is it working now?