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

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
Locked
Guest

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

Post 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]
Locked