January 2012 - Xymon - Xymon mailman web

fetch error - dbcheck.pl
by marco.avvisano＠regione.toscana.it 02 Mar '12

02 Mar '12

Hi, I'm migrating to redhat Red Hat Enterprise Linux Server release 6.1 (Santiago) (64). The query is done correctly (tablespace) but the values continues to fetch until it finds an empty table. On the new server i get this message: fbh 6: 'maxsize' NULLable, type -5, 20, dsize 19, p0 s18965564 out: ftype 1, indp 0, bufl 81, rlen 81 <- prepare= ( DBI::st=HASH(0xba2c30) ) [1 items] at Hobbit_fd_lib.pm line 1089 via at dbcheck.pl line 1356 -> execute for DBD::DB2::st (DBI::st=HASH(0xba2c30)~0x107fd20) <- execute= ( -1 ) [1 items] at Hobbit_fd_lib.pm line 1093 via at Hobbit_fd_lib.pm line 1090 -> fetchall_arrayref in DBD::_::st for DBD::DB2::st (DBI::st=HASH(0xba2c30)~0x107fd20 HASH(0x1080260)) 2<- FETCH= ( [ 'name' 'size' 'free' 'used' 'usedpct' 'autoextend' 'maxsize' ] ) [1 items] at DBI.pm line 2043 via at Hobbit_fd_lib.pm line 1099 dbd_st_fetch 7 fields 0: rc=0 'SYSCATSPACE' 1: rc=0 '745013248' 2: rc=0 '142999552' 3: rc=0 '602013696' 4: rc=0 '80.80' 5: rc=0 '1' 6: rc=0 '-1' (..) 2<> FETCH= ( [ 'name' 'size' 'free' 'used' 'usedpct' 'autoextend' 'maxsize' ] ) [1 items] ('NAME' from cache) at DBI.pm li ne 2043 via at Hobbit_fd_lib.pm line 1099 !! info: '' '[IBM][CLI Driver][DB2/AIX64] SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a quer y is an empty table. SQLSTATE=02000 ' (err#0) --------------- Summary of my perl5 (revision 5 version 12 subversion 4) configuration: Platform: osname=linux, osvers=2.6.32-131.6.1.el6.x86_64, archname=x86_64-linux uname='linux my.server 2.6.32-131.6.1.el6.x86_64 #1 smp mon jun 20 14:15:38 edt 2011 x86_64 x86_64 x86_64 gnulinux ' config_args='-de -Dcc=gcc -Dprefix=/opt/perl5' hint=recommended, useposix=true, d_sigaction=define useithreads=undef, usemultiplicity=undef useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef use64bitint=define, use64bitall=define, uselongdouble=undef usemymalloc=n, bincompat5005=undef Compiler: cc='gcc', ccflags ='-fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64', optimize='-O2', cppflags='-fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include' ccversion='', gccversion='4.4.5 20110214 (Red Hat 4.4.5-6)', gccosandvers='' intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16 ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8 alignbytes=8, prototype=define Linker and Libraries: ld='gcc', ldflags =' -fstack-protector -L/usr/local/lib' libpth=/usr/local/lib /lib/../lib64 /usr/lib/../lib64 /lib /usr/lib /lib64 /usr/lib64 /usr/local/lib64 libs=-lnsl -ldb -ldl -lm -lcrypt -lutil -lc perllibs=-lnsl -ldl -lm -lcrypt -lutil -lc libc=/lib/libc-2.12.so, so=so, useshrplib=false, libperl=libperl.a gnulibc_version='2.12' Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E' cccdlflags='-fPIC', lddlflags='-shared -O2 -L/usr/local/lib -fstack-protector' Characteristics of this binary (from libperl): Compile-time options: PERL_DONT_CREATE_GVSV PERL_MALLOC_WRAP USE_64_BIT_ALL USE_64_BIT_INT USE_LARGE_FILES USE_PERLIO USE_PERL_ATOF Built under linux Compiled at Sep 15 2011 10:39:35 @INC: /opt/perl5/lib/site_perl/5.12.4/x86_64-linux /opt/perl5/lib/site_perl/5.12.4 /opt/perl5/lib/5.12.4/x86_64-linux /opt/perl5/lib/5.12.4 ---------------------- Program Information dbcheck.pl version 1.08 Hobbit_fd_lib.pm version 1.15 OS Information Linux my.server 2.6.32-131.6.1.el6.x86_64 #1 SMP Mon Jun 20 14:15:38 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux Perl version is v5.12.4 Module Information FindBin 1.50 POSIX 1.19 Text::Wrap 2009.0305 Sys::SigAction 0.15 Config::IniFiles 2.68 DBI 1.616 DBD::DB2 1.81 DBD::DBM 0.06 DBD::ExampleP 12.014310 DBD::File 0.40 DBD::Gofer 0.014282 DBD::SQLite 1.33 DBD::Sponge 12.010002 DBD::mysql 4.020 ----------------- Anyone have simular problem? Thanks for help Marco

