ℹ️ Your data is safe here... unless you make the SNIP gods angry. And let's just say they have a really bad sense of humor.

From aspo73, 4 Years ago, written in Plain Text.
Embed
  1. a-teeg@TG-AZS-LNMS:/opt/librenms$ sudo ./validate.php
  2. ====================================
  3. Component | Version
  4. --------- | -------
  5. LibreNMS  | 1.63-62-g30a5ba890
  6. DB Schema | 2020_06_23_00522_alter_availability_perc_column (170)
  7. PHP       | 7.2.24-0ubuntu0.18.04.6
  8. Python    | 3.6.9
  9. MySQL     | 10.1.44-MariaDB-0ubuntu0.18.04.1
  10. RRDTool   | 1.7.0
  11. SNMP      | NET-SNMP 5.7.3
  12. ====================================
  13.  
  14. [OK]    Composer Version: 1.10.9
  15. [OK]    Dependencies up-to-date.
  16. [OK]    Database connection successful
  17. [WARN]  Your database schema has extra migrations (2020_04_06_001048_the_great_index_rename, 2020_05_24_212054_poller_cluster_settings, 2020_04_08_172357_alert_schedule_utc, 2020_05_22_020303_alter_metric_column, 2020_06_06_222222_create_device_outages_table, 2020_06_23_00522_alter_availability_perc_column). If you just switched to the stable release from the daily release, your database is in between releases and this will be resolved with the next release.
  18. [FAIL]  Database: missing index (access_points/deleted)
  19. [FAIL]  Database: extra index (access_points/access_points_deleted_index)
  20. [FAIL]  Database: missing index (alerts/device_id)
  21. [FAIL]  Database: missing index (alerts/rule_id)
  22. [FAIL]  Database: missing index (alerts/unique_alert)
  23. [FAIL]  Database: extra index (alerts/alerts_device_id_index)
  24. [FAIL]  Database: extra index (alerts/alerts_device_id_rule_id_unique)
  25. [FAIL]  Database: extra index (alerts/alerts_rule_id_index)
  26. [FAIL]  Database: missing index (alert_device_map/alert_device_map_rule_id_device_id_uindex)
  27. [FAIL]  Database: extra index (alert_device_map/alert_device_map_rule_id_device_id_unique)
  28. [FAIL]  Database: missing index (alert_group_map/alert_group_map_rule_id_group_id_uindex)
  29. [FAIL]  Database: extra index (alert_group_map/alert_group_map_rule_id_group_id_unique)
  30. [FAIL]  Database: missing index (alert_log/device_id)
  31. [FAIL]  Database: missing index (alert_log/rule_id)
  32. [FAIL]  Database: missing index (alert_log/time_logged)
  33. [FAIL]  Database: extra index (alert_log/alert_log_device_id_index)
  34. [FAIL]  Database: extra index (alert_log/alert_log_rule_id_index)
  35. [FAIL]  Database: extra index (alert_log/alert_log_time_logged_index)
  36. [FAIL]  Database: missing index (alert_rules/name)
  37. [FAIL]  Database: extra index (alert_rules/alert_rules_name_unique)
  38. [FAIL]  Database: missing index (alert_schedulables/schedule_id)
  39. [FAIL]  Database: extra index (alert_schedulables/alert_schedulables_schedule_id_index)
  40. [FAIL]  Database: missing column (alert_schedule/start_recurring_dt)
  41. [FAIL]  Database: missing column (alert_schedule/end_recurring_dt)
  42. [FAIL]  Database: missing column (alert_schedule/start_recurring_hr)
  43. [FAIL]  Database: missing column (alert_schedule/end_recurring_hr)
  44. [FAIL]  Database: missing index (api_tokens/token_hash)
  45. [FAIL]  Database: extra index (api_tokens/api_tokens_token_hash_unique)
  46. [FAIL]  Database: missing index (applications/unique_index)
  47. [FAIL]  Database: extra index (applications/applications_device_id_app_type_unique)
  48. [FAIL]  Database: incorrect column (application_metrics/metric)
  49. [FAIL]  Database: missing index (application_metrics/application_metrics_app_id_metric_uindex)
  50. [FAIL]  Database: extra index (application_metrics/application_metrics_app_id_metric_unique)
  51. [FAIL]  Database: missing index (bgpPeers/device_id)
  52. [FAIL]  Database: extra index (bgpPeers/bgppeers_device_id_context_name_index)
  53. [FAIL]  Database: missing index (bgpPeers_cbgp/device_id)
  54. [FAIL]  Database: missing index (bgpPeers_cbgp/unique_index)
  55. [FAIL]  Database: extra index (bgpPeers_cbgp/bgppeers_cbgp_device_id_bgppeeridentifier_afi_safi_unique)
  56. [FAIL]  Database: extra index (bgpPeers_cbgp/bgppeers_cbgp_device_id_bgppeeridentifier_context_name_index)
  57. [FAIL]  Database: missing index (bill_data/bill_id)
  58. [FAIL]  Database: extra index (bill_data/bill_data_bill_id_index)
  59. [FAIL]  Database: missing index (bill_history/bill_id)
  60. [FAIL]  Database: missing index (bill_history/unique_index)
  61. [FAIL]  Database: extra index (bill_history/bill_history_bill_id_bill_datefrom_bill_dateto_unique)
  62. [FAIL]  Database: extra index (bill_history/bill_history_bill_id_index)
  63. [FAIL]  Database: missing index (cef_switching/device_id)
  64. [FAIL]  Database: extra index (cef_switching/cef_switching_device_id_entphysicalindex_afi_cef_index_unique)
  65. [FAIL]  Database: missing index (ciscoASA/device_id)
  66. [FAIL]  Database: extra index (ciscoASA/ciscoasa_device_id_index)
  67. [FAIL]  Database: missing index (component/device)
  68. [FAIL]  Database: missing index (component/type)
  69. [FAIL]  Database: extra index (component/component_device_id_index)
  70. [FAIL]  Database: extra index (component/component_type_index)
  71. [FAIL]  Database: missing index (component_prefs/component)
  72. [FAIL]  Database: extra index (component_prefs/component_prefs_component_index)
  73. [FAIL]  Database: missing index (component_statuslog/device)
  74. [FAIL]  Database: extra index (component_statuslog/component_statuslog_component_id_index)
  75. [FAIL]  Database: missing index (config/uniqueindex_configname)
  76. [FAIL]  Database: extra index (config/config_config_name_unique)
  77. [FAIL]  Database: missing index (customers/username)
  78. [FAIL]  Database: extra index (customers/customers_username_unique)
  79. [FAIL]  Database: missing index (devices/hostname)
  80. [FAIL]  Database: missing index (devices/last_poll_attempted)
  81. [FAIL]  Database: missing index (devices/last_polled)
  82. [FAIL]  Database: missing index (devices/os)
  83. [FAIL]  Database: missing index (devices/status)
  84. [FAIL]  Database: missing index (devices/sysName)
  85. [FAIL]  Database: extra index (devices/devices_hostname_index)
  86. [FAIL]  Database: extra index (devices/devices_last_poll_attempted_index)
  87. [FAIL]  Database: extra index (devices/devices_last_polled_index)
  88. [FAIL]  Database: extra index (devices/devices_os_index)
  89. [FAIL]  Database: extra index (devices/devices_status_index)
  90. [FAIL]  Database: extra index (devices/devices_sysname_index)
  91. [FAIL]  Database: missing index (devices_attribs/device_id)
  92. [FAIL]  Database: extra index (devices_attribs/devices_attribs_device_id_index)
  93. [FAIL]  Database: missing index (devices_perms/user_id)
  94. [FAIL]  Database: extra index (devices_perms/devices_perms_user_id_index)
  95. [FAIL]  Database: missing index (device_graphs/device_id)
  96. [FAIL]  Database: extra index (device_graphs/device_graphs_device_id_index)
  97. [FAIL]  Database: missing index (device_groups/name)
  98. [FAIL]  Database: extra index (device_groups/device_groups_name_unique)
  99. [FAIL]  Database: missing index (device_perf/device_id)
  100. [FAIL]  Database: extra index (device_perf/device_perf_device_id_index)
  101. [FAIL]  Database: missing index (device_relationships/device_relationship_child_device_id_fk)
  102. [FAIL]  Database: extra index (device_relationships/device_relationships_child_device_id_index)
  103. [FAIL]  Database: missing index (entityState/entityState_device_id_index)
  104. [FAIL]  Database: extra index (entityState/entitystate_device_id_index)
  105. [FAIL]  Database: missing index (entPhysical/device_id)
  106. [FAIL]  Database: extra index (entPhysical/entphysical_device_id_index)
  107. [FAIL]  Database: missing index (eventlog/datetime)
  108. [FAIL]  Database: missing index (eventlog/device_id)
  109. [FAIL]  Database: extra index (eventlog/eventlog_datetime_index)
  110. [FAIL]  Database: extra index (eventlog/eventlog_device_id_index)
  111. [FAIL]  Database: missing index (graph_types/graph_section)
  112. [FAIL]  Database: missing index (graph_types/graph_subtype)
  113. [FAIL]  Database: missing index (graph_types/graph_type)
  114. [FAIL]  Database: extra index (graph_types/graph_types_graph_section_index)
  115. [FAIL]  Database: extra index (graph_types/graph_types_graph_subtype_index)
  116. [FAIL]  Database: extra index (graph_types/graph_types_graph_type_index)
  117. [FAIL]  Database: missing index (hrDevice/device_id)
  118. [FAIL]  Database: extra index (hrDevice/hrdevice_device_id_index)
  119. [FAIL]  Database: missing index (ipsec_tunnels/unique_index)
  120. [FAIL]  Database: extra index (ipsec_tunnels/ipsec_tunnels_device_id_peer_addr_unique)
  121. [FAIL]  Database: missing index (ipv4_addresses/interface_id)
  122. [FAIL]  Database: extra index (ipv4_addresses/ipv4_addresses_port_id_index)
  123. [FAIL]  Database: missing index (ipv4_mac/mac_address)
  124. [FAIL]  Database: missing index (ipv4_mac/port_id)
  125. [FAIL]  Database: extra index (ipv4_mac/ipv4_mac_mac_address_index)
  126. [FAIL]  Database: extra index (ipv4_mac/ipv4_mac_port_id_index)
  127. [FAIL]  Database: missing index (ipv6_addresses/interface_id)
  128. [FAIL]  Database: extra index (ipv6_addresses/ipv6_addresses_port_id_index)
  129. [FAIL]  Database: missing index (juniAtmVp/port_id)
  130. [FAIL]  Database: extra index (juniAtmVp/juniatmvp_port_id_index)
  131. [FAIL]  Database: missing index (links/dst_if)
  132. [FAIL]  Database: missing index (links/src_if)
  133. [FAIL]  Database: extra index (links/links_local_port_id_index)
  134. [FAIL]  Database: extra index (links/links_remote_port_id_index)
  135. [FAIL]  Database: missing index (loadbalancer_vservers/device_id)
  136. [FAIL]  Database: extra index (loadbalancer_vservers/loadbalancer_vservers_device_id_index)
  137. [FAIL]  Database: missing index (locations/locations_location_uindex)
  138. [FAIL]  Database: extra index (locations/locations_location_unique)
  139. [FAIL]  Database: missing index (mac_accounting/interface_id)
  140. [FAIL]  Database: missing index (mac_accounting/interface_id_2)
  141. [FAIL]  Database: extra index (mac_accounting/mac_accounting_port_id_index)
  142. [FAIL]  Database: missing index (mefinfo/device_id)
  143. [FAIL]  Database: missing index (mefinfo/mefID)
  144. [FAIL]  Database: extra index (mefinfo/mefinfo_device_id_index)
  145. [FAIL]  Database: extra index (mefinfo/mefinfo_mefid_index)
  146. [FAIL]  Database: missing index (mempools/device_id)
  147. [FAIL]  Database: extra index (mempools/mempools_device_id_index)
  148. [FAIL]  Database: missing index (mpls_lsps/device_id)
  149. [FAIL]  Database: extra index (mpls_lsps/mpls_lsps_device_id_index)
  150. [FAIL]  Database: missing index (mpls_lsp_paths/device_id)
  151. [FAIL]  Database: extra index (mpls_lsp_paths/mpls_lsp_paths_device_id_index)
  152. [FAIL]  Database: missing index (mpls_saps/device_id)
  153. [FAIL]  Database: extra index (mpls_saps/mpls_saps_device_id_index)
  154. [FAIL]  Database: missing index (mpls_sdps/device_id)
  155. [FAIL]  Database: extra index (mpls_sdps/mpls_sdps_device_id_index)
  156. [FAIL]  Database: missing index (mpls_sdp_binds/device_id)
  157. [FAIL]  Database: extra index (mpls_sdp_binds/mpls_sdp_binds_device_id_index)
  158. [FAIL]  Database: missing index (mpls_services/device_id)
  159. [FAIL]  Database: extra index (mpls_services/mpls_services_device_id_index)
  160. [FAIL]  Database: missing index (mpls_tunnel_ar_hops/device_id)
  161. [FAIL]  Database: extra index (mpls_tunnel_ar_hops/mpls_tunnel_ar_hops_device_id_index)
  162. [FAIL]  Database: missing index (mpls_tunnel_c_hops/device_id)
  163. [FAIL]  Database: extra index (mpls_tunnel_c_hops/mpls_tunnel_c_hops_device_id_index)
  164. [FAIL]  Database: missing index (munin_plugins/UNIQUE)
  165. [FAIL]  Database: missing index (munin_plugins/device_id)
  166. [FAIL]  Database: extra index (munin_plugins/munin_plugins_device_id_index)
  167. [FAIL]  Database: extra index (munin_plugins/munin_plugins_device_id_mplug_type_unique)
  168. [FAIL]  Database: missing index (munin_plugins_ds/splug_id)
  169. [FAIL]  Database: extra index (munin_plugins_ds/munin_plugins_ds_mplug_id_ds_name_unique)
  170. [FAIL]  Database: missing index (notifications/checksum)
  171. [FAIL]  Database: extra index (notifications/notifications_checksum_unique)
  172. [FAIL]  Database: missing index (ospf_areas/device_area)
  173. [FAIL]  Database: extra index (ospf_areas/ospf_areas_device_id_ospfareaid_context_name_unique)
  174. [FAIL]  Database: missing index (ospf_instances/device_id)
  175. [FAIL]  Database: extra index (ospf_instances/ospf_instances_device_id_ospf_instance_id_context_name_unique)
  176. [FAIL]  Database: missing index (ospf_nbrs/device_id)
  177. [FAIL]  Database: extra index (ospf_nbrs/ospf_nbrs_device_id_ospf_nbr_id_context_name_unique)
  178. [FAIL]  Database: missing index (ospf_ports/device_id)
  179. [FAIL]  Database: extra index (ospf_ports/ospf_ports_device_id_ospf_port_id_context_name_unique)
  180. [FAIL]  Database: missing index (packages/device_id)
  181. [FAIL]  Database: missing index (packages/unique_key)
  182. [FAIL]  Database: extra index (packages/packages_device_id_index)
  183. [FAIL]  Database: extra index (packages/packages_device_id_name_manager_arch_version_build_unique)
  184. [FAIL]  Database: missing index (perf_times/type)
  185. [FAIL]  Database: extra index (perf_times/perf_times_type_index)
  186. [FAIL]  Database: missing index (pollers/poller_name)
  187. [FAIL]  Database: extra index (pollers/pollers_poller_name_unique)
  188. [FAIL]  Database: extra column (poller_cluster/poller_enabled)
  189. [FAIL]  Database: extra column (poller_cluster/poller_frequency)
  190. [FAIL]  Database: extra column (poller_cluster/poller_workers)
  191. [FAIL]  Database: extra column (poller_cluster/poller_down_retry)
  192. [FAIL]  Database: extra column (poller_cluster/discovery_enabled)
  193. [FAIL]  Database: extra column (poller_cluster/discovery_frequency)
  194. [FAIL]  Database: extra column (poller_cluster/discovery_workers)
  195. [FAIL]  Database: extra column (poller_cluster/services_enabled)
  196. [FAIL]  Database: extra column (poller_cluster/services_frequency)
  197. [FAIL]  Database: extra column (poller_cluster/services_workers)
  198. [FAIL]  Database: extra column (poller_cluster/billing_enabled)
  199. [FAIL]  Database: extra column (poller_cluster/billing_frequency)
  200. [FAIL]  Database: extra column (poller_cluster/billing_calculate_frequency)
  201. [FAIL]  Database: extra column (poller_cluster/alerting_enabled)
  202. [FAIL]  Database: extra column (poller_cluster/alerting_frequency)
  203. [FAIL]  Database: extra column (poller_cluster/ping_enabled)
  204. [FAIL]  Database: extra column (poller_cluster/ping_frequency)
  205. [FAIL]  Database: extra column (poller_cluster/update_enabled)
  206. [FAIL]  Database: extra column (poller_cluster/update_frequency)
  207. [FAIL]  Database: extra column (poller_cluster/loglevel)
  208. [FAIL]  Database: extra column (poller_cluster/watchdog_enabled)
  209. [FAIL]  Database: extra column (poller_cluster/watchdog_log)
  210. [FAIL]  Database: missing index (poller_cluster_stats/parent_poller_poller_type)
  211. [FAIL]  Database: extra index (poller_cluster_stats/poller_cluster_stats_parent_poller_poller_type_unique)
  212. [FAIL]  Database: missing index (ports/device_ifIndex)
  213. [FAIL]  Database: missing index (ports/if_2)
  214. [FAIL]  Database: extra index (ports/ports_device_id_ifindex_unique)
  215. [FAIL]  Database: extra index (ports/ports_ifdescr_index)
  216. [FAIL]  Database: missing index (ports_adsl/interface_id)
  217. [FAIL]  Database: extra index (ports_adsl/ports_adsl_port_id_unique)
  218. [FAIL]  Database: missing index (ports_fdb/mac_address)
  219. [FAIL]  Database: extra index (ports_fdb/ports_fdb_mac_address_index)
  220. [FAIL]  Database: missing index (ports_stack/device_id)
  221. [FAIL]  Database: extra index (ports_stack/ports_stack_device_id_port_id_high_port_id_low_unique)
  222. [FAIL]  Database: missing index (ports_stp/device_id)
  223. [FAIL]  Database: extra index (ports_stp/ports_stp_device_id_port_id_unique)
  224. [FAIL]  Database: missing index (ports_vlans/unique)
  225. [FAIL]  Database: extra index (ports_vlans/ports_vlans_device_id_port_id_vlan_unique)
  226. [FAIL]  Database: missing index (processes/device_id)
  227. [FAIL]  Database: extra index (processes/processes_device_id_index)
  228. [FAIL]  Database: missing index (processors/device_id)
  229. [FAIL]  Database: extra index (processors/processors_device_id_index)
  230. [FAIL]  Database: missing index (proxmox/cluster_vm)
  231. [FAIL]  Database: extra index (proxmox/proxmox_cluster_vmid_unique)
  232. [FAIL]  Database: missing index (proxmox_ports/vm_port)
  233. [FAIL]  Database: extra index (proxmox_ports/proxmox_ports_vm_id_port_unique)
  234. [FAIL]  Database: missing index (sensors/sensor_class)
  235. [FAIL]  Database: missing index (sensors/sensor_host)
  236. [FAIL]  Database: missing index (sensors/sensor_type)
  237. [FAIL]  Database: extra index (sensors/sensors_device_id_index)
  238. [FAIL]  Database: extra index (sensors/sensors_sensor_class_index)
  239. [FAIL]  Database: extra index (sensors/sensors_sensor_type_index)
  240. [FAIL]  Database: missing index (sensors_to_state_indexes/sensor_id_state_index_id)
  241. [FAIL]  Database: missing index (sensors_to_state_indexes/state_index_id)
  242. [FAIL]  Database: extra index (sensors_to_state_indexes/sensors_to_state_indexes_sensor_id_state_index_id_unique)
  243. [FAIL]  Database: extra index (sensors_to_state_indexes/sensors_to_state_indexes_state_index_id_index)
  244. [FAIL]  Database: missing index (services/service_host)
  245. [FAIL]  Database: extra index (services/services_device_id_index)
  246. [FAIL]  Database: missing index (session/session_value)
  247. [FAIL]  Database: extra index (session/session_session_value_unique)
  248. [FAIL]  Database: missing index (slas/device_id)
  249. [FAIL]  Database: missing index (slas/unique_key)
  250. [FAIL]  Database: extra index (slas/slas_device_id_index)
  251. [FAIL]  Database: extra index (slas/slas_device_id_sla_nr_unique)
  252. [FAIL]  Database: missing index (state_indexes/state_name)
  253. [FAIL]  Database: extra index (state_indexes/state_indexes_state_name_unique)
  254. [FAIL]  Database: missing index (state_translations/state_index_id_value)
  255. [FAIL]  Database: extra index (state_translations/state_translations_state_index_id_state_value_unique)
  256. [FAIL]  Database: missing index (storage/device_id)
  257. [FAIL]  Database: missing index (storage/index_unique)
  258. [FAIL]  Database: extra index (storage/storage_device_id_index)
  259. [FAIL]  Database: extra index (storage/storage_device_id_storage_mib_storage_index_unique)
  260. [FAIL]  Database: missing index (stp/stp_host)
  261. [FAIL]  Database: extra index (stp/stp_device_id_index)
  262. [FAIL]  Database: missing index (syslog/datetime)
  263. [FAIL]  Database: missing index (syslog/device_id)
  264. [FAIL]  Database: missing index (syslog/device_id-timestamp)
  265. [FAIL]  Database: missing index (syslog/priority_level)
  266. [FAIL]  Database: missing index (syslog/program)
  267. [FAIL]  Database: extra index (syslog/syslog_device_id_index)
  268. [FAIL]  Database: extra index (syslog/syslog_device_id_timestamp_index)
  269. [FAIL]  Database: extra index (syslog/syslog_priority_level_index)
  270. [FAIL]  Database: extra index (syslog/syslog_program_index)
  271. [FAIL]  Database: extra index (syslog/syslog_timestamp_index)
  272. [FAIL]  Database: missing index (tnmsneinfo/device_id)
  273. [FAIL]  Database: missing index (tnmsneinfo/neID)
  274. [FAIL]  Database: extra index (tnmsneinfo/tnmsneinfo_device_id_index)
  275. [FAIL]  Database: extra index (tnmsneinfo/tnmsneinfo_neid_index)
  276. [FAIL]  Database: missing index (toner/device_id)
  277. [FAIL]  Database: extra index (toner/toner_device_id_index)
  278. [FAIL]  Database: missing index (ucd_diskio/device_id)
  279. [FAIL]  Database: extra index (ucd_diskio/ucd_diskio_device_id_index)
  280. [FAIL]  Database: missing index (users/username)
  281. [FAIL]  Database: extra index (users/users_auth_type_username_unique)
  282. [FAIL]  Database: missing index (vminfo/device_id)
  283. [FAIL]  Database: missing index (vminfo/vmwVmVMID)
  284. [FAIL]  Database: extra index (vminfo/vminfo_device_id_index)
  285. [FAIL]  Database: extra index (vminfo/vminfo_vmwvmvmid_index)
  286. [FAIL]  Database: missing index (vrfs/device_id)
  287. [FAIL]  Database: extra index (vrfs/vrfs_device_id_index)
  288. [FAIL]  Database: missing index (vrf_lite_cisco/context)
  289. [FAIL]  Database: missing index (vrf_lite_cisco/device)
  290. [FAIL]  Database: missing index (vrf_lite_cisco/mix)
  291. [FAIL]  Database: missing index (vrf_lite_cisco/vrf)
  292. [FAIL]  Database: extra index (vrf_lite_cisco/vrf_lite_cisco_context_name_index)
  293. [FAIL]  Database: extra index (vrf_lite_cisco/vrf_lite_cisco_device_id_context_name_vrf_name_index)
  294. [FAIL]  Database: extra index (vrf_lite_cisco/vrf_lite_cisco_device_id_index)
  295. [FAIL]  Database: extra index (vrf_lite_cisco/vrf_lite_cisco_vrf_name_index)
  296. [FAIL]  Database: missing index (widgets/widget)
  297. [FAIL]  Database: extra index (widgets/widgets_widget_unique)
  298. [FAIL]  Database: missing index (wireless_sensors/sensor_class)
  299. [FAIL]  Database: missing index (wireless_sensors/sensor_host)
  300. [FAIL]  Database: missing index (wireless_sensors/sensor_type)
  301. [FAIL]  Database: extra index (wireless_sensors/wireless_sensors_device_id_index)
  302. [FAIL]  Database: extra index (wireless_sensors/wireless_sensors_sensor_class_index)
  303. [FAIL]  Database: extra index (wireless_sensors/wireless_sensors_sensor_type_index)
  304. [FAIL]  Database: extra table (availability)
  305. [FAIL]  Database: extra table (device_outages)
  306. [FAIL]  We have detected that your database schema may be wrong, please report the following to us on Discord (https://t.libren.ms/discord) or the community site (https://t.libren.ms/5gscd):
  307.         [FIX]:
  308.         Run the following SQL statements to fix.
  309.         SQL Statements:
  310.          ALTER TABLE `access_points` DROP INDEX `access_points_deleted_index`;
  311.          ALTER TABLE `access_points` ADD INDEX `deleted` (`deleted`);
  312.          ALTER TABLE `alerts` DROP INDEX `alerts_device_id_index`;
  313.          ALTER TABLE `alerts` DROP INDEX `alerts_device_id_rule_id_unique`;
  314.          ALTER TABLE `alerts` DROP INDEX `alerts_rule_id_index`;
  315.          ALTER TABLE `alerts` ADD INDEX `device_id` (`device_id`);
  316.          ALTER TABLE `alerts` ADD INDEX `rule_id` (`rule_id`);
  317.          ALTER TABLE `alerts` ADD UNIQUE `unique_alert` (`device_id`,`rule_id`);
  318.          ALTER TABLE `alert_device_map` DROP INDEX `alert_device_map_rule_id_device_id_unique`;
  319.          ALTER TABLE `alert_device_map` ADD UNIQUE `alert_device_map_rule_id_device_id_uindex` (`rule_id`,`device_id`);
  320.          ALTER TABLE `alert_group_map` DROP INDEX `alert_group_map_rule_id_group_id_unique`;
  321.          ALTER TABLE `alert_group_map` ADD UNIQUE `alert_group_map_rule_id_group_id_uindex` (`rule_id`,`group_id`);
  322.          ALTER TABLE `alert_log` DROP INDEX `alert_log_device_id_index`;
  323.          ALTER TABLE `alert_log` DROP INDEX `alert_log_rule_id_index`;
  324.          ALTER TABLE `alert_log` DROP INDEX `alert_log_time_logged_index`;
  325.           and 273 more...
  326. [WARN]  Your local git branch is not master, this will prevent automatic updates.
  327.         [FIX]:
  328.         You can switch back to master with git checkout master
  329. [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.
  330.         [FIX]:
  331.         sudo chown -R librenms:librenms /opt/librenms
  332.         sudo setfacl -d -m g::rwx /opt/librenms/rrd /opt/librenms/logs /opt/librenms/bootstrap/cache/ /opt/librenms/storage/
  333.         sudo chmod -R ug=rwX /opt/librenms/rrd /opt/librenms/logs /opt/librenms/bootstrap/cache/ /opt/librenms/storage/
  334.         Files:
  335.          /opt/librenms/.git/ORIG_HEAD
  336.  
captcha