Hey all,
So, first of all, it seems like the first time every day that I run “validate.php”, I get this:
[root@librenms librenms]# ./validate.php
| Component |
Version |
| LibreNMS |
1.59 |
| DB Schema |
2020_01_09_1300_migrate_devices_attribs_table (154) |
| PHP |
7.2.24 |
| MySQL |
5.5.64-MariaDB |
| RRDTool |
1.4.8 |
| SNMP |
NET-SNMP 5.7.2 |
====================================
[OK] Composer Version: 1.9.2
[OK] Dependencies up-to-date.
[OK] Database connection successful
[WARN] Your database schema has extra migrations (2019_12_17_151314_add_invert_map_to_alert_rules, 2020_01_09_1300_migrate_devices_attribs_table). If you just switched to the stable release from the daily release, your database is in between releases and this will be resolved with the next release.
[OK] Database schema correct
[FAIL] Some folders have incorrect file permissions, this may cause issues.
[FIX]:
sudo chown -R librenms:librenms /opt/librenms
sudo setfacl -d -m g::rwx /opt/librenms/rrd /opt/librenms/logs /opt/librenms/bootstrap/cache/ /opt/librenms/storage/
sudo chmod -R ug=rwX /opt/librenms/rrd /opt/librenms/logs /opt/librenms/bootstrap/cache/ /opt/librenms/storage/
Files:
/opt/librenms/bootstrap/cache/services.php
So, I run the commands to fix the file permissions. But that doesn’t seem to help my problem.
I currently have two Juniper MX-480 and a Juniper EX-4600 stack added to the Devices list, as a test. Here’s what I have observed:
-
When I browse to the Ports tab on any of the devices, the list is empty under the Basic, Details, and the default Graphs. However, the mini versions of the graphs populate, though there is absolutely no data in any of them.
-
If I select the Graphs - Bits - Mini link, all of the interface graphs start populating. They are all red, and none show any traffic.
-
If I click on one of the interface graphs, there are no graphs displayed. The three stacked mini graphs in the “header” are all red, and if I hover over them, the displayed graphs show “Error drawing graph”.
-
Real time graphing works! However, the bandwidth usage displayed at timelines under 5s is way off, but 5s and up seem to be pretty accurate.
Any ideas on where to start with this?
TIA,
Alex
OK, now something is really messed up. Can’t log in, gives an error. Here’s the output of validate.php:
====================================
| Component |
Version |
| LibreNMS |
1.60 |
| DB Schema |
2019_12_28_180000_add_overwrite_ip_to_devices (156) |
| PHP |
7.2.24 |
| MySQL |
5.5.64-MariaDB |
| RRDTool |
1.4.8 |
| SNMP |
NET-SNMP 5.7.2 |
| ==================================== |
|
[OK] Composer Version: 1.9.3
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] Database: missing column (alert_rules/invert_map)
[FAIL] Database: missing column (devices/disable_notify)
[FAIL] We have detected that your database schema may be wrong, please report the following to us on Discord (LibreNMS) or the community site (Report database schema issues here - LibreNMS Community):
[FIX]:
Run the following SQL statements to fix.
SQL Statements:
ALTER TABLE alert_rules ADD invert_map tinyint(1) NOT NULL DEFAULT ‘0’ AFTER proc;
ALTER TABLE devices ADD disable_notify tinyint(1) NOT NULL DEFAULT ‘0’ AFTER max_depth;
[FAIL] Some folders have incorrect file permissions, this may cause issues.
[FIX]:
sudo chown -R librenms:librenms /opt/librenms
sudo setfacl -d -m g::rwx /opt/librenms/rrd /opt/librenms/logs /opt/librenms/bootstrap/cache/ /opt/librenms/storage/
sudo chmod -R ug=rwX /opt/librenms/rrd /opt/librenms/logs /opt/librenms/bootstrap/cache/ /opt/librenms/storage/
Files:
/opt/librenms/bootstrap/cache/services.php
I have applied the SQL statements, and rerun the permissions fixes (AGAIN!!!). New validate.php output:
====================================
| Component |
Version |
| LibreNMS |
1.60 |
| DB Schema |
2019_12_28_180000_add_overwrite_ip_to_devices (156) |
| PHP |
7.2.24 |
| MySQL |
5.5.64-MariaDB |
| RRDTool |
1.4.8 |
| SNMP |
NET-SNMP 5.7.2 |
| ==================================== |
|
[OK] Composer Version: 1.9.3
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct
Still all red graphs. But at least now I can log in and use the interface.
Well, I should clarify that statement: the graphs for the INTERFACES are red and empty. However, the graphs for the processor, memory, environmental, power, even the transceivers, are all good and working.
Anyone?
Nothing, after 21 days… No ideas from anyone?
Might have to abandon this. I hate to, because I really like the interface and see the advantages. But if the graphing refuses to work, and no one can offer any advice or help, I guess I don’t really have any choice.