- observium - lists.observium.org

STRICT mode on SQL.
by Dirk-Willem van Gulik 22 Jan '16

22 Jan '16

FWIIW - may be that the STRICT mode is not the only delta. Spotted below error[1] during the initial discovery/poll cycle; and [2] in the update-error log (we are trying to figure out why the port graphs stopped updating). All on a -latest community version as of a few hours ago. Against "MYSQL Server version: 5.6.27 Source distribution” and PHP 5.6.17 (cli). Dw 1: SQL[SELECT *, I.`port_id` AS `port_id` FROM `ports` AS I LEFT JOIN `ports-state` AS S ON I.`port_id` = S.`port_id` WHERE `device_id` = '1'] RUNTIME[0.00157404s] ….. SQL[INSERT INTO `ports` (`device_id`,`ifIndex`) VALUES ('1','29')] RUNTIME[0.00024199s] ERROR[Error in query: (1062) Duplicate entry '1-29' for key 'device_ifIndex'] SQL[SELECT * FROM `ports` WHERE `port_id` = ''] RUNTIME[0.00043392s] Adding: po1(29)() SQL[INSERT INTO `ports` (`device_id`,`ifIndex`) VALUES ('1','30')] RUNTIME[0.00025010s] ERROR[Error in query: (1062) Duplicate entry '1-30' for key 'device_ifIndex’] …. 2: [observium@observium /usr/local/www/observium/logs]$ more update-errors.log [2016/01/22 12:09:22 +0000] discovery.php(23667): ====== Schema update 137 -> 138 ============== [2016/01/22 12:09:22 +0000] discovery.php(23667): Query: ALTER TABLE `sensors` ADD `entPhysicalIndex_measured` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL AFTER `sensor_custom_limit`; [2016/01/22 12:09:22 +0000] discovery.php(23667): Error: (1060) Duplicate column name 'entPhysicalIndex_measured' [2016/01/22 12:09:22 +0000] discovery.php(23667): Query: ALTER TABLE `sensors` ADD `measured_class` VARCHAR( 32 ) NULL DEFAULT NULL AFTER `entPhysicalIndex_measured`; [2016/01/22 12:09:22 +0000] discovery.php(23667): Error: (1060) Duplicate column name 'measured_class' [2016/01/22 12:09:22 +0000] discovery.php(23667): Query: ALTER TABLE `sensors` ADD `measured_entity` VARCHAR( 32 ) NULL DEFAULT NULL AFTER `measured_class`; [2016/01/22 12:09:22 +0000] discovery.php(23667): Error: (1060) Duplicate column name ‘measured_entity'

2 1

ModbusTCP via SNMP Gateway. Possible to monitor in Observium?
by Henrik Cednert (Filmlance) 22 Jan '16

22 Jan '16

Hi I have a schneider tsxetg100 ethernet gateway that has a PowerLogic PM3250 attached to it. I can successfully monitor this in APC StruxureWare Data Center expert but trying to get away from that solution. Observium does find and see the tsxetg100 as a generic device but I don't see the PowerLogic attached to it. Is it possible to monitor a Modbus TCP device like this through the SNMP gateway? The tsxetg100: http://www.schneider-electric.com/download/ww/en/details/25779671-TSXETG100… The Powerlogic: http://www.schneider-electric.com/en/product-range/61274-powerlogic-pm3000-… Cheers and thanks -- Henrik Cednert cto | td | compositor Filmlance International Direct + 46 (0)704 71 89 54

4 15

Making older pre rfc 1759 printers happy
by Dirk-Willem van Gulik 22 Jan '16

22 Jan '16

