- 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: processors
- 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.30
- [max] => 1.98
- [avg] => 1.61
- [exitcode] => 0
- )
- SQL[[0;33mINSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`) VALUES ('10','10','0','1.30','1.98','1.61','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 = 277330078
- .*.*.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 = 2773297
- Uptime seconds: 2773301
- RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/uptime.rrd N:2773301[0m]
- InfluxDB data:
- uptimeArray
- (
- [hostname] => tcb-gpon2.tvt-datos.es
- )
- Array
- (
- [uptime] => 2773301
- )
- END
- Uptime: 32 days, 2h 21m 41s
- 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.1131 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.11313199996948[0m]
- InfluxDB data:
- poller-perfArray
- (
- [hostname] => tcb-gpon2.tvt-datos.es
- [module] => core
- )
- Array
- (
- [poller] => 0.11313199996948
- )
- END
- Modules status: Global+ OS Device
- #### Load poller module processors ####
- Attempting to initialize OS: smartax
- OS initialized: LibreNMS\OS\Smartax
- SQL[[0;33mSELECT * FROM processors WHERE device_id='257'[0m]
- SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OUQn -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.5.0.1 .enterprises.2011.2.6.7.1.1.2.1.5.0.2 .enterprises.2011.2.6.7.1.1.2.1.5.0.3 .enterprises.2011.2.6.7.1.1.2.1.5.0.4 .enterprises.2011.2.6.7.1.1.2.1.5.0.5 .enterprises.2011.2.6.7.1.1.2.1.5.0.6 .enterprises.2011.2.6.7.1.1.2.1.5.0.7 .enterprises.2011.2.6.7.1.1.2.1.5.0.8 .enterprises.2011.2.6.7.1.1.2.1.5.0.9 .enterprises.2011.2.6.7.1.1.2.1.5.0.10[0m]
- .*.4.1.2*.*.5.0.1 = 17
- .*.4.1.2*.*.5.0.2 = 16
- .*.4.1.2*.*.5.0.3 = 15
- .*.4.1.2*.*.5.0.4 = 22
- .*.4.1.2*.*.5.0.5 = 15
- .*.4.1.2*.*.5.0.6 = 19
- .*.4.1.2*.*.5.0.7 = 8
- .*.4.1.2*.*.5.0.8 = 19
- .*.4.1.2*.*.5.0.9 = 16
- .*.4.1.2*.*.5.0.10 = 15
- SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OUQn -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.5.0.11 .enterprises.2011.2.6.7.1.1.2.1.5.0.12[0m]
- .*.4.1.2*.*.5.0.11 = 14
- .*.4.1.2*.*.5.0.12 = 14
- Array
- (
- [.1.3.6.1.4.1.2011.2.6.7.1.1.2.1.5.0.1] => 17
- [.1.3.6.1.4.1.2011.2.6.7.1.1.2.1.5.0.2] => 16
- [.1.3.6.1.4.1.2011.2.6.7.1.1.2.1.5.0.3] => 15
- [.1.3.6.1.4.1.2011.2.6.7.1.1.2.1.5.0.4] => 22
- [.1.3.6.1.4.1.2011.2.6.7.1.1.2.1.5.0.5] => 15
- [.1.3.6.1.4.1.2011.2.6.7.1.1.2.1.5.0.6] => 19
- [.1.3.6.1.4.1.2011.2.6.7.1.1.2.1.5.0.7] => 8
- [.1.3.6.1.4.1.2011.2.6.7.1.1.2.1.5.0.8] => 19
- [.1.3.6.1.4.1.2011.2.6.7.1.1.2.1.5.0.9] => 16
- [.1.3.6.1.4.1.2011.2.6.7.1.1.2.1.5.0.10] => 15
- [.1.3.6.1.4.1.2011.2.6.7.1.1.2.1.5.0.11] => 14
- [.1.3.6.1.4.1.2011.2.6.7.1.1.2.1.5.0.12] => 14
- )
- 0%
- RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/processor-smartax-1.rrd N:0[0m]
- InfluxDB data:
- processorsArray
- (
- [hostname] => tcb-gpon2.tvt-datos.es
- [processor_type] => smartax
- [processor_index] => 1
- )
- Array
- (
- [usage] => 0
- )
- END
- 0%
- RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/processor-smartax-2.rrd N:0[0m]
- InfluxDB data:
- processorsArray
- (
- [hostname] => tcb-gpon2.tvt-datos.es
- [processor_type] => smartax
- [processor_index] => 2
- )
- Array
- (
- [usage] => 0
- )
- END
- 0%
- RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/processor-smartax-3.rrd N:0[0m]
- InfluxDB data:
- processorsArray
- (
- [hostname] => tcb-gpon2.tvt-datos.es
- [processor_type] => smartax
- [processor_index] => 3
- )
- Array
- (
- [usage] => 0
- )
- END
- 0%
- RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/processor-smartax-4.rrd N:0[0m]
- InfluxDB data:
- processorsArray
- (
- [hostname] => tcb-gpon2.tvt-datos.es
- [processor_type] => smartax
- [processor_index] => 4
- )
- Array
- (
- [usage] => 0
- )
- END
- 0%
- RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/processor-smartax-5.rrd N:0[0m]
- InfluxDB data:
- processorsArray
- (
- [hostname] => tcb-gpon2.tvt-datos.es
- [processor_type] => smartax
- [processor_index] => 5
- )
- Array
- (
- [usage] => 0
- )
- END
- 0%
- RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/processor-smartax-6.rrd N:0[0m]
- InfluxDB data:
- processorsArray
- (
- [hostname] => tcb-gpon2.tvt-datos.es
- [processor_type] => smartax
- [processor_index] => 6
- )
- Array
- (
- [usage] => 0
- )
- END
- 0%
- RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/processor-smartax-7.rrd N:0[0m]
- InfluxDB data:
- processorsArray
- (
- [hostname] => tcb-gpon2.tvt-datos.es
- [processor_type] => smartax
- [processor_index] => 7
- )
- Array
- (
- [usage] => 0
- )
- END
- 0%
- RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/processor-smartax-8.rrd N:0[0m]
- InfluxDB data:
- processorsArray
- (
- [hostname] => tcb-gpon2.tvt-datos.es
- [processor_type] => smartax
- [processor_index] => 8
- )
- Array
- (
- [usage] => 0
- )
- END
- 0%
- RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/processor-smartax-9.rrd N:0[0m]
- InfluxDB data:
- processorsArray
- (
- [hostname] => tcb-gpon2.tvt-datos.es
- [processor_type] => smartax
- [processor_index] => 9
- )
- Array
- (
- [usage] => 0
- )
- END
- 0%
- RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/processor-smartax-10.rrd N:0[0m]
- InfluxDB data:
- processorsArray
- (
- [hostname] => tcb-gpon2.tvt-datos.es
- [processor_type] => smartax
- [processor_index] => 10
- )
- Array
- (
- [usage] => 0
- )
- END
- 0%
- RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/processor-smartax-11.rrd N:0[0m]
- InfluxDB data:
- processorsArray
- (
- [hostname] => tcb-gpon2.tvt-datos.es
- [processor_type] => smartax
- [processor_index] => 11
- )
- Array
- (
- [usage] => 0
- )
- END
- 0%
- RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/processor-smartax-12.rrd N:0[0m]
- InfluxDB data:
- processorsArray
- (
- [hostname] => tcb-gpon2.tvt-datos.es
- [processor_type] => smartax
- [processor_index] => 12
- )
- Array
- (
- [usage] => 0
- )
- END
- >> Runtime for poller module 'processors': 0.1979 seconds with 94768 bytes
- >> SNMP: [2/0.13s] MySQL: [1/0.00s] RRD: [13/0.00s]
- #### Unload poller module processors ####
- RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/poller-perf-processors.rrd N:0.19788813591003[0m]
- InfluxDB data:
- poller-perfArray
- (
- [hostname] => tcb-gpon2.tvt-datos.es
- [module] => processors
- )
- Array
- (
- [poller] => 0.19788813591003
- )
- 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:1.61[0m]
- InfluxDB data:
- ping-perfArray
- (
- [hostname] => tcb-gpon2.tvt-datos.es
- )
- Array
- (
- [ping] => 1.61
- )
- END
- RRD[[0;32mupdate /opt/dev_librenms/rrd/tcb-gpon2.tvt-datos.es/poller-perf.rrd N:4.913[0m]
- InfluxDB data:
- poller-perfArray
- (
- [hostname] => tcb-gpon2.tvt-datos.es
- [module] => ALL
- )
- Array
- (
- [poller] => 4.913
- )
- END
- SQL[[0;33mUPDATE `devices` set `uptime` ='2773301',`last_ping` =NOW(),`last_ping_timetaken` ='1.61' WHERE `device_id` = '257'[0m]
- Updating tcb-gpon2.tvt-datos.es
- Polled in 4.913 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` ='<binary>'4hn0DZmIY>JcҮC GCR_e8jgĨ0HcIc^2ؐYYX>4E=S?շ{UT4+U\n=ol*egI]ë?/^&TIB<q7>S˦ڞB\Z.Ye./mjچI%kY^TĭӘ7M};qvLr\\ZĵbN3<5SY Q$R,K]˶ݫ?o7-UB%l7v*ϜmG|vk\ZwloTȅ\\T*,2<F~u\\e5UESvR1Q#f{Uۢ+uSIՙ,T22IE)]]@ɪ}jēJL)KNfRٜ}˦G&6=_u/%Heru?՝/Ԙܶ\ZMo$m\nlIϹxV?OY\\)^MhOeF6yxSxX w2=i>OSN#\'J=_z?ި~1FΦ0}ӶjM{IDzT=I[e<+w#ڂ;5 lz}.^GnD\\oT^cכQuP[{3~xu\0m/< 䱣#}.\'Y?_^l=t~&U/sj$71vJS{_Ax[߷;I_w?n#=mAױ\n\';OU@=#tL)1%oҲ^)VmYًHޮ,]eKsF˅mFvPYȬ$]=|S#vĎ;b_8vb?o%{dg%JX +a%V*+meru74ߙwzpu_u<60 nG(p_樧GC74(pQ8\nGਯ!G=ׅpQ8\nG(/owoo\>\'D0OiF>D}O>\'ڦ~\rE}O>\'D>i0}O>\'D}O\r6>\'D}O9>#_\'D}O>ѧgaD}O> tg}O>\'Ds}\Z3]fO>\'D}OGG}z&\'D}O>ѧ>#ײ;D}O> uԧz}O>\'D3Q>}O>\'D}PG}>\'D}O9>5\\m>,D}O>\'D>D}O>\'FY}O>\'Ds}:3bO>\'D}ajo:B}O>\'Dt-fO>\'D}Ou\'D}O>ѧ:#YG}O>\'DSwVȬ#>\'D}A㻎eD}O> ]G1}O>\'Ds}:(<fO>\'D}Ou䚶j}O>\'DQͣO>\'D}OGG}6>\'D}O9>]\r阬6>\'D}O9>=<D>0uԧj}O>\'D3Q!ͣO>\'D}PC}&ͣO>\'D}HG}:6>\'D}O9>CSG}&\'D}O>ѧ:rCYG}O>\'DSwyͬ#>\'D}A㻎<\'`D}O> ]G0}O>\'Ds}#/u>\'D}O9>u|בo:B}P/Qj' 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 '?4h?n?0?D?ZmI???Y??>J?c?ҮC???? ????G??CR_???e???8?jg???Ĩ??0????H?c??I??' at line 1 (UPDATE `alert_log` set `details` ='<binary>'4hn0DZmIY>JcҮC GCR_e8jgĨ0HcIc^2ؐYYX>4E=S?շ{UT4+U\n=ol*egI]ë?/^&TIB<q7>S˦ڞB\Z.Ye./mjچI%kY^TĭӘ7M};qvLr\\ZĵbN3<5SY Q$R,K]˶ݫ?o7-UB%l7v*ϜmG|vk\ZwloTȅ\\T*,2<F~u\\e5UESvR1Q#f{Uۢ+uSIՙ,T22IE)]]@ɪ}jēJL)KNfRٜ}˦G&6=_u/%Heru?՝/Ԙܶ\ZMo$m\nlIϹxV?OY\\)^MhOeF6yxSxX w2=i>OSN#\'J=_z?ި~1FΦ0}ӶjM{IDzT=I[e<+w#ڂ;5 lz}.^GnD\\oT^cכQuP[{3~xu\0m/< 䱣#}.\'Y?_^l=t~&U/sj$71vJS{_Ax[߷;I_w?n#=mAױ\n\';OU@=#tL)1%oҲ^)VmYًHޮ,]eKsF˅mFvPYȬ$]=|S#vĎ;b_8vb?o%{dg%JX +a%V*+meru74ߙwzpu_u<60 nG(p_樧GC74(pQ8\nGਯ!G=ׅpQ8\nG(/owoo\>\'D0OiF>D}O>\'ڦ~\rE}O>\'D>i0}O>\'D}O\r6>\'D}O9>#_\'D}O>ѧgaD}O> tg}O>\'Ds}\Z3]fO>\'D}OGG}z&\'D}O>ѧ>#ײ;D}O> uԧz}O>\'D3Q>}O>\'D}PG}>\'D}O9>5\\m>,D}O>\'D>D}O>\'FY}O>\'Ds}:3bO>\'D}ajo:B}O>\'Dt-fO>\'D}Ou\'D}O>ѧ:#YG}O>\'DSwVȬ#>\'D}A㻎eD}O> ]G1}O>\'Ds}:(<fO>\'D}Ou䚶j}O>\'DQͣO>\'D}OGG}6>\'D}O9>]\r阬6>\'D}O9>=<D>0uԧj}O>\'D3Q!ͣO>\'D}PC}&ͣO>\'D}HG}:6>\'D}O9>CSG}&\'D}O>ѧ:rCYG}O>\'DSwyͬ#>\'D}A㻎<\'`D}O> ]G0}O>\'Ds}#/u>\'D}O9>u|בo:B}P/Qj' WHERE id = '81')[0m
- [0m
- #### End Alerts ####
- SQL[[0;33mINSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES ('poll','257','1534435728.7763','5.248','1','librenms.tvt-datos.es')[0m]
- ./poller.php 257 2018-08-16 18:08:54 - 1 devices polled in 5.248 secs
- SNMP [5/0.29s]: Get[5/0.29s] Getnext[0/0.00s] Walk[0/0.00s]
- MySQL [22/0.02s]: Cell[5/0.00s] Row[2/0.00s] Rows[9/0.01s] Column[2/0.00s] Update[2/0.00s] Insert[2/0.00s] Delete[0/0.00s]
- RRD [17/0.00s]: Update[17/0.00s] Create [0/0.00s] Other[0/0.00s]