1 1

monitoring aggregated network traffic
by s.seitz＠netz-haut.de 24 Feb '12

24 Feb '12

Hi, thanks for your very helpful answer. It took me a few days to get back to that issue, so sorry for that late responose. I've added additional lines for outgoing, and it works as expected. I'm absolutely fine with hardcoed interfaces, cause I need the aggregated view of particular interfaces. Thanks again, Stephan Am Donnerstag, den 13.10.2011, 19:42 +0200 schrieb Henrik Størner: On 13-10-2011 16:44, netz-haut - stephan seitz wrote: > is there any "usual" way, to monitor and graph the traffic of a bulk > of network interfaces? The reason is, some of our hosts are connected > to iSCSI storages via multipath over two or four independent > interfaces. Since the traffic is balanced equally, every interface > shows (more or less) the same amount of traffic. This leads to very > useless rrdtool graphics as there is only one multicolored thick line > visible. It would be really helpful to see a graph which shows the > SUM of the particular interfaces. This can be done by creating an RRD graph definition to do the summation for you. In RRDtool, you first use one or more "DEF" lines to grab specific data items from one or more RRD files, and put them into some "variables". You can then either use these variables directly to make a line on the graph, or you can use them for calculating other variables via a "CDEF" line. The default ifstat graph has these lines: DEF:inbytes at RRDIDX@=@RRDFN@:bytesReceived:AVERAGE CDEF:in at RRDIDX@=inbytes at RRDIDX@,8,* (The @RRDIDX@ and @RRDFN@ are because this graph repeats over all the interfaces - Xymon replaces these with a number and the RRD filename). What this does is to first define a variable "inbytes at RRDIDX@" which has the "bytesReceived" value from the RRD. The it computes another variable, "in at RRDIDX@" as 8*inbytes - to convert from bytes to bits. The notation here is Reverse Polish (RPN). So if you have 4 RRD files, one for each interface, you can have RRDtool do the math for you like this: [ifsum] TITLE Network Traffic YAXIS Bits/second DEF:inbytes0=ifstat.eth0.rrd:bytesReceived:AVERAGE DEF:inbytes1=ifstat.eth1.rrd:bytesReceived:AVERAGE DEF:inbytes2=ifstat.eth2.rrd:bytesReceived:AVERAGE DEF:inbytes3=ifstat.eth3.rrd:bytesReceived:AVERAGE CDEF:intotal=inbytes0,inbytes1,inbytes2,inbytes3,+,+,+ CDEF:inbits=intotal,8,* LINE:inbits#FF0000:Aggregate inbound The "LINE" definition then uses the "inbits" value to draw a (red) line with this data. Have a look at graphs.cfg, and I'm sure you can figure out to add a line for the outgoing data also. Add "ifsum" to the GRAPHS setting in xymonserver.cfg, and the graph should show up on the "trends" page. Regards, Henrik PS: I haven't actually tested any of this, so feel free to provide corrections :-) _______________________________________________ Xymon mailing list Xymon at xymon.com http://lists.xymon.com/mailman/listinfo/xymon

3 7

Stop all alerts for maintainance
by akshar.bhosale＠gmail.com 08 Feb '12

08 Feb '12

hi, we have xymon 4.2.2. We want to stop all alerts at a time for some maintainance. How that can be done in one go? -akshar

6 5

Hobbit Server Summary Report
by yefee.liang＠gmail.com 01 Feb '12

01 Feb '12

