Page 1 of 1

Re: [Nagios-devel] ndoutils missing output column from

Posted: Mon Oct 05, 2009 1:23 pm
by Guest
--001636ed690d29ab9b047530dc82
Content-Type: text/plain; charset=ISO-8859-1

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

On Mon, Oct 5, 2009 at 4:53 AM, Hendrik Baecker wrote:

> -----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',
> >

...[email truncated]...


This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]