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