Hi, How do you go about getting a summary report of clients that a Hobbit server is monitoring and being reported. For example, 1. how many full clients are there (or how many is a hobbit server receiving data)? 2. how many client-less clients are there (no clients, only pings)? My ad-hoc/convoluted approach: # FULL clients are those sending data and updating netstat.rrd files: cd $HOME/data/rrd ls -t */netstat.rrd > file newer_files file TODAY > full_client_list # client-less are those with up-to-date tcp.conn.rrd files ls -t */tcp.conn.rrd > file newer_files file TODAY > all_active (full + client_less) client_less_list = all_active - full_client_list Thank you, Ye-fee

2 1

File Monitor in Central Mode on WinXP
by paul＠shadowsoft.com 31 Jan '12

31 Jan '12

Folks, I am using the filemonitor in bbwin in central mode. It finds the file if it is there but the NOEXIST does not work. I have the following in client-local: [nas] file:c:/publicdata/logs/shouldnotbehere.txt and I have the following in hobbit-clients: HOST=nas FILE "C:/Publicdata/Logs/shouldnotbehere.txt" NOEXIST color=red If the file exists it reports the file but nothing else. Please advise. Paul

1 0

TS - Is there a DB frontend for Xymon maintenance?
by d.tom.schmitt＠L-3com.com 31 Jan '12

31 Jan '12

Team, Has anyone created a Database (MySQL) front-end to handle the HOSTS and ALERTS information? Thus, when finished, you extract all of the data from the tables in the DB and re-create the HOSTS and/or ALERTS files. And then you restart Xymon? I have a need for multiple Admins to do ADD, CHANGE, DELETE requests to the system but they cannot work on the files at the same time. I have had to create a LOCK and UNLOCK (exclusive) while someone is working on the files. The NOTES files are individual files and are no problem as you probably would not be working on someone else's NOTES files. Thanks, Tom Schmitt Senior IT Staff - R&D L-3 Communication Systems West 640 North 2200 West P.O. Box 16850 Salt Lake City, UT 84116 Phone (801) 594-3030 Cell (801) 231-7230 eFax (470) 201-6644 \\\\||//// \ ~ ~ / | @ @ | --oOo---(_)---oOo-- Have A Nice Day !

3 2

how to add a specific http timeout
by nicolas＠lienard.name 31 Jan '12

31 Jan '12

Hi Currently, xymonnet is running with a global timeout of 20 seconds (--timeout=20). For a particular device, i need to increase the HTTP timeout (120 seconds.. sic). I did't find anything regarding this kind of feature. only a old mail of 2006 saying it's not possible. (http://lists.xymon.com/archive/2006-August/009042.html) Is it still not possible to override this timeout individually ? Cheers Nico

2 2

makerpm.sh
by Paul.Root＠CenturyLink.com 31 Jan '12

31 Jan '12

Just how does one use build/makerpm.sh to create an rpm? I'm trying to use it to build just the client, and it's trying to build rrdtool, and I know I don't need that on a client. Paul Root - Senior Engineer Managed Services Systems - CenturyLink This communication is the property of CenturyLink and may contain confidential or privileged information. Unauthorized use of this communication is strictly prohibited and may be unlawful. If you have received this communication in error, please immediately notify the sender by reply e-mail and destroy all copies of the communication and any attachments.

2 2

Load Average threshold - a mathematic rule regarding the number of threads ?
by nicolas＠lienard.name 31 Jan '12

31 Jan '12

Hello Our LA rule is currently "LOAD 5 10" but we can't apply this kind of rule automatically for all our devices anymore. Indeed, we have more and more devices with many threads. I'd like to know if people have the same issue because it's very annoying to override the LOAD when we could automatize it. For instance we would like to follow this kind of rule: 1 cpu : "LOAD 2 4" 2 cpu : "LOAD 4 8" 2 cpu, 12 threads by cpu (=24 threads in total) : "LOAD 48 96" We could calculate it with n=`grep -ci process /proc/cpuinfo` and applying LOAD "n x2" "n x4" It is possible to have this kind of feature ? Anybody else is interested by that ? how do you handle your Load Average threshold ? CHeers Nico

2 1

ping.jsp is empty, Xymon considers this an error
by nleskiw＠gmail.com 31 Jan '12

31 Jan '12

The applications we're testing use an empty ping.jsp page. Xymon considers no content an error. I tried setting httpstatus;URL;0|2..;3..|4..|5..|999 but that hasn't worked. (Other than adding text to the ping.jsp page) can anyone make any recommendations on how to avoid this and still test the URL? -Nick

3 2