[root@librenms ~]# cd /opt/librenms/
[root@librenms librenms]# ./daily.sh
Re-running /opt/librenms/daily.sh as librenms user
Updating to latest codebase FAIL
error: unable to unlink old ‘includes/definitions/avaya-vsp.yaml’ (Permission de nied)
error: unable to unlink old ‘includes/definitions/ciena-sds.yaml’ (Permission de nied)
error: unable to create file tests/data/avaya-vsp_8404c.json (Permission denied)
error: unable to create file tests/snmpsim/avaya-vsp_8404c.snmprec (Permission d enied)
Updating Composer packages OK
Updating SQL-Schema OK
Updating submodules OK
Cleaning up DB OK
Fetching notifications OK
Caching PeeringDB data OK
[root@librenms librenms]# ./validate.php
Component
Version
LibreNMS
1.37-87-ge13920c
DB Schema
247
PHP
7.0.27
MySQL
5.5.56-MariaDB
RRDTool
1.4.8
SNMP
NET-SNMP 5.7.2
====================================
[OK] Composer Version: 1.6.3
[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 (https://t.libren.ms/5gscd):
[FIX] Run the following SQL statements to fix.
SQL Statements:
ALTER TABLE notifications CHANGE datetimedatetime timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:00’;
ALTER TABLE users CHANGE created_atcreated_at timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:01’;
[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:
172.16.10.95
[WARN] Your local git contains modified files, this could prevent automatic updates.
[FIX] You can fix this with ./scripts/github-remove
Modified Files:
doc/Extensions/Applications.md
[root@librenms librenms]#
[OK] Composer Version: 1.6.3
[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 (https://t.libren.ms/5gscd):
[FIX] Run the following SQL statements to fix.
SQL Statements:
ALTER TABLE notifications CHANGE datetimedatetime timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:00’;
ALTER TABLE users CHANGE created_atcreated_at timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:01’;
[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:
172.27.27.30
[WARN] Your local git contains modified files, this could prevent automatic updates.
[FIX] You can fix this with ./scripts/github-remove
Modified Files:
doc/Extensions/Applications.md
[root@librenms librenms]# ./daily.sh
Re-running /opt/librenms/daily.sh as librenms user
Updating to latest codebase FAIL
error: Your local changes to the following files would be overwritten by merge:
doc/Extensions/Applications.md
Please, commit your changes or stash them before you can merge.
error: The following untracked working tree files would be overwritten by merge:
ciena-sds_8700.snmprec
Please move or remove them before you can merge.
Aborting
Updating Composer packages OK
Updating SQL-Schema OK
Updating submodules OK
Cleaning up DB OK
Fetching notifications OK
Caching PeeringDB data OK
[root@librenms librenms]#
Thanks for the help, but my problem is I’m not making changes to the SQL database, I am also not modifying files. I can’t figure out why this keeps happening.
I downloaded a clean version of the vmware image from the librenms site, all I’ve done is added a bunch of devices to monitor, but every few days ./daily.sh fails and i have to do these fixes all over again and I don’t understand whats causing this.
I have fixed the database error and removed the modified files.
When i run a ./daily.sh and ./validate.php everything is ok. I will not make any chances for the next few days and keep watching it…
[root@librenms librenms]# ./daily.sh
Re-running /opt/librenms/daily.sh as librenms user
Updating to latest codebase OK
Updating Composer packages OK
Updating SQL-Schema OK
Updating submodules OK
Cleaning up DB OK
Fetching notifications OK
Caching PeeringDB data OK
[root@librenms librenms]# ./validate.php
I have the same problem because add some test-documents with different name, after run ./scripts/github-remove -d , i can update with ./daily.sh without errors.