Hello,
I looked at the recent posts about this issue to see if that will solve my issue, no dice.
This post is for 2 librenms servers i have -
Server 1 -
[root@catcardeye librenms]# ./validate.php
Component Version LibreNMS 1.43-70-g9aa429c DB Schema 267 PHP 7.1.21 MySQL 10.2.17-MariaDB RRDTool 1.3.8 SNMP NET-SNMP 5.5 ==================================== [OK] Composer Version: 1.7.2
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] Database: incorrect column (ports/ifInOctets_delta)
[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 TABLEports
CHANGEifInOctets_delta
ifInOctets_delta
bigint(20) unsigned NULL ;
[WARN] Your install is over 24 hours out of date, last update: Fri, 14 Sep 2018 02:10:28 +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:
.codeclimate.yml
.editorconfig
.env.example
.github/ISSUE_TEMPLATE.md
.github/ISSUE_TEMPLATE/New-Device.md
.github/PULL_REQUEST_TEMPLATE.md
.github/ci-reporter.yml
.github/lock.yml
.github/no-response.yml
.github/stale.yml
.gitignore
.mention-bot
.scrutinizer.yml
.travis.yml
AUTHORS.md
and 8109 more…
[root@catcardeye librenms]# ./scripts/github-remove
Traceback (most recent call last):
File “./scripts/github-remove”, line 3, in
from subprocess import call, check_output
ImportError: cannot import name check_output
[root@catcardeye librenms]# ./validate.php
Component Version LibreNMS 1.43-70-g9aa429c DB Schema 267 PHP 7.1.21 MySQL 10.2.17-MariaDB RRDTool 1.3.8 SNMP NET-SNMP 5.5 ==================================== [OK] Composer Version: 1.7.2
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] Database: incorrect column (ports/ifInOctets_delta)
[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 TABLEports
CHANGEifInOctets_delta
ifInOctets_delta
bigint(20) unsigned NULL ;
[WARN] Your install is over 24 hours out of date, last update: Fri, 14 Sep 2018 02:10:28 +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:
.codeclimate.yml
.editorconfig
.env.example
.github/ISSUE_TEMPLATE.md
.github/ISSUE_TEMPLATE/New-Device.md
.github/PULL_REQUEST_TEMPLATE.md
.github/ci-reporter.yml
.github/lock.yml
.github/no-response.yml
.github/stale.yml
.gitignore
.mention-bot
.scrutinizer.yml
.travis.yml
AUTHORS.md
and 8109 more…
[root@catcardeye librenms]#
Server 2 -
[root@librenms librenms]# ./validate.php
Component Version LibreNMS 1.43-119-g6242f94 DB Schema 268 PHP 7.1.21 MySQL 5.7.23 RRDTool 1.3.8 SNMP NET-SNMP 5.5 ==================================== [OK] Composer Version: 1.7.2
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct
[WARN] Your local git contains modified files, this could prevent automatic updates.
[FIX] You can fix this with ./scripts/github-remove
Modified Files:
bootstrap/cache/.gitignore
[root@librenms librenms]# ./scripts/github-remove
Traceback (most recent call last):
File “./scripts/github-remove”, line 3, in
from subprocess import call, check_output
ImportError: cannot import name check_output
[root@librenms librenms]# ./validate.php
Component Version LibreNMS 1.43-119-g6242f94 DB Schema 268 PHP 7.1.21 MySQL 5.7.23 RRDTool 1.3.8 SNMP NET-SNMP 5.5 ==================================== [OK] Composer Version: 1.7.2
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct
[WARN] Your local git contains modified files, this could prevent automatic updates.
[FIX] You can fix this with ./scripts/github-remove
Modified Files:
bootstrap/cache/.gitignore
[root@librenms librenms]#
For both servers i did run ’
git checkout storage
’
After which i had to do the following on each server -
chown -R librenms:librenms /opt/librenms
setfacl -d -m g::rwx /opt/librenms/rrd /opt/librenms/logs /opt/librenms/bootstrap/cache/ /opt/librenms/storage/
chmod -R ug=rwX /opt/librenms/rrd /opt/librenms/logs /opt/librenms/bootstrap/cache/ /opt/librenms/storage/
After which i was right back at where i started.
Ideas?
-Mike