Alerts Widget Blank

Help
,
1

My Alerts Widget is always blank, no alerts appear at all no matter how old. Any ideas?
(Running on Ubuntu 16.04.5)
.

librenms@librenms:~$ ./validate.php
====================================
Component | Version
--------- | -------
LibreNMS  | 1.48.1-10-g49f206f
DB Schema | 2019_01_16_195644_add_vrf_id_and_bgpLocalAs (131)
PHP       | 7.0.32-0ubuntu0.16.04.1
MySQL     | 10.0.36-MariaDB-0ubuntu0.16.04.1
RRDTool   | 1.5.5
SNMP      | NET-SNMP 5.7.3
====================================

[OK]    Composer Version: 1.8.3
[OK]    Dependencies up-to-date.
[OK]    Database connection successful
[OK]    Database schema correct
2

Hello,

Sounds like a permissions issue maybe? What auth method are you using?

3

Nothing tricky, just the default.

4

Gun_Runner

Need more info. I haven’t seen this issue.

5

Please let me know what info you need to see…

And I will look at permissions. Which file should I check out first? And what permissions should it be?

6

Ok, after a reboot It seems that alerts are appearing on the widget, but then disappearing after a certain amount of time. I am not clicking “Acknowledge”.

Is this the expected behavior? If so, is it possible to set it to have the alerts stay on the widget and not auto removing?

7

Check the eventlog in the web ui to see why they are clearing.
They will clear if the alert clears.

8

Ah, well in the case of this last alert it was a “High CPU Usage” alert, so yes it cleared. Souinds like this is expected then…

1 Like
9

Yes that is expected

10

Do you have any errors in logs/librenms.log?

It should not be “blank”, but an empty table.

11

That log file is about 1.2GB FYI, not sure if thats normal…

Here are the las few lines:

/opt/librenms/includes/snmp.inc.php:973
/opt/librenms/includes/snmp.inc.php:1208
/opt/librenms/includes/snmp.inc.php:1271
/opt/librenms/includes/polling/mib.inc.php:15
/opt/librenms/includes/polling/functions.inc.php:303
/opt/librenms/poller.php:157    
/opt/librenms/poller.php 23 2019-02-06 09:30:11 - 1 devices polled in 1.911 secs
/opt/librenms/poller.php 24 2019-02-06 09:30:11 - 1 devices polled in 2.361 secs
/opt/librenms/poller.php 6 2019-02-06 09:30:13 - 1 devices polled in 2.242 secs
/opt/librenms/poller.php 5 2019-02-06 09:30:14 - 1 devices polled in 12.56 secs
/opt/librenms/poller.php 20 2019-02-06 09:30:15 - 1 devices polled in 1.639 secs
/opt/librenms/poller.php 11 2019-02-06 09:30:16 - 1 devices polled in 15.01 secs
/opt/librenms/poller.php 21 2019-02-06 09:30:55 - 1 devices polled in 44.45 secs
/opt/librenms/discovery.php new 2019-02-06 09:35:01 - 0 devices discovered in 0.010 secs
/opt/librenms/poller.php 21 2019-02-06 09:35:04 - 1 devices polled in 2.842 secs
/opt/librenms/poller.php 17 2019-02-06 09:35:08 - 1 devices polled in 6.642 secs
/opt/librenms/poller.php 25 2019-02-06 09:35:09 - 1 devices polled in 4.634 secs
/opt/librenms/poller.php 10 2019-02-06 09:35:11 - 1 devices polled in 2.671 secs
/opt/librenms/poller.php 9 2019-02-06 09:35:12 - 1 devices polled in 2.839 secs
/opt/librenms/poller.php 24 2019-02-06 09:35:13 - 1 devices polled in 1.775 secs
/opt/librenms/poller.php 5 2019-02-06 09:35:14 - 1 devices polled in 12.73 secs
/opt/librenms/poller.php 6 2019-02-06 09:35:14 - 1 devices polled in 2.401 secs
[2019-02-06 09:35:15] production.ERROR: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'module' cannot be null (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.0,,,upsAdvanceIdentLCDFirmwareVersion,NULL,0) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsAdvanceIdentLCDFirmwareVersion,`value`=NULL,`numvalue`=0) (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.0,,,upsAdvanceIdentLCDFirmwareVersion,NULL,0) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsAdvanceIdentLCDFirmwareVersion,`value`=NULL,`numvalue`=0)
/opt/librenms/includes/snmp.inc.php:973
/opt/librenms/includes/snmp.inc.php:1208
/opt/librenms/includes/snmp.inc.php:1271
/opt/librenms/includes/polling/mib.inc.php:15
/opt/librenms/includes/polling/functions.inc.php:303
/opt/librenms/poller.php:157    
    [2019-02-06 09:35:15] production.ERROR: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'module' cannot be null (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.0,,,upsAdvanceIdentPowerRating,1500,1500) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsAdvanceIdentPowerRating,`value`=1500,`numvalue`=1500) (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.0,,,upsAdvanceIdentPowerRating,1500,1500) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsAdvanceIdentPowerRating,`value`=1500,`numvalue`=1500)
