Re: [Nagios-users] Monitor Windows 2003 using nagios + SNMP

[Aaron K. Moore]

Have you added the IP address of your Nagios server to the SNMP allowed list of 
the SNMP service in Windows?  By default it only allows localhost queries.

--
Aaron Kent Moore
Information Technology Services
DeKalb Memorial Hospital, Inc.
Auburn, Indiana


> -Original Message-
> From: arly arly [mailto:arly...@gmail.com] 
> Sent: Thursday, August 06, 2009 2:43 PM
> To: Richard Remington
> Cc: nagios-users@lists.sourceforge.net
> Subject: Re: [Nagios-users] Monitor Windows 2003 using nagios + SNMP
> 
> HI Richard,
> 
> thank you for comment.
> 
> comunity string I set up as for machines I have it works OK. 
> Comunity string is same, and let say it is "niceday" but it 
> is same on all machines I have plan to monitor.
> 
> I tried all, but it I am really stuck, same configuration ( 
> which I btw just copy /paste to machines behind firewal  ) 
> works corretly on machines which are direct accessable from 
> nagios server.
> 
> I have port 161 open.
> 
> Thank you all for comment, I need to hear your experiences 
> regarding this
> 
> Kind regards,
> 
> Arlytex
> 
> 
> 
> 2009/8/6 Richard Remington :
> > Hi Arlytex,
> >
> > Is it possible that the SNMP password (community string) is 
> not 'public' on your Windows 2003 servers that are behind the 
> firewall? Perhaps if they're behind a firewall, someone also 
> went to the trouble to change the SNMP community string 
> (password) to reach them?
> >
> > Regards,
> >
> > Richard
> >
> > arly arly wrote:
> >> Hi all,
> >>
> >> I am using nagios3 and I would like an monitoring system for my 
> >> network. I have cca 10 hosts in "my network" but they are behind 
> >> firewall.
> >> I mean in "my network" which is not exposed to outside world, some 
> >> machines are behidn firewals in.
> >>
> >> Critical machines run Windows 2003 server OS, and I tried to use
> >> NSClient++, in combination with check_nrpe ( I tried both 
> ports 5666
> >> and 12489 ) and I can get information from windows 
> servers--checking 
> >> them with check_nrpe looks ok.
> >>
> >> Then I realized that with SNMP I could better informations 
> ( tested 
> >> on machines directly accessible from nagios server ) and 
> decided to 
> >> copy/paste working SNMP configuration from windows 
> machines and add 
> >> necessary servers to nagios conf files and have all 
> unified via SNMP 
> >> monitoring. I am using *.pl scripts from 
> >> http://nagios.manubulon.com/snmp_storage.html and for machines 
> >> directly accessible all is ok
> >>
> >> But I got into troubles for servers behind firewall :) 
> Ports 161/162 
> >> ( UDP/TCP ) are open on firewal to windows servers
> >>
> >> When I run
> >> ./check_snmp_storage.pl -H AAA.AAA.AAA.AAA -C public -m 
> ^C: -w 80 -c 
> >> 90 ( AAA.AAA.AAA.AAA address of win. machine behind firewal ) I am 
> >> getting an error
> >>
> >> ERROR: Description/Type table : No response from remote 
> host 'AAA.AAA.AAA.AAA'.
> >> what means no return information from server. First I suspected on 
> >> connectivity and I moved SNMP to listen on another port, 
> run command 
> >> ./check_snmp_storage.pl -H AAA.AAA.AAA.AAA -C public -m 
> ^C: -w 80 -c 
> >> 90 --port  but same issue ( this process works when I 
> test it on 
> >> machines which are not behind firewall ) On windows 
> machine netstat 
> >> -a shows
> >>
> >>  UDP    server:snmp        *:*
> >>  UDP    server:snmptrap    *:*
> >>
> >> what means snmp is listenning ( same configuration of SNMP service 
> >> works ok for machines which are in same net as nagios server )
> >>
> >> I am suspection it could something to do with SNMP client / SNMP 
> >> protocol how it works, as I am getting correct response 
> when I sent 
> >> it to 5666 + check_nrpe.
> >>
> >> Any reasonable hint what I could check will very useful, 
> so thank you 
> >> in advance. I am preety lost I do not really know what to 
> check more 
> >> in order to resolve this.
> >>
> >> Operating system I use for nagios server is Debian stable 5, I am 
> >> very sure configuration of SNMP on Windows servers is 
> correct. HW I 
> >> am want to monitor are HP Proliants DL360 G5, DL380 G5
> >>
> >> Kind regards,
> >>
> >> Arlytex
> >>
> >> 
> -
> >> - Let Crystal Reports handle the reporting - Free Crystal 
> >> Reports 2008 30-Day trial. Simplify your report design, 
> integration 
> >> and deployment - and focus on what you do best, core application 
> >> coding. Discover what's new with Crystal Reports now.  
> >> http://p.sf.net/sfu/bobj-july 
> >> ___
> >> Nagios-users mailing list
> >> Nagios-users@lists.sourceforge.net
> >> https://lists.sourceforge.net/lists/listinfo/nagios-users
> >> ::: Please include Nagios version, plugin version (-v) and 
> OS when reporting any issue.
> >> ::: Messages without supporting info will risk being sent to 
> >> /dev/null
> >>
> >>
> >
> >
> > 
> --

