==========================================================
Component | Version |
---|---|
LibreNMS | 74c7611bcadbfbc705317d8fdc78951241fdd26b |
DB Schema | 190 |
PHP | 7.0.15-0ubuntu0.16.04.2 |
MySQL | 5.7.17-0ubuntu0.16.04.1 |
RRDTool | 1.5.5 |
SNMP | NET-SNMP 5.7.3 |
==========================================================
[WARN] Your install is out of date, last update: Mon, 15 May 2017 22:07:14 +0000
[OK] Database connection successful
[FAIL] Database: missing index (applications/unique_index)
[FAIL] Database: missing index (config/uniqueindex_configname)
[FAIL] Database: missing column (users/remember_token)
[FAIL] Database: incorrect column (users/updated_at)
[FAIL] We have detected that your database schema may be wrong, please report the following to us on IRC or the community site (https://t.libren.ms/5gscd):
ALTER TABLE applications
ADD UNIQUE unique_index
(device_id
,app_type
);
ALTER TABLE config
ADD UNIQUE uniqueindex_configname
(config_name
);
ALTER TABLE users
ADD remember_token
varchar(100) NULL AFTER realname
;
ALTER TABLE users
CHANGE updated_at
updated_at
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP;