Re: [Nagios-devel] ndoutils missing output column
Posted: Mon Oct 05, 2009 7:53 am
This is a multi-part message in MIME format.
--------------060604070208060507070204
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
-----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
>
> http://tracker.nagios.org/view.php?id=73
>
>
> On Mon, Oct 5, 2009 at 5:08 AM, shadih rahman > wrote:
>
> Can someone advise why was characterset change to latin1 ?
>
>
> On Mon, Oct 5, 2009 at 5:06 AM, shadih rahman
> > 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
> > wrote:
>
> I used alter table for all
...[email truncated]...
This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]
--------------060604070208060507070204
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
-----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
>
> http://tracker.nagios.org/view.php?id=73
>
>
> On Mon, Oct 5, 2009 at 5:08 AM, shadih rahman > wrote:
>
> Can someone advise why was characterset change to latin1 ?
>
>
> On Mon, Oct 5, 2009 at 5:06 AM, shadih rahman
> > 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
> > wrote:
>
> I used alter table for all
...[email truncated]...
This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]