December 2007 - Xymon - Xymon mailman web

dbcheck.pl + MsSQL monitoring
by linuxmasterjedi＠free.fr 04 Dec '07

04 Dec '07

Hello guys, I'm wondering if someone already checking MsSQL databases. I'm curious about each step to monitor it. I've installed freetds and wrote that : [myMySQL_DB] host = bahia.latecoere.gl.local port = 1433 tds version = 7.0 Netapp.ini: [myMySQL_DB] dbtype = SQLServer hostname = MsSQLServer1 port = 1433 username = hobbit password = hobbitpwd bb-hosts group MsSQL 0.0.0.0 myMySQL_DB # noconn noping dbcheck NAME:"CE" DESCR:"MsSQLServer1:" But it doesn't work, I have this error : Connection failed with unknown error for "DBI:Sybase:host=bahia;port=1433;encryptPassword=1"! Anyone could have an idea why ?

2 1

test
by michael.nemeth＠lmco.com 04 Dec '07

04 Dec '07

1 0

[hobbit] Solaris vmstat and sar
by jkwade＠futurefrontiers.com 03 Dec '07

03 Dec '07

But you should not see a major difference like 67% idle to 1% idle.... I've tried using two screens on the same system comparing sar to vmstat and using different intervals. vmstat significantly understates cpu usage in comparison to top, uptime, and sar. Does any have any ideas? James -----Original Message----- From: Langford, Kenneth [mailto:crlangfo at ugs.com] Sent: Monday, December 03, 2007 2:13 PM To: hobbit at hswn.dk Subject: RE: [hobbit] Solaris vmstat and sar The vmstat first line shows the system average stats for systems since the last time the system was booted. Vmstat shows the average use over the 5 second interval in you example below of vmstat 5 5. Sar shows the stats at the time the check was taken. So you are not comparing apples to apples. So they are going to give you different results. Ken L. -----Original Message----- From: James Wade [mailto:jkwade at futurefrontiers.com] Sent: Monday, December 03, 2007 2:34 PM To: hobbit at hswn.dk Subject: RE: [hobbit] Solaris vmstat and sar Tried that, It didn't work. You still get some lines that have incorrect data, like 67% idle. The sar data showed cpu idle at 1% or 0% all 5 lines. James -----Original Message----- From: Lund, Holly [mailto:holly.lund at hq.doe.gov] Sent: Monday, December 03, 2007 1:12 PM To: hobbit at hswn.dk Subject: RE: [hobbit] Solaris vmstat and sar vmstat first output is invalid. doing vmstat 5 5 the other 4 should change to reflect sar Holly Lund To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

1 0

[hobbit] Solaris vmstat and sar
by jkwade＠futurefrontiers.com 03 Dec '07

03 Dec '07

Tried that, It didn't work. You still get some lines that have incorrect data, like 67% idle. The sar data showed cpu idle at 1% or 0% all 5 lines. James -----Original Message----- From: Lund, Holly [mailto:holly.lund at hq.doe.gov] Sent: Monday, December 03, 2007 1:12 PM To: hobbit at hswn.dk Subject: RE: [hobbit] Solaris vmstat and sar vmstat first output is invalid. doing vmstat 5 5 the other 4 should change to reflect sar Holly Lund

2 1

[hobbit] Solaris vmstat and sar
by jkwade＠futurefrontiers.com 03 Dec '07

03 Dec '07

I agree with you, but the snapshots that I emailed were taken at the same time. I'm now graphing both Sar CPU Utilization, and Hobbit CPU Utilization which uses vmstat. SAR shows the more correct CPU Utilization as compared to CPU Load (uptime). Also, "TOP" confirms that CPU is loaded. I have a multi-cpu version of top I use and all the CPU's are max'd with 1% or 2% idle. During this timeframe, cpu utilization using vmstat shows 67% idle.. I've seen this problem for a while now on multiple systems, but I just recently wrote my own sar script to put sar cpu into hobbit graphs to confirm this. Here's where I just did a 5 minute average in two different windows on the same box at the same time: vmstat shows 67% idle, sar, 26% idle: vmstat 300 2 kthr memory page disk faults cpu r b w swap free re mf pi po fr de sr s3 s3 s9 s1 in sy cs us sy id 0 4 0 68896560 24040168 673 3181 1548 15 14 0 0 12 12 0 0 12938 44125 19506 18 15 67 0 4 0 68896480 24040352 673 3181 1548 15 14 0 0 12 12 0 0 12942 44130 19525 18 15 67 $ sar 300 1 12:44:17 %usr %sys %wio %idle 12:49:17 31 32 11 26 TOP shows sar is correct: load averages: 18.56, 17.41, 17.71 12:54:14 866 processes: 836 sleeping, 1 running, 7 stopped, 22 on cpu CPU states: 14.6% idle, 36.6% user, 32.4% kernel, 16.5% iowait, 0.0% swap Memory: 48G real, 24G free, 18G swap in use, 65G swap free James _____ From: Lars Ebeling [mailto:lars.ebeling at leopg9.no-ip.org] Sent: Monday, December 03, 2007 12:28 PM To: hobbit at hswn.dk Subject: Re: [hobbit] Solaris vmstat and sar Hello, I don't think you should compare like that. They are snapshots and only reflecting the status at that moment. I did vmstat -n 5 5 on HP-UX and got: VM memory page faults avm free re at pi po fr de sr in sy cs 65466 9823 22 8 2 0 0 0 1 113 3 139 CPU cpu procs us sy id r b w 37 4 60 2 0 0 65466 9675 6 4 1 0 0 0 0 113 377 87 2 1 96 2 0 0 71121 8536 174 43 5 0 0 0 0 117 6766 142 23 13 65 2 4 0 71121 8991 201 98 3 0 0 0 0 98 8594 238 65 24 12 2 4 0 84056 8990 86 34 1 0 0 0 0 103 3979 120 5 3 92 5 1 0 # Here you can see that idle varies 60% 96% 65% 12% 92% Regards Lars ----- Original Message ----- From: James <mailto:jkwade at futurefrontiers.com> Wade To: hobbit at hswn.dk Sent: Monday, December 03, 2007 7:10 PM Subject: [hobbit] Solaris vmstat and sar All, Solaris vmstat is crummy for CPU Utilization. If I do a vmstat on a Solaris box that's having high load, I get 67% idle, yet sar shows 3% idle. Has anyone seen this before? sar -u 1 1 12:08:40 %usr %sys %wio %idle 12:08:41 46 44 6 4 vmstat 1 1 kthr memory page disk faults cpu r b w swap free re mf pi po fr de sr s3 s3 s9 s1 in sy cs us sy id 0 4 0 68897248 24039040 673 3180 1550 15 14 0 0 12 12 0 0 12901 44078 19363 18 15 67 So, what's the work around because Hobbit is using vmstat? James

