Hendrik, Thanks for your reply. how can I verify, that your nagios is using the new compiled binaries? Also your query is looking at nagios_hoststatus table not nagios_hostchecks table. Please advise on this. Thanks <div class="gmail_quote">On Mon, Oct 5, 2009 at 4:53 AM, Hendrik Baecker <<a href="mailto:andurin@process-zero.de">andurin@process-zero.de</a>> wrote: <blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> <div bgcolor="#ffffff" text="#000000"> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Shadin, I'm sorry but the problem is not reproduceable with the latest cvs head. Did you 'make clean' your sources before installation? There were some small changes in some header files that may require a clean before a new compile. Did you verify, that your nagios is using the new compiled binaries? mysql> select * from nagios_hoststatus order by status_update_time limit 1\G *************************** 1. row *************************** hoststatus_id: 14333 instance_id: 4 host_object_id: 15721 status_update_time: 2009-10-05 10:48:20 output: PING OK - Packet loss = 0%, RTA = 3.54 ms long_output: perfdata: rta=3.535000ms;5000.000000;5000.000000;0.000000 pl=0%;100;100;0 current_state: 0 has_been_checked: 1 should_be_scheduled: 1 current_check_attempt: 1 max_check_attempts: 2 last_check: 2009-10-05 10:48:10 next_check: 2009-10-05 10:51:20 check_type: 0 last_state_change: 2009-08-19 19:53:11 last_hard_state_change: 2009-08-19 19:53:11 last_hard_state: 0 last_time_up: 2009-10-05 10:48:20 last_time_down: 1970-01-01 01:00:00 last_time_unreachable: 1970-01-01 01:00:00 state_type: 1 last_notification: 1970-01-01 01:00:00 next_notification: 1970-01-01 01:00:00 no_more_notifications: 0 notifications_enabled: 1 problem_has_been_acknowledged: 0 acknowledgement_type: 0 current_notification_number: 0 passive_checks_enabled: 1 active_checks_enabled: 1 event_handler_enabled: 1 flap_detection_enabled: 0 is_flapping: 0 percent_state_change: 0 latency: 0.121 execution_time: 2.03093 scheduled_downtime_depth: 0 failure_prediction_enabled: 1 process_performance_data: 1 obsess_over_host: 1 modified_host_attributes: 0 event_handler: check_command: check-host-alive normal_check_interval: 180 retry_check_interval: 15 check_timeperiod_object_id: 15717 Am 05.10.2009 07:37, schrieb shadih rahman: > Appears to be a bug open on this issue. Can someone advise on this > issue. Is it a ndoutils issue or nagios -3.2 issue. Please advise > on this. Thanks > > <a href="http://tracker.nagios.org/view.php?id=73" target="_blank">http://tracker.nagios.org/view.php?id=73</a> > > > On Mon, Oct 5, 2009 at 5:08 AM, shadih rahman <<a href="mailto:shadhin71@gmail.com" target="_blank">shadhin71@gmail.com</a> > <a href="mailto:shadhin71@gmail.com" target="_blank"><mailto:shadhin71@gmail.com></a>> wrote: > > Can someone advise why was characterset change to latin1 ? > > > On Mon, Oct 5, 2009 at 5:06 AM, shadih rahman > <<a href="mailto:shadhin71@gmail.com" target="_blank">shadhin71@gmail.com</a> <a href="mailto:shadhin71@gmail.com" target="_blank"><mailto:shadhin71@gmail.com></a>> wrote: > > Here is an actual query which is coming as empty. Please > advise on this. Thanks > > INSERT INTO nagios_hostchecks SET instance_id='1', > host_object_id='1501', check_type='0', is_raw_check='0', > current_check_attempt='1', max_check_attempts='3', > state='0', state_type='1', > start_time=FROM_UNIXTIME(1254718978), > start_time_usec='231137', end_time=FROM_UNIXTIME(0), > end_time_usec='0', timeout='30', early_timeout='0', > execution_time='0.000000', latency='0.230000', > return_code='0', output='', perfdata='(null)', > command_object_id='2', command_args='', > command_line='/usr/lib64/nagios/plugins/check_fping -H > xxxxx\.net\.xxxxxx -w 3000\.0,100% -c 3000\.0,100% -n 1' ON > DUPLICATE KEY UPDATE instance_id='1', host_object_id='1501', > check_type='0', is_raw_check='0', current_check_attempt='1', > max_check_attempts='3', state='0', state_type='1', > start_time=FROM_UNIXTIME(1254718978), > start_time_usec='231137', end_time=FROM_UNIXTIME(0), > end_time_usec='0', timeout='30', early_timeout='0', > execution_time='0.000000', latency='0.230000', > return_code='0', output='', perfdata='(null)' | > | 612 | root | localhost | nagios | Query | 0 | > NULL | show full processlist > > > > > On Mon, Oct 5, 2009 at 3:11 AM, shadih rahman > <<a href="mailto:shadhin71@gmail.com" target="_blank">shadhin71@gmail.com</a> <a href="mailto:shadhin71@gmail.com" target="_blank"><mailto:shadhin71@gmail.com></a>> wrote: > > I used alter table for all table mentioned in the patch. > > cat mysql-upgrade-1.4b8.sql > ALTER TABLE `nagios_hostchecks` ADD COLUMN `long_output` > varchar(8192) NOT NULL default '' AFTER `output`; > ALTER TABLE `nagios_hoststatus` ADD COLUMN `long_output` > varchar(8192) NOT NULL default '' AFTER `output`; > ALTER TABLE `nagios_servicechecks` ADD COLUMN > `long_output` varchar(8192) NOT NULL default '' AFTER > `output`; > ALTER TABLE `nagios_servicestatus` ADD COLUMN > `long_output` varchar(8192) NOT NULL default '' AFTER > `output`; > ALTER TABLE `nagios_statehistory` ADD COLUMN > `long_output` varchar(8192) NOT NULL default '' AFTER > `output`; > > ALTER TABLE `nagios_eventhandlers` ADD COLUMN > `long_output` varchar(8192) NOT NULL default '' AFTER > `output`; > ALTER TABLE `nagios_systemcommands` ADD COLUMN > `long_output` varchar(8192) NOT NULL default '' AFTER > `output`; > ALTER TABLE `nagios_notifications` ADD COLUMN > `long_output` varchar(8192) NOT NULL default '' AFTER > `output`; > > > > > mysql> desc nagios_hostchecks > -> ; > +-----------------------+---------------+------+-----+---------------------+----------------+ > | Field | Type | Null | Key | > Default | Extra | > +-----------------------+---------------+------+-----+---------------------+----------------+ > | hostcheck_id | int(11) | NO | PRI | > NULL | auto_increment | > | instance_id | smallint(6) | NO | MUL | > 0 | | > | host_object_id | int(11) | NO | | > 0 | | > | check_type | smallint(6) | NO | | > 0 | | > | is_raw_check | smallint(6) | NO | | > 0 | | > | current_check_attempt | smallint(6) | NO | | > 0 | | > | max_check_attempts | smallint(6) | NO | | > 0 | | > | state | smallint(6) | NO | | > 0 | | > | state_type | smallint(6) | NO | | > 0 | | > | start_time | datetime | NO | MUL | > 0000-00-00 00:00:00 | | > | start_time_usec | int(11) | NO | | > 0 | | > | end_time | datetime | NO | | > 0000-00-00 00:00:00 | | > | end_time_usec | int(11) | NO | | > 0 | | > | command_object_id | int(11) | NO | | > 0 | | > | command_args | varchar(255) | NO | > | | | > | command_line | varchar(255) | NO | > | | | > | timeout | smallint(6) | NO | | > 0 | | > | early_timeout | smallint(6) | NO | | > 0 | | > | execution_time | double | NO | | > 0 | | > | latency | double | NO | | > 0 | | > | return_code | smallint(6) | NO | | > 0 | | > | output | varchar(255) | NO | > | | | > | long_output | varchar(8192) | NO | > | | | > | perfdata | varchar(255) | NO | > | | | > +-----------------------+---------------+------+-----+---------------------+----------------+ > > > > > mysql> desc nagios_hoststatus; > +-------------------------------+---------------+------+-----+---------------------+----------------+ > | Field | Type | Null | > Key | Default | Extra | > +-------------------------------+---------------+------+-----+---------------------+----------------+ > | hoststatus_id | int(11) | NO | > PRI | NULL | auto_increment | > | instance_id | smallint(6) | NO > | | 0 | | > | host_object_id | int(11) | NO | > UNI | 0 | | > | status_update_time | datetime | NO > | | 0000-00-00 00:00:00 | | > | output | varchar(255) | NO > | | | | > | long_output | varchar(8192) | NO > | | | | > | perfdata | varchar(255) | NO > | | | | > | current_state | smallint(6) | NO > | | 0 | | > | has_been_checked | smallint(6) | NO > | | 0 | | > | should_be_scheduled | smallint(6) | NO > | | 0 | | > | current_check_attempt | smallint(6) | NO > | | 0 | | > | max_check_attempts | smallint(6) | NO > | | 0 | | > | last_check | datetime | NO > | | 0000-00-00 00:00:00 | | > | next_check | datetime | NO > | | 0000-00-00 00:00:00 | | > | check_type | smallint(6) | NO > | | 0 | | > | last_state_change | datetime | NO > | | 0000-00-00 00:00:00 | | > | last_hard_state_change | datetime | NO > | | 0000-00-00 00:00:00 | | > | last_hard_state | smallint(6) | NO > | | 0 | | > | last_time_up | datetime | NO > | | 0000-00-00 00:00:00 | | > | last_time_down | datetime | NO > | | 0000-00-00 00:00:00 | | > | last_time_unreachable | datetime | NO > | | 0000-00-00 00:00:00 | | > | state_type | smallint(6) | NO > | | 0 | | > | last_notification | datetime | NO > | | 0000-00-00 00:00:00 | | > | next_notification | datetime | NO > | | 0000-00-00 00:00:00 | | > | no_more_notifications | smallint(6) | NO > | | 0 | | > | notifications_enabled | smallint(6) | NO > | | 0 | | > | problem_has_been_acknowledged | smallint(6) | NO > | | 0 | | > | acknowledgement_type | smallint(6) | NO > | | 0 | | > | current_notification_number | smallint(6) | NO > | | 0 | | > | passive_checks_enabled | smallint(6) | NO > | | 0 | | > | active_checks_enabled | smallint(6) | NO > | | 0 | | > | event_handler_enabled | smallint(6) | NO > | | 0 | | > | flap_detection_enabled | smallint(6) | NO > | | 0 | | > | is_flapping | smallint(6) | NO > | | 0 | | > | percent_state_change | double | NO > | | 0 | | > | latency | double | NO > | | 0 | | > | execution_time | double | NO > | | 0 | | > | scheduled_downtime_depth | smallint(6) | NO > | | 0 | | > | failure_prediction_enabled | smallint(6) | NO > | | 0 | | > | process_performance_data | smallint(6) | NO > | | 0 | | > | obsess_over_host | smallint(6) | NO > | | 0 | | > | modified_host_attributes | int(11) | NO > | | 0 | | > | event_handler | varchar(255) | NO > | | | | > | check_command | varchar(255) | NO > | | | | > | normal_check_interval | double | NO > | | 0 | | > | retry_check_interval | double | NO > | | 0 | | > | check_timeperiod_object_id | int(11) | NO > | | 0 | | > +-------------------------------+---------------+------+-----+---------------------+----------------+ > 47 rows in set (0.00 sec) > > > > mysql> desc nagios_servicechecks; > +-----------------------+---------------+------+-----+---------------------+----------------+ > | Field | Type | Null | Key | > Default | Extra | > +-----------------------+---------------+------+-----+---------------------+----------------+ > | servicecheck_id | int(11) | NO | PRI | > NULL | auto_increment | > | instance_id | smallint(6) | NO | MUL | > 0 | | > | service_object_id | int(11) | NO | | > 0 | | > | check_type | smallint(6) | NO | | > 0 | | > | current_check_attempt | smallint(6) | NO | | > 0 | | > | max_check_attempts | smallint(6) | NO | | > 0 | | > | state | smallint(6) | NO | | > 0 | | > | state_type | smallint(6) | NO | | > 0 | | > | start_time | datetime | NO | | > 0000-00-00 00:00:00 | | > | start_time_usec | int(11) | NO | | > 0 | | > | end_time | datetime | NO | | > 0000-00-00 00:00:00 | | > | end_time_usec | int(11) | NO | | > 0 | | > | command_object_id | int(11) | NO | | > 0 | | > | command_args | varchar(255) | NO | > | | | > | command_line | varchar(255) | NO | > | | | > | timeout | smallint(6) | NO | | > 0 | | > | early_timeout | smallint(6) | NO | | > 0 | | > | execution_time | double | NO | | > 0 | | > | latency | double | NO | | > 0 | | > | return_code | smallint(6) | NO | | > 0 | | > | output | varchar(255) | NO | > | | | > | long_output | varchar(8192) | NO | > | | | > | perfdata | varchar(255) | NO | > | | | > +-----------------------+---------------+------+-----+---------------------+----------------+ > 23 rows in set (0.00 sec) > > mysql> desc nagios_servicestatus; > +-------------------------------+---------------+------+-----+---------------------+----------------+ > | Field | Type | Null | > Key | Default | Extra | > +-------------------------------+---------------+------+-----+---------------------+----------------+ > | servicestatus_id | int(11) | NO | > PRI | NULL | auto_increment | > | instance_id | smallint(6) | NO > | | 0 | | > | service_object_id | int(11) | NO | > UNI | 0 | | > | status_update_time | datetime | NO > | | 0000-00-00 00:00:00 | | > | output | varchar(255) | NO > | | | | > | long_output | varchar(8192) | NO > | | | | > | perfdata | varchar(255) | NO > | | | | > | current_state | smallint(6) | NO > | | 0 | | > | has_been_checked | smallint(6) | NO > | | 0 | | > | should_be_scheduled | smallint(6) | NO > | | 0 | | > | current_check_attempt | smallint(6) | NO > | | 0 | | > | max_check_attempts | smallint(6) | NO > | | 0 | | > | last_check | datetime | NO > | | 0000-00-00 00:00:00 | | > | next_check | datetime | NO > | | 0000-00-00 00:00:00 | | > | check_type | smallint(6) | NO > | | 0 | | > | last_state_change | datetime | NO > | | 0000-00-00 00:00:00 | | > | last_hard_state_change | datetime | NO > | | 0000-00-00 00:00:00 | | > | last_hard_state | smallint(6) | NO > | | 0 | | > | last_time_ok | datetime | NO > | | 0000-00-00 00:00:00 | | > | last_time_warning | datetime | NO > | | 0000-00-00 00:00:00 | | > | last_time_unknown | datetime | NO > | | 0000-00-00 00:00:00 | | > | last_time_critical | datetime | NO > | | 0000-00-00 00:00:00 | | > | state_type | smallint(6) | NO > | | 0 | | > | last_notification | datetime | NO > | | 0000-00-00 00:00:00 | | > | next_notification | datetime | NO > | | 0000-00-00 00:00:00 | | > | no_more_notifications | smallint(6) | NO > | | 0 | | > | notifications_enabled | smallint(6) | NO > | | 0 | | > | problem_has_been_acknowledged | smallint(6) | NO > | | 0 | | > | acknowledgement_type | smallint(6) | NO > | | 0 | | > | current_notification_number | smallint(6) | NO > | | 0 | | > | passive_checks_enabled | smallint(6) | NO > | | 0 | | > | active_checks_enabled | smallint(6) | NO > | | 0 | | > | event_handler_enabled | smallint(6) | NO > | | 0 | | > | flap_detection_enabled | smallint(6) | NO > | | 0 | | > | is_flapping | smallint(6) | NO > | | 0 | | > | percent_state_change | double | NO > | | 0 | | > | latency | double | NO > | | 0 | | > | execution_time | double | NO > | | 0 | | > | scheduled_downtime_depth | smallint(6) | NO > | | 0 | | > | failure_prediction_enabled | smallint(6) | NO > | | 0 | | > | process_performance_data | smallint(6) | NO > | | 0 | | > | obsess_over_service | smallint(6) | NO > | | 0 | | > | modified_service_attributes | int(11) | NO > | | 0 | | > | event_handler | varchar(255) | NO > | | | | > | check_command | varchar(255) | NO > | | | | > | normal_check_interval | double | NO > | | 0 | | > | retry_check_interval | double | NO > | | 0 | | > | check_timeperiod_object_id | int(11) | NO > | | 0 | | > +-------------------------------+---------------+------+-----+---------------------+----------------+ > 48 rows in set (0.00 sec) > > > > > > > > On Mon, Oct 5, 2009 at 12:32 AM, Michael Friedrich > <<a href="mailto:michael.friedrich@univie.ac.at" target="_blank">michael.friedrich@univie.ac.at</a> > <a href="mailto:michael.friedrich@univie.ac.at" target="_blank"><mailto:michael.friedrich@univie.ac.at></a>> wrote: > > Did you apply the mysql patch for 1.4b8 since there > was an introduction in long_output ? > > shadih rahman wrote: >> All, >> I have updated to ndoutils 1.48 and followed the >> instruction to do so. Now I am seeing that I am >> missing output column data from both >> nagios_hostchecks and nagios_servicechecks tables. >> >> Below I am attaching a query and output to show you >> the behavior. Please advise on this. thanks >> >> >> >> >> select start_time, output from nagios_hostchecks >> where host_object_id =265; >> >> >> 2009-09-08 18:20:31 | FPING OK - >> <a href="http://cocoa.cc.columbia.edu" target="_blank">cocoa.cc.columbia.edu</a> >> <a href="http://cocoa.cc.columbia.edu" target="_blank"><http://cocoa.cc.columbia.edu></a> (loss=0%, >> rta=0.270000 ms) | >> >> | 2009-09-08 18:25:45 | FPING OK - >> <a href="http://cocoa.cc.columbia.edu" target="_blank">cocoa.cc.columbia.edu</a> >> <a href="http://cocoa.cc.columbia.edu" target="_blank"><http://cocoa.cc.columbia.edu></a> (loss=0%, >> rta=1.300000 ms) | >> >> | 2009-09-08 18:34:15 >> | >> | >> >> | 2009-09-09 18:48:31 >> | >> | >> >> | 2009-09-09 18:53:32 >> | >> | >> >> | 2009-09-09 18:58:42 >> | >> | >> >> | 2009-09-09 19:03:52 >> | >> | >> >> -- >> Cordially, >> Shadhin Rahman >> ---------------------------------------------------------------------- >> >> ------------------------------------------------------------------------------ >> Come build with us! The BlackBerry® Developer Conference in SF, CA >> is the only developer event you need to attend this year. Jumpstart your >> developing skills, take BlackBerry mobile applications to market and stay >> ahead of the curve. Join us from November 9-12, 2009. Register now! >> <a href="http://p.sf.net/sfu/devconf" target="_blank">http://p.sf.net/sfu/devconf</a> >> ---------------------------------------------------------------------- >> >> _______________________________________________ >> Nagios-devel mailing list >> <a href="mailto:Nagios-devel@lists.sourceforge.net" target="_blank">Nagios-devel@lists.sourceforge.net</a> <a href="mailto:Nagios-devel@lists.sourceforge.net" target="_blank"><mailto:Nagios-devel@lists.sourceforge.net></a> >> <a href="https://lists.sourceforge.net/lists/listinfo/nagios-devel" target="_blank">https://lists.sourceforge.net/lists/listinfo/nagios-devel</a> >> > > ------------------------------------------------------------------------------ > Come build with us! The BlackBerry® Developer > Conference in SF, CA > is the only developer event you need to attend this > year. Jumpstart your > developing skills, take BlackBerry mobile > applications to market and stay > ahead of the curve. Join us from November 9-12, > 2009. Register now! > <a href="http://p.sf.net/sfu/devconf" target="_blank">http://p.sf.net/sfu/devconf</a> > _______________________________________________ > Nagios-devel mailing list > <a href="mailto:Nagios-devel@lists.sourceforge.net" target="_blank">Nagios-devel@lists.sourceforge.net</a> > <a href="mailto:Nagios-devel@lists.sourceforge.net" target="_blank"><mailto:Nagios-devel@lists.sourceforge.net></a> > <a href="https://lists.sourceforge.net/lists/listinfo/nagios-devel" target="_blank">https://lists.sourceforge.net/lists/listinfo/nagios-devel</a> > > > > > -- > Cordially, > Shadhin Rahman > > > > > -- > Cordially, > Shadhin Rahman > > > > > -- > Cordially, > Shadhin Rahman > > > > > -- > Cordially, > Shadhin Rahman > > > ------------------------------------------------------------------------------ > Come build with us! The BlackBerry® Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9-12, 2009. Register now! > <a href="http://p.sf.net/sfu/devconf" target="_blank">http://p.sf.net/sfu/devconf</a> > > > _______________________________________________ > Nagios-devel mailing list > <a href="mailto:Nagios-devel@lists.sourceforge.net" target="_blank">Nagios-devel@lists.sourceforge.net</a> > <a href="https://lists.sourceforge.net/lists/listinfo/nagios-devel" target="_blank">https://lists.sourceforge.net/lists/listinfo/nagios-devel</a> -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) iD8DBQFKybQBlI0PwfxLQjkRAtWmAJoD01z28GCSBpaRHnHjVDuEIIxuPQCeMdIi P3xNnjaa918hri5WR3BRcJw= =5j+S -----END PGP SIGNATURE----- </div> ------------------------------------------------------------------------------ Come build with us! The BlackBerry® Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9-12, 2009. Register now! <a href="http://p.sf.net/sfu/devconf" target="_blank">http://p.sf.net/sfu/devconf</a> _______________________________________________ Nagios-devel mailing list <a href="mailto:Nagios-devel@lists.sourceforge.net">Nagios-devel@lists.sourceforge.net</a> <a href="https://lists.sourceforge.net/lists/listinfo/nagios-devel" target="_blank">https://lists.sourceforge.net/lists/listinfo/nagios-devel</a> </blockquote></div> -- Cordially, Shadhin Rahman