./validate.php & ./daily.sh errors that cant' be cleared

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 TABLE ports CHANGE ifInOctets_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 TABLE ports CHANGE ifInOctets_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

Hello,

Any thoughts?

-Mike

Hello Mike!

There is plenty of threads created on this topic already, the most popular one of them is:

There is no solution yet.

@angryp Thanks for the reply.

I’ve followed that one with no help, plus i can not get it to upgrade/update.

ugh…

[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 TABLE ports CHANGE ifInOctets_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]#

What version of python are you running? You would need to be running something pretty old for this not to work.

Sorry for not responding right away.

I have Python 2.6.6

It appears that something is hose with the “./scripts/github-remove” as it doesn’t do anything.

-Mike

Wow, I’ve not used 2.6 in quite some time! A quick search and I get: " We intend to provide source-only security fixes for the Python 2.6 series until October 2013"

My two cents: If you wish to run Librenms, I would recommend a more up to date distribution.

I was able to install 3.4.8

I am all fixed now with the update.

-Mike