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.