Re: [Nagios-users] Monitor Windows 2003 using nagios + SNMP

[arly arly]

good question :) actually I cannot see direcly my windows machines
directly from my nagios server, there is firewall between them. So as
IP address represented to Windows machines is ip address of firewall.
When I use check_nrpe and on windows conf. file nsc.ini put ip address
of firewall, it works.
So I included in "traps destinatin " ip address of firewall but still
same problem.

Thank you for commnet and your time

Regards,

Arlytex



2009/8/7 Aaron K. Moore :
> Have you added the IP address of your Nagios server to the SNMP allowed list 
> of the SNMP service in Windows?  By default it only allows localhost queries.
>
> --
> Aaron Kent Moore
> Information Technology Services
> DeKalb Memorial Hospital, Inc.
> Auburn, Indiana
>
>
>> -Original Message-
>> From: arly arly [mailto:arly...@gmail.com]
>> Sent: Thursday, August 06, 2009 2:43 PM
>> To: Richard Remington
>> Cc: nagios-users@lists.sourceforge.net
>> Subject: Re: [Nagios-users] Monitor Windows 2003 using nagios + SNMP
>>
>> HI Richard,
>>
>> thank you for comment.
>>
>> comunity string I set up as for machines I have it works OK.
>> Comunity string is same, and let say it is "niceday" but it
>> is same on all machines I have plan to monitor.
>>
>> I tried all, but it I am really stuck, same configuration (
>> which I btw just copy /paste to machines behind firewal  )
>> works corretly on machines which are direct accessable from
>> nagios server.
>>
>> I have port 161 open.
>>
>> Thank you all for comment, I need to hear your experiences
>> regarding this
>>
>> Kind regards,
>>
>> Arlytex
>>
>>
>>
>> 2009/8/6 Richard Remington :
>> > Hi Arlytex,
>> >
>> > Is it possible that the SNMP password (community string) is
>> not 'public' on your Windows 2003 servers that are behind the
>> firewall? Perhaps if they're behind a firewall, someone also
>> went to the trouble to change the SNMP community string
>> (password) to reach them?
>> >
>> > Regards,
>> >
>> > Richard
>> >
>> > arly arly wrote:
>> >> Hi all,
>> >>
>> >> I am using nagios3 and I would like an monitoring system for my
>> >> network. I have cca 10 hosts in "my network" but they are behind
>> >> firewall.
>> >> I mean in "my network" which is not exposed to outside world, some
>> >> machines are behidn firewals in.
>> >>
>> >> Critical machines run Windows 2003 server OS, and I tried to use
>> >> NSClient++, in combination with check_nrpe ( I tried both
>> ports 5666
>> >> and 12489 ) and I can get information from windows
>> servers--checking
>> >> them with check_nrpe looks ok.
>> >>
>> >> Then I realized that with SNMP I could better informations
>> ( tested
>> >> on machines directly accessible from nagios server ) and
>> decided to
>> >> copy/paste working SNMP configuration from windows
>> machines and add
>> >> necessary servers to nagios conf files and have all
>> unified via SNMP
>> >> monitoring. I am using *.pl scripts from
>> >> http://nagios.manubulon.com/snmp_storage.html and for machines
>> >> directly accessible all is ok
>> >>
>> >> But I got into troubles for servers behind firewall :)
>> Ports 161/162
>> >> ( UDP/TCP ) are open on firewal to windows servers
>> >>
>> >> When I run
>> >> ./check_snmp_storage.pl -H AAA.AAA.AAA.AAA -C public -m
>> ^C: -w 80 -c
>> >> 90 ( AAA.AAA.AAA.AAA address of win. machine behind firewal ) I am
>> >> getting an error
>> >>
>> >> ERROR: Description/Type table : No response from remote
>> host 'AAA.AAA.AAA.AAA'.
>> >> what means no return information from server. First I suspected on
>> >> connectivity and I moved SNMP to listen on another port,
>> run command
>> >> ./check_snmp_storage.pl -H AAA.AAA.AAA.AAA -C public -m
>> ^C: -w 80 -c
>> >> 90 --port  but same issue ( this process works when I
>> test it on
>> >> machines which are not behind firewall ) On windows
>> machine netstat
>> >> -a shows
>> >>
>> >>  UDP    server:snmp        *:*
>> >>  UDP    server:snmptrap    *:*
>> >>
>> >> what means snmp is listenning ( same configuration of SNMP service
>> >> works ok for machines which are in same net as nagios server )
>> >>
>> >> I am suspection it could something to do with SNMP client / SNMP
>> >> protocol how it works, as I am getting correct response
>> when I sent
>> >> it to 5666 + check_nrpe.
>> >>
>> >> Any reasonable hint what I could check will very useful,
>> so thank you
>> >> in advance. I am preety lost I do not really know what to
>> check more
>> >> in order to resolve this.
>> >>
>> >> Operating system I use for nagios server is Debian stable 5, I am
>> >> very sure configuration of SNMP on Windows servers is
>> correct. HW I
>> >> am want to monitor are HP Proliants DL360 G5, DL380 G5
>> >>
>> >> Kind regards,
>> >>
>> >> Arlytex
>> >>
>> >>
>> -
>> >> - Let Crystal Reports handle the reporting - Free Crystal
>> >> Reports 2008 30-Day trial. Simplify your report design,
>> integration
>> >> and deployment - and focus on what yo

