Three phase UPS, [SEC=UNCLASSIFIED]
Does anyone else have a three phase ups. I was wanting to know if it is using the UPS-MIB and that you've done something to get all three phases shown as graphs ?
I've done a debug on the discovery and it is clear that all phases are returned by the bulkwalk statements.
so far i've created ./html/images/os/emerson.png and ./includes/polling/os/emerson.inc.php and added to my config.php the following: $os = "emerson"; $config['os'][$os]['text'] = "Emerson UPS"; $config['os'][$os]['type'] = "power"; $config['os'][$os]['over'][0]['graph'] = "device_voltage"; $config['os'][$os]['over'][0]['text'] = "Voltage"; $config['os'][$os]['over'][1]['graph'] = "device_current"; $config['os'][$os]['over'][1]['text'] = "Current"; $config['os'][$os]['over'][2]['graph'] = "device_frequency"; $config['os'][$os]['over'][2]['text'] = "Frequency"; $config['os'][$os]['sysObjectID'][] = ".1.3.6.1.2.1.33"; $config['os'][$os]['mibs'][] = "UPS-MIB";
root@dc3monitor2:/opt/observium# snmpwalk dc6ups01 -v2c -c xxxxx -M /opt/observium/mibs -m UPS-MIB upsMIB UPS-MIB::upsIdentManufacturer.0 = STRING: Chloride UPS-MIB::upsIdentModel.0 = STRING: 80Net UPS-MIB::upsIdentUPSSoftwareVersion.0 = STRING: 10h01517 V4.00.100312 (5135) / 10h01531 V1.10.100326,10h01530 V UPS-MIB::upsIdentAgentSoftwareVersion.0 = STRING: 3.15.3397 UPS-MIB::upsIdentName.0 = STRING: dc6ups01 UPS-MIB::upsIdentAttachedDevices.0 = STRING: none UPS-MIB::upsBatteryStatus.0 = INTEGER: batteryNormal(2) UPS-MIB::upsSecondsOnBattery.0 = INTEGER: 0 seconds UPS-MIB::upsEstimatedMinutesRemaining.0 = INTEGER: 164 minutes UPS-MIB::upsEstimatedChargeRemaining.0 = INTEGER: 100 percent UPS-MIB::upsBatteryVoltage.0 = INTEGER: 5440 0.1 Volt DC UPS-MIB::upsBatteryCurrent.0 = INTEGER: 2 0.1 Amp DC UPS-MIB::upsBatteryTemperature.0 = INTEGER: 19 degrees Centigrade UPS-MIB::upsInputLineBads.0 = Counter32: 56 UPS-MIB::upsInputNumLines.0 = INTEGER: 3 UPS-MIB::upsInputFrequency.1 = INTEGER: 499 0.1 Hertz UPS-MIB::upsInputFrequency.2 = INTEGER: 499 0.1 Hertz UPS-MIB::upsInputFrequency.3 = INTEGER: 499 0.1 Hertz UPS-MIB::upsInputVoltage.1 = INTEGER: 245 RMS Volts UPS-MIB::upsInputVoltage.2 = INTEGER: 245 RMS Volts UPS-MIB::upsInputVoltage.3 = INTEGER: 243 RMS Volts UPS-MIB::upsInputCurrent.1 = INTEGER: 30 0.1 RMS Amp UPS-MIB::upsInputCurrent.2 = INTEGER: 30 0.1 RMS Amp UPS-MIB::upsInputCurrent.3 = INTEGER: 31 0.1 RMS Amp UPS-MIB::upsInputTruePower.1 = INTEGER: 7500 Watts UPS-MIB::upsInputTruePower.2 = INTEGER: 7500 Watts UPS-MIB::upsInputTruePower.3 = INTEGER: 7700 Watts UPS-MIB::upsOutputSource.0 = INTEGER: normal(3) UPS-MIB::upsOutputFrequency.0 = INTEGER: 499 0.1 Hertz UPS-MIB::upsOutputNumLines.0 = INTEGER: 3 UPS-MIB::upsOutputVoltage.1 = INTEGER: 241 RMS Volts UPS-MIB::upsOutputVoltage.2 = INTEGER: 239 RMS Volts UPS-MIB::upsOutputVoltage.3 = INTEGER: 239 RMS Volts UPS-MIB::upsOutputCurrent.1 = INTEGER: 384 0.1 RMS Amp UPS-MIB::upsOutputCurrent.2 = INTEGER: 288 0.1 RMS Amp UPS-MIB::upsOutputCurrent.3 = INTEGER: 328 0.1 RMS Amp UPS-MIB::upsOutputPower.1 = INTEGER: 7900 Watts UPS-MIB::upsOutputPower.2 = INTEGER: 6200 Watts UPS-MIB::upsOutputPower.3 = INTEGER: 7200 Watts UPS-MIB::upsOutputPercentLoad.1 = INTEGER: 27 percent UPS-MIB::upsOutputPercentLoad.2 = INTEGER: 20 percent UPS-MIB::upsOutputPercentLoad.3 = INTEGER: 23 percent UPS-MIB::upsAlarmsPresent.0 = Gauge32: 0 UPS-MIB::upsTestId.0 = OID: UPS-MIB::upsTestNoTestsInitiated UPS-MIB::upsTestSpinLock.0 = INTEGER: 53 UPS-MIB::upsTestResultsSummary.0 = INTEGER: 1082939236 UPS-MIB::upsTestResultsDetail.0 = STRING: UPS-MIB::upsTestStartTime.0 = Timeticks: (0) 0:00:00.00 UPS-MIB::upsTestElapsedTime.0 = Wrong Type (should be INTEGER): Timeticks: (654440200) 75 days, 17:53:22.00 UPS-MIB::upsShutdownType.0 = INTEGER: 0 UPS-MIB::upsShutdownAfterDelay.0 = INTEGER: 0 seconds UPS-MIB::upsStartupAfterDelay.0 = INTEGER: 0 seconds UPS-MIB::upsRebootWithDuration.0 = INTEGER: 0 seconds UPS-MIB::upsAutoRestart.0 = INTEGER: 0 UPS-MIB::upsConfigInputVoltage.0 = INTEGER: 240 RMS Volts UPS-MIB::upsConfigInputFreq.0 = INTEGER: 500 0.1 Hertz UPS-MIB::upsConfigOutputVoltage.0 = INTEGER: 240 RMS Volts UPS-MIB::upsConfigOutputFreq.0 = INTEGER: 500 0.1 Hertz UPS-MIB::upsConfigOutputVA.0 = INTEGER: 99900 Volt-Amps UPS-MIB::upsConfigOutputPower.0 = INTEGER: 90000 Watts UPS-MIB::upsConfigLowBattTime.0 = INTEGER: 0 minutes UPS-MIB::upsConfigAudibleStatus.0 = INTEGER: 0 UPS-MIB::upsConfigLowVoltageTransferPoint.0 = INTEGER: 168 RMS Volts UPS-MIB::upsConfigHighVoltageTransferPoint.0 = INTEGER: 274 RMS Volts
thanks
Peter Hine Senior Technical Support Engineer (Servers) FCoA ITS peter.hine@familycourt.gov.au
********************************************************************** The information contained in this e-mail (including any attachments) is for the exclusive use of the addressee. If you are not the intended recipient please notify the sender immediately and delete this e-mail. It is noted that legal privilege is not waived because you have read this e-mail. **********************************************************************
Hi,
I have a 3 phase UPS using UPS-MIB, and all 3 phases are showing up. I know of other people with similar setups.
The OS block you've added looks fine, would you mind adding that to our jira.observium.org tracker and also attaching the png? :-)
To see what is going on further, discovery -d logs will be needed.
Tom
On 09/04/2014 01:16, Peter.Hine@familycourt.gov.au wrote:
Does anyone else have a three phase ups. I was wanting to know if it is using the UPS-MIB and that you've done something to get all three phases shown as graphs ?
I've done a debug on the discovery and it is clear that all phases are returned by the bulkwalk statements.
so far i've created ./html/images/os/emerson.png and ./includes/polling/os/emerson.inc.php and added to my config.php the following: $os = "emerson"; $config['os'][$os]['text'] = "Emerson UPS"; $config['os'][$os]['type'] = "power"; $config['os'][$os]['over'][0]['graph'] = "device_voltage"; $config['os'][$os]['over'][0]['text'] = "Voltage"; $config['os'][$os]['over'][1]['graph'] = "device_current"; $config['os'][$os]['over'][1]['text'] = "Current"; $config['os'][$os]['over'][2]['graph'] = "device_frequency"; $config['os'][$os]['over'][2]['text'] = "Frequency"; $config['os'][$os]['sysObjectID'][] = ".1.3.6.1.2.1.33"; $config['os'][$os]['mibs'][] = "UPS-MIB";
root@dc3monitor2:/opt/observium# snmpwalk dc6ups01 -v2c -c xxxxx -M /opt/observium/mibs -m UPS-MIB upsMIB UPS-MIB::upsIdentManufacturer.0 = STRING: Chloride UPS-MIB::upsIdentModel.0 = STRING: 80Net UPS-MIB::upsIdentUPSSoftwareVersion.0 = STRING: 10h01517 V4.00.100312 (5135) / 10h01531 V1.10.100326,10h01530 V UPS-MIB::upsIdentAgentSoftwareVersion.0 = STRING: 3.15.3397 UPS-MIB::upsIdentName.0 = STRING: dc6ups01 UPS-MIB::upsIdentAttachedDevices.0 = STRING: none UPS-MIB::upsBatteryStatus.0 = INTEGER: batteryNormal(2) UPS-MIB::upsSecondsOnBattery.0 = INTEGER: 0 seconds UPS-MIB::upsEstimatedMinutesRemaining.0 = INTEGER: 164 minutes UPS-MIB::upsEstimatedChargeRemaining.0 = INTEGER: 100 percent UPS-MIB::upsBatteryVoltage.0 = INTEGER: 5440 0.1 Volt DC UPS-MIB::upsBatteryCurrent.0 = INTEGER: 2 0.1 Amp DC UPS-MIB::upsBatteryTemperature.0 = INTEGER: 19 degrees Centigrade UPS-MIB::upsInputLineBads.0 = Counter32: 56 UPS-MIB::upsInputNumLines.0 = INTEGER: 3 UPS-MIB::upsInputFrequency.1 = INTEGER: 499 0.1 Hertz UPS-MIB::upsInputFrequency.2 = INTEGER: 499 0.1 Hertz UPS-MIB::upsInputFrequency.3 = INTEGER: 499 0.1 Hertz UPS-MIB::upsInputVoltage.1 = INTEGER: 245 RMS Volts UPS-MIB::upsInputVoltage.2 = INTEGER: 245 RMS Volts UPS-MIB::upsInputVoltage.3 = INTEGER: 243 RMS Volts UPS-MIB::upsInputCurrent.1 = INTEGER: 30 0.1 RMS Amp UPS-MIB::upsInputCurrent.2 = INTEGER: 30 0.1 RMS Amp UPS-MIB::upsInputCurrent.3 = INTEGER: 31 0.1 RMS Amp UPS-MIB::upsInputTruePower.1 = INTEGER: 7500 Watts UPS-MIB::upsInputTruePower.2 = INTEGER: 7500 Watts UPS-MIB::upsInputTruePower.3 = INTEGER: 7700 Watts UPS-MIB::upsOutputSource.0 = INTEGER: normal(3) UPS-MIB::upsOutputFrequency.0 = INTEGER: 499 0.1 Hertz UPS-MIB::upsOutputNumLines.0 = INTEGER: 3 UPS-MIB::upsOutputVoltage.1 = INTEGER: 241 RMS Volts UPS-MIB::upsOutputVoltage.2 = INTEGER: 239 RMS Volts UPS-MIB::upsOutputVoltage.3 = INTEGER: 239 RMS Volts UPS-MIB::upsOutputCurrent.1 = INTEGER: 384 0.1 RMS Amp UPS-MIB::upsOutputCurrent.2 = INTEGER: 288 0.1 RMS Amp UPS-MIB::upsOutputCurrent.3 = INTEGER: 328 0.1 RMS Amp UPS-MIB::upsOutputPower.1 = INTEGER: 7900 Watts UPS-MIB::upsOutputPower.2 = INTEGER: 6200 Watts UPS-MIB::upsOutputPower.3 = INTEGER: 7200 Watts UPS-MIB::upsOutputPercentLoad.1 = INTEGER: 27 percent UPS-MIB::upsOutputPercentLoad.2 = INTEGER: 20 percent UPS-MIB::upsOutputPercentLoad.3 = INTEGER: 23 percent UPS-MIB::upsAlarmsPresent.0 = Gauge32: 0 UPS-MIB::upsTestId.0 = OID: UPS-MIB::upsTestNoTestsInitiated UPS-MIB::upsTestSpinLock.0 = INTEGER: 53 UPS-MIB::upsTestResultsSummary.0 = INTEGER: 1082939236 UPS-MIB::upsTestResultsDetail.0 = STRING: UPS-MIB::upsTestStartTime.0 = Timeticks: (0) 0:00:00.00 UPS-MIB::upsTestElapsedTime.0 = Wrong Type (should be INTEGER): Timeticks: (654440200) 75 days, 17:53:22.00 UPS-MIB::upsShutdownType.0 = INTEGER: 0 UPS-MIB::upsShutdownAfterDelay.0 = INTEGER: 0 seconds UPS-MIB::upsStartupAfterDelay.0 = INTEGER: 0 seconds UPS-MIB::upsRebootWithDuration.0 = INTEGER: 0 seconds UPS-MIB::upsAutoRestart.0 = INTEGER: 0 UPS-MIB::upsConfigInputVoltage.0 = INTEGER: 240 RMS Volts UPS-MIB::upsConfigInputFreq.0 = INTEGER: 500 0.1 Hertz UPS-MIB::upsConfigOutputVoltage.0 = INTEGER: 240 RMS Volts UPS-MIB::upsConfigOutputFreq.0 = INTEGER: 500 0.1 Hertz UPS-MIB::upsConfigOutputVA.0 = INTEGER: 99900 Volt-Amps UPS-MIB::upsConfigOutputPower.0 = INTEGER: 90000 Watts UPS-MIB::upsConfigLowBattTime.0 = INTEGER: 0 minutes UPS-MIB::upsConfigAudibleStatus.0 = INTEGER: 0 UPS-MIB::upsConfigLowVoltageTransferPoint.0 = INTEGER: 168 RMS Volts UPS-MIB::upsConfigHighVoltageTransferPoint.0 = INTEGER: 274 RMS Volts
thanks
Peter Hine Senior Technical Support Engineer (Servers) FCoA ITS peter.hine@familycourt.gov.au
The information contained in this e-mail (including any attachments) is for the exclusive use of the addressee. If you are not the intended recipient please notify the sender immediately and delete this e-mail. It is noted that legal privilege is not waived because you have read this e-mail.
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Thanks,
yes, i will add to tracker, i had opened a request yesterday, then spotted i had no phase data, so cancelled. given that there is a warning in the doco that you want O/S's to be a generic as possible, should a ups os be created, with an allowance for a brand ?
emerson.inc.php is a copy of liebert.inc.php. cat ./includes/polling/os/emerson.inc.php <?php
/** * Observium * * This file is part of Observium. * * @package observium * @subpackage poller * @copyright (C) 2006-2014 Adam Armstrong * */
// Uses UPS-MIB include("includes/polling/os/ups-mib.inc.php");
// EOF
DEBUG! -[0;32mObservium v0.14.4.5185 -[1;37mDiscovery -[0m-[0m
SQL[-[0;33mSELECT version FROM `dbSchema` ORDER BY version DESC LIMIT 1-[0m] -[0m
SQL[-[0;33mSELECT revision FROM `dbSchema`-[0m] -[0m
SQL[-[0;33mSELECT * FROM `devices` WHERE status = 1 AND disabled = 0 AND `hostname` LIKE 'dc6ups01' ORDER BY device_id DESC-[0m] -[0m
SQL[-[0;33mSELECT * FROM devices_attribs WHERE `device_id` = '6'-[0m] -[0m dc6ups01 6 emerson DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpget -v2c -c 'public' -Ovq -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' sysDescr.0 Mfgr=Chloride, Model=AM-P3-CN, SN=1112-b27a, OSVer=2.6.17.7-090219, AgentVer=3.15.3397
DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpget -v2c -c 'public' -Ovqn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' sysObjectID.0 .1.3.6.1.2.1.33
| Mfgr=Chloride, Model=AM-P3-CN, SN=1112-b27a, OSVer=2.6.17.7-090219, AgentVer=3.15.3397 | .1.3.6.1.2.1.33 | Ports : DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m IF-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' ifDescr ifDescr.1 = lo0 ifDescr.2 = eth0
DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m IF-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' ifAlias ifAlias = No Such Object available on this agent at this OID
DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m IF-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' ifName ifName = No Such Object available on this agent at this OID
DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m IF-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' ifType ifType.1 = softwareLoopback ifType.2 = ethernetCsmacd
SQL[-[0;33mSELECT * FROM `ports` WHERE `device_id` = '6'-[0m] -[0m ignored (by descr): lo0 [ lo ] X. Port Stacks: SQL[-[0;33mSELECT * FROM `ports_stack` WHERE `device_id` = '6'-[0m] -[0m DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -M /opt/observium/mibs 'udp':'dc6ups01':'161' ifStackStatus ifStackStatus = No Such Object available on this agent at this OID
Processors : hrDevice: DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' hrDevice hrDevice = No Such Object available on this agent at this OID
DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' hrProcessorLoad hrProcessorLoad = No Such Object available on this agent at this OID
SQL[-[0;33mSELECT COUNT(*) FROM processors WHERE device_id = '6' AND processor_type != 'ucd-old'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `processors` WHERE `device_id` = '6'-[0m] -[0m
Memory : HOST-RESOURCES-MIB DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' hrStorageEntry hrStorageEntry = No Such Object available on this agent at this OID
SQL[-[0;33mSELECT * FROM `mempools` WHERE `device_id` = '6'-[0m] -[0m
SQL[-[0;33mSELECT `port_id`, `ifIndex` FROM `ports` WHERE `device_id` = '6' GROUP BY `port_id`-[0m] -[0m IPv4 Addresses : DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' ipAdEntIfIndex ipAdEntIfIndex.10.251.2.41 = 2 ipAdEntIfIndex.127.0.0.1 = 1
DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' ipAdEntNetMask ipAdEntNetMask.10.251.2.41 = 255.255.128.0 ipAdEntNetMask.127.0.0.1 = 255.0.0.0
IP-MIB Array ( [2] => Array ( [10.251.2.41] => Array ( [ipAdEntIfIndex] => 2 [ipAdEntNetMask] => 255.255.128.0 )
)
[1] => Array ( [127.0.0.1] => Array ( [ipAdEntIfIndex] => 1 [ipAdEntNetMask] => 255.0.0.0 )
)
)
$vars
========= array( [2] => array( [10.251.2.41] => array( [ipAdEntIfIndex] => string(1) "2" [ipAdEntNetMask] => string(13) "255.255.128.0" ) ) [1] => array( [127.0.0.1] => array( [ipAdEntIfIndex] => string(1) "1" [ipAdEntNetMask] => string(9) "255.0.0.0" ) ) )
SQL[-[0;33mSELECT * FROM `ipv4_addresses` AS A LEFT JOIN `ports` AS I ON A.`port_id` = I.`port_id` WHERE I.`device_id` = '6'-[0m] -[0m
SQL[-[0;33mSELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '10.251.0.0/17'-[0m] -[0m . SQL[-[0;33mSELECT * FROM `ipv4_addresses` AS A LEFT JOIN `ports` AS I ON A.`port_id` = I.`port_id` WHERE I.`device_id` = '6'-[0m] -[0m
SQL[-[0;33mSELECT `port_id`, `ifIndex` FROM `ports` WHERE `device_id` = '6' GROUP BY `port_id`-[0m] -[0m IPv6 Addresses : DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' ipAddressIfIndex.ipv6 ipAddressIfIndex.ipv6 = No Such Object available on this agent at this OID
DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' ipAddressPrefix.ipv6 ipAddressPrefix.ipv6 = No Such Object available on this agent at this OID
DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' ipAddressOrigin.ipv6 ipAddressOrigin.ipv6 = No Such Object available on this agent at this OID
DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUn -m IPV6-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' ipv6AddrPfxLength .1.3.6.1.2.1.55.1.8.1.2 = No Such Object available on this agent at this OID
TRANSLATE (REWRITE):[.1.3.6.1.2.1.55.1.8.1.2] DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUn -m IPV6-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' ipv6AddrType .1.3.6.1.2.1.55.1.8.1.3 = No Such Object available on this agent at this OID
TRANSLATE (REWRITE):[.1.3.6.1.2.1.55.1.8.1.3]
SQL[-[0;33mSELECT * FROM `ipv6_addresses` AS A LEFT JOIN `ports` AS I ON A.`port_id` = I.`port_id` WHERE I.`device_id` = '6'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `ipv6_addresses` AS A LEFT JOIN `ports` AS I ON A.`port_id` = I.`port_id` WHERE I.`device_id` = '6'-[0m] -[0m
Sensors: UPS-MIB Caching OIDs: upsInput DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m UPS-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' upsInput upsInputLineBads.0 = 56 upsInputNumLines.0 = 3 upsInputFrequency.1 = 498 upsInputFrequency.2 = 498 upsInputFrequency.3 = 498 upsInputVoltage.1 = 247 upsInputVoltage.2 = 247 upsInputVoltage.3 = 246 upsInputCurrent.1 = 30 upsInputCurrent.2 = 30 upsInputCurrent.3 = 30 upsInputTruePower.1 = 7600 upsInputTruePower.2 = 7600 upsInputTruePower.3 = 7400
upsOutput DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m UPS-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' upsOutput upsOutputSource.0 = normal upsOutputFrequency.0 = 499 upsOutputNumLines.0 = 3 upsOutputVoltage.1 = 240 upsOutputVoltage.2 = 239 upsOutputVoltage.3 = 240 upsOutputCurrent.1 = 384 upsOutputCurrent.2 = 288 upsOutputCurrent.3 = 328 upsOutputPower.1 = 7900 upsOutputPower.2 = 6200 upsOutputPower.3 = 7100 upsOutputPercentLoad.1 = 27 upsOutputPercentLoad.2 = 20 upsOutputPercentLoad.3 = 23
upsBypass DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m UPS-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' upsBypass upsBypass = No Such Object available on this agent at this OID
Discover sensor: voltage, dc6ups01, 1.3.6.1.2.1.33.1.3.3.1.3., upsInputEntry., ups-mib, Input Phase , 1, 1, , , , , 247, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m .Discover sensor: frequency, dc6ups01, 1.3.6.1.2.1.33.1.3.3.1.2., upsInputEntry., ups-mib, Input Phase , 10, 1, , , , , 49.8, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'frequency' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'frequency' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m .Discover sensor: current, dc6ups01, 1.3.6.1.2.1.33.1.3.3.1.4., upsInputEntry., ups-mib, Input Phase , 10, 1, , , , , 3, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m .Discover sensor: power, dc6ups01, 1.3.6.1.2.1.33.1.3.3.1.5., upsInputEntry., ups-mib, Input Phase , 10, 1, , , , , 760, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'power' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'power' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m .Discover sensor: voltage, dc6ups01, 1.3.6.1.2.1.33.1.4.4.1.2., upsOutputEntry., ups-mib, Output Phase , 1, 1, , , , , 240, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m .Discover sensor: current, dc6ups01, 1.3.6.1.2.1.33.1.4.4.1.3., upsOutputEntry., ups-mib, Output Phase , 10, 1, , , , , 38.4, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m .Discover sensor: power, dc6ups01, 1.3.6.1.2.1.33.1.4.4.1.4., upsOutputEntry., ups-mib, Output Phase , 1, 1, , , , , 7900, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'power' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'power' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m .Discover sensor: capacity, dc6ups01, .1.3.6.1.2.1.33.1.4.4.1.5., upsOutputPercentLoad., ups-mib, Output Phase , 1, 1, , , , , 27, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'capacity' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputPercentLoad.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'capacity' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputPercentLoad.'-[0m] -[0m .Discover sensor: voltage, dc6ups01, 1.3.6.1.2.1.33.1.3.3.1.3., upsInputEntry., ups-mib, Input Phase , 1, 1, , , , , 247, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m .Discover sensor: frequency, dc6ups01, 1.3.6.1.2.1.33.1.3.3.1.2., upsInputEntry., ups-mib, Input Phase , 10, 1, , , , , 49.8, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'frequency' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'frequency' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m .Discover sensor: current, dc6ups01, 1.3.6.1.2.1.33.1.3.3.1.4., upsInputEntry., ups-mib, Input Phase , 10, 1, , , , , 3, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m .Discover sensor: power, dc6ups01, 1.3.6.1.2.1.33.1.3.3.1.5., upsInputEntry., ups-mib, Input Phase , 10, 1, , , , , 760, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'power' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'power' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m .Discover sensor: voltage, dc6ups01, 1.3.6.1.2.1.33.1.4.4.1.2., upsOutputEntry., ups-mib, Output Phase , 1, 1, , , , , 239, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m .Discover sensor: current, dc6ups01, 1.3.6.1.2.1.33.1.4.4.1.3., upsOutputEntry., ups-mib, Output Phase , 10, 1, , , , , 28.8, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m .Discover sensor: power, dc6ups01, 1.3.6.1.2.1.33.1.4.4.1.4., upsOutputEntry., ups-mib, Output Phase , 1, 1, , , , , 6200, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'power' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'power' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m .Discover sensor: capacity, dc6ups01, .1.3.6.1.2.1.33.1.4.4.1.5., upsOutputPercentLoad., ups-mib, Output Phase , 1, 1, , , , , 20, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'capacity' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputPercentLoad.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'capacity' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputPercentLoad.'-[0m] -[0m .Discover sensor: voltage, dc6ups01, 1.3.6.1.2.1.33.1.3.3.1.3., upsInputEntry., ups-mib, Input Phase , 1, 1, , , , , 246, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m .Discover sensor: frequency, dc6ups01, 1.3.6.1.2.1.33.1.3.3.1.2., upsInputEntry., ups-mib, Input Phase , 10, 1, , , , , 49.8, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'frequency' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'frequency' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m .Discover sensor: current, dc6ups01, 1.3.6.1.2.1.33.1.3.3.1.4., upsInputEntry., ups-mib, Input Phase , 10, 1, , , , , 3, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m .Discover sensor: power, dc6ups01, 1.3.6.1.2.1.33.1.3.3.1.5., upsInputEntry., ups-mib, Input Phase , 10, 1, , , , , 740, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'power' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'power' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsInputEntry.'-[0m] -[0m .Discover sensor: voltage, dc6ups01, 1.3.6.1.2.1.33.1.4.4.1.2., upsOutputEntry., ups-mib, Output Phase , 1, 1, , , , , 240, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m .Discover sensor: current, dc6ups01, 1.3.6.1.2.1.33.1.4.4.1.3., upsOutputEntry., ups-mib, Output Phase , 10, 1, , , , , 32.8, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m .Discover sensor: power, dc6ups01, 1.3.6.1.2.1.33.1.4.4.1.4., upsOutputEntry., ups-mib, Output Phase , 1, 1, , , , , 7100, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'power' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'power' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputEntry.'-[0m] -[0m .Discover sensor: capacity, dc6ups01, .1.3.6.1.2.1.33.1.4.4.1.5., upsOutputPercentLoad., ups-mib, Output Phase , 1, 1, , , , , 23, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'capacity' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputPercentLoad.'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'capacity' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputPercentLoad.'-[0m] -[0m .DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m UPS-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' upsBattery upsBatteryStatus.0 = batteryNormal upsSecondsOnBattery.0 = 0 upsEstimatedMinutesRemaining.0 = 164 upsEstimatedChargeRemaining.0 = 100 upsBatteryVoltage.0 = 5430 upsBatteryCurrent.0 = 65533 upsBatteryTemperature.0 = 19
Discover sensor: temperature, dc6ups01, 1.3.6.1.2.1.33.1.2.7.0, upsBatteryTemperature, ups-mib, Battery, 1, 1, , , , , 19, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'temperature' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsBatteryTemperature'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'temperature' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsBatteryTemperature'-[0m] -[0m .Discover sensor: current, dc6ups01, 1.3.6.1.2.1.33.1.2.6.0, upsBatteryCurrent, ups-mib, Battery, 10, 1, , , , , 6553.3, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsBatteryCurrent'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsBatteryCurrent'-[0m] -[0m .Discover sensor: voltage, dc6ups01, 1.3.6.1.2.1.33.1.2.5.0, upsBatteryVoltage, ups-mib, Battery, 10, 1, , , , , 543, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsBatteryVoltage'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsBatteryVoltage'-[0m] -[0m .DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpget -v2c -c 'public' -Oqc -m UPS-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' upsConfigLowBattTime.0
Discover sensor: runtime, dc6ups01, .1.3.6.1.2.1.33.1.2.3.0, upsEstimatedMinutesRemaining.0, mge, Battery Runtime Remaining, 1, 1, , , , , 164, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'runtime' AND `device_id` = '6' AND `sensor_type` = 'mge' AND `sensor_index` = 'upsEstimatedMinutesRemaining.0'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'runtime' AND `device_id` = '6' AND `sensor_type` = 'mge' AND `sensor_index` = 'upsEstimatedMinutesRemaining.0'-[0m] -[0m .DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpget -v2c -c 'public' -Oqv -M /opt/observium/mibs 'udp':'dc6ups01':'161' 1.3.6.1.2.1.33.1.4.2.0 499
Discover sensor: frequency, dc6ups01, 1.3.6.1.2.1.33.1.4.2.0, upsOutputFrequency, ups-mib, Output, 10, 1, , , , , 49.9, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'frequency' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputFrequency'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'frequency' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsOutputFrequency'-[0m] -[0m .DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpget -v2c -c 'public' -Oqv -M /opt/observium/mibs 'udp':'dc6ups01':'161' 1.3.6.1.2.1.33.1.5.1.0 No Such Object available on this agent at this OID
Discover sensor: frequency, dc6ups01, 1.3.6.1.2.1.33.1.5.1.0, upsBypassFrequency, ups-mib, Bypass, 10, 1, , , , , 0, snmp, , , ,
SQL[-[0;33mSELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'frequency' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsBypassFrequency'-[0m] -[0m
SQL[-[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'frequency' AND `device_id` = '6' AND `sensor_type` = 'ups-mib' AND `sensor_index` = 'upsBypassFrequency'-[0m] -[0m .Array ( [ups-mib] => Array ( [upsBatteryTemperature] => 1 )
)
== array( [ups-mib] => array( [upsBatteryTemperature] => int(1) ) )
SQL[-[0;33mSELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'temperature' AND S.`device_id` = D.`device_id` AND D.`device_id` = '6' AND S.`poller_type` = 'snmp'-[0m] -[0m upsBatteryTemperature -> ups-mib
== null
SQL[-[0;33mSELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'humidity' AND S.`device_id` = D.`device_id` AND D.`device_id` = '6' AND S.`poller_type` = 'snmp'-[0m] -[0m
== null
SQL[-[0;33mSELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'fanspeed' AND S.`device_id` = D.`device_id` AND D.`device_id` = '6' AND S.`poller_type` = 'snmp'-[0m] -[0m
== null
SQL[-[0;33mSELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'airflow' AND S.`device_id` = D.`device_id` AND D.`device_id` = '6' AND S.`poller_type` = 'snmp'-[0m] -[0m Array ( [ups-mib] => Array ( [upsInputEntry.] => 1 [upsOutputEntry.] => 1 [upsBatteryVoltage] => 1 )
)
== array( [ups-mib] => array( [upsInputEntry.] => int(1) [upsOutputEntry.] => int(1) [upsBatteryVoltage] => int(1) ) )
SQL[-[0;33mSELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'voltage' AND S.`device_id` = D.`device_id` AND D.`device_id` = '6' AND S.`poller_type` = 'snmp'-[0m] -[0m upsInputEntry. -> ups-mib upsOutputEntry. -> ups-mib upsBatteryVoltage -> ups-mib Array ( [ups-mib] => Array ( [upsInputEntry.] => 1 [upsOutputEntry.] => 1 [upsBatteryCurrent] => 1 )
)
== array( [ups-mib] => array( [upsInputEntry.] => int(1) [upsOutputEntry.] => int(1) [upsBatteryCurrent] => int(1) ) )
SQL[-[0;33mSELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'current' AND S.`device_id` = D.`device_id` AND D.`device_id` = '6' AND S.`poller_type` = 'snmp'-[0m] -[0m upsInputEntry. -> ups-mib upsOutputEntry. -> ups-mib upsBatteryCurrent -> ups-mib Array ( [ups-mib] => Array ( [upsInputEntry.] => 1 [upsOutputEntry.] => 1 )
)
== array( [ups-mib] => array( [upsInputEntry.] => int(1) [upsOutputEntry.] => int(1) ) )
SQL[-[0;33mSELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'power' AND S.`device_id` = D.`device_id` AND D.`device_id` = '6' AND S.`poller_type` = 'snmp'-[0m] -[0m upsInputEntry. -> ups-mib upsOutputEntry. -> ups-mib
== null
SQL[-[0;33mSELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'apower' AND S.`device_id` = D.`device_id` AND D.`device_id` = '6' AND S.`poller_type` = 'snmp'-[0m] -[0m Array ( [ups-mib] => Array ( [upsInputEntry.] => 1 [upsOutputFrequency] => 1 [upsBypassFrequency] => 1 )
)
== array( [ups-mib] => array( [upsInputEntry.] => int(1) [upsOutputFrequency] => int(1) [upsBypassFrequency] => int(1) ) )
SQL[-[0;33mSELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'frequency' AND S.`device_id` = D.`device_id` AND D.`device_id` = '6' AND S.`poller_type` = 'snmp'-[0m] -[0m upsInputEntry. -> ups-mib upsOutputFrequency -> ups-mib upsBypassFrequency -> ups-mib
== null
SQL[-[0;33mSELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'dbm' AND S.`device_id` = D.`device_id` AND D.`device_id` = '6' AND S.`poller_type` = 'snmp'-[0m] -[0m Array ( [ups-mib] => Array ( [upsOutputPercentLoad.] => 1 )
)
== array( [ups-mib] => array( [upsOutputPercentLoad.] => int(1) ) )
SQL[-[0;33mSELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'capacity' AND S.`device_id` = D.`device_id` AND D.`device_id` = '6' AND S.`poller_type` = 'snmp'-[0m] -[0m upsOutputPercentLoad. -> ups-mib Array ( [mge] => Array ( [upsEstimatedMinutesRemaining.0] => 1 )
)
== array( [mge] => array( [upsEstimatedMinutesRemaining.0] => int(1) ) )
SQL[-[0;33mSELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'runtime' AND S.`device_id` = D.`device_id` AND D.`device_id` = '6' AND S.`poller_type` = 'snmp'-[0m] -[0m upsEstimatedMinutesRemaining.0 -> mge
== null
SQL[-[0;33mSELECT * FROM `sensors` AS S, `devices` AS D WHERE S.`sensor_class` = 'state' AND S.`device_id` = D.`device_id` AND D.`device_id` = '6' AND S.`poller_type` = 'snmp'-[0m] -[0m
Storage : DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' hrStorageEntry hrStorageEntry = No Such Object available on this agent at this OID
SQL[-[0;33mSELECT * FROM `storage` WHERE `device_id` = '6'-[0m] -[0m
Inventory: Physical Inventory : DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'dc6ups01':'161' entPhysicalEntry entPhysicalEntry = No Such Object available on this agent at this OID
DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m ENTITY-MIB:IF-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' entAliasMappingIdentifier entAliasMappingIdentifier = No Such Object available on this agent at this OID
hrDevice : DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs 'udp':'dc6ups01':'161' hrDeviceEntry hrDeviceEntry = No Such Object available on this agent at this OID
DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs 'udp':'dc6ups01':'161' hrProcessorEntry hrProcessorEntry = No Such Object available on this agent at this OID
SQL[-[0;33mSELECT * FROM `entPhysical` WHERE `device_id` = '6'-[0m] -[0m Discovery protocols: LLDP-MIB DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m LLDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' lldpRemoteSystemsData lldpRemoteSystemsData = No Such Object available on this agent at this OID
|| || || || CISCO-CDP-MIB DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m CISCO-CDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'dc6ups01':'161' cdpCache cdpCache = No Such Object available on this agent at this OID
SQL[-[0;33mSELECT * FROM `links` AS L, `ports` AS I WHERE L.`local_port_id` = I.`port_id` AND I.`device_id` = '6'-[0m] -[0m
OSPF Neighbours: DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m OSPF-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' OSPF-MIB::ospfNbrIpAddr ospfNbrIpAddr = No Such Object available on this agent at this OID
SQL[-[0;33mSELECT port_id, ifIndex FROM ports WHERE device_id = '6' GROUP BY port_id-[0m] -[0m ARP/NDP Tables : DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OXqs -m IP-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' ipNetToPhysicalPhysAddress ipNetToPhysicalPhysAddress No Such Object available on this agent at this OID
DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OXqs -m IPV6-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' ipv6NetToMediaPhysAddress ipv6NetToMediaPhysAddress No Such Object available on this agent at this OID
DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OXqs -m IP-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' ipNetToMediaPhysAddress ipNetToMediaPhysAddress[1][1.0.251.10] 0:0:c:9f:f0:1
Used IP-MIB::ipNetToMediaPhysAddress
SQL[-[0;33mSELECT mac_id, mac_address, ip_address, ip_version, ifIndex FROM ip_mac AS M LEFT JOIN ports AS I ON M.port_id = I.port_id WHERE I.device_id = '6'-[0m] -[0m
BGP Sessions: DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpget -v2c -c 'public' -Oqvn -m BGP4-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' bgpLocalAs.0 No Such Object available on this agent at this OID
No BGP on host SQL[-[0;33mSELECT * FROM bgpPeers WHERE device_id = '6'-[0m] -[0m
VLANs:
SQL[-[0;33mSELECT * FROM `vlans` WHERE `device_id` = '6';-[0m] -[0m
SQL[-[0;33mSELECT * FROM `ports_vlans` WHERE `device_id` = '6';-[0m] -[0m Q-BRIDGE-MIB DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpget -v2c -c 'public' -Oqv -m Q-BRIDGE-MIB -M /opt/observium/mibs 'udp':'dc6ups01':'161' dot1qVlanVersionNumber.0 No Such Object available on this agent at this OID
Toner : Checking ... Array ( )
== array() DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpget -v2c -c 'public' -OUqnv -M /opt/observium/mibs 'udp':'dc6ups01':'161' 1.3.6.1.2.1.43.10.2.1.4.1.1 No Such Object available on this agent at this OID
UCD Disk IO : DEBUG: SNMP Auth options = -v2c -c 'public' /usr/bin/snmpbulkwalk -v2c -c 'public' -OQUs -m UCD-DISKIO-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'dc6ups01':'161' diskIOEntry diskIOEntry = No Such Object available on this agent at this OID
SQL[-[0;33mSELECT * FROM `ucd_diskio` WHERE `device_id` = '6'-[0m] -[0m
SQL[-[0;33mUPDATE `devices` set `last_discovered` =NOW(),`type` ='power',`last_discovered_timetaken` ='3.569' WHERE `device_id` = '6'-[0m] -[0m
SQL[-[0;33mINSERT INTO `devices_perftimes` (`device_id`,`operation`,`start`,`duration`) VALUES ('6','discover','1396996109.8388','3.5698199272156')-[0m] -[0m Discovered in 3.569 seconds
<h4>Building alerts for device dc6ups01</h4> SQL[-[0;33mSELECT * FROM `alert_tests`-[0m] -[0m
SQL[-[0;33mSELECT * FROM `alert_assoc`-[0m] -[0m
SQL[-[0;33mSELECT * FROM `alert_table` WHERE `device_id` = '6'-[0m] -[0m <h5>Checkers matching this device</h5> <h5>Matching entities</h5> Checking for stale entries:
SQL[-[0;33mINSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`) VALUES ('discover','dc6ups01','1396996109.8298','3.603','1')-[0m] -[0m ./discovery.php dc6ups01 April 8, 2014, 22:28 - 1 devices discovered in 3.603 secs
SQL[-[0;33mSELECT count(*) FROM ports-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM devices-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM `sensors`-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM `services`-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM `applications`-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM `bgpPeers`-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM `ospf_ports`-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM `eigrp_ports`-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM `ipsec_tunnels`-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM `munin_plugins`-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM `pseudowires`-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM `vrfs`-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM `vminfo`-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM `users`-[0m] -[0m
SQL[-[0;33mSELECT count(*) FROM `bills`-[0m] -[0m
SQL[-[0;33mSELECT SUM(`last_polled_timetaken`) FROM devices-[0m] -[0m
SQL[-[0;33mSELECT sysObjectID, COUNT( * ) as count FROM `devices` WHERE `os` = 'generic' GROUP BY `sysObjectID`-[0m] -[0m
SQL[-[0;33mSELECT COUNT(*) AS count,os from devices group by `os`-[0m] -[0m
SQL[-[0;33mSELECT COUNT(*) AS `count`, `type` FROM `devices` GROUP BY `type`-[0m] -[0m
SQL[-[0;33mSELECT COUNT(*) AS `count`, `app_type` FROM `applications` GROUP BY `app_type`-[0m] -[0m MySQL: Cell[2/0s] Row[79/0.07s] Rows[24/0.02s] Column[0/0s] Update[1/0.02s] Insert[2/0s] Delete[0/0s]
********************************************************************** The information contained in this e-mail (including any attachments) is for the exclusive use of the addressee. If you are not the intended recipient please notify the sender immediately and delete this e-mail. It is noted that legal privilege is not waived because you have read this e-mail. **********************************************************************
OK,
I've solved the phases not being detected. before i upload this. Can i get some assistance on what this stanza of code means.
---------------- $config['os'][$os]['over'][0]['graph'] = "device_voltage"; $config['os'][$os]['over'][0]['text'] = "Voltage"; $config['os'][$os]['over'][1]['graph'] = "device_current"; $config['os'][$os]['over'][1]['text'] = "Current"; $config['os'][$os]['over'][2]['graph'] = "device_frequency"; $config['os'][$os]['over'][2]['text'] = "Frequency"; ----------------
I thought it was to control the small graphs created in the top right corner (when viewing the device), and possibly the pop up graphs that you get when you hover over a device name.
If that is right, then this code is not working, as i still get memory, traffic and CPU Usage.
Thanks Peter
From: Tom Laermans tom.laermans@powersource.cx To: Observium Network Observation System observium@observium.org Date: 09/04/2014 10:13 Subject: Re: [Observium] Three phase UPS, [SEC=UNCLASSIFIED] Sent by: "observium" observium-bounces@observium.org
Hi,
I have a 3 phase UPS using UPS-MIB, and all 3 phases are showing up. I know of other people with similar setups.
The OS block you've added looks fine, would you mind adding that to our jira.observium.org tracker and also attaching the png? :-)
To see what is going on further, discovery -d logs will be needed.
Tom
_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
********************************************************************** The information contained in this e-mail (including any attachments) is for the exclusive use of the addressee. If you are not the intended recipient please notify the sender immediately and delete this e-mail. It is noted that legal privilege is not waived because you have read this e-mail. **********************************************************************
Are you sure you changed it for the correct OS type? :)
adam.
On 07/07/14 23:22, Peter.Hine@familycourt.gov.au wrote:
OK,
I've solved the phases not being detected. before i upload this. Can i get some assistance on what this stanza of code means.
$config['os'][$os]['over'][0]['graph'] = "device_voltage"; $config['os'][$os]['over'][0]['text'] = "Voltage"; $config['os'][$os]['over'][1]['graph'] = "device_current"; $config['os'][$os]['over'][1]['text'] = "Current"; $config['os'][$os]['over'][2]['graph'] = "device_frequency"; $config['os'][$os]['over'][2]['text'] = "Frequency";
I thought it was to control the small graphs created in the top right corner (when viewing the device), and possibly the pop up graphs that you get when you hover over a device name.
If that is right, then this code is not working, as i still get memory, traffic and CPU Usage.
Thanks Peter
From: Tom Laermans tom.laermans@powersource.cx To: Observium Network Observation System observium@observium.org Date: 09/04/2014 10:13 Subject: Re: [Observium] Three phase UPS, [SEC=UNCLASSIFIED] Sent by: "observium" observium-bounces@observium.org
Hi,
I have a 3 phase UPS using UPS-MIB, and all 3 phases are showing up. I know of other people with similar setups.
The OS block you've added looks fine, would you mind adding that to our jira.observium.org tracker and also attaching the png? :-)
To see what is going on further, discovery -d logs will be needed.
Tom
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
The information contained in this e-mail (including any attachments) is for the exclusive use of the addressee. If you are not the intended recipient please notify the sender immediately and delete this e-mail. It is noted that legal privilege is not waived because you have read this e-mail.
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
this is the full stanza. it is currently in config.php the ups is correctly found as a emerson ups and shows the correct .png
$os = "emerson"; $config['os'][$os]['text'] = "Emerson UPS"; $config['os'][$os]['type'] = "power"; $config['os'][$os]['over'][0]['graph'] = "device_voltage"; $config['os'][$os]['over'][0]['text'] = "Voltage"; $config['os'][$os]['over'][1]['graph'] = "device_current"; $config['os'][$os]['over'][1]['text'] = "Current"; $config['os'][$os]['over'][2]['graph'] = "device_frequency"; $config['os'][$os]['over'][2]['text'] = "Frequency"; $config['os'][$os]['sysObjectID'][] = ".1.3.6.1.2.1.33"; $config['os'][$os]['mibs'][] = "UPS-MIB";
however, i just moved it to "./includes/definitions/os.inc.php" (which i was trying not to do) and now it works.
thanks
Peter Hine
From: Adam Armstrong adama@memetic.org To: Observium Network Observation System observium@observium.org Date: 09/07/2014 21:27 Subject: Re: [Observium] Three phase UPS, [SEC=UNCLASSIFIED] Sent by: "observium" observium-bounces@observium.org
Are you sure you changed it for the correct OS type? :)
adam.
********************************************************************** The information contained in this e-mail (including any attachments) is for the exclusive use of the addressee. If you are not the intended recipient please notify the sender immediately and delete this e-mail. It is noted that legal privilege is not waived because you have read this e-mail. **********************************************************************
participants (3)
-
Adam Armstrong -
Peter.Hine＠familycourt.gov.au -
Tom Laermans