==========================================================
| 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;