ERROR: can not parse an empty rpn expression
root@libre_nms:/opt/librenms# ./validate.php ====================================
| Component | Version |
|---|---|
| LibreNMS | 1.60-9-gf8ce4df0f |
| DB Schema | 2020_02_05_224042_device_inserted_null (158) |
| PHP | 7.2.24-0ubuntu0.18.04.2 |
| MySQL | 10.1.44-MariaDB-0ubuntu0.18.04.1 |
| RRDTool | 1.7.0 |
| SNMP | NET-SNMP 5.7.3 |
| ==================================== |
[OK] Composer Version: 1.9.3
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct
root@libre_nms:/opt/librenms#
LibreNMS Poller
SQL[select migration from migrations order by id desc limit 1 0.63ms]
SQL[select count(*) as aggregate from migrations limit 1 0.4ms]
SQL[SELECT version() 0.44ms]
===================================
Version info:
Commit SHA: f8ce4df0f8c69e560a82c112d708175f9752a855
Commit Date: 1581063106
DB Schema: 2020_02_05_224042_device_inserted_null (158)
PHP: 7.2.24-0ubuntu0.18.04.2
MySQL: 10.1.44-MariaDB-0ubuntu0.18.04.1
RRDTool: 1.7.0
SNMP: NET-SNMP 5.7.3
==================================DEBUG!
Updating os_def.cache…
Done
Override poller modules:
Starting polling run:
SQL[SELECT * FROM devices WHERE disabled = 0 AND hostname = ‘192.x.x.x’ ORDER BY device_id ASC 1.61ms]
SQL[select distinct os from devices 0.5ms]
SQL[select * from devices where device_id = ? limit 1 [2] 1.08ms]
SQL[select * from devices_attribs where devices_attribs.device_id = ? and devices_attribs.device_id is not null [2] 0.69ms]
Hostname: 192.x.x.x
Device ID: 2
OS: sonicwall
SQL[select hostname, overwrite_ip from devices where hostname = ? limit 1 [“192.x.x.x”] 0.78ms]
[FPING] ‘/usr/bin/fping’ ‘-e’ ‘-q’ ‘-c’ ‘3’ ‘-p’ ‘500’ ‘-t’ ‘500’ ‘192.x.x.x’
array (
‘xmt’ => 3,
‘rcv’ => 3,
‘loss’ => 0,
‘min’ => 0.3,
‘max’ => 0.44,
‘avg’ => 0.38,
‘dup’ => 0,
‘exitcode’ => 0,
)
SQL[INSERT 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) {“xmt”:3,“rcv”:3,“loss”:0,“min”:0.3,“max”:0.44,“avg”:0.38,“device_id”:2,“debug”:“”} 2.49ms]
SQL[select hostname, overwrite_ip from devices where hostname = ? limit 1 [“192.x.x.x”] 0.46ms]
SNMP Check response code: 0
Modules status: Global+
OS
Device
Load poller module core
SQL[select hostname, overwrite_ip from devices where hostname = ? limit 1 [“192.x.x.x”] 0.79ms]
SNMP[‘/usr/bin/snmpget’ ‘-v2c’ ‘-c’ ‘COMMUNITY’ ‘-OQnUt’ ‘-m’ ‘SNMPv2-MIB’ ‘-M’ ‘/opt/librenms/mibs:/opt/librenms/mibs/sonicwall’ ‘udp:HOSTNAME:161’ ‘sysUpTime.0’ ‘sysLocation.0’ ‘sysContact.0’ ‘sysName.0’ ‘sysObjectID.0’ ‘sysDescr.0’]
...0 = 552291300
...0 = name
...0 = name
...0 = name
...0 = ..4.1.8741.1
..*.0 = SonicWALL NSA 2600 (SonicOS Enhanced *-23n)
SQL[select hostname, overwrite_ip from devices where hostname = ? limit 1 [“192.X.X.X”] 1.08ms]
SNMP[‘/usr/bin/snmpget’ ‘-v2c’ ‘-c’ ‘COMMUNITY’ ‘-OQnUst’ ‘-m’ ‘HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB’ ‘-M’ ‘/opt/librenms/mibs:/opt/librenms/mibs/sonicwall’ ‘udp:HOSTNAME:161’ ‘snmpEngineTime.0’ ‘hrSystemUptime.0’]
snmpEngineTime.0 = No Such Object available on this agent at this OID
hrSystemUptime.0 = No Such Object available on this agent at this OID
Uptime seconds: 5522913
RRD[update /opt/librenms/rrd/192.x.x.x/uptime.rrd N:5522913]
Uptime: 63 days 22 hours 8 minutes 33 seconds
SQL[select * from locations where (location = ?) limit 1 [“city”] 1.02ms]
Runtime for poller module ‘core’: 0.0457 seconds with 168488 bytes
SNMP: [2/0.04s] MySQL: [0/0.00s] RRD: [1/0.00s]
Unload poller module core
RRD[update /opt/librenms/rrd/192.x.x.x/poller-perf-core.rrd N:0.04569411277771]
Start Device Groups
SQL[select * from devices where devices.device_id = ? limit 1 [2] 1.94ms]
SQL[select * from device_groups 0.78ms]
SQL[select * from device_group_device where device_id = ? [2] 0.76ms]
Groups Added:
Groups Removed:
End Device Groups, runtime: 0.0139s
Enabling graphs: SQL[SELECT graph FROM device_graphs WHERE device_id = ? [2] 0.65ms]
SQL[DELETE FROM device_graphs WHERE device_id = ? AND graph = ? [2,“netstat_icmp”] 2.6ms]
SQL[DELETE FROM device_graphs WHERE device_id = ? AND graph = ? [2,“netstat_icmp_info”] 10.43ms]
SQL[DELETE FROM device_graphs WHERE device_id = ? AND graph = ? [2,“netstat_ip”] 20.51ms]
SQL[DELETE FROM device_graphs WHERE device_id = ? AND graph = ? [2,“netstat_ip_frag”] 8.48ms]
SQL[DELETE FROM device_graphs WHERE device_id = ? AND graph = ? [2,“netstat_snmp”] 8.75ms]
SQL[DELETE FROM device_graphs WHERE device_id = ? AND graph = ? [2,“netstat_snmp_pkt”] 8.76ms]
SQL[DELETE FROM device_graphs WHERE device_id = ? AND graph = ? [2,“netstat_tcp”] 8.83ms]
SQL[DELETE FROM device_graphs WHERE device_id = ? AND graph = ? [2,“netstat_udp”] 8.35ms]
uptime
RRD[update /opt/librenms/rrd/192.x.x.x/ping-perf.rrd N:0.38]
RRD[update /opt/librenms/rrd/192.x.x.x/poller-perf.rrd N:1.198]
SQL[UPDATE devices set uptime=?,last_ping=NOW(),last_ping_timetaken=?,last_polled=NOW(),last_polled_timetaken=? WHERE device_id = ? [5522913,0.38,1.198,2] 7.59ms]
Updating 192.X.X.X
Polled in 1.198 seconds
Start Alerts
SQL[select * from devices where devices.device_id = ? limit 1 [2] 1.08ms]
SQL[select device_groups.*, device_group_device.device_id as pivot_device_id, device_group_device.device_group_id as pivot_device_group_id from device_groups inner join device_group_device on device_groups.id = device_group_device.device_group_id where device_group_device.device_id = ? [2] 0.91ms]
SQL[select * from locations where locations.id = ? limit 1 [2] 0.75ms]
SQL[select exists(select * from alert_schedule inner join alert_schedulables on alert_schedule.schedule_id = alert_schedulables.schedule_id where ((recurring = ? and start <= NOW() and end >= NOW()) or (recurring = ? and (start_recurring_dt <= date_format(NOW(), ‘–%d’) and (end_recurring_dt >= date_format(NOW(), ‘–%d’) or end_recurring_dt is null or end_recurring_dt = ? or end_recurring_dt = ?)) and start_recurring_hr <= date_format(NOW(), ‘%H:%i:%s’) and end_recurring_hr >= date_format(NOW(), ‘%H:%i:%s’) and (recurring_day like CONCAT(‘%’, date_format(NOW(), ‘’), ‘%’) or recurring_day is null or recurring_day = ?))) and ((alert_schedulable_type = ? and alert_schedulable_id = ?) or (alert_schedulable_type = ? and 0 = 1) or (alert_schedulable_type = ? and alert_schedulable_id = ?))) as exists [0,1,“0000-00-00”,“”,“”,“device”,2,“device_group”,“location”,2] 1.87ms]
SQL[select * from devices where devices.device_id = ? limit 1 [2] 0.99ms]
SQL[SELECT DISTINCT a.* FROM alert_rules a
LEFT JOIN alert_device_map d ON a.id=d.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND d.device_id = ?)
LEFT JOIN alert_group_map g ON a.id=g.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND g.group_id IN (SELECT DISTINCT device_group_id FROM device_group_device WHERE device_id = ?))
LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
WHERE a.disabled = 0 AND (
(d.device_id IS NULL AND g.group_id IS NULL)
OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=?))
OR (a.invert_map = 1 AND (d.device_id != ? OR d.device_id IS NULL) AND (dg.device_id != ? OR dg.device_id IS NULL))
) [2,2,2,2,2,2,2] 1.19ms]
Rule #1 (Devices up/down):
SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [2] 1.31ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [1,2] 0.74ms]
Status: NOCHG
Rule #2 (Device rebooted):
SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 AND (devices.disabled = 0 && devices.ignore = 0) = 1 [2] 1.51ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [2,2] 0.91ms]
Status: NOCHG
Rule #3 (BGP Session down):
SQL[SELECT * FROM devices,bgpPeers WHERE (devices.device_id = ? AND devices.device_id = bgpPeers.device_id) AND bgpPeers.bgpPeerState != “established” AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND bgpPeers.bgpPeerAdminStatus != “stop” [2] 1.77ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [3,2] 0.57ms]
Status: NOCHG
Rule #4 (BGP Session established):
SQL[SELECT * FROM devices,bgpPeers WHERE (devices.device_id = ? AND devices.device_id = bgpPeers.device_id) AND bgpPeers.bgpPeerFsmEstablishedTime < 300 AND bgpPeers.bgpPeerState = “established” AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [2] 1.7ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [4,2] 0.54ms]
Status: NOCHG
Rule #5 (Port status up/down):
SQL[SELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND (ports.ifOperStatus = “down” && ports.ifAdminStatus != “down” && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 [2] 1.82ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [5,2] 0.62ms]
Status: NOCHG
Rule #6 (Port utilisation over threshold):
SQL[SELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND (((SELECT IF(ports.ifOutOctets_rate>ports.ifInOctets_rate, ports.ifOutOctets_rate, 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 [2] 2.04ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [6,2] 0.74ms]
Status: NOCHG
Rule #7 (Sensor over limit - Check Device Health Settings):
SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current > sensors.sensor_limit AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [2] 1.5ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [7,2] 0.66ms]
Status: NOCHG
Rule #8 (Sensor under limit - Check Device Health Settings):
SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current < sensors.sensor_limit_low AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [2] 1.53ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [8,2] 0.54ms]
Status: NOCHG
Rule #9 (Service up/down):
SQL[SELECT * FROM devices,services WHERE (devices.device_id = ? AND devices.device_id = services.device_id) AND services.service_status != 0 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [2] 1.07ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [9,2] 0.4ms]
Status: NOCHG
Rule #10 (Wireless Sensor over limit):
SQL[SELECT * FROM devices,wireless_sensors WHERE (devices.device_id = ? AND devices.device_id = wireless_sensors.device_id) AND wireless_sensors.sensor_current >= wireless_sensors.sensor_limit AND wireless_sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [2] 1.29ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [10,2] 0.46ms]
Status: NOCHG
Rule #11 (Wireless Sensor under limit):
SQL[SELECT * FROM devices,wireless_sensors WHERE (devices.device_id = ? AND devices.device_id = wireless_sensors.device_id) AND wireless_sensors.sensor_current <= wireless_sensors.sensor_limit_low AND wireless_sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [2] 1.14ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [11,2] 0.56ms]
Status: NOCHG
Rule #12 (State Sensor Critical):
SQL[SELECT * FROM devices,sensors,sensors_to_state_indexes,state_indexes,state_translations WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id AND sensors.sensor_id = sensors_to_state_indexes.sensor_id AND sensors_to_state_indexes.state_index_id = state_indexes.state_index_id AND state_indexes.state_index_id = state_translations.state_index_id) AND (sensors.sensor_current = state_translations.state_value && state_translations.state_generic_value = 2) = 1 AND sensors.sensor_alert = 1 [2] 1.87ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [12,2] 0.54ms]
Status: NOCHG
Rule #13 (CustomOID over limit):
SQL[SELECT * FROM devices,customoids WHERE (devices.device_id = ? AND devices.device_id = customoids.device_id) AND customoids.customoid_current >= customoids.customoid_limit AND customoids.customoid_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [2] 1.35ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [13,2] 0.72ms]
Status: NOCHG
Rule #14 (CustomOID under limit):
SQL[SELECT * FROM devices,customoids WHERE (devices.device_id = ? AND devices.device_id = customoids.device_id) AND customoids.customoid_current <= customoids.customoid_limit_low AND customoids.customoid_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [2] 1.35ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [14,2] 0.48ms]
Status: NOCHG
Rule #15 (CustomOID over warning limit):
SQL[SELECT * FROM devices,customoids WHERE (devices.device_id = ? AND devices.device_id = customoids.device_id) AND customoids.customoid_current >= customoids.customoid_limit_warn AND customoids.customoid_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [2] 1.24ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [15,2] 0.5ms]
Status: NOCHG
Rule #16 (CustomOID under warning limit):
SQL[SELECT * FROM devices,customoids WHERE (devices.device_id = ? AND devices.device_id = customoids.device_id) AND customoids.customoid_current <= customoids.customoid_limit_low_warn AND customoids.customoid_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [2] 1.2ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [16,2] 0.44ms]
Status: NOCHG
End Alerts
SQL[INSERT IGNORE INTO perf_times (type,doing,start,duration,devices,poller) VALUES (:type,:doing,:start,:duration,:devices,:poller) {“type”:“poll”,“doing”:“192.x.x.x”,“start”:1581112368.731745,“duration”:“1.724”,“devices”:1,“poller”:null} 1.94ms]
./poller.php 192.x.x.x 2020-02-07 15:52:50 - 1 devices polled in 1.724 secs
SNMP [3/0.05s]: Get[3/0.05s] Getnext[0/0.00s] Walk[0/0.00s]
MySQL [30/0.13s]: Cell[17/0.02s] Row[-17/-0.02s] Rows[19/0.04s] Column[0/0.00s] Update[1/0.01s] Insert[2/0.01s] Delete[8/0.08s]
RRD [4/0.00s]: Update[4/0.00s] Create [0/0.00s] Other[0/0.00s]
root@libre_nms:/opt/librenms#
LibreNMS Discovery
SQL[select migration from migrations order by id desc limit 1 0.72ms]
SQL[select count(*) as aggregate from migrations limit 1 0.8ms]
SQL[SELECT version() 1.02ms]
===================================
Version info:
Commit SHA: f8ce4df0f8c69e560a82c112d708175f9752a855
Commit Date: 1581063106
DB Schema: 2020_02_05_224042_device_inserted_null (158)
PHP: 7.2.24-0ubuntu0.18.04.2
MySQL: 10.1.44-MariaDB-0ubuntu0.18.04.1
RRDTool: 1.7.0
SNMP: NET-SNMP 5.7.3
==================================DEBUG!
Updating os_def.cache…
Done
Override discovery modules:
SQL[SELECT * FROM devices WHERE disabled = 0 AND snmp_disable = 0 AND hostname LIKE ‘192.x.x.x’ ORDER BY device_id DESC 1.49ms]
SQL[select distinct os from devices 0.66ms]
SQL[select * from devices where device_id = ? limit 1 [2] 1.03ms]
SQL[select * from devices_attribs where devices_attribs.device_id = ? and devices_attribs.device_id is not null [2] 0.39ms]
192.x.x.x.100.201 2 sonicwall SQL[select hostname, overwrite_ip from devices where hostname = ? limit 1 [“192.x.x.x”] 0.69ms]
[FPING] ‘/usr/bin/fping’ ‘-e’ ‘-q’ ‘-c’ ‘3’ ‘-p’ ‘500’ ‘-t’ ‘500’ ‘192.x.x.x’
array (
‘xmt’ => 3,
‘rcv’ => 3,
‘loss’ => 0,
‘min’ => 0.37,
‘max’ => 0.44,
‘avg’ => 0.39,
‘dup’ => 0,
‘exitcode’ => 0,
)
SQL[INSERT 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) {“xmt”:3,“rcv”:3,“loss”:0,“min”:0.37,“max”:0.44,“avg”:0.39,“device_id”:2,“debug”:“”} 2.91ms]
SQL[select hostname, overwrite_ip from devices where hostname = ? limit 1 [“192.x.x.x”] 0.85ms]
SNMP Check response code: 0
Attempting to initialize OS: sonicwall
OS initialized: LibreNMS\OS\Sonicwall
Modules status: Global+
OS
Device
Load disco module core
SQL[select hostname, overwrite_ip from devices where hostname = ? limit 1 [“192.x.x.x”] 0.86ms]
SNMP[‘/usr/bin/snmpget’ ‘-v2c’ ‘-c’ ‘COMMUNITY’ ‘-OUQn’ ‘-m’ ‘SNMPv2-MIB’ ‘-M’ ‘/opt/librenms/mibs:/opt/librenms/mibs/sonicwall’ ‘udp:HOSTNAME:161’ ‘sysName.0’ ‘sysObjectID.0’ ‘sysDescr.0’]
...0 = name
...0 = ..4.1.8741.1
..*.0 = SonicWALL NSA ** (SonicOS Enhanced )
Runtime for discovery module ‘core’: 0.0200 seconds with 1032 bytes
SNMP: [2/0.04s] MySQL: [2/0.01s] RRD: [0/0.00s]
Unload disco module core
SQL[UPDATE devices set last_discovered=NOW(),last_discovered_timetaken=? WHERE device_id = ? [1.056,2] 2.48ms]
Discovered in 1.056 seconds
SQL[INSERT IGNORE INTO perf_times (type,doing,start,duration,devices,poller) VALUES (:type,:doing,:start,:duration,:devices,:poller) {“type”:“discover”,“doing”:“192.x.x.x”,“start”:1581113067.154134,“duration”:“1.350”,“devices”:1,“poller”:“libre_nms”} 8.46ms]
./discovery.php 192.x.x.x 2020-02-07 16:04:28 - 1 devices discovered in 1.350 secs
SNMP [2/0.04s]: Get[2/0.04s] Getnext[0/0.00s] Walk[0/0.00s]
MySQL [4/0.02s]: Cell[1/0.00s] Row[-1/-0.00s] Rows[1/0.00s] Column[0/0.00s] Update[1/0.00s] Insert[2/0.01s] Delete[0/0.00s]
RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]
I am having trouble seeing any networking graphs, and adding host from the web gui doesn’t work. It does work from the cmd line.