./lnms migrate no column availability_perc

Help
#1

Hello All,
I have issue when fixed database out of date . When I running ./lnms migrate --pretend is failed with :

In SchemaException.php line 85:
There is no column with name 'availability_perc' on table 'availability'.

I’d appreciate any help you can provide
Thanks

#2

what says validate.php ?

#3

./validate.php

Component Version
LibreNMS 1.64.1-356-gd75cc52
DB Schema 2020_03_25_165300_add_column_to_ports (162)
PHP 7.2.17
Python 3.6.8
MySQL 5.5.60-MariaDB
RRDTool 1.4.8
SNMP NET-SNMP 5.7.2

====================================

[OK] Composer Version: 1.10.8
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] Your database is out of date!
[FIX]:
./lnms migrate

validate.php still like that.

#4

what happens if you run “./lnms migrate” as user librenms ?

#5

Im having the same issue and I am running the migrate as librenms user

#6

I got a similar problem.

[email protected]:~# su - librenms
[email protected]:~$ ./lnms migrate

  • Application In Production!     *

Do you really wish to run this command? (yes/no) [no]:

yes

Migrating: 2021_03_17_160729_service_templates_cleanup

In SchemaException.php line 86:

There is no column with name ‘type’ on table ‘service_templates’.

[email protected]:~$
[email protected]:~$
[email protected]:~$

=================

[email protected]:~$ ./validate.php

Component Version
LibreNMS 21.8.0
DB Schema 2021_02_21_203415_location_add_fixed_coordinates_flag (204)
PHP 7.3.25-1+ubuntu18.04.1+deb.sury.org+1
Python 3.6.9
MySQL 10.5.12-MariaDB-1:10.5.12+maria~bionic
RRDTool 1.7.0
SNMP NET-SNMP 5.7.3

====================================

[OK] Composer Version: 2.1.6
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] Your database is out of date!
[FIX]:
./lnms migrate
[WARN] IPv6 is disabled on your server, you will not be able to add IPv6 devices.
[WARN] Your local git contains modified files, this could prevent automatic updates.
[FIX]:
You can fix this with ./scripts/github-remove
Modified Files:
config/database.php
[FAIL] We have found some files that are owned by a different user than ‘librenms’, this will stop you updating automatically and / or rrd files being updated causing graphs to fail.
[FIX]:
sudo chown -R librenms:librenms /opt/librenms
sudo setfacl -d -m g::rwx /opt/librenms/rrd /opt/librenms/logs /opt/librenms/bootstrap/cache/ /opt/librenms/storage/
sudo chmod -R ug=rwX /opt/librenms/rrd /opt/librenms/logs /opt/librenms/bootstrap/cache/ /opt/librenms/storage/
Files:
/opt/librenms/.mysql_history

#7

@SourceDoctor , @lucasv92 , @Jellyfrog , @murrant

Please let me know if you have come across a fix for this problem. This looks like the last leg to bring my monitoring instance online.

Thanks,
Santosh Kotla