/opt/librenms/includes/snmp.inc.php:973
/opt/librenms/includes/snmp.inc.php:1208
/opt/librenms/includes/snmp.inc.php:1271
/opt/librenms/includes/polling/mib.inc.php:15
/opt/librenms/includes/polling/functions.inc.php:303
/opt/librenms/poller.php:157    
[2019-02-06 09:35:15] production.ERROR: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'module' cannot be null (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.0,,,upsAdvanceIdentLoadPower,900,900) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsAdvanceIdentLoadPower,`value`=900,`numvalue`=900) (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.0,,,upsAdvanceIdentLoadPower,900,900) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsAdvanceIdentLoadPower,`value`=900,`numvalue`=900)
/opt/librenms/includes/snmp.inc.php:973
/opt/librenms/includes/snmp.inc.php:1208
/opt/librenms/includes/snmp.inc.php:1271
/opt/librenms/includes/polling/mib.inc.php:15
/opt/librenms/includes/polling/functions.inc.php:303
/opt/librenms/poller.php:157    
[2019-02-06 09:35:15] production.ERROR: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'module' cannot be null (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.0,,,upsAdvanceIdentCurrentRating,NULL,0) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsAdvanceIdentCurrentRating,`value`=NULL,`numvalue`=0) (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.0,,,upsAdvanceIdentCurrentRating,NULL,0) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsAdvanceIdentCurrentRating,`value`=NULL,`numvalue`=0)
/opt/librenms/includes/snmp.inc.php:973
/opt/librenms/includes/snmp.inc.php:1208
/opt/librenms/includes/snmp.inc.php:1271
/opt/librenms/includes/polling/mib.inc.php:15
/opt/librenms/includes/polling/functions.inc.php:303
/opt/librenms/poller.php:157    
[2019-02-06 09:35:15] production.ERROR: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'module' cannot be null (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.0,,,upsAdvanceBatteryVoltageRating,24,24) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsAdvanceBatteryVoltageRating,`value`=24,`numvalue`=24) (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.0,,,upsAdvanceBatteryVoltageRating,24,24) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsAdvanceBatteryVoltageRating,`value`=24,`numvalue`=24)
/opt/librenms/includes/snmp.inc.php:973
/opt/librenms/includes/snmp.inc.php:1208
/opt/librenms/includes/snmp.inc.php:1271
/opt/librenms/includes/polling/mib.inc.php:15
/opt/librenms/includes/polling/functions.inc.php:303
/opt/librenms/poller.php:157    
[2019-02-06 09:35:15] production.ERROR: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'module' cannot be null (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.0,,,upsAdvanceInputStatus,normal,0) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsAdvanceInputStatus,`value`=normal,`numvalue`=0) (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.0,,,upsAdvanceInputStatus,normal,0) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsAdvanceInputStatus,`value`=normal,`numvalue`=0)
/opt/librenms/includes/snmp.inc.php:973
/opt/librenms/includes/snmp.inc.php:1208
/opt/librenms/includes/snmp.inc.php:1271
/opt/librenms/includes/polling/mib.inc.php:15
/opt/librenms/includes/polling/functions.inc.php:303
/opt/librenms/poller.php:157    
[2019-02-06 09:35:15] production.ERROR: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'module' cannot be null (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.0,,,upsBaseOutputWorkingFrequency,57~63 Hz,0) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsBaseOutputWorkingFrequency,`value`=57~63 Hz,`numvalue`=0) (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.0,,,upsBaseOutputWorkingFrequency,57~63 Hz,0) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsBaseOutputWorkingFrequency,`value`=57~63 Hz,`numvalue`=0)
/opt/librenms/includes/snmp.inc.php:973
/opt/librenms/includes/snmp.inc.php:1208
/opt/librenms/includes/snmp.inc.php:1271
/opt/librenms/includes/polling/mib.inc.php:15
/opt/librenms/includes/polling/functions.inc.php:303
/opt/librenms/poller.php:157    
[2019-02-06 09:35:15] production.ERROR: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'module' cannot be null (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.0,,,upsAdvanceConfigAutoRestore,NULL,0) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsAdvanceConfigAutoRestore,`value`=NULL,`numvalue`=0) (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.0,,,upsAdvanceConfigAutoRestore,NULL,0) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsAdvanceConfigAutoRestore,`value`=NULL,`numvalue`=0)
/opt/librenms/includes/snmp.inc.php:973
/opt/librenms/includes/snmp.inc.php:1208
/opt/librenms/includes/snmp.inc.php:1271
/opt/librenms/includes/polling/mib.inc.php:15
/opt/librenms/includes/polling/functions.inc.php:303
/opt/librenms/poller.php:157    
[2019-02-06 09:35:15] production.ERROR: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'module' cannot be null (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.0,,,upsAdvanceConfigRechargedCapacity,NULL,0) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsAdvanceConfigRechargedCapacity,`value`=NULL,`numvalue`=0) (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.0,,,upsAdvanceConfigRechargedCapacity,NULL,0) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsAdvanceConfigRechargedCapacity,`value`=NULL,`numvalue`=0)
/opt/librenms/includes/snmp.inc.php:973
/opt/librenms/includes/snmp.inc.php:1208
/opt/librenms/includes/snmp.inc.php:1271
/opt/librenms/includes/polling/mib.inc.php:15
/opt/librenms/includes/polling/functions.inc.php:303
/opt/librenms/poller.php:157    
[2019-02-06 09:35:15] production.ERROR: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'module' cannot be null (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.0,,,upsAdvanceConfigColdStart,NULL,0) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsAdvanceConfigColdStart,`value`=NULL,`numvalue`=0) (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.0,,,upsAdvanceConfigColdStart,NULL,0) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsAdvanceConfigColdStart,`value`=NULL,`numvalue`=0)
/opt/librenms/includes/snmp.inc.php:973
/opt/librenms/includes/snmp.inc.php:1208
/opt/librenms/includes/snmp.inc.php:1271
/opt/librenms/includes/polling/mib.inc.php:15
/opt/librenms/includes/polling/functions.inc.php:303
/opt/librenms/poller.php:157    
[2019-02-06 09:35:15] production.ERROR: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'module' cannot be null (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.0,,,upsAdvanceConfigDeepDischargeProtection,0,0) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsAdvanceConfigDeepDischargeProtection,`value`=0,`numvalue`=0) (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.0,,,upsAdvanceConfigDeepDischargeProtection,0,0) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsAdvanceConfigDeepDischargeProtection,`value`=0,`numvalue`=0)
/opt/librenms/includes/snmp.inc.php:973
/opt/librenms/includes/snmp.inc.php:1208
/opt/librenms/includes/snmp.inc.php:1271
/opt/librenms/includes/polling/mib.inc.php:15
/opt/librenms/includes/polling/functions.inc.php:303
/opt/librenms/poller.php:157    
[2019-02-06 09:35:15] production.ERROR: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'module' cannot be null (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.0,,,upsAdvanceConfigSleepAfterAllClientShut,disable,0) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsAdvanceConfigSleepAfterAllClientShut,`value`=disable,`numvalue`=0) (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.0,,,upsAdvanceConfigSleepAfterAllClientShut,disable,0) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsAdvanceConfigSleepAfterAllClientShut,`value`=disable,`numvalue`=0)
/opt/librenms/includes/snmp.inc.php:973
/opt/librenms/includes/snmp.inc.php:1208
/opt/librenms/includes/snmp.inc.php:1271
/opt/librenms/includes/polling/mib.inc.php:15
/opt/librenms/includes/polling/functions.inc.php:303
/opt/librenms/poller.php:157    
[2019-02-06 09:35:15] production.ERROR: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'module' cannot be null (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.9.0,,,upsAdvanceIdent,000000000000,0) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsAdvanceIdent,`value`=000000000000,`numvalue`=0) (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.9.0,,,upsAdvanceIdent,000000000000,0) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsAdvanceIdent,`value`=000000000000,`numvalue`=0)
/opt/librenms/includes/snmp.inc.php:973
/opt/librenms/includes/snmp.inc.php:1208
/opt/librenms/includes/snmp.inc.php:1271
/opt/librenms/includes/polling/mib.inc.php:15
/opt/librenms/includes/polling/functions.inc.php:303
/opt/librenms/poller.php:157    
[2019-02-06 09:35:15] production.ERROR: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'module' cannot be null (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.4.0,,,upsBaseBattery,0,0) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsBaseBattery,`value`=0,`numvalue`=0) (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.4.0,,,upsBaseBattery,0,0) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsBaseBattery,`value`=0,`numvalue`=0)
/opt/librenms/includes/snmp.inc.php:973
/opt/librenms/includes/snmp.inc.php:1208
/opt/librenms/includes/snmp.inc.php:1271
/opt/librenms/includes/polling/mib.inc.php:15
/opt/librenms/includes/polling/functions.inc.php:303
/opt/librenms/poller.php:157    
[2019-02-06 09:35:15] production.ERROR: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'module' cannot be null (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.5.0,,,upsAdvanceOutput,0,0) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsAdvanceOutput,`value`=0,`numvalue`=0) (SQL: INSERT INTO `device_oids` (`device_id`,`oid`,`module`,`mib`,`object_type`,`value`,`numvalue`) VALUES (23,.5.0,,,upsAdvanceOutput,0,0) ON DUPLICATE KEY UPDATE `module`=,`mib`=,`object_type`=upsAdvanceOutput,`value`=0,`numvalue`=0)
/opt/librenms/includes/snmp.inc.php:973
/opt/librenms/includes/snmp.inc.php:1208
/opt/librenms/includes/snmp.inc.php:1271
/opt/librenms/includes/polling/mib.inc.php:15
/opt/librenms/includes/polling/functions.inc.php:303
/opt/librenms/poller.php:157    
/opt/librenms/poller.php 23 2019-02-06 09:35:15 - 1 devices polled in 2.045 secs
/opt/librenms/poller.php 20 2019-02-06 09:35:16 - 1 devices polled in 1.761 secs
/opt/librenms/poller.php 22 2019-02-06 09:35:17 - 1 devices polled in 2.249 secs
/opt/librenms/poller.php 11 2019-02-06 09:35:17 - 1 devices polled in 15.30 secs
12

Did you set up log rotate as described in the install docs?

Looks like you’ve enable the unsupported mib polling and tried to set it up.

13

Well this is the VM downloaded from the Librenms site, from a year or so ago. Guess I figured it was already done since it doesn’t mention it on the VMs install page.

MIB Polling is not enabled globally (in the config file) but it was turned on in a couple of the devices modules sections. They are all turned off now.