Extra Table Oxidized

Help Oxidized
1

LibreNMS and Oxidezed have been running fine.
Recently (3 days ago) my auto update for LibreNMS failed.
I just ran a validate.php and am getting the following error:

[FAIL] Database: extra table (oxidized_config_devicetype)
[FAIL] Database: extra table (oxidized_config_hostname)
[FAIL] Database: extra table (oxidized_config_password)
[FAIL] Database: extra table (oxidized_config_username)
[FAIL] We have detected that your database schema may be wrong, please report the following to us on Discord (https://t.libren.ms/discord) or the community site (https://t.libren.ms/5gscd):
[FIX]:
Run the following SQL statements to fix.
SQL Statements:
DROP TABLE oxidized_config_devicetype;
DROP TABLE oxidized_config_hostname;
DROP TABLE oxidized_config_password;
DROP TABLE oxidized_config_username;
[WARN] Your install is over 24 hours out of date, last update: Fri, 12 Apr 2019 04:15:13 +0000
[FIX]:
Make sure your daily.sh cron is running and run ./daily.sh by hand to see if there are any errors.

Those tables hold my Oxidized info so I would not think that I should remove them?

2

can you post the full outputs of ./daily.sh and ./validate.php there seems to be some info missing

3

sudo -u librenms /opt/librenms/daily.sh
Updating to latest codebase FAIL
/opt/librenms/daily.sh: line 74: /bin/php: Argument list too long
M LibreNMS/Alert/Transport/Api.php
M LibreNMS/Alert/Transport/Boxcar.php
M LibreNMS/Alert/Transport/Clickatell.php
M LibreNMS/Alert/Transport/Discord.php
M LibreNMS/Alert/Transport/Hipchat.php
M LibreNMS/Alert/Transport/Mattermost.php
M LibreNMS/Alert/Transport/Nagios.php
M LibreNMS/Alert/Transport/Pagerduty.php
M LibreNMS/Alert/Transport/Playsms.php
M LibreNMS/Alert/Transport/Pushover.php
M LibreNMS/Alert/Transport/Rocket.php
M LibreNMS/Alert/Transport/Slack.php
M LibreNMS/Alert/Transport/Smseagle.php
M LibreNMS/Alert/Transport/Smsfeedback.php
M LibreNMS/Alert/Transport/Telegram.php
M LibreNMS/Plugins.php
.
.
A mibs/dell/DELL-NETWORKING-VIRTUAL-LINK-TRUNK-MIB
M tests/data/dnos.json
M tests/snmpsim/dnos.snmprec
Pull is not possible because you have unmerged files.
Please, fix them up in the work tree, and then use 'git add/rm ’
as appropriate to mark resolution, or use ‘git commit -a’.
Updating Composer packages OK
Updating SQL-Schema OK
Updating submodules OK
Cleaning up DB OK
Fetching notifications OK
Caching PeeringDB data OK

sudo -u librenms /opt/librenms/validate.php

Component Version
LibreNMS 1.50-297-g4a35b50
DB Schema 2019_02_10_220000_add_dates_to_fdb (132)
PHP 7.1.28
MySQL 5.5.60-MariaDB
RRDTool 1.6.0
SNMP NET-SNMP 5.7.2

====================================

[OK] Composer Version: 1.8.5
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] Database: extra table (oxidized_config_devicetype)
[FAIL] Database: extra table (oxidized_config_hostname)
[FAIL] Database: extra table (oxidized_config_password)
[FAIL] Database: extra table (oxidized_config_username)
[FAIL] We have detected that your database schema may be wrong, please report the following to us on Discord (https://t.libren.ms/discord) or the community site (https://t.libren.ms/5gscd):
[FIX]:
Run the following SQL statements to fix.
SQL Statements:
DROP TABLE oxidized_config_devicetype;
DROP TABLE oxidized_config_hostname;
DROP TABLE oxidized_config_password;
DROP TABLE oxidized_config_username;
[WARN] Some devices have not been polled in the last 5 minutes. You may have performance issues.
[FIX]:
Check your poll log and see: http://docs.librenms.org/Support/Performance/
Devices:
talltimberstik.rtr.13093hbedl.tlh.velocityonline.net
[WARN] Your install is over 24 hours out of date, last update: Fri, 12 Apr 2019 04:15:13 +0000
[FIX]:
Make sure your daily.sh cron is running and run ./daily.sh by hand to see if there are any errors.
[WARN] Your local git contains modified files, this could prevent automatic updates.
[FIX]:
You can fix this with ./scripts/github-remove
Modified Files:
html/pages/device/edit.inc.php
html/pages/device/edit/oxidizedcreds.inc.php
[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/packages.php

4

someone in your company has added extra tables to the database. I suggest you ask them why.

5

If your company is building credential support for oxidized in LIbreNMS, please, Please, PLEASE, send those changes upstream. It’s a sorely lacking area of librenms imo… i have ~30 groups to work around it.

6

Yes, I had an employee that was working on a better way to integrate Oxidized into LibreNMS.
However he did not finish and is no longer here. They were actually VIEWs instead of TABLEs. I removed them and after many iterations I was able to get the system back to stable. Thank you.