Migrated from UBUNTU to CentOS causing issues

Help
1

hello, I have recently shifted the server from UBUNTU to centos and there are issues likes graphs are not getting generated. On validation I get the following message:

====================================
Component | Version
--------- | -------
LibreNMS  | 1.54
DB Schema | 2019_02_10_220000_add_dates_to_fdb (132)
PHP       | 7.2.19
MySQL     | 5.5.60-MariaDB
RRDTool   | 1.4.8
SNMP      | NET-SNMP 5.7.2
====================================

[OK]    Composer Version: 1.8.6
[OK]    Dependencies up-to-date.
[OK]    Database connection successful
[FAIL]  Your database is out of date!
        [FIX]:
        ./lnms migrate
[FAIL]  The poller (librenms) has not completed within the last 5 minutes, check the cron job.

when I try to do ./lnms migrate I get this error:
**************************************
* Application In Production! *
**************************************

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

Migrating: 2019_05_12_202407_create_mpls_lsps_table

In Connection.php line 664:

  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'mpls_lsps' already exists (SQL: create table `mpls_lsps
  ` (`lsp_id` int unsigned not null auto_increment primary key, `vrf_oid` int unsigned not null, `lsp_oid` int unsigned n
  ot null, `device_id` int unsigned not null, `mplsLspRowStatus` enum('active', 'notInService', 'notReady', 'createAndGo'
  , 'createAndWait', 'destroy') not null, `mplsLspLastChange` bigint null, `mplsLspName` varchar(64) not null, `mplsLspAd
  minState` enum('noop', 'inService', 'outOfService') not null, `mplsLspOperState` enum('unknown', 'inService', 'outOfSer
  vice', 'transition') not null, `mplsLspFromAddr` varchar(32) not null, `mplsLspToAddr` varchar(32) not null, `mplsLspTy
  pe` enum('unknown', 'dynamic', 'static', 'bypassOnly', 'p2mpLsp', 'p2mpAuto', 'mplsTp', 'meshP2p', 'oneHopP2p', 'srTe',
   'meshP2pSrTe', 'oneHopP2pSrTe') not null, `mplsLspFastReroute` enum('true', 'false') not null, `mplsLspAge` bigint nul
  l, `mplsLspTimeUp` bigint null, `mplsLspTimeDown` bigint null, `mplsLspPrimaryTimeUp` bigint null, `mplsLspTransitions`
   int unsigned null, `mplsLspLastTransition` bigint null, `mplsLspConfiguredPaths` int unsigned null, `mplsLspStandbyPat
  hs` int unsigned null, `mplsLspOperationalPaths` int unsigned null) default character set utf8 collate 'utf8_unicode_ci
  ')


In PDOStatement.php line 119:

  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'mpls_lsps' already exists


In PDOStatement.php line 117:

  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'mpls_lsps' already exists
2

You have completed (or partially completed) this migration, but it isn’t marked as done. Either add it to the migrations table manually, or drop the tables it creates so it can run.

3

hello Murrant,

Thanks for your reply.
I tried to do ./lnms migrate but that did not help can you exactly let me know what I may be doing wrong on incomplete as I am just following the guide on docs.librenms
https://docs.librenms.org/Support/FAQ/#how-do-i-move-my-librenms-install-to-another-server

4

Ok so I have resolved everything other than a migration issue:
./validate.php
====================================
Component | Version
--------- | -------
LibreNMS | 1.54-2-g89fae9be1
DB Schema | 2019_02_10_220000_add_dates_to_fdb (132)
PHP | 7.2.19-0ubuntu0.18.04.1
MySQL | 10.1.40-MariaDB-0ubuntu0.18.04.1
RRDTool | 1.7.0
SNMP | NET-SNMP 5.7.3
====================================

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

on ./lnms migrate I am still getting this error:

$ ./lnms migrate
**************************************
*     Application In Production!     *
**************************************

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

Migrating: 2019_05_12_202407_create_mpls_lsps_table

In Connection.php line 664:

  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'mpls_lsps' already exists (SQL: create table `mpls_lsps` (`lsp_id` int unsigned not null auto_increment primary key, `vrf_oid` int unsigned not null, `lsp_oid` int un
  signed not null, `device_id` int unsigned not null, `mplsLspRowStatus` enum('active', 'notInService', 'notReady', 'createAndGo', 'createAndWait', 'destroy') not null, `mplsLspLastChange` bigint null, `mplsLspName` varchar(64) not
  null, `mplsLspAdminState` enum('noop', 'inService', 'outOfService') not null, `mplsLspOperState` enum('unknown', 'inService', 'outOfService', 'transition') not null, `mplsLspFromAddr` varchar(32) not null, `mplsLspToAddr` varchar(
  32) not null, `mplsLspType` enum('unknown', 'dynamic', 'static', 'bypassOnly', 'p2mpLsp', 'p2mpAuto', 'mplsTp', 'meshP2p', 'oneHopP2p', 'srTe', 'meshP2pSrTe', 'oneHopP2pSrTe') not null, `mplsLspFastReroute` enum('true', 'false') n
  ot null, `mplsLspAge` bigint null, `mplsLspTimeUp` bigint null, `mplsLspTimeDown` bigint null, `mplsLspPrimaryTimeUp` bigint null, `mplsLspTransitions` int unsigned null, `mplsLspLastTransition` bigint null, `mplsLspConfiguredPath
  s` int unsigned null, `mplsLspStandbyPaths` int unsigned null, `mplsLspOperationalPaths` int unsigned null) default character set utf8 collate 'utf8_unicode_ci')


In PDOStatement.php line 119:

  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'mpls_lsps' already exists


In PDOStatement.php line 117:

  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'mpls_lsps' already exists

What am I missing?

5

Drop the tables it creates so the migration can run.