branto-librenms

[librenms@netmaster02 ~]$ ./validate.php
==========================================================
Component | Version
--------- | -------
LibreNMS  | e7e5d51b3041b49f0e0af5a1a58b5ef6f0a94d50
DB Schema | 187
PHP       | 7.1.4
MySQL     | 5.5.52-MariaDB
RRDTool   | 1.4.8
SNMP      | NET-SNMP 5.7.2
==========================================================

[OK]    Database connection successful
[FAIL]  MySQL column collation is wrong:  [FIX] https://t.libren.ms/-zdwk
     api_tokens description latin1 latin1_swedish_ci
[FAIL]  Database: missing index (config/uniqueindex_configname)
[FAIL]  Database: missing index (dbSchema/PRIMARY)
[FAIL]  Database: incorrect index (ospf_areas/device_area)
[FAIL]  Database: incorrect index (ospf_instances/device_id)
[FAIL]  Database: incorrect index (ospf_nbrs/device_id)
[FAIL]  Database: incorrect index (ospf_ports/device_id)
[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 `config` ADD UNIQUE `uniqueindex_configname` (`config_name`);
     ALTER TABLE `dbSchema` ADD PRIMARY KEY (`version`);
     ALTER TABLE `ospf_areas` DROP INDEX `device_area`, UNIQUE `device_area` (`device_id`,`ospfAreaId`,`context_name`);
     ALTER TABLE `ospf_instances` DROP INDEX `device_id`, UNIQUE `device_id` (`device_id`,`ospf_instance_id`,`context_name`);
     ALTER TABLE `ospf_nbrs` DROP INDEX `device_id`, UNIQUE `device_id` (`device_id`,`ospf_nbr_id`,`context_name`);
     ALTER TABLE `ospf_ports` DROP INDEX `device_id`, UNIQUE `device_id` (`device_id`,`ospf_port_id`,`context_name`);
[FAIL]  The poller has not run in the last 5 minutes, check the cron job

[WARN]  Your local git contains modified files, this could prevent automatic updates.
Modified files:
     html/install.php
[librenms@netmaster02 ~]$ mysql -p -u librenms librenms < /opt/librenms/sql-schema/171.sql
Enter password:
ERROR 1054 (42S22) at line 149: Unknown column 'twofactor' in 'users'
[librenms@netmaster02 ~]$]