LibreNMS Poller SQL[[0;33mSELECT version FROM `dbSchema` ORDER BY version DESC LIMIT 1[0m] SQL[[0;33mSELECT version()[0m] =================================== Version info: Commit SHA: 2e835383804dd9215a27c482aa64890bec8f7d6a Commit Date: 1534435387 DB Schema: 258 PHP: 7.2.6 MySQL: 5.5.56-MariaDB RRDTool: 1.4.8 SNMP: NET-SNMP 5.7.2 ==================================DEBUG! Updating os_def.cache... Done http transport being usedOverride poller modules: sensors(temperature) Starting polling run: SQL[[0;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `device_id` = 257 ORDER BY `device_id` ASC[0m] SQL[[0;33mSELECT * FROM devices_attribs WHERE `device_id` = '257'[0m] Hostname: tcb-gpon2.tvt-datos.es Device ID: 257 OS: smartax (huawei) [FPING] /usr/sbin/fping -e -q -c 10 -p 500 -t 500 tcb-gpon2.tvt-datos.es Array ( [xmt] => 10 [rcv] => 10 [loss] => 0 [min] => 1.46 [max] => 9.95 [avg] => 2.71 [exitcode] => 0 ) SQL[[0;33mINSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`) VALUES ('10','10','0','1.46','9.95','2.71','257',NOW())[0m] SNMP Check response code: 0 Modules status: Global+ OS Device #### Load poller module core #### SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OQnUt -m SNMPv2-MIB -M /opt/dev_librenms/mibs:/opt/dev_librenms/mibs/huawei -t 2 -r 5 udp:HOSTNAME:161 sysUpTime.0 sysLocation.0 sysContact.0 sysName.0 sysObjectID.0 sysDescr.0[0m] .*.*.0 = 277334540 .*.*.0 = Shenzhen China .*.*.0 = R&D Shenzhen, Huawei Technologies Co., Ltd. .*.*.0 = tcb-gpon2 .*.*.0 = .*.4.1.2* .*.*.0 = Huawei Integrated Access Software SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/dev_librenms/mibs:/opt/dev_librenms/mibs/huawei -t 2 -r 5 udp:HOSTNAME:161 snmpEngineTime.0 hrSystemUptime.0[0m] snmpEngineTime.0 = 2773342 Uptime seconds: 2773345 RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/uptime.rrd N:2773345[0m] InfluxDB data: uptimeArray ( [hostname] => tcb-gpon2.tvt-datos.es ) Array ( [uptime] => 2773345 ) END Uptime: 32 days, 2h 22m 25s SQL[[0;33mSELECT `lat`,`lng` FROM `locations` WHERE `location`='Shenzhen China' LIMIT 1[0m] Using cached lat/lng from other device >> Runtime for poller module 'core': 0.1359 seconds with 1110600 bytes >> SNMP: [2/0.09s] MySQL: [1/0.00s] RRD: [1/0.00s] #### Unload poller module core #### RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/poller-perf-core.rrd N:0.1359179019928[0m] InfluxDB data: poller-perfArray ( [hostname] => tcb-gpon2.tvt-datos.es [module] => core ) Array ( [poller] => 0.1359179019928 ) END Modules status: Global+ OS Device #### Load poller module sensors #### SQL[[0;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = '257' AND `sensor_class` IN ('temperature') GROUP BY `sensor_class`[0m] SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'temperature' AND `device_id` = '257'[0m] SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OUQnte -M /opt/dev_librenms/mibs:/opt/dev_librenms/mibs/huawei -t 2 -r 5 udp:HOSTNAME:161 enterprises.2011.2.6.7.1.1.2.1.10.0.1 enterprises.2011.2.6.7.1.1.2.1.10.0.2 enterprises.2011.2.6.7.1.1.2.1.10.0.3 enterprises.2011.2.6.7.1.1.2.1.10.0.4 enterprises.2011.2.6.7.1.1.2.1.10.0.5 enterprises.2011.2.6.7.1.1.2.1.10.0.6 enterprises.2011.2.6.7.1.1.2.1.10.0.7 enterprises.2011.2.6.7.1.1.2.1.10.0.8 enterprises.2011.2.6.7.1.1.2.1.10.0.9 enterprises.2011.2.6.7.1.1.2.1.10.0.10[0m] .*.4.1.2*.*.10.0.1 = 31 .*.4.1.2*.*.10.0.2 = 32 .*.4.1.2*.*.10.0.3 = 31 .*.4.1.2*.*.10.0.4 = 30 .*.4.1.2*.*.10.0.5 = 31 .*.4.1.2*.*.10.0.6 = 31 .*.4.1.2*.*.10.0.7 = 37 .*.4.1.2*.*.10.0.8 = 39 .*.4.1.2*.*.10.0.9 = 31 .*.4.1.2*.*.10.0.10 = 31 SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OUQnte -M /opt/dev_librenms/mibs:/opt/dev_librenms/mibs/huawei -t 2 -r 5 udp:HOSTNAME:161 enterprises.2011.2.6.7.1.1.2.1.10.0.11 enterprises.2011.2.6.7.1.1.2.1.10.0.12 enterprises.2011.2.6.7.1.1.2.1.10.0.17 enterprises.2011.2.6.7.1.1.2.1.10.0.18[0m] .*.4.1.2*.*.10.0.11 = 31 .*.4.1.2*.*.10.0.12 = 30 .*.4.1.2*.*.10.0.17 = 31 .*.4.1.2*.*.10.0.18 = 29 Checking (snmp) temperature H805GPFD... Checking (snmp) temperature H805GPFD... Checking (snmp) temperature H805GPFD... Checking (snmp) temperature H805GPFD... Checking (snmp) temperature H805GPFD... Checking (snmp) temperature H805GPFD... Checking (snmp) temperature H802SCUN... Checking (snmp) temperature H802SCUN... Checking (snmp) temperature H805GPFD... Checking (snmp) temperature H805GPFD... Checking (snmp) temperature H805GPFD... Checking (snmp) temperature H805GPFD... Checking (snmp) temperature H801X2CS... Checking (snmp) temperature H801X2CS... Warning: A non-numeric value encountered in /opt/dev_librenms/includes/polling/functions.inc.php on line 164 0 RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/sensor-temperature-smartax-1.rrd N:0[0m] InfluxDB data: sensorArray ( [hostname] => tcb-gpon2.tvt-datos.es [sensor_class] => temperature [sensor_type] => smartax [sensor_descr] => H805GPFD [sensor_index] => 1 ) Array ( [sensor] => 0 ) END Warning: A non-numeric value encountered in /opt/dev_librenms/includes/polling/functions.inc.php on line 164 0 RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/sensor-temperature-smartax-2.rrd N:0[0m] InfluxDB data: sensorArray ( [hostname] => tcb-gpon2.tvt-datos.es [sensor_class] => temperature [sensor_type] => smartax [sensor_descr] => H805GPFD [sensor_index] => 2 ) Array ( [sensor] => 0 ) END Warning: A non-numeric value encountered in /opt/dev_librenms/includes/polling/functions.inc.php on line 164 0 RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/sensor-temperature-smartax-3.rrd N:0[0m] InfluxDB data: sensorArray ( [hostname] => tcb-gpon2.tvt-datos.es [sensor_class] => temperature [sensor_type] => smartax [sensor_descr] => H805GPFD [sensor_index] => 3 ) Array ( [sensor] => 0 ) END Warning: A non-numeric value encountered in /opt/dev_librenms/includes/polling/functions.inc.php on line 164 0 RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/sensor-temperature-smartax-4.rrd N:0[0m] InfluxDB data: sensorArray ( [hostname] => tcb-gpon2.tvt-datos.es [sensor_class] => temperature [sensor_type] => smartax [sensor_descr] => H805GPFD [sensor_index] => 4 ) Array ( [sensor] => 0 ) END Warning: A non-numeric value encountered in /opt/dev_librenms/includes/polling/functions.inc.php on line 164 0 RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/sensor-temperature-smartax-5.rrd N:0[0m] InfluxDB data: sensorArray ( [hostname] => tcb-gpon2.tvt-datos.es [sensor_class] => temperature [sensor_type] => smartax [sensor_descr] => H805GPFD [sensor_index] => 5 ) Array ( [sensor] => 0 ) END Warning: A non-numeric value encountered in /opt/dev_librenms/includes/polling/functions.inc.php on line 164 0 RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/sensor-temperature-smartax-6.rrd N:0[0m] InfluxDB data: sensorArray ( [hostname] => tcb-gpon2.tvt-datos.es [sensor_class] => temperature [sensor_type] => smartax [sensor_descr] => H805GPFD [sensor_index] => 6 ) Array ( [sensor] => 0 ) END Warning: A non-numeric value encountered in /opt/dev_librenms/includes/polling/functions.inc.php on line 164 0 RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/sensor-temperature-smartax-7.rrd N:0[0m] InfluxDB data: sensorArray ( [hostname] => tcb-gpon2.tvt-datos.es [sensor_class] => temperature [sensor_type] => smartax [sensor_descr] => H802SCUN [sensor_index] => 7 ) Array ( [sensor] => 0 ) END Warning: A non-numeric value encountered in /opt/dev_librenms/includes/polling/functions.inc.php on line 164 0 RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/sensor-temperature-smartax-8.rrd N:0[0m] InfluxDB data: sensorArray ( [hostname] => tcb-gpon2.tvt-datos.es [sensor_class] => temperature [sensor_type] => smartax [sensor_descr] => H802SCUN [sensor_index] => 8 ) Array ( [sensor] => 0 ) END Warning: A non-numeric value encountered in /opt/dev_librenms/includes/polling/functions.inc.php on line 164 0 RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/sensor-temperature-smartax-9.rrd N:0[0m] InfluxDB data: sensorArray ( [hostname] => tcb-gpon2.tvt-datos.es [sensor_class] => temperature [sensor_type] => smartax [sensor_descr] => H805GPFD [sensor_index] => 9 ) Array ( [sensor] => 0 ) END Warning: A non-numeric value encountered in /opt/dev_librenms/includes/polling/functions.inc.php on line 164 0 RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/sensor-temperature-smartax-10.rrd N:0[0m] InfluxDB data: sensorArray ( [hostname] => tcb-gpon2.tvt-datos.es [sensor_class] => temperature [sensor_type] => smartax [sensor_descr] => H805GPFD [sensor_index] => 10 ) Array ( [sensor] => 0 ) END Warning: A non-numeric value encountered in /opt/dev_librenms/includes/polling/functions.inc.php on line 164 0 RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/sensor-temperature-smartax-11.rrd N:0[0m] InfluxDB data: sensorArray ( [hostname] => tcb-gpon2.tvt-datos.es [sensor_class] => temperature [sensor_type] => smartax [sensor_descr] => H805GPFD [sensor_index] => 11 ) Array ( [sensor] => 0 ) END Warning: A non-numeric value encountered in /opt/dev_librenms/includes/polling/functions.inc.php on line 164 0 RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/sensor-temperature-smartax-12.rrd N:0[0m] InfluxDB data: sensorArray ( [hostname] => tcb-gpon2.tvt-datos.es [sensor_class] => temperature [sensor_type] => smartax [sensor_descr] => H805GPFD [sensor_index] => 12 ) Array ( [sensor] => 0 ) END Warning: A non-numeric value encountered in /opt/dev_librenms/includes/polling/functions.inc.php on line 164 0 RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/sensor-temperature-smartax-17.rrd N:0[0m] InfluxDB data: sensorArray ( [hostname] => tcb-gpon2.tvt-datos.es [sensor_class] => temperature [sensor_type] => smartax [sensor_descr] => H801X2CS [sensor_index] => 17 ) Array ( [sensor] => 0 ) END Warning: A non-numeric value encountered in /opt/dev_librenms/includes/polling/functions.inc.php on line 164 0 RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/sensor-temperature-smartax-18.rrd N:0[0m] InfluxDB data: sensorArray ( [hostname] => tcb-gpon2.tvt-datos.es [sensor_class] => temperature [sensor_type] => smartax [sensor_descr] => H801X2CS [sensor_index] => 18 ) Array ( [sensor] => 0 ) END >> Runtime for poller module 'sensors': 0.7588 seconds with 2640 bytes >> SNMP: [2/0.69s] MySQL: [2/0.00s] RRD: [15/0.00s] #### Unload poller module sensors #### RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/poller-perf-sensors.rrd N:0.7588369846344[0m] InfluxDB data: poller-perfArray ( [hostname] => tcb-gpon2.tvt-datos.es [module] => sensors ) Array ( [poller] => 0.7588369846344 ) END ### Start Device Groups ### SQL[[0;33mSELECT * FROM device_groups ORDER BY name[0m] SQL[[0;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='257'[0m] Groups Added: Groups Removed: ### End Device Groups ### RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/ping-perf.rrd N:2.71[0m] InfluxDB data: ping-perfArray ( [hostname] => tcb-gpon2.tvt-datos.es ) Array ( [ping] => 2.71 ) END RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/poller-perf.rrd N:5.502[0m] InfluxDB data: poller-perfArray ( [hostname] => tcb-gpon2.tvt-datos.es [module] => ALL ) Array ( [poller] => 5.502 ) END SQL[[0;33mUPDATE `devices` set `uptime` ='2773345',`last_ping` =NOW(),`last_ping_timetaken` ='2.71' WHERE `device_id` = '257'[0m] Updating tcb-gpon2.tvt-datos.es Polled in 5.502 seconds #### Start Alerts #### SQL[[0;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='257'[0m] SQL[[0;33mSELECT alert_schedule.schedule_id FROM alert_schedule LEFT JOIN alert_schedule_items ON alert_schedule.schedule_id=alert_schedule_items.schedule_id WHERE ( alert_schedule_items.target = '257' ) && ((alert_schedule.recurring = 0 AND (NOW() BETWEEN alert_schedule.start AND alert_schedule.end)) OR (alert_schedule.recurring = 1 AND (alert_schedule.start_recurring_dt <= date_format(NOW(), '[1;33m-[0;35m-%d') AND (end_recurring_dt >= date_format(NOW(), '[1;33m-[0;35m-%d') OR end_recurring_dt is NULL OR end_recurring_dt = '0000-00-00' OR end_recurring_dt = '')) AND (date_format(now(), '%H:%i:%s') BETWEEN `start_recurring_hr` AND end_recurring_hr) AND (recurring_day LIKE CONCAT('%',date_format(now(), '[0;37m'),'%') OR recurring_day is null or recurring_day = ''))) LIMIT 1[0m] SQL[[0;33mSELECT DISTINCT a.* FROM alert_rules a LEFT JOIN alert_device_map d ON a.id=d.rule_id LEFT JOIN alert_group_map g ON a.id=g.rule_id LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id WHERE a.disabled = 0 AND ((d.device_id IS NULL AND g.group_id IS NULL) OR d.device_id='257' OR dg.device_id='257')[0m] Rule [0;35m#1 (Port utilisation over threshold):[0m SQL[[0;33mSELECT * FROM devices,ports WHERE (devices.device_id = '257' AND devices.device_id = ports.device_id) AND (((ports.ifInOctets_rate*8) / ports.ifSpeed)*100) >= 80 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1[0m] SQL[[0;33mSELECT state FROM alerts WHERE rule_id = '1' AND device_id = '257' ORDER BY id DESC LIMIT 1[0m] Status: [0;34mNOCHG[0m Rule [0;35m#2 (Port status up/down):[0m SQL[[0;33mSELECT * FROM devices,ports WHERE (devices.device_id = '257' AND devices.device_id = ports.device_id) AND (ports.ifOperStatus = "down" && ports.ifAdminStatus != "down" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1[0m] SQL[[0;33mSELECT state FROM alerts WHERE rule_id = '2' AND device_id = '257' ORDER BY id DESC LIMIT 1[0m] Status: [0;34mNOCHGSQL[[0;33mSELECT alert_log.id, alert_log.details FROM alert_log,alert_rules WHERE alert_log.rule_id = alert_rules.id && alert_log.device_id = '257' && alert_log.rule_id = '2' && alert_rules.disabled = 0 ORDER BY alert_log.id DESC LIMIT 1[0m] SQL[[0;33mUPDATE `alert_log` set `details` =''NJRUw`o%iߒ-\ZI8q0.ۙQ5a\\,,UgƼe/U!糲|i,z,jU~ohVc+\Z{U,)&**^M^x\"oU`uvu;^̊vR=XEu|Y>JNAˢm\'}Km*uI6-EMJ*ug4mS58+_IUz~HKUgl~6-cp×Nھj\"R̪Xtt$GT~+~?EO}6Z7rd+a%VJXp\ZB|gZëw}m?@㙶iE];r#?#΢T;ڦ_\"}Q8\nG(p2G=8\Z G(pQ8\nGG}\r9.pQ8\nG(}\r7G{{;y{U>G]+r\'0}n:?Gms?Gۇs/}O>\'D;}~tM3\'D}O>6ӧk(D}O>\'}3\"?D}O>\'DCSÿ}O>\'D}HG}w>\'D}a:3pu>\'D}O9>-E6D}O>\'BlYG}O>\'DQɬ#>\'D}Aȵ,>\'D}O9>}\'D}O>0tԧz}O>\'D3Q!}O>\'D}O\rW<>\'D}O>ѧoO>\'D}O>ѧ>}D}O>\'FX}O>\'Ds}j|[>\'D}O>ѧ>]YG}O>\'DSw~#>\'D}A㻎fD}O> ]G2}O>\'Ds}uu>\'D}O9>u|QG:B}O>\'B:\n\"YG}O>\'DSw0uԧj}O>\'DQ!ͣO>\'D}OWC}:&ͣO>\'D}OOG}:6>\'D}O9>}0tgj}O>\'D3Pj}O>\'D3QͣO>\'D}Qɬ#>\'D}A㻎gD}O> ]Ge3}O>\'Ds}# u>\'D}O9>u|ב;:B}O>\'D:CfO>\'D}Ou[.\'D?߿\Zm' WHERE id = '81'[0m] [1;31mMySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?NJ??RU??????????w`o?%i????ߒ-??????\ZI??8??q??0.?ۙQ5a\\???,?,U' at line 1 (UPDATE `alert_log` set `details` =''NJRUw`o%iߒ-\ZI8q0.ۙQ5a\\,,UgƼe/U!糲|i,z,jU~ohVc+\Z{U,)&**^M^x\"oU`uvu;^̊vR=XEu|Y>JNAˢm\'}Km*uI6-EMJ*ug4mS58+_IUz~HKUgl~6-cp×Nھj\"R̪Xtt$GT~+~?EO}6Z7rd+a%VJXp\ZB|gZëw}m?@㙶iE];r#?#΢T;ڦ_\"}Q8\nG(p2G=8\Z G(pQ8\nGG}\r9.pQ8\nG(}\r7G{{;y{U>G]+r\'0}n:?Gms?Gۇs/}O>\'D;}~tM3\'D}O>6ӧk(D}O>\'}3\"?D}O>\'DCSÿ}O>\'D}HG}w>\'D}a:3pu>\'D}O9>-E6D}O>\'BlYG}O>\'DQɬ#>\'D}Aȵ,>\'D}O9>}\'D}O>0tԧz}O>\'D3Q!}O>\'D}O\rW<>\'D}O>ѧoO>\'D}O>ѧ>}D}O>\'FX}O>\'Ds}j|[>\'D}O>ѧ>]YG}O>\'DSw~#>\'D}A㻎fD}O> ]G2}O>\'Ds}uu>\'D}O9>u|QG:B}O>\'B:\n\"YG}O>\'DSw0uԧj}O>\'DQ!ͣO>\'D}OWC}:&ͣO>\'D}OOG}:6>\'D}O9>}0tgj}O>\'D3Pj}O>\'D3QͣO>\'D}Qɬ#>\'D}A㻎gD}O> ]Ge3}O>\'Ds}# u>\'D}O9>u|ב;:B}O>\'D:CfO>\'D}Ou[.\'D?߿\Zm' WHERE id = '81')[0m [0m #### End Alerts #### SQL[[0;33mINSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES ('poll','257','1534435773.4365','5.798','1','librenms.tvt-datos.es')[0m] ./poller.php 257 2018-08-16 18:09:39 - 1 devices polled in 5.798 secs SNMP [5/0.85s]: Get[5/0.85s] Getnext[0/0.00s] Walk[0/0.00s] MySQL [23/0.02s]: Cell[5/0.00s] Row[2/0.00s] Rows[10/0.01s] Column[2/0.00s] Update[2/0.00s] Insert[2/0.00s] Delete[0/0.00s] RRD [19/0.00s]: Update[19/0.00s] Create [0/0.00s] Other[0/0.00s]