Re: [Nagios-users] NDO: Partitioning nagios_servicechecks
On Qui, 2013-06-27 at 09:23 +0100, Rui Miguel Silva Seabra wrote: Hi, We'd like to keep nagios_servicecheks for 14 months of current time but, of course, it can get quite big (37GB just for the table with about 6 months of data). So I tried partitioning it: ALTER TABLE nagios_servicechecks PARTITION BY RANGE(TO_DAYS(end_time)) ( partition p201301 VALUES LESS THAN (TO_DAYS('2013-02-01 00:00:00')), partition p201302 VALUES LESS THAN (TO_DAYS('2013-03-01 00:00:00')), partition p201303 VALUES LESS THAN (TO_DAYS('2013-04-01 00:00:00')), partition p201304 VALUES LESS THAN (TO_DAYS('2013-05-01 00:00:00')), partition p201305 VALUES LESS THAN (TO_DAYS('2013-06-01 00:00:00')), partition p201306 VALUES LESS THAN (TO_DAYS('2013-07-01 00:00:00')), partition p201307 VALUES LESS THAN (TO_DAYS('2013-08-01 00:00:00')), partition p201308 VALUES LESS THAN (TO_DAYS('2013-09-01 00:00:00')), partition p201309 VALUES LESS THAN (TO_DAYS('2013-10-01 00:00:00')), partition p201310 VALUES LESS THAN (TO_DAYS('2013-11-01 00:00:00')), partition p201311 VALUES LESS THAN (TO_DAYS('2013-12-01 00:00:00')), partition p201312 VALUES LESS THAN (TO_DAYS('2014-01-01 00:00:00')), partition p201xxx VALUES LESS THAN maxvalue); However, MySQL complains: ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function As a non expert in MySQL, this appears to me as making little sense since end_time is not a key! CREATE TABLE `nagios_servicechecks` ( `servicecheck_id` int(11) NOT NULL AUTO_INCREMENT, `instance_id` smallint(6) NOT NULL DEFAULT '0', `service_object_id` int(11) NOT NULL DEFAULT '0', `check_type` smallint(6) NOT NULL DEFAULT '0', `current_check_attempt` smallint(6) NOT NULL DEFAULT '0', `max_check_attempts` smallint(6) NOT NULL DEFAULT '0', `state` smallint(6) NOT NULL DEFAULT '0', `state_type` smallint(6) NOT NULL DEFAULT '0', `start_time` datetime NOT NULL DEFAULT '-00-00 00:00:00', `start_time_usec` int(11) NOT NULL DEFAULT '0', `end_time` datetime NOT NULL DEFAULT '-00-00 00:00:00', `end_time_usec` int(11) NOT NULL DEFAULT '0', `command_object_id` int(11) NOT NULL DEFAULT '0', `command_args` varchar(255) NOT NULL DEFAULT '', `command_line` varchar(255) NOT NULL DEFAULT '', `timeout` smallint(6) NOT NULL DEFAULT '0', `early_timeout` smallint(6) NOT NULL DEFAULT '0', `execution_time` double NOT NULL DEFAULT '0', `latency` double NOT NULL DEFAULT '0', `return_code` smallint(6) NOT NULL DEFAULT '0', `output` varchar(255) NOT NULL DEFAULT '', `long_output` text NOT NULL, `perfdata` text NOT NULL, PRIMARY KEY (`servicecheck_id`), KEY `instance_id` (`instance_id`), KEY `service_object_id` (`service_object_id`), KEY `start_time` (`start_time`) ) ENGINE=MyISAM AUTO_INCREMENT=245571748 DEFAULT CHARSET=latin1 COMMENT='Historical service checks' And there is no added index: mysql SHOW INDEX 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 | 245571747 | NULL | NULL | | BTREE | | | nagios_servicechecks | 1 | instance_id |1 | instance_id | A |NULL | NULL | NULL | | BTREE | | | nagios_servicechecks | 1 | service_object_id |1 | service_object_id | A |NULL | NULL | NULL | | BTREE | | | nagios_servicechecks | 1 | start_time|1 | start_time| A |NULL | NULL | NULL | | BTREE | | +--++---+--+---+---+-+--++--++-+ 4 rows in set (0.01 sec) Has anyone tried this successfully and would like to share some hints? Best regards, Rui For the record, the only way I found out how to make this work, was to make servicecheck_id not unique, but still a key. Due to the number of servicechecks one might have, I have my doubts whether that could be a problem, can anyone tell me he knows for sure it is a problem? Rui -- See everything from
[Nagios-users] NDO: Partitioning nagios_servicechecks
Hi, We'd like to keep nagios_servicecheks for 14 months of current time but, of course, it can get quite big (37GB just for the table with about 6 months of data). So I tried partitioning it: ALTER TABLE nagios_servicechecks PARTITION BY RANGE(TO_DAYS(end_time)) ( partition p201301 VALUES LESS THAN (TO_DAYS('2013-02-01 00:00:00')), partition p201302 VALUES LESS THAN (TO_DAYS('2013-03-01 00:00:00')), partition p201303 VALUES LESS THAN (TO_DAYS('2013-04-01 00:00:00')), partition p201304 VALUES LESS THAN (TO_DAYS('2013-05-01 00:00:00')), partition p201305 VALUES LESS THAN (TO_DAYS('2013-06-01 00:00:00')), partition p201306 VALUES LESS THAN (TO_DAYS('2013-07-01 00:00:00')), partition p201307 VALUES LESS THAN (TO_DAYS('2013-08-01 00:00:00')), partition p201308 VALUES LESS THAN (TO_DAYS('2013-09-01 00:00:00')), partition p201309 VALUES LESS THAN (TO_DAYS('2013-10-01 00:00:00')), partition p201310 VALUES LESS THAN (TO_DAYS('2013-11-01 00:00:00')), partition p201311 VALUES LESS THAN (TO_DAYS('2013-12-01 00:00:00')), partition p201312 VALUES LESS THAN (TO_DAYS('2014-01-01 00:00:00')), partition p201xxx VALUES LESS THAN maxvalue); However, MySQL complains: ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function As a non expert in MySQL, this appears to me as making little sense since end_time is not a key! CREATE TABLE `nagios_servicechecks` ( `servicecheck_id` int(11) NOT NULL AUTO_INCREMENT, `instance_id` smallint(6) NOT NULL DEFAULT '0', `service_object_id` int(11) NOT NULL DEFAULT '0', `check_type` smallint(6) NOT NULL DEFAULT '0', `current_check_attempt` smallint(6) NOT NULL DEFAULT '0', `max_check_attempts` smallint(6) NOT NULL DEFAULT '0', `state` smallint(6) NOT NULL DEFAULT '0', `state_type` smallint(6) NOT NULL DEFAULT '0', `start_time` datetime NOT NULL DEFAULT '-00-00 00:00:00', `start_time_usec` int(11) NOT NULL DEFAULT '0', `end_time` datetime NOT NULL DEFAULT '-00-00 00:00:00', `end_time_usec` int(11) NOT NULL DEFAULT '0', `command_object_id` int(11) NOT NULL DEFAULT '0', `command_args` varchar(255) NOT NULL DEFAULT '', `command_line` varchar(255) NOT NULL DEFAULT '', `timeout` smallint(6) NOT NULL DEFAULT '0', `early_timeout` smallint(6) NOT NULL DEFAULT '0', `execution_time` double NOT NULL DEFAULT '0', `latency` double NOT NULL DEFAULT '0', `return_code` smallint(6) NOT NULL DEFAULT '0', `output` varchar(255) NOT NULL DEFAULT '', `long_output` text NOT NULL, `perfdata` text NOT NULL, PRIMARY KEY (`servicecheck_id`), KEY `instance_id` (`instance_id`), KEY `service_object_id` (`service_object_id`), KEY `start_time` (`start_time`) ) ENGINE=MyISAM AUTO_INCREMENT=245571748 DEFAULT CHARSET=latin1 COMMENT='Historical service checks' And there is no added index: mysql SHOW INDEX 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 | 245571747 | NULL | NULL | | BTREE | | | nagios_servicechecks | 1 | instance_id |1 | instance_id | A |NULL | NULL | NULL | | BTREE | | | nagios_servicechecks | 1 | service_object_id |1 | service_object_id | A |NULL | NULL | NULL | | BTREE | | | nagios_servicechecks | 1 | start_time|1 | start_time| A |NULL | NULL | NULL | | BTREE | | +--++---+--+---+---+-+--++--++-+ 4 rows in set (0.01 sec) Has anyone tried this successfully and would like to share some hints? Best regards, Rui -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev ___ 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] Nagios authentication thru LDAP.
Qua, 2011-08-10 às 13:42 -0400, Terry Carmen escreveu: Quoting Robert J Molerio rjm...@nyu.edu: Can anyone indicate how this can be done? We would like users to log on to Nagios via LDAP. I think we need to configure the Apache server within Nagios to be able to do this but we're not sure. It's definitely possible using Apache's LDAP auth, however you might want to consider that when your network is going ape, it's really nice to know that your Nagios machine doesn't require any external resources. That's why I chose local auth (htpasswd). Now matter how much of the brown stuff is flying around, Nagios is up. Terry Tsk tsk tsk. Apache supports falling back to other auth methods and you should use Nagios and LDAP via SSL sockets (https and ldaps) securing passwords. Setting up Apache against LDAP is really easy, and most of the LDAP issues are on its maintenance rather than pointing at it for data. Rui -- Get a FREE DOWNLOAD! and learn more about uberSVN rich system, user administration capabilities and model configuration. Take the hassle out of deploying and managing Subversion and the tools developers use with it. http://p.sf.net/sfu/wandisco-dev2dev ___ 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] Nagios alert via Twitter - authorization issue
That will not work anymore because Twitter is run by idiots who think Oauth is the be all end all of security. It isn't. It is perhaps a good compromise if you don't want to give your user and password to a foreign website in order to have it do things on your behalf but for local applications it actually *reduces* security by imposing a more complicated method than http basic auth via https (BTW, you should use https with basic auth always, and not http as you have) full weird workflows. I suggest the following: 1) create an account in https://identi.ca/ (a Free Software social network) 2) use your command with the following difference in the url: https://identi.ca/api/statuses/update.json (they have a compatible api). Best regards, Rui Seg, 2010-10-11 às 11:29 -0400, John Antram escreveu: Hello everyone! Before I attempt to re-invent the wheel with getting curl:// command lines to authenticate to the new twitter API, has anyone solved it? I'm in the middle of moving part of our network to our new building and just noticed I don't have any tweet-ed alerts since they put the security on the API. My command looks like this in command.cfg: define command { command_namehost-notify-by-twitter command_line/usr/bin/curl --basic --user user:password --data-ascii status=[Nagios] $HOSTSTATE$ alert for $HOSTNAME$ at $SHORTDATETIME$ http://twitter.com/statuses/update.json /dev/null } Thanks everyone! John Antram r...@dvdmenus.net Subatomic Digital Essex/Williston Vermont www.dvdmenus.net -- Beautiful is writing same markup. Internet Explorer 9 supports standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 L3. Spend less time writing and rewriting code and more time creating great experiences on the web. Be a part of the beta today. http://p.sf.net/sfu/beautyoftheweb ___ 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 -- Beautiful is writing same markup. Internet Explorer 9 supports standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 L3. Spend less time writing and rewriting code and more time creating great experiences on the web. Be a part of the beta today. http://p.sf.net/sfu/beautyoftheweb ___ 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] monitoring for exactly 1 process on 3 hosts
Seg, 2010-06-07 às 16:57 -0600, Litwin, Matthew escreveu: I need to monitor that a process is running on one of three hosts and that is not running on the other two. Is there a way to set up a service such that a check must return OK for only one host of a hostgroup and alarm if there is less or more than one instance running in that hostgroup? I think you'll need a local test combining the results of all three, or remotely checking all three (via ssh, NRPE, etc...). Rui -- ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo ___ 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] Nagios client plugins for RHEL5
Qua, 2010-02-17 às 11:47 -0500, Jai Ram escreveu: Hello All: Can anyone pls help me to find the RHEL5 nagios client plugin bundlewe have been monitoring AIX/Sun boxes for which we have the http://download.fedora.redhat.com/pub/epel/ have fun. Rui -- SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev ___ 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] Update 3.0 to 3.1.2
Seg, 2009-07-27 às 08:29 -0500, Marc Powell escreveu: On Jul 27, 2009, at 7:45 AM, Esteban Torres Rodriguez wrote: how to update versión? I have nagios on RHEL 5.1 with install from .tar.gz. Upgrading within the same major version is trivial. ./configure --with-your-options make all (stop nagios) make install (start nagios) You will need to update html/Makefile.in and fix the HTML dir. Append /nagios or it'll install everything in /usr/share This happened to me while making a nagios 3.1.2 RPM Rui -- ___ 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] expire a passive check result.
Hello, When using passive checks, you *should* do the following: define service { namegeneric-passive-service ; active_checks_enabled 0 ; Active service checks are enabled passive_checks_enabled 1 ; Passive service checks are enabled/accepted parallelize_check 1 ; obsess_over_service 1 ; check_freshness 1 ; Default is to NOT check service 'freshness' freshness_threshold 660 is_volatile 0 notifications_enabled 1 ; Service notifications are enabled event_handler_enabled 1 ; Service event handler is enabled flap_detection_enabled 0 ; Flap detection is enabled process_perf_data 1 ; Process performance data retain_status_information 0 ; Retain status information across program restarts retain_nonstatus_information0 ; Retain non-status information across program restarts register0 ; DONT REGISTER THIS DEFINITION - ITS NOT A REAL SERVICE, JUST A TEMPLATE! check_period24x7 max_check_attempts 2 normal_check_interval 5 retry_check_interval1 contact_groups admins notification_interval 0 notification_period 24x7 notification_optionsw,u,c,r } Notice in particular check_freshness and freshness_threshold! Now on a service you have: define service { use generic-passive-service host_name fubar service_description Load is_volatile 0 check_command check-passive } Notice check_command? define command { command_namecheck-passive command_line$USER1$/check_dummy 2 No status update } Helpful, though sparse, hints? :D Rui Ter, 2008-01-08 às 16:48 +, Jaime Ventura escreveu: Hello. I have a system checking its own services and sending them to a nagios server(passive checks). But that system stopped sending results to the nagios server. Since last availlable result was OK, nagios didnt warn me. Is there any way to tell nagios to set the status of a passive check service to UNKNOWN, if a specified time passed since last received result? Thanks, Jaime Or is it? Today is Pungenday, the 8th day of Chaos in the YOLD 3174 + No matter how much you do, you never do enough -- unknown + Whatever you do will be insignificant, | but it is very important that you do it -- Gandhi + So let's do it...? - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace ___ 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] Grouping/services question
Sex, 2007-12-21 às 09:16 -0600, [EMAIL PROTECTED] escreveu: I have 6 servers that are our development Vignette environment. Our development people, who have limited Nagios access for servers they are concerned with would like to have the 6 development servers in a Nagios group. Here's the crux of the problem... How do you monitor a service on one machine that is not on another machine (such as oracle DB Status, or the web portal, or the vignette preview) without creating separate groups. I really don't want to have 6 groups of one server each but I can't see a way around it without playing some check_dummy games in NRPE for services that don't exists on a particular server but are defined in the group. The way you formulate your question seems to suggest you use service { ... hostgroup_name ... ... } If you want to keep that method (which IMHO is wise) then I'd say you need to have that ugly solution. Rui Pzat! Today is Setting Orange, the 63rd day of The Aftermath in the YOLD 3173 + No matter how much you do, you never do enough -- unknown + Whatever you do will be insignificant, | but it is very important that you do it -- Gandhi + So let's do it...? - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ 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] Grouping/services question
Sex, 2007-12-21 às 12:57 -0600, [EMAIL PROTECTED] escreveu: hostgroup_nameUnix,!Storefront host_name !demo,!logger,!snowball,!laddie,!duffgardens /me drolls I didn't know that was possible, since what release of Nagios can that be done? That's great! Rui Hail Eris, Hack GNU/Linux! Today is Setting Orange, the 63rd day of The Aftermath in the YOLD 3173 + No matter how much you do, you never do enough -- unknown + Whatever you do will be insignificant, | but it is very important that you do it -- Gandhi + So let's do it...? - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ 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] nsclient, is it still an acceptable method to monitor nt
Sex, 2007-11-09 às 11:35 +0100, Andreas Ericsson escreveu: NSClient (seems too old, not being developed) NSClient++ (presumably enhanced in some way) OpServices version of NSClient (still being developed) NC_Net (still being developed) In the end I simply went with NC_Net and it appears to work for us just fine, and I often see the author on this list, which tells me that he's still involved with Nagios in some way. It would be nice if all the different people who independently developed all the different versions 'unforked' their efforts though :-), it would make the decision on which one to use much easier, by having a lack of choice!! They aren't really forks. OpServices have simply taken over maintainership of NSClient (more or less, as the original author seems to have vanished). NSClient++ is a re-implementation in C++, with support for NRPE style script based checks as well. NC_Net does things through dot net stuff and some m$ voodoo, but incorporates the NSClient mode of address since that's what the official plugins support. So it's really three different agents. NSClient++ has a nasty bug on the option to check services. It can't handle services that contain white space in their names. Rui All Hail Discordia! Today is Pungenday, the 21st day of The Aftermath in the YOLD 3173 + No matter how much you do, you never do enough -- unknown + Whatever you do will be insignificant, | but it is very important that you do it -- Gandhi + So let's do it...? - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ 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] Nagios Light?
Hi, Nagios is really quite simple, what problems did you run into? Did you skim the fine manual before your first deployment? What do you mean long time? Is it auto-discovery you were looking from? If so, I can tell you that although that's pretty, it sucks from the point of view of security. Rui Qua, 2006-08-02 às 09:43 -0500, jon.johnston escreveu: After trying to work with Nagios for a while, I've determined that it's not the best fit for most of the environments I work with. Looks like great stuff, but takes too long to setup, configure, and get running in network environments where I would leave it with administrators will little to no linux knowledge. Is there something linux-based that would be comparable to nagios light? Thanks for any input. Jon Johnston Creative Business Solutions IBM, Microsoft, Novell/Suse and Sophos Consulting 952-544-1108 http://www.cbsol.com Blog:http://bingo.cbsol.com smime.p7s Description: S/MIME cryptographic signature - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642___ 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