LibreNMS Discovery SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.24ms] SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.15ms] SQL[[1;33mSELECT version() [0;33m[][0m 0.14ms] =================================== Version info: Commit SHA: 83a53d7cd588a099d78b3b2bec2914e7b3b25008 Commit Date: 1548776598 DB Schema: 2019_01_16_195644_add_vrf_id_and_bgpLocalAs (131) PHP: 7.2.14 MySQL: 5.5.60-MariaDB RRDTool: 1.4.8 SNMP: NET-SNMP 5.7.2 ==================================DEBUG! Updating os_def.cache... Done Override discovery modules: sensors SQL[[1;33mSELECT * FROM `devices` WHERE disabled = 0 AND snmp_disable = 0 AND `hostname` LIKE 'sd-test-poe-01.sd.local' ORDER BY device_id DESC [0;33m[][0m 0.69ms] SQL[[1;33mSELECT * FROM devices_attribs WHERE `device_id` = ? [0;33m[4][0m 0.21ms] sd-test-poe-01.sd.local 4 ios [FPING] /usr/sbin/fping -e -q -c 3 -p 500 -t 500 sd-test-poe-01.sd.local Array ( [xmt] => 3 [rcv] => 3 [loss] => 0 [min] => 1.71 [max] => 1.78 [avg] => 1.73 [exitcode] => 0 ) SQL[[1;33mINSERT IGNORE INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`,`debug`) VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW(),:debug) [0;33m{"xmt":"3","rcv":"3","loss":"0","min":"1.71","max":"1.78","avg":"1.73","device_id":4,"debug":"[]"}[0m 0.37ms] SNMP Check response code: 0 SQL[[1;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ? [0;33m[4,"poll_mib"][0m 0.32ms] Attempting to initialize OS: ios OS initialized: LibreNMS\OS\Ios Modules status: Global+ OS Device #### Load disco module core #### SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQn' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'sysName.0' 'sysObjectID.0' 'sysDescr.0'[0m] .*.*.0 = sd-test-poe-01.sd.local .*.*.0 = .*.*.1208 .*.*.0 = Cisco IOS Software, C2960S Software (C2960S-UNIVERSALK9-M), Version 15.0(2)SE11, RELEASE SOFTWARE (fc3) Technical Support: http://www.cisco.com/techsupport Copyright (c) 1986-2017 by Cisco Systems, Inc. Compiled Sat 19-Aug-17 08:57 by prod_rel_team >> Runtime for discovery module 'core': 0.0210 seconds with 1296 bytes >> SNMP: [2/0.06s] MySQL: [4/0.00s] RRD: [0/0.00s] #### Unload disco module core #### Modules status: Global+ OS+ Device #### Load disco module sensors #### CISCO-ENTITY-SENSOR: Caching OIDs: entPhysicalDescrSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ENTITY-MIB:CISCO-ENTITY-SENSOR-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'entPhysicalDescr'[0m] entPhysicalDescr.1 = Catalyst C29xx Switch Stack entPhysicalDescr.1001 = WS-C2960S-48LPD-L entPhysicalDescr.1002 = Switch 1 - WS-C2960S-48LPD-L - Fixed Module 0 entPhysicalDescr.1003 = Fan Container entPhysicalDescr.1004 = Power Supply Container entPhysicalDescr.1005 = RPS Container entPhysicalDescr.1006 = Switch 1 - WS-C2960S-48LPD-L - Power Supply 0 entPhysicalDescr.1007 = Switch 1 - WS-C2960S-48LPD-L - Fan 0 entPhysicalDescr.1008 = Switch 1 - WS-C2960S-48LPD-L - Sensor 0 entPhysicalDescr.1009 = StackPort1 entPhysicalDescr.1010 = GigabitEthernet1/0/1 entPhysicalDescr.1011 = GigabitEthernet1/0/2 entPhysicalDescr.1012 = GigabitEthernet1/0/3 entPhysicalDescr.1013 = GigabitEthernet1/0/4 entPhysicalDescr.1014 = GigabitEthernet1/0/5 entPhysicalDescr.1015 = GigabitEthernet1/0/6 entPhysicalDescr.1016 = GigabitEthernet1/0/7 entPhysicalDescr.1017 = GigabitEthernet1/0/8 entPhysicalDescr.1018 = GigabitEthernet1/0/9 entPhysicalDescr.1019 = GigabitEthernet1/0/10 entPhysicalDescr.1020 = GigabitEthernet1/0/11 entPhysicalDescr.1021 = GigabitEthernet1/0/12 entPhysicalDescr.1022 = GigabitEthernet1/0/13 entPhysicalDescr.1023 = GigabitEthernet1/0/14 entPhysicalDescr.1024 = GigabitEthernet1/0/15 entPhysicalDescr.1025 = GigabitEthernet1/0/16 entPhysicalDescr.1026 = GigabitEthernet1/0/17 entPhysicalDescr.1027 = GigabitEthernet1/0/18 entPhysicalDescr.1028 = GigabitEthernet1/0/19 entPhysicalDescr.1029 = GigabitEthernet1/0/20 entPhysicalDescr.1030 = GigabitEthernet1/0/21 entPhysicalDescr.1031 = GigabitEthernet1/0/22 entPhysicalDescr.1032 = GigabitEthernet1/0/23 entPhysicalDescr.1033 = GigabitEthernet1/0/24 entPhysicalDescr.1034 = GigabitEthernet1/0/25 entPhysicalDescr.1035 = GigabitEthernet1/0/26 entPhysicalDescr.1036 = GigabitEthernet1/0/27 entPhysicalDescr.1037 = GigabitEthernet1/0/28 entPhysicalDescr.1038 = GigabitEthernet1/0/29 entPhysicalDescr.1039 = GigabitEthernet1/0/30 entPhysicalDescr.1040 = GigabitEthernet1/0/31 entPhysicalDescr.1041 = GigabitEthernet1/0/32 entPhysicalDescr.1042 = GigabitEthernet1/0/33 entPhysicalDescr.1043 = GigabitEthernet1/0/34 entPhysicalDescr.1044 = GigabitEthernet1/0/35 entPhysicalDescr.1045 = GigabitEthernet1/0/36 entPhysicalDescr.1046 = GigabitEthernet1/0/37 entPhysicalDescr.1047 = GigabitEthernet1/0/38 entPhysicalDescr.1048 = GigabitEthernet1/0/39 entPhysicalDescr.1049 = GigabitEthernet1/0/40 entPhysicalDescr.1050 = GigabitEthernet1/0/41 entPhysicalDescr.1051 = GigabitEthernet1/0/42 entPhysicalDescr.1052 = GigabitEthernet1/0/43 entPhysicalDescr.1053 = GigabitEthernet1/0/44 entPhysicalDescr.1054 = GigabitEthernet1/0/45 entPhysicalDescr.1055 = GigabitEthernet1/0/46 entPhysicalDescr.1056 = GigabitEthernet1/0/47 entPhysicalDescr.1057 = GigabitEthernet1/0/48 entPhysicalDescr.1058 = TenGigabitEthernet Container entPhysicalDescr.1059 = TenGigabitEthernet Container entPhysicalDescr.1060 = FastEthernet0 entPhysicalNameSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ENTITY-MIB:CISCO-ENTITY-SENSOR-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'entPhysicalName'[0m] entPhysicalName.1 = C29xx Stacking entPhysicalName.1001 = 1 entPhysicalName.1002 = Switch 1 - WS-C2960S-48LPD-L - Fixed Module 0 entPhysicalName.1003 = Switch 1 - Fan Container entPhysicalName.1004 = Switch 1 - Power Supply Container entPhysicalName.1005 = Switch 1 - RPS Container entPhysicalName.1006 = Switch 1 - WS-C2960S-48LPD-L - Power Supply 0 entPhysicalName.1007 = Switch 1 - WS-C2960S-48LPD-L - Fan 0 entPhysicalName.1008 = Switch 1 - WS-C2960S-48LPD-L - Sensor 0 entPhysicalName.1009 = StackPort1 entPhysicalName.1010 = GigabitEthernet1/0/1 entPhysicalName.1011 = GigabitEthernet1/0/2 entPhysicalName.1012 = GigabitEthernet1/0/3 entPhysicalName.1013 = GigabitEthernet1/0/4 entPhysicalName.1014 = GigabitEthernet1/0/5 entPhysicalName.1015 = GigabitEthernet1/0/6 entPhysicalName.1016 = GigabitEthernet1/0/7 entPhysicalName.1017 = GigabitEthernet1/0/8 entPhysicalName.1018 = GigabitEthernet1/0/9 entPhysicalName.1019 = GigabitEthernet1/0/10 entPhysicalName.1020 = GigabitEthernet1/0/11 entPhysicalName.1021 = GigabitEthernet1/0/12 entPhysicalName.1022 = GigabitEthernet1/0/13 entPhysicalName.1023 = GigabitEthernet1/0/14 entPhysicalName.1024 = GigabitEthernet1/0/15 entPhysicalName.1025 = GigabitEthernet1/0/16 entPhysicalName.1026 = GigabitEthernet1/0/17 entPhysicalName.1027 = GigabitEthernet1/0/18 entPhysicalName.1028 = GigabitEthernet1/0/19 entPhysicalName.1029 = GigabitEthernet1/0/20 entPhysicalName.1030 = GigabitEthernet1/0/21 entPhysicalName.1031 = GigabitEthernet1/0/22 entPhysicalName.1032 = GigabitEthernet1/0/23 entPhysicalName.1033 = GigabitEthernet1/0/24 entPhysicalName.1034 = GigabitEthernet1/0/25 entPhysicalName.1035 = GigabitEthernet1/0/26 entPhysicalName.1036 = GigabitEthernet1/0/27 entPhysicalName.1037 = GigabitEthernet1/0/28 entPhysicalName.1038 = GigabitEthernet1/0/29 entPhysicalName.1039 = GigabitEthernet1/0/30 entPhysicalName.1040 = GigabitEthernet1/0/31 entPhysicalName.1041 = GigabitEthernet1/0/32 entPhysicalName.1042 = GigabitEthernet1/0/33 entPhysicalName.1043 = GigabitEthernet1/0/34 entPhysicalName.1044 = GigabitEthernet1/0/35 entPhysicalName.1045 = GigabitEthernet1/0/36 entPhysicalName.1046 = GigabitEthernet1/0/37 entPhysicalName.1047 = GigabitEthernet1/0/38 entPhysicalName.1048 = GigabitEthernet1/0/39 entPhysicalName.1049 = GigabitEthernet1/0/40 entPhysicalName.1050 = GigabitEthernet1/0/41 entPhysicalName.1051 = GigabitEthernet1/0/42 entPhysicalName.1052 = GigabitEthernet1/0/43 entPhysicalName.1053 = GigabitEthernet1/0/44 entPhysicalName.1054 = GigabitEthernet1/0/45 entPhysicalName.1055 = GigabitEthernet1/0/46 entPhysicalName.1056 = GigabitEthernet1/0/47 entPhysicalName.1057 = GigabitEthernet1/0/48 entPhysicalName.1058 = TenGigabitEthernet1/0/1 Container entPhysicalName.1059 = TenGigabitEthernet1/0/2 Container entPhysicalName.1060 = Switch 1 - FastEthernet0 entPhysicalClassSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ENTITY-MIB:CISCO-ENTITY-SENSOR-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'entPhysicalClass'[0m] entPhysicalClass.1 = stack entPhysicalClass.1001 = chassis entPhysicalClass.1002 = module entPhysicalClass.1003 = container entPhysicalClass.1004 = container entPhysicalClass.1005 = container entPhysicalClass.1006 = powerSupply entPhysicalClass.1007 = fan entPhysicalClass.1008 = sensor entPhysicalClass.1009 = port entPhysicalClass.1010 = port entPhysicalClass.1011 = port entPhysicalClass.1012 = port entPhysicalClass.1013 = port entPhysicalClass.1014 = port entPhysicalClass.1015 = port entPhysicalClass.1016 = port entPhysicalClass.1017 = port entPhysicalClass.1018 = port entPhysicalClass.1019 = port entPhysicalClass.1020 = port entPhysicalClass.1021 = port entPhysicalClass.1022 = port entPhysicalClass.1023 = port entPhysicalClass.1024 = port entPhysicalClass.1025 = port entPhysicalClass.1026 = port entPhysicalClass.1027 = port entPhysicalClass.1028 = port entPhysicalClass.1029 = port entPhysicalClass.1030 = port entPhysicalClass.1031 = port entPhysicalClass.1032 = port entPhysicalClass.1033 = port entPhysicalClass.1034 = port entPhysicalClass.1035 = port entPhysicalClass.1036 = port entPhysicalClass.1037 = port entPhysicalClass.1038 = port entPhysicalClass.1039 = port entPhysicalClass.1040 = port entPhysicalClass.1041 = port entPhysicalClass.1042 = port entPhysicalClass.1043 = port entPhysicalClass.1044 = port entPhysicalClass.1045 = port entPhysicalClass.1046 = port entPhysicalClass.1047 = port entPhysicalClass.1048 = port entPhysicalClass.1049 = port entPhysicalClass.1050 = port entPhysicalClass.1051 = port entPhysicalClass.1052 = port entPhysicalClass.1053 = port entPhysicalClass.1054 = port entPhysicalClass.1055 = port entPhysicalClass.1056 = port entPhysicalClass.1057 = port entPhysicalClass.1058 = container entPhysicalClass.1059 = container entPhysicalClass.1060 = port entPhysicalContainedInSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ENTITY-MIB:CISCO-ENTITY-SENSOR-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'entPhysicalContainedIn'[0m] entPhysicalContainedIn.1 = 0 entPhysicalContainedIn.1001 = 1 entPhysicalContainedIn.1002 = 1001 entPhysicalContainedIn.1003 = 1001 entPhysicalContainedIn.1004 = 1001 entPhysicalContainedIn.1005 = 1001 entPhysicalContainedIn.1006 = 1001 entPhysicalContainedIn.1007 = 1001 entPhysicalContainedIn.1008 = 1001 entPhysicalContainedIn.1009 = 1002 entPhysicalContainedIn.1010 = 1002 entPhysicalContainedIn.1011 = 1002 entPhysicalContainedIn.1012 = 1002 entPhysicalContainedIn.1013 = 1002 entPhysicalContainedIn.1014 = 1002 entPhysicalContainedIn.1015 = 1002 entPhysicalContainedIn.1016 = 1002 entPhysicalContainedIn.1017 = 1002 entPhysicalContainedIn.1018 = 1002 entPhysicalContainedIn.1019 = 1002 entPhysicalContainedIn.1020 = 1002 entPhysicalContainedIn.1021 = 1002 entPhysicalContainedIn.1022 = 1002 entPhysicalContainedIn.1023 = 1002 entPhysicalContainedIn.1024 = 1002 entPhysicalContainedIn.1025 = 1002 entPhysicalContainedIn.1026 = 1002 entPhysicalContainedIn.1027 = 1002 entPhysicalContainedIn.1028 = 1002 entPhysicalContainedIn.1029 = 1002 entPhysicalContainedIn.1030 = 1002 entPhysicalContainedIn.1031 = 1002 entPhysicalContainedIn.1032 = 1002 entPhysicalContainedIn.1033 = 1002 entPhysicalContainedIn.1034 = 1002 entPhysicalContainedIn.1035 = 1002 entPhysicalContainedIn.1036 = 1002 entPhysicalContainedIn.1037 = 1002 entPhysicalContainedIn.1038 = 1002 entPhysicalContainedIn.1039 = 1002 entPhysicalContainedIn.1040 = 1002 entPhysicalContainedIn.1041 = 1002 entPhysicalContainedIn.1042 = 1002 entPhysicalContainedIn.1043 = 1002 entPhysicalContainedIn.1044 = 1002 entPhysicalContainedIn.1045 = 1002 entPhysicalContainedIn.1046 = 1002 entPhysicalContainedIn.1047 = 1002 entPhysicalContainedIn.1048 = 1002 entPhysicalContainedIn.1049 = 1002 entPhysicalContainedIn.1050 = 1002 entPhysicalContainedIn.1051 = 1002 entPhysicalContainedIn.1052 = 1002 entPhysicalContainedIn.1053 = 1002 entPhysicalContainedIn.1054 = 1002 entPhysicalContainedIn.1055 = 1002 entPhysicalContainedIn.1056 = 1002 entPhysicalContainedIn.1057 = 1002 entPhysicalContainedIn.1058 = 1002 entPhysicalContainedIn.1059 = 1002 entPhysicalContainedIn.1060 = 1002 entPhysicalParentRelPosSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ENTITY-MIB:CISCO-ENTITY-SENSOR-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'entPhysicalParentRelPos'[0m] entPhysicalParentRelPos.1 = -1 entPhysicalParentRelPos.1001 = 0 entPhysicalParentRelPos.1002 = 1 entPhysicalParentRelPos.1003 = 2 entPhysicalParentRelPos.1004 = 3 entPhysicalParentRelPos.1005 = 4 entPhysicalParentRelPos.1006 = 5 entPhysicalParentRelPos.1007 = 6 entPhysicalParentRelPos.1008 = 7 entPhysicalParentRelPos.1009 = 0 entPhysicalParentRelPos.1010 = 1 entPhysicalParentRelPos.1011 = 2 entPhysicalParentRelPos.1012 = 3 entPhysicalParentRelPos.1013 = 4 entPhysicalParentRelPos.1014 = 5 entPhysicalParentRelPos.1015 = 6 entPhysicalParentRelPos.1016 = 7 entPhysicalParentRelPos.1017 = 8 entPhysicalParentRelPos.1018 = 9 entPhysicalParentRelPos.1019 = 10 entPhysicalParentRelPos.1020 = 11 entPhysicalParentRelPos.1021 = 12 entPhysicalParentRelPos.1022 = 13 entPhysicalParentRelPos.1023 = 14 entPhysicalParentRelPos.1024 = 15 entPhysicalParentRelPos.1025 = 16 entPhysicalParentRelPos.1026 = 17 entPhysicalParentRelPos.1027 = 18 entPhysicalParentRelPos.1028 = 19 entPhysicalParentRelPos.1029 = 20 entPhysicalParentRelPos.1030 = 21 entPhysicalParentRelPos.1031 = 22 entPhysicalParentRelPos.1032 = 23 entPhysicalParentRelPos.1033 = 24 entPhysicalParentRelPos.1034 = 25 entPhysicalParentRelPos.1035 = 26 entPhysicalParentRelPos.1036 = 27 entPhysicalParentRelPos.1037 = 28 entPhysicalParentRelPos.1038 = 29 entPhysicalParentRelPos.1039 = 30 entPhysicalParentRelPos.1040 = 31 entPhysicalParentRelPos.1041 = 32 entPhysicalParentRelPos.1042 = 33 entPhysicalParentRelPos.1043 = 34 entPhysicalParentRelPos.1044 = 35 entPhysicalParentRelPos.1045 = 36 entPhysicalParentRelPos.1046 = 37 entPhysicalParentRelPos.1047 = 38 entPhysicalParentRelPos.1048 = 39 entPhysicalParentRelPos.1049 = 40 entPhysicalParentRelPos.1050 = 41 entPhysicalParentRelPos.1051 = 42 entPhysicalParentRelPos.1052 = 43 entPhysicalParentRelPos.1053 = 44 entPhysicalParentRelPos.1054 = 45 entPhysicalParentRelPos.1055 = 46 entPhysicalParentRelPos.1056 = 47 entPhysicalParentRelPos.1057 = 48 entPhysicalParentRelPos.1058 = 49 entPhysicalParentRelPos.1059 = 50 entPhysicalParentRelPos.1060 = 51 entAliasMappingIdentifierSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ENTITY-MIB:IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'entAliasMappingIdentifier'[0m] entAliasMappingIdentifier.1009.0 = ifIndex.5137 entAliasMappingIdentifier.1010.0 = ifIndex.10101 entAliasMappingIdentifier.1011.0 = ifIndex.10102 entAliasMappingIdentifier.1012.0 = ifIndex.10103 entAliasMappingIdentifier.1013.0 = ifIndex.10104 entAliasMappingIdentifier.1014.0 = ifIndex.10105 entAliasMappingIdentifier.1015.0 = ifIndex.10106 entAliasMappingIdentifier.1016.0 = ifIndex.10107 entAliasMappingIdentifier.1017.0 = ifIndex.10108 entAliasMappingIdentifier.1018.0 = ifIndex.10109 entAliasMappingIdentifier.1019.0 = ifIndex.10110 entAliasMappingIdentifier.1020.0 = ifIndex.10111 entAliasMappingIdentifier.1021.0 = ifIndex.10112 entAliasMappingIdentifier.1022.0 = ifIndex.10113 entAliasMappingIdentifier.1023.0 = ifIndex.10114 entAliasMappingIdentifier.1024.0 = ifIndex.10115 entAliasMappingIdentifier.1025.0 = ifIndex.10116 entAliasMappingIdentifier.1026.0 = ifIndex.10117 entAliasMappingIdentifier.1027.0 = ifIndex.10118 entAliasMappingIdentifier.1028.0 = ifIndex.10119 entAliasMappingIdentifier.1029.0 = ifIndex.10120 entAliasMappingIdentifier.1030.0 = ifIndex.10121 entAliasMappingIdentifier.1031.0 = ifIndex.10122 entAliasMappingIdentifier.1032.0 = ifIndex.10123 entAliasMappingIdentifier.1033.0 = ifIndex.10124 entAliasMappingIdentifier.1034.0 = ifIndex.10125 entAliasMappingIdentifier.1035.0 = ifIndex.10126 entAliasMappingIdentifier.1036.0 = ifIndex.10127 entAliasMappingIdentifier.1037.0 = ifIndex.10128 entAliasMappingIdentifier.1038.0 = ifIndex.10129 entAliasMappingIdentifier.1039.0 = ifIndex.10130 entAliasMappingIdentifier.1040.0 = ifIndex.10131 entAliasMappingIdentifier.1041.0 = ifIndex.10132 entAliasMappingIdentifier.1042.0 = ifIndex.10133 entAliasMappingIdentifier.1043.0 = ifIndex.10134 entAliasMappingIdentifier.1044.0 = ifIndex.10135 entAliasMappingIdentifier.1045.0 = ifIndex.10136 entAliasMappingIdentifier.1046.0 = ifIndex.10137 entAliasMappingIdentifier.1047.0 = ifIndex.10138 entAliasMappingIdentifier.1048.0 = ifIndex.10139 entAliasMappingIdentifier.1049.0 = ifIndex.10140 entAliasMappingIdentifier.1050.0 = ifIndex.10141 entAliasMappingIdentifier.1051.0 = ifIndex.10142 entAliasMappingIdentifier.1052.0 = ifIndex.10143 entAliasMappingIdentifier.1053.0 = ifIndex.10144 entAliasMappingIdentifier.1054.0 = ifIndex.10145 entAliasMappingIdentifier.1055.0 = ifIndex.10146 entAliasMappingIdentifier.1056.0 = ifIndex.10147 entAliasMappingIdentifier.1057.0 = ifIndex.10148 entAliasMappingIdentifier.1060.0 = ifIndex.12002 entSensorTypeSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'CISCO-ENTITY-SENSOR-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'entSensorType'[0m] entSensorType = No Such Object available on this agent at this OID entSensorScaleSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'CISCO-ENTITY-SENSOR-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'entSensorScale'[0m] entSensorScale = No Such Object available on this agent at this OID entSensorValueSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'CISCO-ENTITY-SENSOR-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'entSensorValue'[0m] entSensorValue = No Such Object available on this agent at this OID entSensorMeasuredEntitySNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'CISCO-ENTITY-SENSOR-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'entSensorMeasuredEntity'[0m] entSensorMeasuredEntity = No Such Object available on this agent at this OID entSensorPrecisionSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'CISCO-ENTITY-SENSOR-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'entSensorPrecision'[0m] entSensorPrecision = No Such Object available on this agent at this OID entSensorThresholdSeveritySNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'CISCO-ENTITY-SENSOR-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'entSensorThresholdSeverity'[0m] entSensorThresholdSeverity = No Such Object available on this agent at this OID entSensorThresholdRelationSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'CISCO-ENTITY-SENSOR-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'entSensorThresholdRelation'[0m] entSensorThresholdRelation = No Such Object available on this agent at this OID entSensorThresholdValueSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'CISCO-ENTITY-SENSOR-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'entSensorThresholdValue'[0m] entSensorThresholdValue = No Such Object available on this agent at this OID Array ( ) ENTITY-SENSOR: Caching OIDs: entPhysicalDescr entPhysicalName entPhySensorTypeSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ENTITY-SENSOR-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'entPhySensorType'[0m] entPhySensorType = No Such Object available on this agent at this OID entPhySensorScaleSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ENTITY-SENSOR-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'entPhySensorScale'[0m] entPhySensorScale = No Such Object available on this agent at this OID entPhySensorPrecisionSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ENTITY-SENSOR-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'entPhySensorPrecision'[0m] entPhySensorPrecision = No Such Object available on this agent at this OID entPhySensorValueSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ENTITY-SENSOR-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'entPhySensorValue'[0m] entPhySensorValue = No Such Object available on this agent at this OID entPhySensorOperStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ENTITY-SENSOR-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'entPhySensorOperStatus'[0m] entPhySensorOperStatus = No Such Object available on this agent at this OID SQL[[1;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ? [0;33m[4,"ipmi_hostname"][0m 0.52ms] SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["voltage",4,"ipmi"][0m 0.59ms] SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["temperature",4,"ipmi"][0m 0.47ms] SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["fanspeed",4,"ipmi"][0m 0.55ms] SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["power",4,"ipmi"][0m 0.5ms] Airflow: SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["airflow",4,"snmp"][0m 0.54ms] Current: SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["current",4,"snmp"][0m 0.48ms] Charge: SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["charge",4,"snmp"][0m 0.5ms] Dbm: SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["dbm",4,"snmp"][0m 0.56ms] Fanspeed: SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["fanspeed",4,"snmp"][0m 0.54ms] Frequency: SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["frequency",4,"snmp"][0m 0.48ms] Humidity: SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["humidity",4,"snmp"][0m 0.51ms] Load: SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["load",4,"snmp"][0m 0.47ms] Power: SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["power",4,"snmp"][0m 0.45ms] Power_consumed: SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["power_consumed",4,"snmp"][0m 0.51ms] Power_factor: SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["power_factor",4,"snmp"][0m 0.52ms] Runtime: SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["runtime",4,"snmp"][0m 0.58ms] Signal: SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["signal",4,"snmp"][0m 0.52ms] State: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'CISCO-STACKWISE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'cswSwitchRole'[0m] cswSwitchRole.1001 = master SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQv' '-m' 'CISCO-STACKWISE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'cswRingRedundant.0'[0m] false SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'CISCO-ENVMON-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'ciscoEnvMonVoltageStatusTable'[0m] ciscoEnvMonVoltageStatusTable = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'CISCO-ENVMON-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'ciscoEnvMonTemperatureStatusTable'[0m] ciscoEnvMonTemperatureStatusDescr.1008 = SW#1, Sensor#1, GREEN ciscoEnvMonTemperatureStatusValue.1008 = 25 ciscoEnvMonTemperatureThreshold.1008 = 64 ciscoEnvMonTemperatureLastShutdown.1008 = 0 ciscoEnvMonTemperatureState.1008 = normal Discover sensor: .1.3.6.1.4.1.9.9.13.1.3.1.6.1008, 1008, ciscoEnvMonTemperatureState, SW#1, Sensor#1, GREEN, snmp, 1, 1, 1008, normal SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",4,"ciscoEnvMonTemperatureState","1008"][0m 0.56ms] SQL[[1;33mINSERT IGNORE INTO `sensors` (`poller_type`,`sensor_class`,`device_id`,`sensor_oid`,`sensor_index`,`sensor_type`,`sensor_descr`,`sensor_divisor`,`sensor_multiplier`,`sensor_current`,`entPhysicalIndex`) VALUES (:poller_type,:sensor_class,:device_id,:sensor_oid,:sensor_index,:sensor_type,:sensor_descr,:sensor_divisor,:sensor_multiplier,:sensor_current,:entPhysicalIndex) [0;33m{"poller_type":"snmp","sensor_class":"state","device_id":4,"sensor_oid":".1.3.6.1.4.1.9.9.13.1.3.1.6.1008","sensor_index":1008,"sensor_type":"ciscoEnvMonTemperatureState","sensor_descr":"SW#1, Sensor#1, GREEN","sensor_divisor":"1","sensor_multiplier":"1","sensor_current":"normal","entPhysicalIndex":1008}[0m 0.51ms] ( 7472 inserted ) +SQL[[1;33mINSERT IGNORE INTO `eventlog` (`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES (:device_id,:reference,:type,:datetime,:severity,:message,:username) [0;33m{"device_id":4,"reference":"7472","type":"sensor","datetime":"2019-01-30 08:47:40","severity":3,"message":"Sensor Added: state ciscoEnvMonTemperatureState 1008 SW#1, Sensor#1, GREEN","username":""}[0m 0.29ms] SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",4,"ciscoEnvMonTemperatureState",1008][0m 0.41ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["ciscoEnvMonTemperatureState"][0m 0.18ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":7472,"state_index_id":2}[0m 0.45ms] SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'CISCO-ENVMON-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'ciscoEnvMonFanStatusTable'[0m] ciscoEnvMonFanStatusDescr.1007 = Switch#1, Fan#1 ciscoEnvMonFanState.1007 = normal Discover sensor: .1.3.6.1.4.1.9.9.13.1.4.1.3.1007, 1007, ciscoEnvMonFanState, Switch#1, Fan#1, snmp, 1, 1, 1007, normal SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",4,"ciscoEnvMonFanState","1007"][0m 0.62ms] SQL[[1;33mINSERT IGNORE INTO `sensors` (`poller_type`,`sensor_class`,`device_id`,`sensor_oid`,`sensor_index`,`sensor_type`,`sensor_descr`,`sensor_divisor`,`sensor_multiplier`,`sensor_current`,`entPhysicalIndex`) VALUES (:poller_type,:sensor_class,:device_id,:sensor_oid,:sensor_index,:sensor_type,:sensor_descr,:sensor_divisor,:sensor_multiplier,:sensor_current,:entPhysicalIndex) [0;33m{"poller_type":"snmp","sensor_class":"state","device_id":4,"sensor_oid":".1.3.6.1.4.1.9.9.13.1.4.1.3.1007","sensor_index":1007,"sensor_type":"ciscoEnvMonFanState","sensor_descr":"Switch#1, Fan#1","sensor_divisor":"1","sensor_multiplier":"1","sensor_current":"normal","entPhysicalIndex":1007}[0m 0.3ms] ( 7473 inserted ) +SQL[[1;33mINSERT IGNORE INTO `eventlog` (`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES (:device_id,:reference,:type,:datetime,:severity,:message,:username) [0;33m{"device_id":4,"reference":"7473","type":"sensor","datetime":"2019-01-30 08:47:40","severity":3,"message":"Sensor Added: state ciscoEnvMonFanState 1007 Switch#1, Fan#1","username":""}[0m 0.24ms] SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",4,"ciscoEnvMonFanState",1007][0m 0.32ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["ciscoEnvMonFanState"][0m 0.19ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":7473,"state_index_id":3}[0m 0.24ms] SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'CISCO-ENVMON-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'ciscoEnvMonSupplyStatusTable'[0m] ciscoEnvMonSupplyStatusDescr.1006 = Sw1, PS1 Normal, RPS NotExist ciscoEnvMonSupplyState.1006 = normal ciscoEnvMonSupplySource.1006 = ac Discover sensor: .1.3.6.1.4.1.9.9.13.1.5.1.3.1006, 1006, ciscoEnvMonSupplyState, Sw1, PS1 Normal, RPS NotExist, snmp, 1, 1, 1006, normal SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",4,"ciscoEnvMonSupplyState","1006"][0m 0.61ms] SQL[[1;33mINSERT IGNORE INTO `sensors` (`poller_type`,`sensor_class`,`device_id`,`sensor_oid`,`sensor_index`,`sensor_type`,`sensor_descr`,`sensor_divisor`,`sensor_multiplier`,`sensor_current`,`entPhysicalIndex`) VALUES (:poller_type,:sensor_class,:device_id,:sensor_oid,:sensor_index,:sensor_type,:sensor_descr,:sensor_divisor,:sensor_multiplier,:sensor_current,:entPhysicalIndex) [0;33m{"poller_type":"snmp","sensor_class":"state","device_id":4,"sensor_oid":".1.3.6.1.4.1.9.9.13.1.5.1.3.1006","sensor_index":1006,"sensor_type":"ciscoEnvMonSupplyState","sensor_descr":"Sw1, PS1 Normal, RPS NotExist","sensor_divisor":"1","sensor_multiplier":"1","sensor_current":"normal","entPhysicalIndex":1006}[0m 0.29ms] ( 7474 inserted ) +SQL[[1;33mINSERT IGNORE INTO `eventlog` (`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES (:device_id,:reference,:type,:datetime,:severity,:message,:username) [0;33m{"device_id":4,"reference":"7474","type":"sensor","datetime":"2019-01-30 08:47:40","severity":3,"message":"Sensor Added: state ciscoEnvMonSupplyState 1006 Sw1, PS1 Normal, RPS NotExist","username":""}[0m 0.23ms] SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",4,"ciscoEnvMonSupplyState",1006][0m 0.37ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["ciscoEnvMonSupplyState"][0m 0.15ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":7474,"state_index_id":4}[0m 0.17ms] SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'CISCO-ENTITY-FRU-CONTROL-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'cefcFRUPowerStatusTable'[0m] cefcFRUPowerStatusTable = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'CISCO-RF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'cRFCfgRedundancyOperMode'[0m] cRFCfgRedundancyOperMode = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'CISCO-RF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'cRFStatusUnitState'[0m] cRFStatusUnitState = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'CISCO-RF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/cisco' 'udp:HOSTNAME:161' 'cRFStatusPeerUnitState'[0m] cRFStatusPeerUnitState = No Such Object available on this agent at this OID Array ( [ciscoEnvMonTemperatureState] => Array ( [1008] => 1 ) [ciscoEnvMonFanState] => Array ( [1007] => 1 ) [ciscoEnvMonSupplyState] => Array ( [1006] => 1 ) ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["state",4,"snmp"][0m 0.84ms] 1008 -> ciscoEnvMonTemperatureState 1007 -> ciscoEnvMonFanState 1006 -> ciscoEnvMonSupplyState Count: SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["count",4,"snmp"][0m 0.51ms] Temperature: Discover sensor: .1.3.6.1.4.1.9.9.13.1.3.1.3.1008, 1008, cisco, SW#1, Sensor#1, GREEN, snmp, 1, 1, 1008, 25 SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","temperature",4,"cisco","1008"][0m 0.5ms] SQL[[1;33mINSERT IGNORE INTO `sensors` (`poller_type`,`sensor_class`,`device_id`,`sensor_oid`,`sensor_index`,`sensor_type`,`sensor_descr`,`sensor_divisor`,`sensor_multiplier`,`sensor_limit`,`sensor_limit_warn`,`sensor_limit_low`,`sensor_current`,`entPhysicalIndex`) VALUES (:poller_type,:sensor_class,:device_id,:sensor_oid,:sensor_index,:sensor_type,:sensor_descr,:sensor_divisor,:sensor_multiplier,:sensor_limit,:sensor_limit_warn,:sensor_limit_low,:sensor_current,:entPhysicalIndex) [0;33m{"poller_type":"snmp","sensor_class":"temperature","device_id":4,"sensor_oid":".1.3.6.1.4.1.9.9.13.1.3.1.3.1008","sensor_index":1008,"sensor_type":"cisco","sensor_descr":"SW#1, Sensor#1, GREEN","sensor_divisor":"1","sensor_multiplier":"1","sensor_limit":45,"sensor_limit_warn":"64","sensor_limit_low":15,"sensor_current":"25","entPhysicalIndex":1008}[0m 0.45ms] ( 7475 inserted ) +SQL[[1;33mINSERT IGNORE INTO `eventlog` (`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES (:device_id,:reference,:type,:datetime,:severity,:message,:username) [0;33m{"device_id":4,"reference":"7475","type":"sensor","datetime":"2019-01-30 08:47:40","severity":3,"message":"Sensor Added: temperature cisco 1008 SW#1, Sensor#1, GREEN","username":""}[0m 0.31ms] Array ( [cisco] => Array ( [1008] => 1 ) ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["temperature",4,"snmp"][0m 0.83ms] 1008 -> cisco Voltage: SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["voltage",4,"snmp"][0m 0.71ms] Snr: SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["snr",4,"snmp"][0m 0.71ms] Pressure: SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["pressure",4,"snmp"][0m 0.67ms] Cooling: SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["cooling",4,"snmp"][0m 0.67ms] Delay: SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["delay",4,"snmp"][0m 0.64ms] Quality_factor: SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["quality_factor",4,"snmp"][0m 0.55ms] Chromatic_dispersion: SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["chromatic_dispersion",4,"snmp"][0m 0.57ms] Ber: SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["ber",4,"snmp"][0m 0.6ms] Eer: SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["eer",4,"snmp"][0m 0.57ms] Waterflow: SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["waterflow",4,"snmp"][0m 0.5ms] >> Runtime for discovery module 'sensors': 0.9500 seconds with 668360 bytes >> SNMP: [25/0.75s] MySQL: [48/0.03s] RRD: [0/0.00s] #### Unload disco module sensors #### SQL[[1;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ? [0;33m[4,"poll_mib"][0m 0.19ms] SQL[[1;33mUPDATE `devices` set `last_discovered`=NOW(),`last_discovered_timetaken`=? WHERE `device_id` = ? [0;33m[2.0219999999999998,4][0m 0.54ms] Discovered in 2.022 seconds SQL[[1;33mINSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES (:type,:doing,:start,:duration,:devices,:poller) [0;33m{"type":"discover","doing":"sd-test-poe-01.sd.local","start":1548856058.1496699,"duration":"2.194","devices":1,"poller":"sdnms01.sd.local"}[0m 0.23ms] ./discovery.php sd-test-poe-01.sd.local 2019-01-30 08:47:40 - 1 devices discovered in 2.194 secs SNMP [27/0.80s]: Get[3/0.08s] Getnext[0/0.00s] Walk[24/0.72s] MySQL [55/0.03s]: Cell[5/0.00s] Row[4/0.00s] Rows[32/0.02s] Column[0/0.00s] Update[1/0.00s] Insert[13/0.01s] Delete[0/0.00s] RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]