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
./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.
what happens if you run “./lnms migrate” as user librenms ?
Im having the same issue and I am running the migrate as librenms user
I got a similar problem.
[email protected]:~# su - librenms
[email protected]:~$ ./lnms migrate
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]:~$
=================
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
@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