I tried to change my update channel from release to master by updating the config.php file and the running “cd /opt/librenms && git checkout master”.
After this completed I reloaded the web page and saw the error " Whoops, looks like something went wrong. Check your librenms.log." I added “APP_DEBUG=true” to the .env file and got the following error “SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘disable_notify’ in ‘where clause’ (SQL: select exists(select * from devices where (status = 1 and ignore = 0 and disable_notify = 0 and disabled = 0) and last_polled <= 2020-03-30 13:38:06) as exists)”
At this point I’m getting the following from ‘./validate.php’ and ‘./daily.sh’
root@librenms-01:/opt/librenms# ./validate.php
| Component | Version |
|---|---|
| LibreNMS | 1.61-85-gd4aa45039 |
| DB Schema | 2020_01_09_1300_migrate_devices_attribs_table (155) |
| PHP | 7.2.24-0ubuntu0.18.04.3 |
| MySQL | 10.3.22-MariaDB-1:10.3.22+maria~bionic |
| RRDTool | 1.7.0 |
| SNMP | NET-SNMP 5.7.3 |
| ==================================== |
[OK] Composer Version: 1.10.1
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] Your database is out of date!
[FIX]:
./lnms migrate
root@librenms-01:/opt/librenms# ./daily.sh
Re-running /opt/librenms/daily.sh as librenms user
Updating SQL-Schema OK
Cleaning up DB OK
As well as the following when I run ‘./lnms migrate’
root@librenms-01:/opt/librenms# ./lnms migrate
-
Application In Production! *
Do you really wish to run this command? (yes/no) [no]:
yes
Migrating: 2019_12_28_180000_add_overwrite_ip_to_devices
In Connection.php line 664:
SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘overwrite_ip’ (SQL: alter table devices add overwrite_ip varchar(40) null after ip)
In PDOStatement.php line 119:
SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘overwrite_ip’
In PDOStatement.php line 117:
SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘overwrite_ip’
Wondering if there were any suggestions on getting my install back up and running.