I need help, after getting it to show me the graphs, (because previously it gave me “/opt/librenms/rrd/ no such file” errors) but the graphs do not show me data and -nan appears below
Does anyone know what I can look at?
Although I am doing a stress test and it should be full CPU and memory
Although I am doing a stress test and it should be full CPU and memory
| Component | Version |
|---|---|
| LibreNMS | 22.2.1-11-g5ffbceb |
| DB Schema | 2022_02_03_164059_increase_auth_id_length (235) |
| PHP | 7.3.31-1~deb10u1 |
| Python | 3.7.3 |
| MySQL | 10.3.31-MariaDB-0+deb10u1 |
| RRDTool | 1.7.1 |
| SNMP | 5.7.3 |
====================================
[OK] Composer Version: 2.2.7
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct
$
Do other graphs work for this device? if so, please provide the output of ./poller.php -h HOSTNAME -d -v -m processors
./poller.php -h 4 -d -v -m processors
LibreNMS Poller
SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.52ms]
SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.66ms]
SQL[select version() [] 0.45ms]
===================================
Version info:
Commit SHA: 42c16de54c328b4b1b0225a104adb7a110bb114c
Commit Date: 1646592770
DB Schema: 2022_02_03_164059_increase_auth_id_length (235)
PHP: 7.3.31-1~deb10u1
MySQL: 10.3.31-MariaDB-0+deb10u1
RRDTool: 1.7.1
SNMP: 5.7.3
==================================DEBUG!
Updating os_def.cache
Override poller modules: processors
Starting polling run:
SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `device_id` = 4 ORDER BY `device_id` ASC [] 1.63ms]
SQL[select * from `devices` where `device_id` = ? limit 1 [4] 1.15ms]
SQL[select * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [4] 3.43ms]
Attempting to initialize OS: linux
Attempting to initialize Group OS: unix
OS initialized: LibreNMS\OS\Shared\Unix
Hostname: 192.168.2.130
Device ID: 4
OS: linux
(unix)
[FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' '192.168.2.130'
response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 0.3/0.98/1.35
SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'comunidad1' '-OQXUte' 'udp:192.168.2.130:161' 'SNMPv2-MIB::sysObjectID.0']
SNMPv2-MIB::sysObjectID.0 = NET-SNMP-MIB::netSnmpAgentOIDs.10
SQL[insert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?) [0.3,1.35,0.98,3,3,0,4,"2022-03-07 12:21:49"] 2.69ms]
SQL[update `devices` set `last_ping_timetaken` = ? where `device_id` = ? [0.98,4] 2.9ms]
RRD[update /opt/librenms/rrd/192.168.2.130/ping-perf.rrd N:0.98]
RRDtool Output: SQL[select * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` is null order by `going_down` desc limit 1 [4] 0.56ms]
Modules status: Global+
OS
Device
#### Load poller module core ####
SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'comunidad1' '-OQXUte' '-On' 'udp:192.168.2.130:161' 'SNMPv2-MIB::sysDescr.0' 'SNMPv2-MIB::sysObjectID.0' 'SNMPv2-MIB::sysUpTime.0' 'SNMPv2-MIB::sysName.0']
.1.3.6.1.2.1.1.1.0 = Linux ubuntu-20 5.8.0-63-generic #71-Ubuntu SMP Tue Jul 13 15:59:12 UTC 2021 x86_64
.1.3.6.1.2.1.1.2.0 = .1.3.6.1.4.1.8072.3.2.10
.1.3.6.1.2.1.1.3.0 = 182996350
.1.3.6.1.2.1.1.5.0 = ubuntu-20
SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'comunidad1' '-OQXUte' 'udp:192.168.2.130:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0']
SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = 1829963
HOST-RESOURCES-MIB::hrSystemUptime.0 = 182998371
Uptime seconds: 1829984
RRD[update /opt/librenms/rrd/192.168.2.130/uptime.rrd N:1829984]
RRDtool Output: OK u:0,01 s:0,00 r:1,09
Uptime: 21 days 4 hours 19 minutes 44 seconds
SQL[update `devices` set `uptime` = ? where `device_id` = ? [1829984,4] 31.74ms]
>> Runtime for poller module 'core': 0.1232 seconds with 58656 bytes
>> SNMP: [2/0.08s] MySQL: [1/0.32s] RRD: [1/0.00s]
#### Unload poller module core ####
RRD[update /opt/librenms/rrd/192.168.2.130/poller-perf-core.rrd N:0.12323307991028]
RRDtool Output: OK u:0,01 s:0,00 r:1,18
Modules status: Global+
OS
Device
#### Load poller module processors ####
Attempting to initialize OS: linux
Attempting to initialize Group OS: unix
OS initialized: LibreNMS\OS\Shared\Unix
SQL[SELECT * FROM processors WHERE device_id=? [4] 0.63ms]
>> Runtime for poller module 'processors': 0.0052 seconds with 59360 bytes
>> SNMP: [0/0.00s] MySQL: [1/0.01s] RRD: [1/0.00s]
#### Unload poller module processors ####
RRD[update /opt/librenms/rrd/192.168.2.130/poller-perf-processors.rrd N:0.0051839351654053]
RRDtool Output: OK u:0,01 s:0,00 r:1,22
RRD[update /opt/librenms/rrd/192.168.2.130/poller-perf.rrd N:1.24]
RRDtool Output: OK u:0,01 s:0,00 r:1,23
Polled in 1.24 seconds
### Start Device Groups ###
SQL[select * from `device_groups` [] 0.45ms]
SQL[select * from `device_group_device` where `device_group_device`.`device_id` = ? [4] 0.45ms]
Groups Added:
Groups Removed:
### End Device Groups, runtime: 0.0086s ###
#### Start Alerts ####
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` = ? [4] 0.59ms]
SQL[select exists(select * from `alert_schedule` where (`start` <= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time(`end`) and time(`start`) <= ? and time(`end`) > ?) or (time(`start`) > time(`end`) and (time(`end`) <= ? or time(`start`) > ?))) and (`recurring_day` like ? or `recurring_day` is null)))) and (exists (select * from `devices` inner join `alert_schedulables` on `devices`.`device_id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?))) as `exists` ["2022-03-07T11:21:49.966328Z","2022-03-07T11:21:49.966328Z",0,1,"11:21:49","11:21:49","11:21:49","11:21:49","%","device",4] 0.85ms]
SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [4] 0.89ms]
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 alert_location_map l ON a.id=l.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND l.location_id IN (SELECT DISTINCT location_id FROM devices 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))
) [4,4,4,4,4,4,4,4] 4.06ms]
Rule #1 (Device Down! Due to no ICMP response.):
SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.status_reason = "icmp" [4] 1.92ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [1,4] 0.44ms]
Status: NOCHG
Rule #2 (SNMP not responding on Device - Check on SNMP Service - Device marked Down!):
SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.status_reason = "snmp" [4] 1.53ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [2,4] 0.44ms]
Status: NOCHG
Rule #3 (Device rebooted):
SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 AND (devices.disabled = 0 && devices.ignore = 0) = 1 [4] 1.05ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [3,4] 0.67ms]
Status: NOCHG
Rule #4 (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 [4] 2.72ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [4,4] 0.4ms]
Status: NOCHG
Rule #5 (Ping Latency):
SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND devices.last_ping_timetaken > 10 [4] 1.09ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [5,4] 0.46ms]
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 [4] 2.26ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [6,4] 0.87ms]
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 [4] 1.81ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [7,4] 0.55ms]
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 [4] 1.5ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [8,4] 0.47ms]
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 [4] 1.47ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [9,4] 0.69ms]
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 [4] 1.57ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [10,4] 0.41ms]
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 [4] 1.48ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [11,4] 0.37ms]
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 [4] 2.24ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [12,4] 0.56ms]
Status: NOCHG
Rule #13 (puerto 80):
SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND devices.port = 80 [4] 1.26ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [13,4] 0.38ms]
Status: NOCHG
Rule #14 (Dell Server CPU Status Critical RRRRR):
SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 2 AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10892.1.1100.32.1.5" [4] 1.12ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [14,4] 0.34ms]
Status: NOCHG
Rule #15 (cpuu time):
SQL[SELECT * FROM devices,processes WHERE (devices.device_id = ? AND devices.device_id = processes.device_id) AND processes.cputime < 20 [4] 1ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [15,4] 0.56ms]
Status: NOCHG
Rule #16 (cpu info ):
SQL[SELECT * FROM devices,vminfo WHERE (devices.device_id = ? AND devices.device_id = vminfo.device_id) AND vminfo.vmwVmCpus < 20 [4] 0.97ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [16,4] 0.39ms]
Status: NOCHG
Rule #17 (storagee):
SQL[SELECT * FROM devices,storage WHERE (devices.device_id = ? AND devices.device_id = storage.device_id) AND storage.storage_used < 15 [4] 1.48ms]
SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [17,4] 0.47ms]
Status: NOCHG
#### End Alerts ####
./poller.php 4 2022-03-07 12:21:50 - 1 devices polled in 1.757 secs
SNMP [3/0.13s]: Snmpget[3/0.13s]
SQL [54/0.93s]: Select[51/0.56s] Insert[1/0.03s] Update[2/0.35s]
RRD [5/0.01s]: Update[5/0.01s]
Tiene correo nuevo en /var/mail/librenms
I assume this mysql query is returning zero results SELECT * FROM processors WHERE device_id=4; as it’s suggesting that you have no discovered CPUs.
What does ./discovery.php -h HOSTNAME -d -v -m processors show?
I reinstalled the librenms and it detected everything without problems so I don’t know what it would be exactly but it already works and I don’t mind taking that solution since it is a test machine
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.