====================================
Component | Version
--------- | -------
LibreNMS  | 1.35-75-ge372023
DB Schema | 228
PHP       | 7.0.18-0ubuntu0.16.04.1
MySQL     | 5.7.19-17-57-log
RRDTool   | 1.5.5
SNMP      | NET-SNMP 5.7.3
====================================

[OK]    Database connection successful
[FAIL]  You have not set sql_mode='' in your mysql config.
 [FIX] Set sql-mode='' in your mysql config file in the [mysqld] section.
[FAIL]  MySQL Database collation is wrong: utf8 utf8_general_ci
 [FIX] Check https://t.libren.ms/-zdwk for info on how to fix.
[FAIL]  Database: extra index (bill_perms/PRIMARY)
[FAIL]  Database: extra index (bill_ports/PRIMARY)
[FAIL]  Database: extra index (devices_perms/PRIMARY)
[FAIL]  Database: incorrect column (device_graphs/graph)
[FAIL]  Database: extra index (device_graphs/PRIMARY)
[FAIL]  Database: extra index (device_perf/PRIMARY)
[FAIL]  Database: extra column (ipv4_mac/id)
[FAIL]  Database: extra index (ipv4_mac/id)
[FAIL]  Database: extra index (locations/PRIMARY)
[FAIL]  Database: extra column (ospf_areas/id)
[FAIL]  Database: extra index (ospf_areas/id)
[FAIL]  Database: extra column (ospf_instances/id)
[FAIL]  Database: extra index (ospf_instances/id)
[FAIL]  Database: extra column (ospf_nbrs/id)
[FAIL]  Database: extra index (ospf_nbrs/id)
[FAIL]  Database: extra column (ospf_ports/id)
[FAIL]  Database: extra index (ospf_ports/id)
[FAIL]  Database: extra column (ports_fdb/id)
[FAIL]  Database: extra index (ports_fdb/id)
[FAIL]  Database: extra index (ports_perms/PRIMARY)
[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):
 [FIX] Run the following SQL statements to fix.
 SQL Statements:
  ALTER TABLE `bill_perms` DROP INDEX `PRIMARY`;
  ALTER TABLE `bill_ports` DROP INDEX `PRIMARY`;
  ALTER TABLE `devices_perms` DROP INDEX `PRIMARY`;
  ALTER TABLE `device_graphs` CHANGE `graph` `graph` varchar(255) NULL;
  ALTER TABLE `device_graphs` DROP INDEX `PRIMARY`;
  ALTER TABLE `device_perf` DROP INDEX `PRIMARY`;
  ALTER TABLE `ipv4_mac` DROP `id`;
  ALTER TABLE `ipv4_mac` DROP INDEX `id`;
  ALTER TABLE `locations` DROP INDEX `PRIMARY`;
  ALTER TABLE `ospf_areas` DROP `id`;
  ALTER TABLE `ospf_areas` DROP INDEX `id`;
  ALTER TABLE `ospf_instances` DROP `id`;
  ALTER TABLE `ospf_instances` DROP INDEX `id`;
  ALTER TABLE `ospf_nbrs` DROP `id`;
  ALTER TABLE `ospf_nbrs` DROP INDEX `id`;
   and 5 more...
[WARN]  Your install is over 24 hours out of date, last update: Tue, 09 Jan 2018 05:48:04 +0000
 [FIX] Make sure your daily.sh cron is running and run ./daily.sh by hand to see if there are any errors.
[WARN]  Your local git contains modified files, this could prevent automatic updates.
 [FIX] You can fix this with ./scripts/github-remove
 Modified Files:
  html/.htaccess
[FAIL]  We have found some files that are owned by a different user than librenms, this will stop you updating automatically and / or rrd files being updated causing graphs to fail.
 [FIX] chown -R librenms:librenms /opt/librenms
 Files:
  /opt/librenms/html/.htaccess
  /opt/librenms/emerson