- observium - lists.observium.org

big db.log
by Jose Colin 29 Feb '16

29 Feb '16

Hello Guys Recently i report that i had a lot of php processes running on the server and this consume the whole resources of the server so i checked the logs and notice that i have a 3.5 GB db.log file and in there is the next info: t row 1), Query: INSERT INTO `sensors-state` (`sensor_id`,`sensor_value`,`sensor_event`,`sensor_status`,`sensor_last_change`,`sensor_polled`) VALUES ('278','70','ok','','','1456155044') [2016/02/22 15:30:45 +0000] poller.php(9150): Failed dbQuery (#1364 - Field 'ifInUcastPkts_delta' doesn't have a default value), Query: INSERT INTO `ports-state` (`poll_time`,`poll_period`,`ifInOctets`,`ifOutOctets`,`ifInErrors`,`ifOutErrors`,`ifInUcastPkts`,`ifOutUcastPkts`,`ifInOctets_perc`,`ifOutOctets_perc`,`ifOctets_rate`,`ifUcastPkts_rate`,`ifErrors_rate`,`port_id`) VALUES ('1456155045','1456155045','15446864133','15446864133','0','0','66588490','66588490','0','0','0','0','0','524') [2016/02/22 15:30:45 +0000] poller.php(9150): Failed dbQuery (#1364 - Field 'ifInUcastPkts_delta' doesn't have a default value), Query: INSERT INTO `ports-state` (`poll_time`,`poll_period`,`ifInOctets`,`ifOutOctets`,`ifInErrors`,`ifOutErrors`,`ifInUcastPkts`,`ifOutUcastPkts`,`ifInOctets_perc`,`ifOutOctets_perc`,`ifOctets_rate`,`ifUcastPkts_rate`,`ifErrors_rate`,`port_id`) VALUES ('1456155045','1456155045','64446811076','175584922424','0','0','339891989','309672599','0','0','0','0','0','525') [2016/02/22 15:30:46 +0000] poller.php(6813): Failed dbQuery (#1364 - Field 'mempool_polled' doesn't have a default value), Query: INSERT INTO `mempools-state` (`mempool_id`) VALUES ('91') [2016/02/22 15:30:46 +0000] poller.php(6813): Failed dbQuery (#1364 - Field 'mempool_polled' doesn't have a default value), Query: INSERT INTO `mempools-state` (`mempool_id`) VALUES ('92') [2016/02/22 15:30:46 +0000] poller.php(6813): Failed dbQuery (#1364 - Field 'mempool_polled' doesn't have a default value), Query: this is the reason why i have many poller pids on the server. please can you guide to fix this issue?. thanks in advice. José.

2 2

Device showing interface error cleared long ago
by KA PDE 29 Feb '16

29 Feb '16

Hi, I have a device which is always showing an interface error which was previous to the Observium installation. I cleared the error on the switch and it did not reproduce. However Observium is showing it every day I check. I've tried to delete the device and adding it back and it show the error again. After upgrading to the latests CE it is the same. Maybe this has persisted in the DB, I don't know... Does anyone has any hint for this behaviour? Thanks in advance and best regards, Pau

1 0

Port Customer/Transit/peering
by chott＠praha1.net 28 Feb '16

28 Feb '16

Hello team, we are try set Description of port for recognize usage of port like this notes http://observium.org/w/Interface_Description_Parsing We have lot of port description starting "cust" and "transit" but Observium every time after go to Ports/Customers write "None found." Thank you for help Tom [email-header-praha1] Tomas Chott technický ředitel chott(a)praha1.net<mailto:chott@praha1.net> Phone: +420 245 004 005 Mobile: +420 733 123 135 Metropolitní síť Praha 1 z.s.p.o. Jindrisska 18 110 00 Praha 1 Czech Republic www.praha1.net<http://www.praha1.net> [Popis: Facebook]<http://www.facebook.com/praha1net> <http://www.linkedin.com/pub/tomas-chott/49/97a/1aa>

5 11

DOM optic sensor graphs always rounded to 0W
by Sandy Breeze 26 Feb '16

26 Feb '16

Hi, Currently running: 0.16.1.7533 (26th January 2016) We’ve noticed the DOM optic power sensor data to be graphed at 0W all the time. Noticing the ‘value’ figure is correct on the optic’s power status page, we subsequently found all data in the RRD to be correct. eg:  <row><v>6.1840000000e-04</v></row>  <row><v>6.1300000000e-04</v></row>  <row><v>6.1435000000e-04</v></row> It just seems the rrdtool graph function is not rendering this sensor data with anything useful. The graph is being generated with something like this: rrdtool graph /tmp/FLjPO7rtfRJQOfGn.png -Y --lower-limit 0 --alt-autoscale-max --start 1456347228 --end 1456433628 --width 1152 --height 300 -c BACK#EEEEEE00 -c SHADEA#EEEEEE00 -c SHADEB#EEEEEE00 -c FONT#000000 -c CANVAS#FFFFFF00 -c GRID#a5a5a5 -c MGRID#FF9999 -c FRAME#5e5e5e -c ARROW#5e5e5e -R normal --font LEGEND:8:'DroidSansMono,DejaVuSansMono' --font AXIS:7:'DroidSansMono,DejaVuSansMono' --font-render-mode normal -E -A COMMENT:' Last Max\n' DEF:sensor=/srv/www/iss/observium/rrd/t40-ar14/sensor-power-cisco-entity-sensor-58513400.rrd:sensor:AVERAGE DEF:sensor_max=/srv/www/iss/observium/rrd/t40-ar14/sensor-power-cisco-entity-sensor-58513400.rrd:sensor:MAX DEF:sensor_min=/srv/www/iss/observium/rrd/t40-ar14/sensor-power-cisco-entity-sensor-58513400.rrd:sensor:MIN AREA:sensor_max#c5c5c5 AREA:sensor_min#ffffffff LINE1.5:sensor#cc0000:'Transceiver Rx Power -' GPRINT:sensor:LAST:%6.2lfW GPRINT:sensor:MAX:%6.2lfW\\l HRULE:0.0009585#999999::dashes Seeing the data collected is in the order of 10^-4 d.p. small, how can we stop this being rounded to 0 all the time on a the graph? I understand completely this is rrdtool not automatically choosing a very good scale for you, but is there any way to detect these low values and fix them up for the graphs by order of 1000 say? Cheers Sandy

4 6

Subscription Graphs Issue/API
by Josh Hopper 26 Feb '16

26 Feb '16

Well, my graphs do not work. Trying to figure out where I went wrong so I do not have to reinstall from scratch. Any assistance, is highly appreciated. I see this: [image: Inline image 1] Its the same for every device. I'm on Observium 0.16.2.7629 (stable). I thought it might be my config.php so I posted it below. root@svr-observium:/opt/observium# cat config.php <?php ## Check http://www.observium.org/docs/config_options/ for documentation of possible settings // Database config --- This MUST be configured $config['db_extension'] = 'mysqli'; $config['db_host'] = 'localhost'; $config['db_user'] = 'observium'; $config['db_pass'] = 'XXXXXXXX'; $config['db_name'] = 'observium'; // Base directory #$config['install_dir'] = "/opt/observium"; // Default community list to use when adding/discovering $config['snmp']['community'] = array("public"); // Authentication Model $config['auth_mechanism'] = "mysql"; // default, other options: ldap, http-auth, please see documentation for config help // Enable alerter (not available in CE) // $config['poller-wrapper']['alerter'] = TRUE; // Set up a default alerter (email to a single address) $config['email']['default'] = "user@your-domain"; $config['email']['from'] = "Observium <observium@your-domain>"; $config['email']['default_only'] = TRUE; // End config.php ?>

2 2

Creating group with ifInOctets_perc
by Louis Bailleul 26 Feb '16

26 Feb '16

Hi, Seems that I can’t create a group that uses ifInOctets_perc for its entity match ? Is this because of a reason/bug or I am doing it stupidly ? My alert checker is working fine and I was able to create a group with ifOperStatus. They are both in the Mettrics category so I expected them to work the same way. [cid:image001.png@01D170AF.C90F8400] [cid:image002.png@01D170AF.C90F8400] Best regards, Louis [http://www.pgs.com/mediaFiles/Exclaimer%20graphics/PGS_LOGO_RGB_42x53px.jpg]<http://www.pgs.com> Louis Bailleul Computer Systems Engineer Imaging & Engineering | Imaging Telephone: +44 1932 376000 Direct: +44 1932 376842 VOIP: 74416842 Mobile: +44 7786 525307 Email: louis.bailleul(a)pgs.com<mailto:Louis.Bailleul@pgs.com> A Clearer Image | www.pgs.com<http://www.pgs.com> [http://www.pgs.com/mediaFiles/Exclaimer%20graphics/150731-ColourWave-660x14…] Address: 4 The Heights, Brooklands, Weybridge, Surrey, KT13 0NY, United Kingdom This e-mail, including any attachments and response string, may contain proprietary information which is confidential and may be legally privileged. It is for the intended recipient only. If you are not the intended recipient or transmission error has misdirected this e-mail, please notify the author by return e-mail and delete this message and any attachment immediately. If you are not the intended recipient you must not use, disclose, distribute, forward, copy, print or rely on this e-mail in any way except as permitted by the author.

2 2

Panasas support
by Louis Bailleul 26 Feb '16

26 Feb '16

Hi, I have a few Panasas devices that (not surprisingly) Observium doesn’t handle very well. It basically only get the uptime out of it. The devices are similar to this : http://www.panasas.com/products/activestor-16-18 I have attached debug discovery, poller and snmpwalk of the top tree and enterprise parts. I also have attached the mibs from the device (retrieved from the device itself) and a logo (retrieved from http://www.panasas.com/news/press-room ) It looks like there is very little in the standard places and every interesting thing has been shoved into the enterprise tree. Do you think it is possible to add support for these devices ? Best regards, Louis [http://www.pgs.com/mediaFiles/Exclaimer%20graphics/PGS_LOGO_RGB_42x53px.jpg]<http://www.pgs.com> Louis Bailleul Computer Systems Engineer Imaging & Engineering | Imaging Telephone: +44 1932 376000 Direct: +44 1932 376842 VOIP: 74416842 Mobile: +44 7786 525307 Email: louis.bailleul(a)pgs.com<mailto:Louis.Bailleul@pgs.com> A Clearer Image | www.pgs.com<http://www.pgs.com> [http://www.pgs.com/mediaFiles/Exclaimer%20graphics/150731-ColourWave-660x14…] Address: 4 The Heights, Brooklands, Weybridge, Surrey, KT13 0NY, United Kingdom This e-mail, including any attachments and response string, may contain proprietary information which is confidential and may be legally privileged. It is for the intended recipient only. If you are not the intended recipient or transmission error has misdirected this e-mail, please notify the author by return e-mail and delete this message and any attachment immediately. If you are not the intended recipient you must not use, disclose, distribute, forward, copy, print or rely on this e-mail in any way except as permitted by the author.

2 2

observium-rancid mail configuration
by Sathish.I 26 Feb '16

26 Feb '16

Hi All, I am very new to observium, I have successfully integrated rancid with Observium, taking backup ups. However, I am unable to receive the mail when backup was tacken. Can anyone share the config template to integrate rancid and mail configuration for rancid. Thanks in advance. Regards, Sathish Ippani NSE Team CtrlS is India's First and Asia's largest Tier 4 Datacenter operating across India, USA, and UAE Follow us on <https://www.linkedin.com/company/ctrls-datacenters-ltd> Description: Description: Description: Description: Description: Description: http://www.ctrls.com/email-signature/images/linkedin.jpg <https://twitter.com/CtrlSDC> Description: Description: Description: Description: Description: Description: http://www.ctrls.com/email-signature/images/twitter.jpg <https://www.facebook.com/CtrlSDatacenters> Description: Description: Description: Description: Description: Description: http://www.ctrls.com/email-signature/images/facebook.jpg Description: Description: Description: Description: Description: Description: http://www.ctrls.com/email-signature/images/devider.jpg Description: Description: Description: Description: Description: Description: Ctrls Description: Description: Description: Description: Description: Description: http://www.ctrls.com/email-signature/images/devider.jpg CtrlS Datacenters Ltd 16,Software Units Layout, Madapur (HitechCity), Hyderabad 500081, Telangana, India Mob: +91 9515600544 Tel : +91 (40) 420430700 Fax : +91 (40) 23116055

2 1

Filtering ports/devices
by Michael 26 Feb '16

26 Feb '16

Does anybody know of a syntax that will allow multiple matches when filtering on device hostnames? I'm specifically on the all ports page. We've smashed two separate networks together and there are different naming conventions in use. When I want to look at only one side of the network, it would be easy if I could match all devices starting with p, s or m-. The hostname field doesn't seem to accept regex, nor does it accept "or" statements. Is there a solution to this? Cheers, Michael

1 0

Alerts based on RRD averages?
by Stephen Fulton 25 Feb '16

25 Feb '16

Hi all, I'm curious if it is possible to create an alert that considers an RRD average? For example, if I want to generate an alert that looks at the average utilization of a port over a 24 hour period, and if the average bit rate or percentage is greater than X, send an alert? I have been working with alerts that trigger based on a percentage, but if the port drops below that mark for even a short period of time (minutes, perhaps even an hour or two), the clock resets. That's proving troublesome. Any suggestions? Thanks, -- Stephen

2 1