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: http://docs.librenms.org/Support/Performance/
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: http://docs.librenms.org/Support/Performance/
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]:
yes
Migrating: 2018_07_03_091314_create_access_points_table
In Connection.php line 664:
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