- observium - lists.observium.org

Weird database issue?
by Nick Pais 08 Aug '14

08 Aug '14

Hi guys, It's been a while since I posted on here, but I made a fresh Observium installation (for the moment, yes, it's CE, can't convince the CEO to shell out that cash for Pro yet...) however I'm having a weird issue with the table ports-state: root@comet:/opt/observium# ./poller.php -h 1 -d | grep -C2 MEMORY\ DB SQL[INSERT INTO `ports-state` (`port_id`) VALUES ('1')] Certain MEMORY DB error for table 'ports-state'. SQL[UPDATE `ports-state` set `poll_time` ='1407517231',`poll_period` ='1407517231',`ifInOctets` ='2974209',`ifOutOctets` ='2974209',`ifInErrors` ='0',`ifOutErrors` ='0',`ifInUcastPkts` ='10310',`ifOutUcastPkts` ='10310',`ifInOctets_perc` ='0',`ifOutOctets_perc` ='0',`ifOctets_rate` ='0',`ifUcastPkts_rate` ='0',`ifErrors_rate` ='0' WHERE `port_id` = '1'] -- SQL[INSERT INTO `ports-state` (`port_id`) VALUES ('2')] Certain MEMORY DB error for table 'ports-state'. SQL[UPDATE `ports-state` set `poll_time` ='1407517231',`poll_period` ='1407517231',`ifInOctets` ='997162274',`ifOutOctets` ='12070347',`ifInErrors` ='0',`ifOutErrors` ='0',`ifInUcastPkts` ='929556',`ifOutUcastPkts` ='92562',`ifInOctets_perc` ='0',`ifOutOctets_perc` ='0',`ifOctets_rate` ='0',`ifUcastPkts_rate` ='0',`ifErrors_rate` ='0' WHERE `port_id` = '2'] -- SQL[INSERT INTO `ports-state` (`port_id`) VALUES ('3')] Certain MEMORY DB error for table 'ports-state'. SQL[UPDATE `ports-state` set `poll_time` ='1407517231',`poll_period` ='1407517231',`ifInOctets` ='17012646',`ifOutOctets` ='369532358',`ifInErrors` ='0',`ifOutErrors` ='0',`ifInUcastPkts` ='74830',`ifOutUcastPkts` ='550361',`ifInOctets_perc` ='0',`ifOutOctets_perc` ='0',`ifOctets_rate` ='0',`ifUcastPkts_rate` ='0',`ifErrors_rate` ='0' WHERE `port_id` = '3'] root@comet:/opt/observium# This in turn doesn't enable the "current" port speeds on the web and when I look in the database itself, the table is empty. Has anyone come accross this before? Is there a way to fix this? Details: OS: Debian 7.6 PHP: 5.4.4-14+deb7u12 MySQL: 5.6.15 Observium: v0.14.4.5229 Thanks in advance guys!

2 1

Patch for Jira ticket 333 throws error
by Laurens Vets 08 Aug '14

08 Aug '14

Hello, I've installed Netdisco 2 with the Observium plugin. This plugin allows Netdisco to show graphs and open interface pages in Observium from within Netdisco. This is also related to Jira ticket 333. When I open a URL, http://observium.server//device/hostname=name.domainname/tab=port/ifdescr=R…) in Netdisco, I get the following error: "Invalid device/port combination. The port/device combination was invalid. Please retype and try again.". However, the correct page is shown in Observium... Any idea what generates this error message?

3 3

Bind graph problems
by Brad Pearpoint 07 Aug '14

07 Aug '14

Hi all, I have a problem with my bind graphs in Observium 0.14.8.5736 with RRDtool 1.4.7. I have the Unix-agent configured with the bind plugin on two dev DNS servers. These DNS servers are under really low load, just a couple of requests a minute at most. If I run dns# ./bind | grep -i req-in,Q I receive: req-in,QUERY:1562 Which is correct. Then on my Observium box if I run: obs# rrdtool info /opt/observium/rrd/dns2 /app-bind-1-req-in.rrd | grep query ds[query].index = 0 ds[query].type = "DERIVE" ds[query].minimal_heartbeat = 600 ds[query].min = 0.0000000000e+00 ds[query].max = 7.5000000000e+06 ds[query].last_ds = "1562" <<<<<<<<< Looks good ds[query].value = 0.0000000000e+00 ds[query].unknown_sec = 0 But my graphs in the web interface of totally wrong. My incoming requests graph is showing 100-250 million. Any tips of where to start looking to solve this? Thanks, Brad

4 4

No description names on Calix
by Travis Kreikemeier 07 Aug '14

07 Aug '14

In Observium we are not getting any port descriptions on Calix E7 active ports, nor are we getting ONT names on GPON. Something we need to change or needs to be added to Observium? Thanks! [cid:image001.png@01CFB227.ED080C30] TRAVIS KREIKEMEIER

2 1

