Hello,
We have auto update turned off on our prod Librenms
I tried maually updating today from 1.56 to 1.65
I did :
git pull https://github.com/librenms/librenms 1.65
./scripts/composer_wrapper.php install --no-dev
./build-base.php
However I got somme errors, same as someone else reported here : /t/lnms-migrate-fails/12335
In Connection.php line 669: SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP ‘deleted’; check that column/key exists (SQL: ALTER TABLE access_points DROP INDEX deleted, ADD INDEX access_points_deleted_index(deleted)
In PDOStatement.php line 129: SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP ‘deleted’; check that column/key exists
PDOStatement.php line 127: SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP ‘deleted’; check that column/key exists
lnms migrate did not solve the pb
So I did what was recommended by the previously mentioned bug report :
insert into migrations (migration, batch) VALUES (“2020_04_06_001048_the_great_index_rename”, 1);
./validate.php
and manually run the ~100+ SQL statements
Now LibreNMS is working but still reporting as v1.56 in GUI and by validate.php :
-bash-4.2$ git pull https://github.com/librenms/librenms 1.65
- tag 1.65 -> FETCH_HEAD
Already up-to-date.
-bash-4.2$ ./validate.php
| Component | Version |
|---|---|
| LibreNMS | 1.56-1227-g8a6de3e |
| DB Schema | 2020_06_23_00522_alter_availability_perc_column (170) |
| PHP | 7.3.20 |
| Python | 3.6.8 |
| MySQL | 5.7.30-33 |
| RRDTool | 1.4.8 |
| SNMP | NET-SNMP 5.7.2 |
====================================
[OK] Composer Version: 1.10.9
[OK] Dependencies up-to-date.
[OK] Database connection successful
-bash-4.2$ ./build-base.php
Nothing to migrate.
What can I do to fix?