Re: [Nagios-users] Monitor Windows 2003 using nagios + SNMP

[arly arly]

Hi Kevin,

thank you for extensive mail and time you spent on it.

-- Yes, I enabled SNMP on windows server, set up comunity name, and
all necessary stuff---I have working configuration
 for SNMP on machines which are not behind firewal and it works,and I
just did copy/paste.

--- Yes, it uses nat, and I am specifiying firewal's address in check-command
When I am using check_nrpe + NSCClient++ on port 5666 it works

--- Not so much specific information, than usual, but with SNMP I do
not need some addiional software, only stuff
from included in Windows + Prolinat plugins from HP web site.

I would use NSCClient++ and various stuff, but I am just small
sys-admin and other ( higher ISO levels :):) ) are not satisfied with
" some " plugins, they trust more Microsoft.

Regarding Nagios, I persued them to use, and they will just get web
link to browse what they are interested for.
So this is reason why I would like to monitoring using SNMP on windows
machines---it is already included in Windows 2003 server

I will take a look into plugins you are writing. Thank you for links.


Kind regards,


Arlytex

2009/8/6 Kevin Keane :
> A couple of notes:
>
> - SNMP runs over UDP while NRPE uses TCP. UDP can be more finicky with
> the firewall, because it is more difficult for the firewall to match up
> the response with the original message.
>
> - Stupid question: did you enable SNMP on the Windows server, and
> configure it (by default, the Windows SNMP agent does NOT use the public
> community).
>
> - If the firewall uses NAT, remember that you need to specify the
> firewall's IP address in the check-command, and you need to configure
> the firewall to send the traffic to the actual server you want to
> monitor. I'm sure you already have that set up correctly, since you'd
> need the same thing for the NRPE test that you said works.
>
> - What specific "better information" do you get via SNMP? The reason I'm
> asking is that I wrote a very extensive (and still growing) set of
> plugins that may give you the information you need - and if those
> plugins don't give you what you need, let me know, and I can probably
> add one that does. The plugins should work with NSClient++ although I
> haven't tested it. This plugin collection is on Sourceforge as
> http://sourceforge.net/projects/tntnagiosplugin/
>
> - For my own monitoring, I wrote yet another Windows agent specifically
> to deal with firewall issues. It does not need any ports opened in the
> firewall at all, since the traffic goes in the opposite direction. It
> uses basically NSCA, but transports it over SSL and HTTPS so you can
> safely send it over the public Internet. That is at
> http://www.tntmonitoring.com And of course it uses the plugin collection
> I mentioned earlier.
>
> arly arly wrote:
>> Hi all,
>>
>> I am using nagios3 and I would like an monitoring system for my
>> network. I have cca 10 hosts in "my network" but they are behind
>> firewall.
>> I mean in "my network" which is not exposed to outside world, some
>> machines are behidn firewals in.
>>
>> Critical machines run Windows 2003 server OS, and I tried to use
>> NSClient++, in combination with check_nrpe ( I tried both ports 5666
>> and 12489 ) and I can get information from windows servers--checking
>> them with check_nrpe looks ok.
>>
>> Then I realized that with SNMP I could better informations ( tested on
>> machines directly accessible from nagios server ) and decided to
>> copy/paste working SNMP configuration from windows machines and add
>> necessary servers to nagios conf files and have all unified via SNMP
>> monitoring. I am using *.pl scripts from
>> http://nagios.manubulon.com/snmp_storage.html and for machines
>> directly accessible all is ok
>>
>> But I got into troubles for servers behind firewall :) Ports 161/162 (
>> UDP/TCP ) are open on firewal to windows servers
>>
>> When I run
>> ./check_snmp_storage.pl -H AAA.AAA.AAA.AAA -C public -m ^C: -w 80 -c
>> 90 ( AAA.AAA.AAA.AAA address of win. machine behind firewal ) I am
>> getting an error
>>
>> ERROR: Description/Type table : No response from remote host 
>> 'AAA.AAA.AAA.AAA'.
>> what means no return information from server. First I suspected on
>> connectivity and I moved SNMP to listen on another port, run command
>> ./check_snmp_storage.pl -H AAA.AAA.AAA.AAA -C public -m ^C: -w 80 -c
>> 90 --port 
>> but same issue ( this process works when I test it on machines which
>> are not behind firewall )
>> On windows machine netstat -a shows
>>
>>  UDP    server:snmp        *:*
>>  UDP    server:snmptrap    *:*
>>
>> what means snmp is listenning ( same configuration of SNMP service
>> works ok for machines which are in same net as nagios server )
>>
>> I am suspection it could something to do with SNMP client / SNMP
>> protocol how it works, as I am getting correct response when I sent it
>> to 5666 + check_nrpe.
>>
>> Any reasonable hint what I could check will very useful, so thank you
>> in advance. I am preety lost I 

