Page 2 of 3
Re: XI and Core not showing same for a service
Posted: Mon Sep 08, 2014 11:57 am
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"
Re: XI and Core not showing same for a service
Posted: Mon Sep 08, 2014 12:11 pm
by BanditBBS
| output | varchar(255) | NO | | | |
| long_output | varchar(8192) | NO | | | |
| perfdata | varchar(255) | NO | | | |
Re: XI and Core not showing same for a service
Posted: Mon Sep 08, 2014 12:36 pm
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.
Re: XI and Core not showing same for a service
Posted: Mon Sep 08, 2014 1:22 pm
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!
Re: XI and Core not showing same for a service
Posted: Mon Sep 08, 2014 1:32 pm
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.
Re: XI and Core not showing same for a service
Posted: Mon Sep 08, 2014 1:40 pm
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.
Re: XI and Core not showing same for a service
Posted: Mon Sep 08, 2014 1:51 pm
by BanditBBS
Email sent to open the ticket. I am out the rest of the day(well, in an hour).
Re: XI and Core not showing same for a service
Posted: Mon Sep 08, 2014 1:59 pm
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?
Re: XI and Core not showing same for a service
Posted: Mon Sep 08, 2014 2:02 pm
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
Re: XI and Core not showing same for a service
Posted: Mon Sep 08, 2014 4:34 pm
by abrist
Righto. Catch ya tomorrow.