Hello,
my librenms stopped working due to db issues, i managed to run on all the solution on the fourms and even deleted the mariadb and reinstalled it, rebooted the server and still the same stop on the validation php is happening. not sure how to resolve this and any help is highly appreciated
bash-4.2$ ./daily.sh
Fetching new release information OK
Between releases, waiting for newer release
Updating Composer packages OK
Updated from unset to OK
Updating SQL-Schema OK
Updating submodules OK
Cleaning up DB OK
Fetching notifications OK
Caching PeeringDB data OK
Caching Mac OUI data OK
bash-4.2$ ./validate.php
| Component | Version |
|---|---|
| LibreNMS | 21.6.0-4-gb111ab6 |
| DB Schema | 2021_03_26_014054_change_cache_to_mediumtext (207) |
| PHP | 7.4.16 |
| Python | 3.6.8 |
| MySQL | 10.5.10-MariaDB |
| RRDTool | 1.4.8 |
| SNMP | NET-SNMP 5.7.2 |
| ==================================== |
[OK] Composer Version: 2.1.3
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] Your database is out of date!
[FIX]:
./lnms migrate
bash-4.2$ ./lnms migrate
-
Application In Production! *
Do you really wish to run this command? (yes/no) [no]:
yes
Migrating: 2021_04_08_151101_add_foreign_keys_to_port_group_port_table
In Connection.php line 678:
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘librenms.port_group_port’ doesn’t exist (SQL: alter table port_group_port add constraint port_group_port_port_group_id_foreign foreign key (p ort_group_id) references port_groups (id) on delete CASCADE)
In Exception.php line 18:
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘librenms.port_group_port’ doesn’t exist
In PDOStatement.php line 112:
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘librenms.port_group_port’ doesn’t exist
bash-4.2$