Ubuntu vs CentOS
by Anthony Polselli 07 Aug '14

07 Aug '14

Hi all, We are looking at purchasing the software and want to know which platform is better? We are a CentOS shop, but if we need paid support or want some custom development done, would Ubuntu be better? Thanks, [cid:image001.jpg@01CFB213.F86539E0] __________________________________________ Anthony Polselli, Chief Technology Officer Natural Networks, Inc. 10225 Barnes Canyon Rd. Suite A105 San Diego, CA 92121 anthony(a)naturalnetworks.com<mailto:anthony@naturalnetworks.com> http://www.naturalnetworks.com<http://www.naturalnetworks.com/> (619) 222-3232 office (858) 202-0301 fax

5 5

billing module / e-mail
by Anthony Polselli 07 Aug '14

07 Aug '14

Is it possible to get an automated monthly e-mail listing all of the clients that went over on usage? [cid:image001.jpg@01CFB19F.8FF099A0] __________________________________________ Anthony Polselli, Chief Technology Officer Natural Networks, Inc. 10225 Barnes Canyon Rd. Suite A105 San Diego, CA 92121 anthony(a)naturalnetworks.com<mailto:anthony@naturalnetworks.com> http://www.naturalnetworks.com<http://www.naturalnetworks.com/> (619) 222-3232 office (858) 202-0301 fax

2 1

Re: [Observium] Freeradius monitoring
by Tomasz Karczewski 07 Aug '14

07 Aug '14

Anyone? Tomasz Karczewski Administrator Sieci tkarczewski(a)man.olsztyn.pl http://www.man.olsztyn.pl http://www.uwm.edu.pl tel. (89) 523 45 55 fax. (89) 523 43 47 Ośrodek Eksploatacji i Zarządzania Miejską Siecią Komputerową OLMAN w Olsztynie Uniwersytet Warmińsko-Mazurski w Olsztynie From: observium [mailto:observium-bounces@observium.org] On Behalf Of Tomasz Karczewski Sent: Thursday, August 07, 2014 11:12 AM To: 'Observium Network Observation System' Subject: [Observium] Freeradius monitoring Hi, I'm trying to figure out how to monitor freeradius application in observium. It's hard to find anything. Could you help me with that? Tnx Thomas

3 3

API access key
by Greg Lipschitz 07 Aug '14

07 Aug '14

Evening All, I've noticed in the settings, the option for "API access key" but it doesn't yet seem that it's implemented. We're currently looking at doing some development to pull the graphs for services from Observium and inject them in to our Client Portal so that clients get nice pretty graphs. Has anyone done something similar? Some guidance or pointers would be great :) Cheers! Greg Greg Lipschitz Director Summit IT Management<http://www.thesummitgroup.com.au> | Summit Internet<http://www.summitinternet.com.au> | Summit Creative<http://www.summitcreative.com.au> - ‘reach your peak’ Divisions of The Summit Group (Australia) Pty Ltd Phone (Australia): 1300 049 749 Phone (US & Canada): (321) 216 3844 E-mail: Greg(a)thesummitgroup.com.au<mailto:Greg@thesummitgroup.com.au> Internet: http://www.thesummitgroup.com.au/<http://www.thesummitgroup.com.au> Address: Level 1, 39 Railway Road, Blackburn VIC 3130 Postal: P.O. Box 3225, Doncaster East VIC 3109 Follow us on Facebook<http://www.facebook.com/thesummitgroup/> | LinkedIn<http://www.linkedin.com/company/1942329> | Twitter<http://twitter.com/summitgroupau/> -- ExchangeDefender Message Security: Click below to verify authenticity https://admin.exchangedefender.com/verify.php?id=s77BXM8O023601&from=greg@t…

2 3

windows wmi monitoring
by Simon Smith 07 Aug '14

07 Aug '14

Hi All, hoping someone can help, altho I'm sure this has been answered in the past? i just can’t find the webpage or emails from it at all i want to monitor a few windows machines i have setup the SNMP correctly and all is well but the processor is being detected as Unknown Processor Type due to windows being a tool! i read somewhere that i could use the WMI to fix this issue plus get more outta the windows machine dos anyone have a guide or instructions how to setup the WMI correctly to identify things for observium? Regards Simon

4 4

How to add SNMP support in observium for ambient Temperature
by observium＠willfahrt.net 06 Aug '14

06 Aug '14

Hi all, I hope someone can help, I'm sure this has been answered before? - Sorry in advance! I want to monitor a few Linux machines with ambient temperature sensing devices. The NetSNMPd Client Configuration is working and I get a successful response as you can see: ~# snmpget -v 2c temphost -c public .1.3.6.1.2.1.25.1.10 HOST-RESOURCES-MIB::hrSystem.9 = Gauge32: 23000 How can I modify the host configuration to add the ambient Temperature information in the Observium? Best regards, Jens

3 5