2 1

Solaris vmstat and sar
by jkwade＠futurefrontiers.com 03 Dec '07

03 Dec '07

All, Solaris vmstat is crummy for CPU Utilization. If I do a vmstat on a Solaris box that's having high load, I get 67% idle, yet sar shows 3% idle. Has anyone seen this before? sar -u 1 1 12:08:40 %usr %sys %wio %idle 12:08:41 46 44 6 4 vmstat 1 1 kthr memory page disk faults cpu r b w swap free re mf pi po fr de sr s3 s3 s9 s1 in sy cs us sy id 0 4 0 68897248 24039040 673 3180 1550 15 14 0 0 12 12 0 0 12901 44078 19363 18 15 67 So, what's the work around because Hobbit is using vmstat? James

2 1

Sending alerts to remote system running qpage
by Keller_Liora＠emc.com 03 Dec '07

03 Dec '07

Hi, We are moving from BB to Hobbit. We are using qpage to send out pages from BB to a remote system which is running qpage. We would like to keep the qpage and modem on the same server, but the Hobbit server is running on a different system. Any idea how we can send alerts from Hobbit to a remote qpage server? Thanks, Liora

3 2

[hobbit] Sending alerts to remote system running qpage
by Keller_Liora＠emc.com 01 Dec '07

01 Dec '07

We are using qpage to page on cell phones, we don't use email-sms. On BB we configured "QPAGEARGS" and set the remote hostname.

2 1

Hobbit server doesn't start on CentOS 5 with hobbit-4.2.0-7.el5.re.i386.rpm installed
by spa＠syntec.co.uk 01 Dec '07

01 Dec '07

I installed an RPM of hobbit-4.2.0 called hobbit-4.2.0-7.el5.re.i386.rpm, which I probably got from here: http://rpm.razorsedge.org/centos-5/RE/repodata/repoview/hobbit-4-4.2.0-7.el5 .re.html It includes the All-in-one patch. So I configured the cfg files and started hobbit, but I get this in hobbitlaunch.log: 2007-11-29 17:33:47 hobbitlaunch starting 2007-11-29 17:33:47 Loading tasklist configuration from /usr/libexec/hobbit/server/etc/hobbitlaunch.cfg 2007-11-29 17:33:47 Loading hostnames 2007-11-29 17:33:47 Loading saved state 2007-11-29 17:33:47 Cannot access checkpoint file /usr/libexec/hobbit/server/tmp/hobbitd.chk for restore 2007-11-29 17:33:47 Setting up network listener on 0.0.0.0:1984 2007-11-29 17:33:47 Setting up signal handlers 2007-11-29 17:33:47 Setting up hobbitd channels 2007-11-29 17:33:47 Could not get shm of size 262144: No space left on device 2007-11-29 17:33:47 Cannot setup status channel 2007-11-29 17:33:47 Task hobbitd terminated, status 1 This is the first time I've started it, so I presume that this is normal: "Cannot access checkpoint file /usr/libexec/hobbit/server/tmp/hobbitd.chk for restore". The problem looks like this: "Could not get shm of size 262144: No space left on device". I see that there are two similar issues listed on http://www.hswn.dk/hobbit/help/known-issues.html that relate to FreeBSD, but none of the sysctl keys listed are in this version of Linux: # cat /proc/version Linux version 2.6.18-8.1.15.el5.centos.plus (mockbuild at builder6.centos.org) (gcc version 4.1.1 20070105 (Red Hat 4.1.1-52)) #1 SMP Thu Oct 25 06:49:40 EDT 2007 Google returns 1 result for "Could not get shm of size" "No space left on device" and that was the Known Issues page I've already checked. Any ideas? Also, I noticed that the hobbitd.pid file did not get deleted when hobbitd terminated. It seems like it should have been. Many thanks, Sebastian

7 17