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` =''4hn0DZmIY>JcҮC GCR_e8jgĨ0HcIc^2ؐYYX>4E=S?շ{UT4+U\n=ol*egI]ë?/^&TIBS˦ڞB\Z.Ye./mjچI%kY^TĭӘ7M};qvLr\\ZĵbN3<5SY Q$R,K]˶ݫ?o7-UB%l7v*ϜmG|vk\ZwloTȅ\\T*,2OSN#\'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}:(\'D}Ou䚶j}O>\'DQͣO>\'D}OGG}6>\'D}O9>]\r阬6>\'D}O9>=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` =''4hn0DZmIY>JcҮC GCR_e8jgĨ0HcIc^2ؐYYX>4E=S?շ{UT4+U\n=ol*egI]ë?/^&TIBS˦ڞB\Z.Ye./mjچI%kY^TĭӘ7M};qvLr\\ZĵbN3<5SY Q$R,K]˶ݫ?o7-UB%l7v*ϜmG|vk\ZwloTȅ\\T*,2OSN#\'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}:(\'D}Ou䚶j}O>\'DQͣO>\'D}OGG}6>\'D}O9>]\r阬6>\'D}O9>=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]