From quartist, 1 Year ago, written in Plain Text.
  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. ====================================
  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 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 (
  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 cron is running and run ./ 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