[Nagios-users] nagios taking too long to start

[shadih rahman]

Hi,
   I have sizeable installation of nagios server.  I have two server with
failover setup.  Since I am using ndo, my server takes a long time to start
up.  While my primary servers doing initial insertion and deletion, my
backup thinks primary is not in service so it starts notifications instead
of primary.

   I am trying to see how I can resolve this issue.  I have downloaded the
newer version of ndo but it did not help.  I think it has to do with my
indexing.  I have read the following thread which talks about reducing the
table size by lowering the retention time.

http://www.mail-archive.com/nagios-users@lists.sourceforge.net/msg23938.html

  However my requirement is that I have to keep most of hostchecks,
servicechecks and events for longtime.  Also, in another post Jim Avery
mentioned the following.

  innodb_flush_log_at_trx_commit = 2

What does innodb flush means when it comes to master-master replication
between primary and secondary. Please advise on this.  Thanks




Following are my current indexes --

mysql> show indexes from nagios_objects;
+++---+--+---+---+-+--++--++-+
| Table  | Non_unique | Key_name  | Seq_in_index | Column_name
| Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment
|
+++---+--+---+---+-+--++--++-+
| nagios_objects |  0 | PRIMARY   |1 | object_id
| A |   26095 | NULL | NULL   |  | BTREE  |
|
| nagios_objects |  1 | objecttype_id |1 | objecttype_id
| A |   3 | NULL | NULL   |  | BTREE  |
|
| nagios_objects |  1 | objecttype_id |2 | name1
| A |   26095 | NULL | NULL   |  | BTREE  |
|
| nagios_objects |  1 | objecttype_id |3 | name2
| A |   26095 | NULL | NULL   | YES  | BTREE  |
|
+++---+--+---+---+-+--++--++-+
4 rows in set (0.01 sec)



mysql> show indexes from nagios_hostchecks;
+---++-+--+-+---+-+--++--++-+
| Table | Non_unique | Key_name| Seq_in_index |
Column_name | Collation | Cardinality | Sub_part | Packed | Null |
Index_type | Comment |
+---++-+--+-+---+-+--++--++-+
| nagios_hostchecks |  0 | PRIMARY |1 |
hostcheck_id| A |12532724 | NULL | NULL   |  |
BTREE  | |
| nagios_hostchecks |  0 | instance_id |1 |
instance_id | A |  16 | NULL | NULL   |  |
BTREE  | |
| nagios_hostchecks |  0 | instance_id |2 |
host_object_id  | A |  16 | NULL | NULL   |  |
BTREE  | |
| nagios_hostchecks |  0 | instance_id |3 |
start_time  | A |12532724 | NULL | NULL   |  |
BTREE  | |
| nagios_hostchecks |  0 | instance_id |4 |
start_time_usec | A |12532724 | NULL | NULL   |  |
BTREE  | |
+---++-+--+-+---+-+--++--++-+
5 rows in set (0.14 sec)


mysql> show indexes from nagios_servicechecks;
+--++-+--+---+---+-+--++--++-+
| Table| Non_unique | Key_name| Seq_in_index |
Column_name   | Collation | Cardinality | Sub_part | Packed | Null |
Index_type | Comment |
+--++-+--+---+---+-+--++--++-+
| nagios_servicechecks |  0 | PRIMARY |1 |
servicecheck_id   | A |1922 | NULL | NULL   |  |
BTREE  | |
| nagios_servicechecks |  0 | instance_id |1 |
instance_id   | A |  17 | NULL | NULL   |  |
BTREE  | |
| nagios_servicechecks |  0 | instance_id |2 |
service_object_id | A |  17 | NULL | NULL   |  |
BTREE  | |
| nagios_servicechecks |  0 | instance_id |3 |
start_time| A |1922 | NULL | NULL   |  |
BTREE  | |
| nagios_servicechecks |   

Re: [Nagios-users] Version 2.12 vs. 3.1.2

[Israel Brewster]

For the most part, yes, v. 2 config files will convey transparently to  
v.3 There may be some of the more obscure parameters in v2 that don't  
work, but you'd have to consult the documentation to find out what,  
specifically. In general though, as long as you don't do anything TOO  
fancy, there shouldn't be any problems. There wasn't for me. General  
procedure is to upgrade to 3, run a check on your config files, and if  
any errors are reported, fix them. As I said, for me, there wasn't any  
problems reported, so you should be fine.

