Re: [Nagios-devel] ndoutils missing output column from
Posted: Fri Oct 02, 2009 6:12 pm
--001636ed75670ae0b10474f88a33
Content-Type: text/plain; charset=ISO-8859-1
I meant to say the version of ndoUtils is 1.4b8 .
On Fri, Oct 2, 2009 at 1:42 PM, 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 - cocoa.cc.columbia.edu (loss=0%,
> rta=0.270000 ms) |
>
> | 2009-09-08 18:25:45 | FPING OK - cocoa.cc.columbia.edu (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
>
--
Cordially,
Shadhin Rahman
--001636ed75670ae0b10474f88a33
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: base64
SSBtZWFudCB0byBzYXkgdGhlIHZlcnNpb24gb2YgbmRvVXRpbHMgaXMgMS40YjggLjxicj48YnI+
PGRpdiBjbGFzcz0iZ21haWxfcXVvdGUiPk9uIEZyaSwgT2N0IDIsIDIwMDkgYXQgMTo0MiBQTSwg
c2hhZGloIHJhaG1hbiA8c3BhbiBkaXI9Imx0ciI+Jmx0OzxhIGhyZWY9Im1haWx0bzpzaGFkaGlu
NzFAZ21haWwuY29tIj5zaGFkaGluNzFAZ21haWwuY29tPC9hPiZndDs8L3NwYW4+IHdyb3RlOjxi
cj4KPGJsb2NrcXVvdGUgY2xhc3M9ImdtYWlsX3F1b3RlIiBzdHlsZT0iYm9yZGVyLWxlZnQ6IDFw
eCBzb2xpZCByZ2IoMjA0LCAyMDQsIDIwNCk7IG1hcmdpbjogMHB0IDBwdCAwcHQgMC44ZXg7IHBh
ZGRpbmctbGVmdDogMWV4OyI+QWxsLDxicj6goCBJIGhhdmUgdXBkYXRlZCB0byBuZG91dGlscyAx
LjQ4IGFuZCBmb2xsb3dlZCB0aGUgaW5zdHJ1Y3Rpb24gdG8gZG8gc28uoCBOb3cgSSBhbSBzZWVp
bmcgdGhhdCBJIGFtIG1pc3Npbmcgb3V0cHV0IGNvbHVtbiBkYXRhIGZyb20gYm90aCBuYWdpb3Nf
aG9zdGNoZWNrcyBhbmQgbmFnaW9zX3NlcnZpY2VjaGVja3MgdGFibGVzLjxicj4KPGJyPkJlbG93
IEkgYW0gYXR0YWNoaW5nIGEgcXVlcnkgYW5kIG91dHB1dCB0byBzaG93IHlvdSB0aGUgYmVoYXZp
b3IuoCBQbGVhc2UgYWR2aXNlIG9uIHRoaXMuoCB0aGFua3M8YnI+Cjxicj48YnI+PGJyPjxicj6g
c2VsZWN0IHN0YXJ0X3RpbWUsIG91dHB1dCBmcm9tIG5hZ2lvc19ob3N0Y2hlY2tzIHdoZXJlIGhv
c3Rfb2JqZWN0X2lkID0yNjU7PGJyPjxicj48YnI+oDIwMDktMDktMDggMTg6MjA6MzEgfCBGUElO
RyBPSyAtIDxhIGhyZWY9Imh0dHA6Ly9jb2NvYS5jYy5jb2x1bWJpYS5lZHUiIHRhcmdldD0iX2Js
YW5rIj5jb2NvYS5jYy5jb2x1bWJpYS5lZHU8L2E+IChsb3NzPTAlLCBydGE9MC4yNzAwMDAgbXMp
IHwgPGJyPgoKPGJyPnwgMjAwOS0wOS0wOCAxODoyNTo0NSB8IEZQSU5HIE9LIC0gPGEgaHJlZj0i
aHR0cDovL2NvY29hLmNjLmNvbHVtYmlhLmVkdSIgdGFyZ2V0PSJfYmxhbmsiPmNvY29hLmNjLmNv
bHVtYmlhLmVkdTwvYT4gKGxvc3M9MCUsIHJ0YT0xLjMwMDAwMCBtcykgfCA8YnI+PGJyPnwgMjAw
OS0wOS0wOCAxODozNDoxNSB8oKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCg
oKCgoKCgoKCgoKCgoKCgoKCgoKCgIHwgPGJyPgoKPGJyPnwgMjAwOS0wOS0wOSAxODo0ODozMSB8
oKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCg
oKCgIHwgPGJyPjxicj58IDIwMDktMDktMDkgMTg6NTM6MzIgfKCgoKCgoKCgoKCgoKCgoKCgoKCg
oKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoCB8IDxicj48YnI+fCAyMDA5
LTA5LTA5IDE4OjU4OjQyIHygoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCg
oKCgoKCgoKCgoKCgoKCgoKCgoKAgfCA8YnI+Cgo8YnI+fCAyMDA5LTA5LTA5IDE5OjAzOjUyIHyg
oKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCg
oKAgfDxiciBjbGVhcj0iYWxsIj48Zm9udCBjb2xvcj0iIzg4ODg4OCI+PGJyPi0tIDxicj5Db3Jk
aWFsbHksPGJyPlNoYWRoaW4gUmFobWFuPGJyPgo8L2ZvbnQ+PC9ibG9ja3F1b3RlPjwvZGl2Pjxi
cj48YnIgY2xlYXI9ImFsbCI+PGJyPi0tIDxicj5Db3JkaWFsbHksPGJyPlNoYWRoaW4gUmFobWFu
PGJyPgo=
--001636ed75670ae0b10474f88a33--
This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]
Content-Type: text/plain; charset=ISO-8859-1
I meant to say the version of ndoUtils is 1.4b8 .
On Fri, Oct 2, 2009 at 1:42 PM, 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 - cocoa.cc.columbia.edu (loss=0%,
> rta=0.270000 ms) |
>
> | 2009-09-08 18:25:45 | FPING OK - cocoa.cc.columbia.edu (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
>
--
Cordially,
Shadhin Rahman
--001636ed75670ae0b10474f88a33
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: base64
SSBtZWFudCB0byBzYXkgdGhlIHZlcnNpb24gb2YgbmRvVXRpbHMgaXMgMS40YjggLjxicj48YnI+
PGRpdiBjbGFzcz0iZ21haWxfcXVvdGUiPk9uIEZyaSwgT2N0IDIsIDIwMDkgYXQgMTo0MiBQTSwg
c2hhZGloIHJhaG1hbiA8c3BhbiBkaXI9Imx0ciI+Jmx0OzxhIGhyZWY9Im1haWx0bzpzaGFkaGlu
NzFAZ21haWwuY29tIj5zaGFkaGluNzFAZ21haWwuY29tPC9hPiZndDs8L3NwYW4+IHdyb3RlOjxi
cj4KPGJsb2NrcXVvdGUgY2xhc3M9ImdtYWlsX3F1b3RlIiBzdHlsZT0iYm9yZGVyLWxlZnQ6IDFw
eCBzb2xpZCByZ2IoMjA0LCAyMDQsIDIwNCk7IG1hcmdpbjogMHB0IDBwdCAwcHQgMC44ZXg7IHBh
ZGRpbmctbGVmdDogMWV4OyI+QWxsLDxicj6goCBJIGhhdmUgdXBkYXRlZCB0byBuZG91dGlscyAx
LjQ4IGFuZCBmb2xsb3dlZCB0aGUgaW5zdHJ1Y3Rpb24gdG8gZG8gc28uoCBOb3cgSSBhbSBzZWVp
bmcgdGhhdCBJIGFtIG1pc3Npbmcgb3V0cHV0IGNvbHVtbiBkYXRhIGZyb20gYm90aCBuYWdpb3Nf
aG9zdGNoZWNrcyBhbmQgbmFnaW9zX3NlcnZpY2VjaGVja3MgdGFibGVzLjxicj4KPGJyPkJlbG93
IEkgYW0gYXR0YWNoaW5nIGEgcXVlcnkgYW5kIG91dHB1dCB0byBzaG93IHlvdSB0aGUgYmVoYXZp
b3IuoCBQbGVhc2UgYWR2aXNlIG9uIHRoaXMuoCB0aGFua3M8YnI+Cjxicj48YnI+PGJyPjxicj6g
c2VsZWN0IHN0YXJ0X3RpbWUsIG91dHB1dCBmcm9tIG5hZ2lvc19ob3N0Y2hlY2tzIHdoZXJlIGhv
c3Rfb2JqZWN0X2lkID0yNjU7PGJyPjxicj48YnI+oDIwMDktMDktMDggMTg6MjA6MzEgfCBGUElO
RyBPSyAtIDxhIGhyZWY9Imh0dHA6Ly9jb2NvYS5jYy5jb2x1bWJpYS5lZHUiIHRhcmdldD0iX2Js
YW5rIj5jb2NvYS5jYy5jb2x1bWJpYS5lZHU8L2E+IChsb3NzPTAlLCBydGE9MC4yNzAwMDAgbXMp
IHwgPGJyPgoKPGJyPnwgMjAwOS0wOS0wOCAxODoyNTo0NSB8IEZQSU5HIE9LIC0gPGEgaHJlZj0i
aHR0cDovL2NvY29hLmNjLmNvbHVtYmlhLmVkdSIgdGFyZ2V0PSJfYmxhbmsiPmNvY29hLmNjLmNv
bHVtYmlhLmVkdTwvYT4gKGxvc3M9MCUsIHJ0YT0xLjMwMDAwMCBtcykgfCA8YnI+PGJyPnwgMjAw
OS0wOS0wOCAxODozNDoxNSB8oKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCg
oKCgoKCgoKCgoKCgoKCgoKCgoKCgIHwgPGJyPgoKPGJyPnwgMjAwOS0wOS0wOSAxODo0ODozMSB8
oKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCg
oKCgIHwgPGJyPjxicj58IDIwMDktMDktMDkgMTg6NTM6MzIgfKCgoKCgoKCgoKCgoKCgoKCgoKCg
oKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoCB8IDxicj48YnI+fCAyMDA5
LTA5LTA5IDE4OjU4OjQyIHygoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCg
oKCgoKCgoKCgoKCgoKCgoKCgoKAgfCA8YnI+Cgo8YnI+fCAyMDA5LTA5LTA5IDE5OjAzOjUyIHyg
oKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCg
oKAgfDxiciBjbGVhcj0iYWxsIj48Zm9udCBjb2xvcj0iIzg4ODg4OCI+PGJyPi0tIDxicj5Db3Jk
aWFsbHksPGJyPlNoYWRoaW4gUmFobWFuPGJyPgo8L2ZvbnQ+PC9ibG9ja3F1b3RlPjwvZGl2Pjxi
cj48YnIgY2xlYXI9ImFsbCI+PGJyPi0tIDxicj5Db3JkaWFsbHksPGJyPlNoYWRoaW4gUmFobWFu
PGJyPgo=
--001636ed75670ae0b10474f88a33--
This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]