1. ====================================
2. Component | Version
3. --------- | -------
4. LibreNMS  | 1.35-75-ge372023
5. DB Schema | 228
6. PHP       | 7.0.18-0ubuntu0.16.04.1
7. MySQL     | 5.7.19-17-57-log
8. RRDTool   | 1.5.5
9. SNMP      | NET-SNMP 5.7.3
10. ====================================
11.  
12. [OK]    Database connection successful
13. [FAIL]  You have not set sql_mode='' in your mysql config.
14.  [FIX] Set sql-mode='' in your mysql config file in the [mysqld] section.
15. [FAIL]  MySQL Database collation is wrong: utf8 utf8_general_ci
16.  [FIX] Check https://t.libren.ms/-zdwk for info on how to fix.
17. [FAIL]  Database: extra index (bill_perms/PRIMARY)
18. [FAIL]  Database: extra index (bill_ports/PRIMARY)
19. [FAIL]  Database: extra index (devices_perms/PRIMARY)
20. [FAIL]  Database: incorrect column (device_graphs/graph)
21. [FAIL]  Database: extra index (device_graphs/PRIMARY)
22. [FAIL]  Database: extra index (device_perf/PRIMARY)
23. [FAIL]  Database: extra column (ipv4_mac/id)
24. [FAIL]  Database: extra index (ipv4_mac/id)
25. [FAIL]  Database: extra index (locations/PRIMARY)
26. [FAIL]  Database: extra column (ospf_areas/id)
27. [FAIL]  Database: extra index (ospf_areas/id)
28. [FAIL]  Database: extra column (ospf_instances/id)
29. [FAIL]  Database: extra index (ospf_instances/id)
30. [FAIL]  Database: extra column (ospf_nbrs/id)
31. [FAIL]  Database: extra index (ospf_nbrs/id)
32. [FAIL]  Database: extra column (ospf_ports/id)
33. [FAIL]  Database: extra index (ospf_ports/id)
34. [FAIL]  Database: extra column (ports_fdb/id)
35. [FAIL]  Database: extra index (ports_fdb/id)
36. [FAIL]  Database: extra index (ports_perms/PRIMARY)
37. [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):
38.  [FIX] Run the following SQL statements to fix.
39.  SQL Statements:
40.   ALTER TABLE `bill_perms` DROP INDEX `PRIMARY`;
41.   ALTER TABLE `bill_ports` DROP INDEX `PRIMARY`;
42.   ALTER TABLE `devices_perms` DROP INDEX `PRIMARY`;
43.   ALTER TABLE `device_graphs` CHANGE `graph` `graph` varchar(255) NULL;
44.   ALTER TABLE `device_graphs` DROP INDEX `PRIMARY`;
45.   ALTER TABLE `device_perf` DROP INDEX `PRIMARY`;
46.   ALTER TABLE `ipv4_mac` DROP `id`;
47.   ALTER TABLE `ipv4_mac` DROP INDEX `id`;
48.   ALTER TABLE `locations` DROP INDEX `PRIMARY`;
49.   ALTER TABLE `ospf_areas` DROP `id`;
50.   ALTER TABLE `ospf_areas` DROP INDEX `id`;
51.   ALTER TABLE `ospf_instances` DROP `id`;
52.   ALTER TABLE `ospf_instances` DROP INDEX `id`;
53.   ALTER TABLE `ospf_nbrs` DROP `id`;
54.   ALTER TABLE `ospf_nbrs` DROP INDEX `id`;
55.    and 5 more...
56. [WARN]  Your install is over 24 hours out of date, last update: Tue, 09 Jan 2018 05:48:04 +0000
57.  [FIX] Make sure your daily.sh cron is running and run ./daily.sh by hand to see if there are any errors.
58. [WARN]  Your local git contains modified files, this could prevent automatic updates.
59.  [FIX] You can fix this with ./scripts/github-remove
60.  Modified Files:
61.   html/.htaccess
62. [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.
63.  [FIX] chown -R librenms:librenms /opt/librenms
64.  Files:
65.   /opt/librenms/html/.htaccess
66.   /opt/librenms/emerson
67.