Minor diff to make things work with an older type of printer. Dw --- toner.inc.php.orig 2016-01-21 19:49:49.528405666 +0100 +++ toner.inc.php 2016-01-21 20:06:36.382527604 +0100 @@ -39,10 +39,11 @@ $index = $split_oid[count($split_oid)-1]; if (is_numeric($role)) { - $type_oid = ".1.3.6.1.2.1.43.11.1.1.5.1.$index"; - $descr_oid = ".1.3.6.1.2.1.43.11.1.1.6.1.$index"; - $capacity_oid = ".1.3.6.1.2.1.43.11.1.1.8.1.$index"; - $toner_oid = ".1.3.6.1.2.1.43.11.1.1.9.1.$index"; + $class_oid = ".1.3.6.1.2.1.43.11.1.1.4.1.$index"; // prtMarkerSuppliesClass (supplyThatIsConsumed(3), receptacleThatIsFilled(4)) + $type_oid = ".1.3.6.1.2.1.43.11.1.1.5.1.$index"; // prtMarkerSuppliesType + $descr_oid = ".1.3.6.1.2.1.43.11.1.1.6.1.$index"; // prtMarkerSuppliesDescription + $capacity_oid = ".1.3.6.1.2.1.43.11.1.1.8.1.$index"; // prtMarkerSuppliesMaxCapacity + $toner_oid = ".1.3.6.1.2.1.43.11.1.1.9.1.$index"; // prtMarkerSuppliesLevel $classtype = snmp_get($device, $class_oid, "-Oqv"); $resourcetype = snmp_get($device, $type_oid, "-Oqv"); @@ -52,8 +53,10 @@ { switch ($resourcetype) { - case 3: - case 21: + case 3: // Toner + case 5: // Ink or particulate + case 6: // InkCardridge + case 21: // Toner Cardridge /* .1.3.6.1.2.1.43.11.1.1.8 prtMarkerSuppliesMaxCapacity * The value (-1) means other and specifically indicates that the sub-unit places * no restrictions on this parameter. The value (-2) means unknown. @@ -133,8 +136,11 @@ set_dev_attrib($device, "transferroller_cap_oid", $capacity_oid); } break; - case 4: - if (stristr($descr, 'waste') !== FALSE) + case 4: // Waste Toner + case 8: // Waste Ink or toner + case 24: // Waste liquid or Ink + if (stristr($descr, 'waste') !== FALSE || stristr($descr, 'absorber') == FALSE || $classtype == 3) { echo(" WasteTonerBox"); set_dev_attrib($device, "wastebox_oid", $toner_oid);

3 6

Proxmox
by Cody Cook 22 Jan '16

22 Jan '16

Hi everyone, Two things about Proxmox and my usage with Observium: Upgraded all of my Proxmox boxes except one to 4.0 from 3.4. I use zfs for all the file systems. Since switching to Proxmox 4.0, appears that snmp no longer includes the zfs volumes automatically in the SNMP reply. :( Does anyone have some suggestions on automatically showing their zfs vols in SNMP? I read a manpage for snmpd.conf but only recognized the ignoreDisk screen to manually add. Some other site said begemotSnmpdModulePath."hostres" = /usr/lib/snmp_hostres.so would be useful if I was on FreeBSD, but I am using Debian :P Another question I had is that I was reading that there is the ability to query Proxmox for VMs. Neither my 3.4 or my 4.0 box show VMs. My enable_libvirt is 1 and I use lxc+ssh and openvz+ssh in the libvirt protocols option in the config (lxc for 4.0, openvz for 3.4). I don't see anything VM. I do have tab for VMs for my vmware esxi server though. The public key from Observium is in the authorized_keys file for each of my root users on each proxmox box. What am I missing here? net-snmp version: 5.7.2.1+dfsg-1 Cody

2 2

Location
by Tibor Marchyn 22 Jan '16

22 Jan '16

Hi all, I don't know if it's bug, but I have set locaton on alsmost all my devices, but let's say 1 day ago it wasn't. so few of them was as Unknown location and in devices menu I saw structure like "Unknown -> unset ; Prague -> address, ... " I have fixed location and started poller and discovery. Poller got new location for each device where it was unset. But in menu I still saw structure like Devices - Locations | |- <empty string> | |-Address1 (8 count) | |-<Prague> |-Address1 (55 count) And Address1 is same for both sections because devices in both sections have same sysLocation parameter. Also doesn't matter which menu I click, I always got list of all devices with this sysLocation parameter (63 count). Also I have in config these lines to replace location with exact address and it works fine. $config['location_map']['Prague'] = "my street, Prague, Czech Republic"; $config['location_map']['Nashville'] = "us street, Franklin, TN 12345"; Do you know how to force Observium to move fixed location devices under "Prague" town and show proper count of devices? Thanks

2 1

[Observium] /usr/local/www/observium/html/includes/graphs/sensor/capacity.inc.php
by Dirk-Willem van Gulik 21 Jan '16

21 Jan '16

Hmm - in -latest.tar.gz there seems to be a reference to /usr/local/www/observium/html/includes/graphs/sensor/capacity.inc.php from /usr/local/www/observium-latest/html/includes/graphs/graph.inc.php with Graph type: sensor, subtype: graph which is somehow caused by: includes/graphs/sensor/auth.inc.php not checking (unlike graph.inc.php) if such an include exists. So I wonder if that auth.inc should become: { if ($subtype == 'graph') { // Fix generic subtype $subtype = $sensor['sensor_class']; $possible_inc = $config['html_dir'] . "/includes/graphs/$type/$subtype.inc.php"; if (is_file($possible_inc)) { $graph_include = $possible_inc; }; } Dw.

1 0

Spikes in billing
by Eduardo Schoedler 21 Jan '16

21 Jan '16

Hi, Is there a way to remove spikes from the billing? [image: Imagem inline 1] Thank you. Regards, -- Eduardo Schoedler

2 16

Lost discover of the 'ports'.
by Dirk-Willem van Gulik 21 Jan '16

21 Jan '16

We recently installed a new/parallel Observium (the old one had not been upgraded for years). The baseline is from http://www.observium.org/observium-community-latest.tar.gz as of today; with a new/fresh config.php. All fine & modern — except for the Ports on the various firewalls and switches not showing up automatically (Neither in ports or in settings; Port Properties). The ‘ports’ poller module is enable; as are POE and ports/port-stack in discovery. Any hint as where to fix/debug/dig as to understand why this is ? Thanks, Dw. Observium CE 0.15.6.6430 Discovery Current Revision : 6430 New Revision : 7522 XXXXXXXX Module [ os ] time: 0.1062s Ports : em0(1)[] em1(2)[] ste0(3)[] ste1(4)[] ste2(5)[] ste3(6)[] em2(7)[] em3(8)[] em4(9)[] pflog0(10)[] pfsync0(11)[] lo0(12)[] enc0(13)[] em0_vlan1(14)[] em0_vlan2(15)[] em0_vlan3(16)[] em0_vlan4(17)[] pppoe2(18)[] ….. Observium CE 0.15.6.6430 Discovery Current Revision : 6430 New Revision : 7522 XXXXXXX Module [ os ] time: 0.0709s Ports : Slot0/1(1)[] Slot0/2(2)[] Slot0/3(3)[] Slot0/4(4)[] Slot0/5(5)[] Slot0/6(6)[] Slot0/7(7)[] Slot0/8(8)[] Slot0/9(9)[] Slot0/10(10)[] Slot0/11(11)[] Slot0/12(12)[] Slot0/13(13)[] Slot0/14(14)[] Slot0/15(15)[] Slot0/16(16)[] Slot0/17(17)[] Slot0/18(18)[] Slot0/19(19)[] Slot0/20(20)[] Slot0/21(21)[] Slot0/22(22)[] Slot0/23(23)[] Slot0/24(24)[] Slot0/25(25)[] Slot0/26(26)[] Slot0/27(27)[] Slot0/28(28)[] po1(29)[] po2(30)[] po3(31)[] po4(32)[] po5(33)[] po6(34)[] po7(35)[] po8(36)[] po9(37)[] po10(38)[] po11(39)[] po12(40)[] po13(41)[] po14(42)[] vlanMgmt(43)[] Module [ ports ] time: 0.4609s Port Stacks: ...................................................................................... Module [ ports-stack ] time: 0.1803s Processors : AGENT-GENERAL-MIB hrDevice:

2 9

Narrower OID detection
by Dirk-Willem van Gulik 21 Jan '16

21 Jan '16

I’ve got a couple of devices with SNMPv2-MIB::sysDescr.0 = STRING: Linux ypenburg 2.6.36.2-wndap660_620-WNDAP660_V3.0.5.0 #1 Fri Oct 23 19:40:53 IST 2015 ppc SNMPv2-MIB::sysObjectID.0 = OID: SNMPv2-SMI::enterprises.4526.100.7.13 So I’d like to expand the $os = "netgear"; $config['os'][$os]['text'] = "Netgear"; $config['os'][$os]['type'] = "network"; $config['os'][$os]['icon'] = "netgear"; $config['os'][$os]['sysObjectID'][] = ".1.3.6.1.4.1.4526"; $config['os'][$os]['sysObjectID'][] = ".1.3.6.1.4.1.12622"; $config['os'][$os]['over'][0]['graph'] = "device_bits"; $config['os'][$os]['mibs'][] = "UCD-SNMP-MIB”; with a much *narrower* section; specific for the wifi access point devices (all in 1.3.6.1.4.1.4526.100.4,7,8,15.*) - as to make auto discovery work better & get the incon/type right. What is the best way to go about it (currently we use a small stub in include/discover/wifi that ‘forces’ the setting) — or is the config[] somehow able to go from narrow to broad already ? Dw. *: http://www.circitor.fr/Mibs/Html/Netgear-MIB.php

1 0

Support for EMC VNX-series
by Eddy Mouws 21 Jan '16

21 Jan '16

Hi, I ‘m not certain if this is the right way to ask; but I see support for EMC devices is available. When will it become available in the CE-edition ? Regards, Eddy [cid:imaged81d12.JPG@e4bcd153.4ea42732] Eddy Mouws Email: eddy(a)businessconnect.nl<mailto:eddy@businessconnect.nl> WWW: www.businessconnect.nl<http://www.businessconnect.nl/> Hofdreef 42b 4881 DR Zundert Nederland Tel: 076-5987777 Fax: 076-5987070 Disclaimer: Deze e-mail en eventuele bestanden die bij dit bericht zijn verzonden, zijn vertrouwelijke en uitsluitend bestemd voor gebruik door de geadresseerde(n). Indien dit bericht niet voor u is bestemd, is openbaarmaking, vermenigvuldiging, verspreiding en/of het ondernemen van acties op basis van inhoud van de per abuis verkregen informatie verboden. Tevens verzoeken wij u vriendelijk om de afzender hiervan onmiddellijk per email op de hoogte te brengen en het bericht vervolgens van uw systeem te verwijderen.

1 0