Hi,
I try to update my Librenms.
I had a problem.
root@uvinct648:/usr/local/share/librenms# ./build-base.php ?
– Updating database schema
262 -> 263 …SQL Error! SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP ‘access_level’; check that column/key exists (SQL: ALTER TABLE devices_perms
DROP access_level
/usr/local/share/librenms/includes/sql-schema/update.php:92
/usr/local/share/librenms/build-base.php:51
i have this error :
The script try to delete a colone don’t exist :
access_level * in the table devices_perms.
I can see this when i open my librnms :
Unhandled MySQL Error [42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘auth_type’ in ‘where clause’
root@uvinct648:/usr/local/share/librenms# ./validate.php
Component |
Version |
LibreNMS |
1.44-7-g68484d305 |
DB Schema |
262 |
PHP |
7.0.30-0+deb9u1 |
MySQL |
5.5.60-0+deb7u1-log |
RRDTool |
1.6.0 |
SNMP |
NET-SNMP 5.7.3 |
====================================
[OK] Composer Version: 1.7.2
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] Your database schema (262) is older than the latest (268).
[FIX] Manually run ./daily.sh, and check for any errors.
[FAIL] The poller (uvinct648) has not completed within the last 5 minutes, check the cron job.
[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:
sw-derva2.reseau.nantes.net
sw-manu-3850-rg.reseau.nantes.net
sw-manu-a1.reseau.nantes.net
sw-manu-a2.reseau.nantes.net
sw-manu-ab0-1.reseau.nantes.net
sw-manu-asso.reseau.nantes.net
sw-manu-bib-1.reseau.nantes.net
sw-manu-bib-2.reseau.nantes.net
sw-manu-cd0-1.reseau.nantes.net
sw-manu-cd0-2.reseau.nantes.net
sw-manu-cd1-1.reseau.nantes.net
sw-manu-cd1-2.reseau.nantes.net
sw-manu-cd1-pm-voip.reseau.nantes.net
sw-manu-cd2-1.reseau.nantes.net
sw-manu-cd2-2.reseau.nantes.net
and 690 more…
[FAIL] Discovery has not completed in the last 24 hours.
[FIX] Check the cron job to make sure it is running and using discovery-wrapper.py
[FAIL] fping could not be executed. fping must have CAP_NET_RAW capability (getcap) or suid. Selinux exlusions may be required.
(This account is currently not available.)
[FAIL] fping6 could not be executed. fping6 must have CAP_NET_RAW capability (getcap) or suid. Selinux exlusions may be required.
(This account is currently not available.)
[WARN] Your local git contains modified files, this could prevent automatic updates.
[FIX] You can fix this with ./scripts/github-remove
Modified Files:
This account is currently not available.
[FAIL] Some folders have incorrect file permissions, this may cause issues.
[FIX] sudo chown -R librenms:librenms /usr/local/share/librenms
sudo setfacl -d -m g::rwx /usr/local/share/librenms/rrd /usr/local/share/librenms/logs /usr/local/share/librenms/bootstrap/cache/ /usr/local/share/librenms/storage/
sudo chmod -R ug=rwX /usr/local/share/librenms/rrd /usr/local/share/librenms/logs /usr/local/share/librenms/bootstrap/cache/ /usr/local/share/librenms/storage/
Files:
/usr/local/share/librenms/storage/framework/views/5be6204bd43948519cf1e1e5722710d672e96c2d.php
root@uvinct648:/usr/local/share/librenms#