---
Israel Brewster
Computer Support Technician II
Frontier Flying Service Inc.
5245 Airport Industrial Rd
Fairbanks, AK 99709
(907) 450-7250 x293
---
BEGIN:VCARD
VERSION:3.0
N:Brewster;Israel;;;
FN:Israel Brewster
ORG:Frontier Flying Service;MIS
TITLE:PC Support Tech II
EMAIL;type=INTERNET;type=WORK;type=pref:isr...@frontierflying.com
TEL;type=WORK;type=pref:907-450-7293
item1.ADR;type=WORK;type=pref:;;5245 Airport Industrial Wy;Fairbanks;AK;99701;
item1.X-ABADR:us
X-ABUID:36305438-95EA-4410-91AB-45D16CABCDDC\:ABPerson
END:VCARD



On Aug 5, 2009, at 12:04 PM, Neil Dombrowski wrote:

I am new to fairly new to nagios, and have to set up a new server  
with a

new config. Currently when we do a yum install nagios we get 2.12, but
I'm hearing that we'll have v3 in our repository soon.  My question  
is:

if I use v2.12 to set up my config files, will they just plug into v3?

If the format/location of the files are the same, then I can just
install 2.12 and configure it now. If they are different, I'll  
probably

get v3 elsewhere and start with that.

Thanks,
   Neil

--



--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008  
30-Day
trial. Simplify your report design, integration and deployment - and  
focus on

what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when  
reporting any issue.

::: Messages without supporting info will risk being sent to /dev/null


--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july___
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting 
any issue. 
::: Messages without supporting info will risk being sent to /dev/null

Re: [Nagios-users] check_dns error

[Dei Bertine]

resolv.conf did it for me. :-)

Cheers! 





From: Marc Powell 
To: Nagios Users Mailinglist 
Sent: Thursday, August 6, 2009 9:09:14 PM
Subject: Re: [Nagios-users] check_dns error


On Aug 6, 2009, at 8:06 PM, Dei Bertine wrote:

> Hi,
>
> I received this error in Nagios today but wasnt sure on how to find  
> the solution to this.
>
> "domain 10.1.13.22 was not found by the server.."
>
> No changes were made in our network which I find bizaare.
>
> Please advise.

mmm. Without more information, we're just going to be blindly  
guessing. Here's mine: You've configured check_dns to ask for the IP  
address of an IP address instead of a hostname and nslookup complained  
that didn't make any sense. check_dns does a lookup of names, not IP  
addresses.

If you can't figure it out and want something more specific, post the  
host, service and command definitions as well as the log entries  
related to the event. Is it happening all the time or just once? Was  
it working correctly at one point and broke? Did you change your  
nagios configuration to cause this to happen?

--
Marc


--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting 
any issue. 
::: Messages without supporting info will risk being sent to /dev/null



  --
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july___
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting 
any issue. 
::: Messages without supporting info will risk being sent to /dev/null

[Nagios-users] NDOUtils mysql question?

[Andrew Davis]

