Ubuntu 18.04 Graphs not functioning

ERROR: can not parse an empty rpn expression

[email protected]_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
[email protected]_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]
[email protected]_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.

Is that output snipped in any way more than obscuring the IP?

No sir it is not changed

No Sir it has not