My device group maps and network Maps are no longer showing devices and only the interconnects.
This is my validate.php
Component | Version
--------- | -------
LibreNMS | 1.42.01-11-gabd2c63
DB Schema | 258
PHP | 7.0.30-0ubuntu0.16.04.1
MySQL | 10.0.34-MariaDB-0ubuntu0.16.04.1
RRDTool | 1.5.5
SNMP | NET-SNMP 5.7.3
[OK] Composer Version: 1.7.0
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] Database: incorrect column (notifications/datetime)
[FAIL] Database: incorrect column (users/created_at)
[FAIL] We have detected that your database schema may be wrong, please report the following to us on IRC or the community site (Report database schema issues here - LibreNMS Community):
[FIX] Run the following SQL statements to fix.
ALTER TABLE notifications CHANGE datetimedatetime timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:00’ ;
ALTER TABLE users CHANGE created_atcreated_at timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:01’ ;
[WARN] Your local git contains modified files, this could prevent automatic updates.
[FIX] You can fix this with ./scripts/github-remove
I have previously modified the defaults.inc.php to include a bunch of bad.if and I copied it back. I’m not quite sure how to get back to the newest version of defaults.inc.php but running a diff of both files, I don’t think that’s the problem.
OK, for anyone who’s run into this again, this is what i did to fix it:
/opt/librenms/scripts$ sudo ./github-remove -d
Are you sure you want to delete all modified and untracked files? [y/N] y
/opt/librenms$ sudo ./daily.sh
And now its fixed!
Now time to put my custom bad if files into my config.php instead…
I’m currently having the exact same issue for the network map. I have other device group maps that work just fine though. This has been occurring for maybe for a week or so. The solution posted by Sy_Na does not help.
==================================== Component | Version --------- | ------- LibreNMS | 1.53.1-20-g71da38c DB Schema | 2019_05_30_225937_device_groups_rewrite (135) PHP | 7.2.16 MySQL | 5.5.60-MariaDB RRDTool | 1.4.8 SNMP | NET-SNMP 5.7.2 ====================================