I have migrate a database from my another crashed server while migrating it I have the issue in validation which is as follows:
librenms@nms:~$ ./validate.php
| Component | Version |
|---|---|
| LibreNMS | 24.1.0-84-gfed0a7b3d (2024-02-14T18:51:41+05:45) |
| DB Schema | 2023_11_21_172239_increase_vminfo.vmwvmguestos_column_length (274) |
| PHP | 8.3.2-1+ubuntu20.04.1+deb.sury.org+1 |
| Python | 3.8.10 |
| Database | MariaDB 10.3.39-MariaDB-0ubuntu0.20.04.2 |
| RRDTool | 1.7.2 |
| SNMP | 5.8 |
| =========================================== |
[OK] Composer Version: 2.7.1
[OK] Dependencies up-to-date.
[FAIL] APP_KEY does not match key used to encrypt data. APP_KEY must be the same on all nodes.
[FIX]:
If you rotated APP_KEY, run lnms key:rotate to resolve.
[OK] Database connection successful
[FAIL] Your database is out of date!
[FIX]:
./lnms migrate
Attempt to fix this issue (y or n)?:n
[OK] SQL Server meets minimum requirements
[OK] lower_case_table_names is enabled
[OK] MySQL engine is optimal
[OK] MySQL and PHP time match
[OK] Distributed Polling setting is enabled globally
[FAIL] You have not enabled rrdcached
[FIX]:
lnms config:set rrdcached
[OK] Active pollers found
[OK] Dispatcher Service not detected
[OK] Locks are functional
[OK] Python poller wrapper is polling
[OK] Redis is unavailable
[OK] rrd_dir is writable
[OK] rrdtool version ok
as I try to fix the ./lnms migrate its giving following error:
librenms@nms:~$ ./lnms migrate
APPLICATION IN PRODUCTION.
┌ Are you sure you want to run this command? ──────────────────┐
│ Yes │
└──────────────────────────────────────────────────────────────┘
INFO Running migrations.
2023_12_08_080319_create_custom_map_table … 5ms FAIL
In Connection.php line 822:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘custom_maps’ already exists (Connection: mysql, SQL: create
table custom_maps (custom_map_id int unsigned not null auto_increment primary key, name varchar(100) not null, widt h varchar(10) not null, height varchar(10) not null, background_suffix varchar(10) null, background_version int unsi
gned not null, options longtext null, newnodeconfig longtext not null, newedgeconfig longtext not null, created_at
timestamp null, updated_at timestamp null) default character set utf8mb4 collate ‘utf8mb4_unicode_ci’)
In Connection.php line 580:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘custom_maps’ already exists
What can be done for this error?