XI and Core not showing same for a service

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: XI and Core not showing same for a service

Post by abrist »

Well, I cannot make this *not* work. I created a script to echo the output (status and perf) and exit 0 from the pm. I then set it up as a check. The check itself tested ok, and runs ok. It generates a large quantity of perfdata, but seems to run and return "OK" just fine. I have altered the column sizes on this box, so lets check what you have setup on your side:

Code: Select all

echo "desc nagios.nagios_servicestatus" | mysql -t -pnagiosxi | grep "output\|perfdata"
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
User avatar
BanditBBS
Posts: 2474
Joined: Tue May 31, 2011 12:57 pm
Location: Scio, OH
Contact:

Re: XI and Core not showing same for a service

Post by BanditBBS »

| output | varchar(255) | NO | | | |
| long_output | varchar(8192) | NO | | | |
| perfdata | varchar(255) | NO | | | |
2 of XI5.6.14 Prod/DR/DEV - Nagios LogServer 2 Nodes
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: XI and Core not showing same for a service

Post by abrist »

Warning, backup your db first. We will try to increase these column sizes:

Code: Select all

echo "alter table nagios.nagios_servicestatus modify output varchar(50000);" | mysql -pnagiosxi
echo "alter table nagios.nagios_servicestatus modify long_output varchar(50000);" | mysql -pnagiosxi
echo "alter table nagios.nagios_servicestatus modify perfdata varchar(50000);" | mysql -pnagiosxi
echo "desc nagios.nagios_servicestatus" | mysql -t -pnagiosxi | grep "output\|perfdata"
Please note that this will potentially increase the table size significantly.
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
User avatar
BanditBBS
Posts: 2474
Joined: Tue May 31, 2011 12:57 pm
Location: Scio, OH
Contact:

Re: XI and Core not showing same for a service

Post by BanditBBS »

abrist wrote:Warning, backup your db first. We will try to increase these column sizes:

Code: Select all

echo "alter table nagios.nagios_servicestatus modify output varchar(50000);" | mysql -pnagiosxi
echo "alter table nagios.nagios_servicestatus modify long_output varchar(50000);" | mysql -pnagiosxi
echo "alter table nagios.nagios_servicestatus modify perfdata varchar(50000);" | mysql -pnagiosxi
echo "desc nagios.nagios_servicestatus" | mysql -t -pnagiosxi | grep "output\|perfdata"
Please note that this will potentially increase the table size significantly.

Code: Select all

[root@iss-chi-nag02 nagiosxi]# echo "desc nagios.nagios_servicestatus" | mysql -t -pnagiosxi | grep "output\|perfdata"
| output                        | mediumtext   | YES  |     | NULL                |                |
| long_output                   | mediumtext   | YES  |     | NULL                |                |
| perfdata                      | mediumtext   | YES  |     | NULL                |                |
testing stuff now!
2 of XI5.6.14 Prod/DR/DEV - Nagios LogServer 2 Nodes
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
User avatar
BanditBBS
Posts: 2474
Joined: Tue May 31, 2011 12:57 pm
Location: Scio, OH
Contact:

Re: XI and Core not showing same for a service

Post by BanditBBS »

Still doing the same thing. I even created a new copy of the service with a new name just to start over fresh. Both old and new doing the same. The changes to the DB definitely made a change though as now quite a bit more information is shown on the screen when looking at service detail.
2 of XI5.6.14 Prod/DR/DEV - Nagios LogServer 2 Nodes
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: XI and Core not showing same for a service

Post by abrist »

Well, I may have to remote in to look at this as I am unable to reproduce the behavior on my end. Open a ticket and we will move from there.
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
User avatar
BanditBBS
Posts: 2474
Joined: Tue May 31, 2011 12:57 pm
Location: Scio, OH
Contact:

Re: XI and Core not showing same for a service

Post by BanditBBS »

Email sent to open the ticket. I am out the rest of the day(well, in an hour).
2 of XI5.6.14 Prod/DR/DEV - Nagios LogServer 2 Nodes
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: XI and Core not showing same for a service

Post by abrist »

Dang. We may have to pick this up tomorrow as I am not free until 3:30 pm.

EDIT: Do you use rrdcached, ramdisk, etc?
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
User avatar
BanditBBS
Posts: 2474
Joined: Tue May 31, 2011 12:57 pm
Location: Scio, OH
Contact:

Re: XI and Core not showing same for a service

Post by BanditBBS »

abrist wrote:Dang. We may have to pick this up tomorrow as I am not free until 3:30 pm.

EDIT: Do you use rrdcached, ramdisk, etc?
Tomorrow is fine.

yes and yes and define etc :)
2 of XI5.6.14 Prod/DR/DEV - Nagios LogServer 2 Nodes
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: XI and Core not showing same for a service

Post by abrist »

Righto. Catch ya tomorrow.
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
Locked