Device group Maps and Network Maps are broken

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.
SQL Statements:
ALTER TABLE notifications CHANGE datetime datetime timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:00’ ;
ALTER TABLE users CHANGE created_at created_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
Modified Files:
includes/defaults.inc.php

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.

Any help please?

Thanks in advance!

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
Removing html/includes/print-menubar-custom.inc.php
Removing includes/defaults.inc.php.bkup
Removing includes/defaults.inc.php.custom.bkup

then:

/opt/librenms$ sudo ./daily.sh

And now its fixed!

Now time to put my custom bad if files into my config.php instead…

Always put your bad ifs into the config file.
Don’t modify the defaults.inc.php

1 Like

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.

My validate.php:

====================================
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
====================================

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

And in my config.php, the ignored interfaces:
# ignore interfaces
$config[‘bad_if_regexp’][] = '/^em./’;*
$config[‘bad_if_regexp’][] = '/^dsc./’;*
$config[‘bad_if_regexp’][] = '/^tap./’;*
$config[‘bad_if_regexp’][] = '/^gre./’;*
$config[‘bad_if_regexp’][] = '/^ipip./’;*
$config[‘bad_if_regexp’][] = '/^pime./’;*
$config[‘bad_if_regexp’][] = '/^pimd./’;*
$config[‘bad_if_regexp’][] = '/^mtun./’;*
$config[‘bad_if_regexp’][] = '/^demux./’;*
$config[‘bad_if_regexp’][] = '/^cpb./’;*
$config[‘bad_if_regexp’][] = '/^pip./’;*
$config[‘bad_if_regexp’][] = '/^pp./’;*
$config[‘bad_if_regexp’][] = '/^vme./’;*
$config[‘bad_if_regexp’][] = '/^ptp0./’;*

And I’m using xdp:
$config[‘network_map_items’] = array(‘xdp’);

Any help would be greatly appreciated!

Looks like network maps are working again without issue. Not sure why/how.

Fix was merged into the daily build. Thank you to rmedlyn

1 Like