Our Nagios server also has Cacti on it. I'm pretty sure that Cacti uses 
an InnoDB database, while NDOUtils uses myISAM. The two are backed up 
differently (example: mysqlhotcopy doesn't working on InnoDB databases). 
Does anyone know what mysql command you run to determine which type of 
DB is used for various databases, especially considering you can run 
multiple types at once? I know I can use "mysqlshow" or the "show 
databases;" options to show the databases themselves, but it doesn't 
list the DB type. Using mysqlshow with a -t and a DB name shows the 
table types, but again, not the database types. I'm sort of stuck on 
this. I want to make sure I know what DB types I'm dealing with so I can 
ensure I'm backing them up properly. Google searches aren't helping... 
the results all go back to the "mysql versus innodb" debate...


--


 A. Davis
 Email: ncc...@gmail.com

 "There is no limit to what a man can accomplish
  if he doesn't care who gets the credit." - Ronald Reagan

--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july___
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting 
any issue. 
::: Messages without supporting info will risk being sent to /dev/null

Re: [Nagios-users] NDOUtils mysql question?

[Marc Powell]

On Aug 7, 2009, at 2:03 PM, Andrew Davis wrote:

> Our Nagios server also has Cacti on it. I'm pretty sure that Cacti  
> uses an InnoDB database, while NDOUtils uses myISAM. The two are  
> backed up differently (example: mysqlhotcopy doesn't working on  
> InnoDB databases). Does anyone know what mysql command you run to  
> determine which type of DB is used for various databases, especially  
> considering you can run multiple types at once? I know I can use  
> "mysqlshow" or the "show databases;" options to show the databases  
> themselves, but it doesn't list the DB type.

It's not a database level option. It's table level.

> Using mysqlshow with a -t and a DB name shows the table types, but  
> again, not the database types. I'm sort of stuck on this. I want to  
> make sure I know what DB types I'm dealing with so I can ensure I'm  
> backing them up properly. Google searches aren't helping... the  
> results all go back to the "mysql versus innodb" debate...

My Google-fu seems to be more powerful.

mysql -u Username -p -h database.hostname.com -e "show table status"  
databasename.

--
Marc


--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting 
any issue. 
::: Messages without supporting info will risk being sent to /dev/null

Re: [Nagios-users] NDOUtils mysql question?

[shadih rahman]

I would double check these information.  Cacti runs on rrd( round robin
database).  I have innodb for my ndoutils 1.47b.

On Fri, Aug 7, 2009 at 3:03 PM, Andrew Davis  wrote:

>  Our Nagios server also has Cacti on it. I'm pretty sure that Cacti uses an
> InnoDB database, while NDOUtils uses myISAM. The two are backed up
> differently (example: mysqlhotcopy doesn't working on InnoDB databases).
> Does anyone know what mysql command you run to determine which type of DB is
> used for various databases, especially considering you can run multiple
> types at once? I know I can use "mysqlshow" or the "show databases;" options
> to show the databases themselves, but it doesn't list the DB type. Using
> mysqlshow with a -t and a DB name shows the table types, but again, not the
> database types. I'm sort of stuck on this. I want to make sure I know what
> DB types I'm dealing with so I can ensure I'm backing them up properly.
> Google searches aren't helping... the results all go back to the "mysql
> versus innodb" debate...
>
> --
>
>
>   A. Davis
>   Email: ncc...@gmail.com
>
>   "There is no limit to what a man can accomplish
>if he doesn't care who gets the credit." - Ronald Reagan
>
>
>
> --
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus
> on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> ___
> Nagios-users mailing list
> Nagios-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-users
> ::: Please include Nagios version, plugin version (-v) and OS when
> reporting any issue.
> ::: Messages without supporting info will risk being sent to /dev/null
>



-- 
Cordially,
Shadhin Rahman
--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july___
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting 
any issue. 
::: Messages without supporting info will risk being sent to /dev/null

Re: [Nagios-users] NDOUtils mysql question?

[Andrew Davis]

Okay, perhaps I inverted it then. My build of Cacti stores everything to 
a mysql DB, though it could admittedly be a myISAM DB with NDOutils 
being of the InnoDB type. However it works out, I'm pretty confident 
that I have two database types on one mysql server and I'm trying to 
figure out how to use a mysql command to list the database names and 
their types...


# mysql -u root -p -e "show databases;"
Enter password:
++
| Database   |
++
| information_schema |
| cacti  |
| mysql  |
| nagdb  |
| nagios |
| test   |
++

 A. Davis
 Email: ncc...@gmail.com

 "There is no limit to what a man can accomplish
  if he doesn't care who gets the credit." - Ronald Reagan



shadih rahman wrote:
I would double check these information.  Cacti runs on rrd( round 
robin database).  I have innodb for my ndoutils 1.47b.


On Fri, Aug 7, 2009 at 3:03 PM, Andrew Davis > wrote:


Our Nagios server also has Cacti on it. I'm pretty sure that Cacti
uses an InnoDB database, while NDOUtils uses myISAM. The two are
backed up differently (example: mysqlhotcopy doesn't working on
InnoDB databases). Does anyone know what mysql command you run to
determine which type of DB is used for various databases,
especially considering you can run multiple types at once? I know
I can use "mysqlshow" or the "show databases;" options to show the
databases themselves, but it doesn't list the DB type. Using
mysqlshow with a -t and a DB name shows the table types, but
again, not the database types. I'm sort of stuck on this. I want
to make sure I know what DB types I'm dealing with so I can ensure
I'm backing them up properly. Google searches aren't helping...
the results all go back to the "mysql versus innodb" debate...

-- 



  A. Davis
  Email: ncc...@gmail.com 

  "There is no limit to what a man can accomplish
   if he doesn't care who gets the credit." - Ronald Reagan





--
Let Crystal Reports handle the reporting - Free Crystal Reports
2008 30-Day
trial. Simplify your report design, integration and deployment -
and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Nagios-users mailing list
Nagios-users@lists.sourceforge.net

https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when
reporting any issue.
::: Messages without supporting info will risk being sent to /dev/null




--
Cordially,
Shadhin Rahman
--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july___
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting 
any issue. 
::: Messages without supporting info will risk being sent to /dev/null

Re: [Nagios-users] NDOUtils mysql question?

[David Rosenstrauch]

On 08/07/2009 03:03 PM, Andrew Davis wrote:
> Our Nagios server also has Cacti on it. I'm pretty sure that Cacti uses 
> an InnoDB database, while NDOUtils uses myISAM. The two are backed up 
> differently (example: mysqlhotcopy doesn't working on InnoDB databases). 
> Does anyone know what mysql command you run to determine which type of 
> DB is used for various databases, especially considering you can run 
> multiple types at once? I know I can use "mysqlshow" or the "show 
> databases;" options to show the databases themselves, but it doesn't 
> list the DB type. Using mysqlshow with a -t and a DB name shows the 
> table types, but again, not the database types. I'm sort of stuck on 
> this. I want to make sure I know what DB types I'm dealing with so I can 
> ensure I'm backing them up properly. Google searches aren't helping... 
> the results all go back to the "mysql versus innodb" debate...

I think the engine type is set on a table by table basis, not database-wide.

You can see this as follows:

mysql> show create table mysql.time_zone\G
*** 1. row ***
Table: time_zone
Create Table: CREATE TABLE `time_zone` (
   `Time_zone_id` int(10) unsigned NOT NULL auto_increment,
   `Use_leap_seconds` enum('Y','N') NOT NULL default 'N',
   PRIMARY KEY  (`Time_zone_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zones'
1 row in set (0.00 sec)


Note the "ENGINE=MyISAM" at the end.

HTH,

DR

--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting 
any issue. 
::: Messages without supporting info will risk being sent to /dev/null

Re: [Nagios-users] NDOUtils mysql question?

[Andrew Davis]

Really? You sure about that? I'm pretty confident that mysql supports 
different types of databases (myISAM and InnoDB as two of them) as well 
as different table types within a database. Your reply did help, though, 
as when I ran it for the default mysql DB, I was reminded of the phrase 
"engine" in the output. Thus, now I see:


mysql -u root -p -e "show table status" mysql
Enter password:
+---++-++--++-++--+---++-+-+-+-+--++---+
| Name  | Engine | Version | Row_format | Rows | 
Avg_row_length | Data_length | Max_data_length| Index_length | 
Data_free | Auto_increment | Create_time | Update_time | 
Check_time  | Collation   | Checksum | Create_options | 
Comment   |

+---++-++--++-++--+---++-+-+-+-+--++---+
| columns_priv  | MyISAM |  10 | Fixed  |0 
|  0 |   0 | 227994731135631359 | 1024 
| 0 |   NULL | 2009-02-12 10:21:04 | 2009-02-12 10:21:04 
| NULL| utf8_bin| NULL || 
Column privileges 


mysql> show engines;
++-++
| Engine | Support | 
Comment|

++-++
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great 
performance |
| MEMORY | YES | Hash based, stored in memory, useful for 
temporary tables  |
| InnoDB | YES | Supports transactions, row-level locking, and 
foreign keys |
| BerkeleyDB | YES | Supports transactions and page-level 
locking   |
| BLACKHOLE  | NO  | /dev/null storage engine (anything you write to 
it disappears) |
| EXAMPLE| NO  | Example storage 
engine |
| ARCHIVE| NO  | Archive storage 
engine |
| CSV| NO  | CSV storage 
engine |
| ndbcluster | NO  | Clustered, fault-tolerant, memory-based 
tables |
| FEDERATED  | NO  | Federated MySQL storage 
engine |
| MRG_MYISAM | YES | Collection of identical MyISAM 
tables  |
| ISAM   | NO  | Obsolete storage 
engine|

++-++
12 rows in set (0.00 sec)

An "engine" is another way of saying "database type". This is distinct 
from a table type. Of course, the above only shows me the engines that 
are already compiled in and available for use, but hopefully I can go 
forward from here... I'm thinking I can do a "show databases;", then 
pump that into a "for x in ..." to show the engine type for each DB.


Thanks for the assist...

 A. Davis
 Email: ncc...@gmail.com

 "There is no limit to what a man can accomplish
  if he doesn't care who gets the credit." - Ronald Reagan



Marc Powell wrote:

On Aug 7, 2009, at 2:03 PM, Andrew Davis wrote:

  
Our Nagios server also has Cacti on it. I'm pretty sure that Cacti  
uses an InnoDB database, while NDOUtils uses myISAM. The two are  
backed up differently (example: mysqlhotcopy doesn't working on  
InnoDB databases). Does anyone know what mysql command you run to  
determine which type of DB is used for various databases, especially  
considering you can run multiple types at once? I know I can use  
"mysqlshow" or the "show databases;" options to show the databases  
themselves, but it doesn't list the DB type.



It's not a database level option. It's table level.

  
Using mysqlshow with a -t and a DB name shows the table types, but  
again, not the database types. I'm sort of stuck on this. I want to  
make sure I know what DB types I'm dealing with so I can ensure I'm  
backing them up properly. Google searches aren't helping... the  
results all go back to the "mysql versus innodb" debate...



My Google-fu seems to be more powerful.

mysql -u Username -p -h database.hostname.com -e "show table status"  
databasename.


--
Marc


--
Let Crystal Reports handle the rep

Re: [Nagios-users] NDOUtils mysql question?

[Marc Powell]

On Aug 7, 2009, at 3:15 PM, Andrew Davis wrote:

> Really? You sure about that? I'm pretty confident that mysql  
> supports different types of databases (myISAM and InnoDB as two of  
> them) as well as different table types within a database.

If you really wanted to be sure about that and not question the  
answers you receive, shouldn't you be asking on mysql-users instead of  
the unrelated nagios-users? That would be the forum for definitive  
answers about mysql database types, don't you agree?

--
Marc


--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting 
any issue. 
::: Messages without supporting info will risk being sent to /dev/null

Re: [Nagios-users] NDOUtils mysql question?

[Andrew Davis]

My apologies... didn't mean to come across as rude. I figured that 
others may have tools like Cacti along with NDOutils on the same server 
and thus might find that they have multiple database types as well... 
hence my email to the Nagios list instead of the mysql list. In my case, 
I learned the hard way that mysqlhotcopy doesn't backup InnoDB 
databases... hence my need to determine the DB type so I knew how to 
properly backup the various DB's.


In any case, your original reply pointed me in the right direction. I 
just wrote up the script below. It first shows all the databases, then 
determines the database type for each, making it easy to parse out:


#!/bin/bash

DATABASES=`mysql -uroot -p -e "show databases;"|awk -F "|" 
'{print $1}'|grep -vE "Database|information_schema|test|nagdb"`


for x in $DATABASES
do
   DATABASE_TYPE=`mysql -uroot -p -e "show table status;" 
$x|awk '{print $2}'|uniq|grep -v Engine`

   echo $x:$DATABASE_TYPE
done

exit 0

Of course, I've also learned its possible to mix engines within a 
database, so this isn't exactly foolproof. The output looks something 
like this:


# /root/test.sh
cacti:MyISAM
mysql:MyISAM
nagios:InnoDB

Thanks for pointing me in the right direction...

 A. Davis
 Email: ncc...@gmail.com

 "There is no limit to what a man can accomplish
  if he doesn't care who gets the credit." - Ronald Reagan



Marc Powell wrote:

On Aug 7, 2009, at 3:15 PM, Andrew Davis wrote:

  
Really? You sure about that? I'm pretty confident that mysql  
supports different types of databases (myISAM and InnoDB as two of  
them) as well as different table types within a database.



If you really wanted to be sure about that and not question the  
answers you receive, shouldn't you be asking on mysql-users instead of  
the unrelated nagios-users? That would be the forum for definitive  
answers about mysql database types, don't you agree?


--
Marc


--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july

___
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null
  
--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july___
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting 
any issue. 
::: Messages without supporting info will risk being sent to /dev/null

[Nagios-users] Strengths of Cacti?

[Kevin Keane]

I'm curious to learn more about Cacti - the Cacti Web site and Google 
are of course very helpful, but I'm looking primarily for a comparison 
between Cacti and pnp4nagios.

Right now, I'm using nagios 3.0.6 together with pnp4nagios, and that 
seems to be working very well, and setting up pnp4nagios is a snap, of 
course.

At first glance, it seems that Cacti does roughly the same thing as 
pnp4nagios. Is that correct, or are they really like apples and oranges? 
Which one is better? Or probably a better question: what are their 
respective strengths and weaknesses, why would I use one or the other?


--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting 
any issue. 
::: Messages without supporting info will risk being sent to /dev/null

Re: [Nagios-users] Strengths of Cacti?

[Mark Young]

On Aug 7, 2009, at 4:59 PM, Kevin Keane wrote:

> I'm curious to learn more about Cacti - the Cacti Web site and Google
> are of course very helpful, but I'm looking primarily for a comparison
> between Cacti and pnp4nagios.
>
> Right now, I'm using nagios 3.0.6 together with pnp4nagios, and that
> seems to be working very well, and setting up pnp4nagios is a snap, of
> course.
>
> At first glance, it seems that Cacti does roughly the same thing as
> pnp4nagios. Is that correct, or are they really like apples and  
> oranges?
> Which one is better? Or probably a better question: what are their
> respective strengths and weaknesses, why would I use one or the other?


Cacti and PNP4Nagios are different ideas.  Cacti polls its own data,  
often through SNMP traps.  While PNP4Nagios uses Nagios performance  
data from Nagios' scheduled checks.  In my experience both can/should  
be setup depending on your needs.  As a Nagios addon, PNP4Nagios is a  
great way to use the performance data from Nagios in an efficient way;  
Nagios handles the checks and sends notifications.  Cacti often polls  
fewer services but at a smaller time interval (services such as router  
bandwidth, system load) and is much more efficient if all you want is  
graphs.

If PNP4Nagios is working great for you I suggest you stay with it.  If  
you are looking for "fine grain" graphing you could either increase  
the Nagios check interval, or setup Cacti.  You should keep in mind  
that if you are working in a large installation both solution have  
scaling issues (and solutions).  Also if you are looking to expand  
your graphing you should look into Nagios plugins that offer  
performance data.  Such as switching from check_ping to check_icmp

Best of luck!

Mark Young

--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting 
any issue. 
::: Messages without supporting info will risk being sent to /dev/null

Re: [Nagios-users] Monitor Windows 2003 using nagios + SNMP

[Marc Powell]

On Aug 7, 2009, at 7:59 AM, arly arly wrote:

> Hi Kevin,
>
> thank you for extensive mail and time you spent on it.
>
> -- Yes, I enabled SNMP on windows server, set up comunity name, and
> all necessary stuff---I have working configuration
> for SNMP on machines which are not behind firewal and it works,and I
> just did copy/paste.

Have you taken the simple step of verifying, using Wireshark or other  
packet capture program, whether the SNMP request is making it to the  
Windows box at all? That would seem to be a Good Thing to do to point  
you in the right direction. If it doesn't get there, work your way  
back to the Nagios box and find out where it's being stopped.

--
Marc


--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting 
any issue. 
::: Messages without supporting info will risk being sent to /dev/null