./lnms migrate

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?

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.