went to log into my libre server this morning and was prompted with “something went wrong”. logged into back end to find the output of ./validate requesting i run a migrate command. i’ve been unsuccessful in running the command and getting db errors of existing tables. anyone seen this before?
librenms@librenms:~$ ./validate.php
Component
Version
LibreNMS
1.53.1
DB Schema
(0)
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
[FAIL] The poller (librenms) has not completed within the last 5 minutes, check the cron job.
[WARN] Some devices have not been polled in the last 5 minutes. You may have performance issues.
[FIX]:
Check your poll log and see: Performance - LibreNMS Docs
Devices: ep-wap2.jetsonsys.com
[FAIL] Some devices have not completed their polling run in 5 minutes, this will create gaps in data.
[FIX]:
Check your poll log and see: Performance - LibreNMS Docs
Devices: lm-router.jetsonsys.com
[FAIL] Discovery has not completed in the last 24 hours.
[FIX]:
Check the cron job to make sure it is running and using discovery-wrapper.py
librenms@librenms:~$ ./lnms migrate
Application In Production! *
Do you really wish to run this command? (yes/no) [no]:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘access_points’ already exists (SQL: create table a ccess_points (accesspoint_id int unsigned not null auto_increment primary key, device_id int unsigned not null
, name varchar(255) not null, radio_number tinyint null, type varchar(16) not null, mac_addr varchar(24) no
t null, deleted tinyint(1) not null default ‘0’, channel tinyint unsigned not null default ‘0’, txpow tinyint
not null default ‘0’, radioutil tinyint not null default ‘0’, numasoclients smallint not null default ‘0’, nu mmonclients smallint not null default ‘0’, numactbssid tinyint not null default ‘0’, nummonbssid tinyint not n
ull default ‘0’, interference tinyint unsigned not null) default character set utf8 collate ‘utf8_unicode_ci’)
In PDOStatement.php line 119:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘access_points’ already exists
In PDOStatement.php line 117:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘access_points’ already exists
librenms@librenms:~$ ./daily.sh
Updating to latest release OK
Updating Composer packages OK
Updating SQL-Schema OK
Updating submodules OK
Cleaning up DB OK
Fetching notifications OK
Caching PeeringDB data OK
i have attempted to delete the migrations table and re-run ./lnms migrate but the error persists. i have also attempted ./lnms migrate:install but get the following:
librenms@librenms:~$ ./lnms migrate:install
In Connection.php line 664:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘migrations’ already exists (SQL: create table migr ations (id int unsigned not null auto_increment primary key, migration varchar(255) not null, batch int not
null) default character set utf8 collate ‘utf8_unicode_ci’)
In PDOStatement.php line 119:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘migrations’ already exists
In PDOStatement.php line 117:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘migrations’ already exists