a-teeg@TG-AZS-LNMS:/opt/librenms$ sudo ./validate.php ==================================== Component | Version --------- | ------- LibreNMS | 1.63-62-g30a5ba890 DB Schema | 2020_06_23_00522_alter_availability_perc_column (170) PHP | 7.2.24-0ubuntu0.18.04.6 Python | 3.6.9 MySQL | 10.1.44-MariaDB-0ubuntu0.18.04.1 RRDTool | 1.7.0 SNMP | NET-SNMP 5.7.3 ==================================== [OK] Composer Version: 1.10.9 [OK] Dependencies up-to-date. [OK] Database connection successful [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. [FAIL] Database: missing index (access_points/deleted) [FAIL] Database: extra index (access_points/access_points_deleted_index) [FAIL] Database: missing index (alerts/device_id) [FAIL] Database: missing index (alerts/rule_id) [FAIL] Database: missing index (alerts/unique_alert) [FAIL] Database: extra index (alerts/alerts_device_id_index) [FAIL] Database: extra index (alerts/alerts_device_id_rule_id_unique) [FAIL] Database: extra index (alerts/alerts_rule_id_index) [FAIL] Database: missing index (alert_device_map/alert_device_map_rule_id_device_id_uindex) [FAIL] Database: extra index (alert_device_map/alert_device_map_rule_id_device_id_unique) [FAIL] Database: missing index (alert_group_map/alert_group_map_rule_id_group_id_uindex) [FAIL] Database: extra index (alert_group_map/alert_group_map_rule_id_group_id_unique) [FAIL] Database: missing index (alert_log/device_id) [FAIL] Database: missing index (alert_log/rule_id) [FAIL] Database: missing index (alert_log/time_logged) [FAIL] Database: extra index (alert_log/alert_log_device_id_index) [FAIL] Database: extra index (alert_log/alert_log_rule_id_index) [FAIL] Database: extra index (alert_log/alert_log_time_logged_index) [FAIL] Database: missing index (alert_rules/name) [FAIL] Database: extra index (alert_rules/alert_rules_name_unique) [FAIL] Database: missing index (alert_schedulables/schedule_id) [FAIL] Database: extra index (alert_schedulables/alert_schedulables_schedule_id_index) [FAIL] Database: missing column (alert_schedule/start_recurring_dt) [FAIL] Database: missing column (alert_schedule/end_recurring_dt) [FAIL] Database: missing column (alert_schedule/start_recurring_hr) [FAIL] Database: missing column (alert_schedule/end_recurring_hr) [FAIL] Database: missing index (api_tokens/token_hash) [FAIL] Database: extra index (api_tokens/api_tokens_token_hash_unique) [FAIL] Database: missing index (applications/unique_index) [FAIL] Database: extra index (applications/applications_device_id_app_type_unique) [FAIL] Database: incorrect column (application_metrics/metric) [FAIL] Database: missing index (application_metrics/application_metrics_app_id_metric_uindex) [FAIL] Database: extra index (application_metrics/application_metrics_app_id_metric_unique) [FAIL] Database: missing index (bgpPeers/device_id) [FAIL] Database: extra index (bgpPeers/bgppeers_device_id_context_name_index) [FAIL] Database: missing index (bgpPeers_cbgp/device_id) [FAIL] Database: missing index (bgpPeers_cbgp/unique_index) [FAIL] Database: extra index (bgpPeers_cbgp/bgppeers_cbgp_device_id_bgppeeridentifier_afi_safi_unique) [FAIL] Database: extra index (bgpPeers_cbgp/bgppeers_cbgp_device_id_bgppeeridentifier_context_name_index) [FAIL] Database: missing index (bill_data/bill_id) [FAIL] Database: extra index (bill_data/bill_data_bill_id_index) [FAIL] Database: missing index (bill_history/bill_id) [FAIL] Database: missing index (bill_history/unique_index) [FAIL] Database: extra index (bill_history/bill_history_bill_id_bill_datefrom_bill_dateto_unique) [FAIL] Database: extra index (bill_history/bill_history_bill_id_index) [FAIL] Database: missing index (cef_switching/device_id) [FAIL] Database: extra index (cef_switching/cef_switching_device_id_entphysicalindex_afi_cef_index_unique) [FAIL] Database: missing index (ciscoASA/device_id) [FAIL] Database: extra index (ciscoASA/ciscoasa_device_id_index) [FAIL] Database: missing index (component/device) [FAIL] Database: missing index (component/type) [FAIL] Database: extra index (component/component_device_id_index) [FAIL] Database: extra index (component/component_type_index) [FAIL] Database: missing index (component_prefs/component) [FAIL] Database: extra index (component_prefs/component_prefs_component_index) [FAIL] Database: missing index (component_statuslog/device) [FAIL] Database: extra index (component_statuslog/component_statuslog_component_id_index) [FAIL] Database: missing index (config/uniqueindex_configname) [FAIL] Database: extra index (config/config_config_name_unique) [FAIL] Database: missing index (customers/username) [FAIL] Database: extra index (customers/customers_username_unique) [FAIL] Database: missing index (devices/hostname) [FAIL] Database: missing index (devices/last_poll_attempted) [FAIL] Database: missing index (devices/last_polled) [FAIL] Database: missing index (devices/os) [FAIL] Database: missing index (devices/status) [FAIL] Database: missing index (devices/sysName) [FAIL] Database: extra index (devices/devices_hostname_index) [FAIL] Database: extra index (devices/devices_last_poll_attempted_index) [FAIL] Database: extra index (devices/devices_last_polled_index) [FAIL] Database: extra index (devices/devices_os_index) [FAIL] Database: extra index (devices/devices_status_index) [FAIL] Database: extra index (devices/devices_sysname_index) [FAIL] Database: missing index (devices_attribs/device_id) [FAIL] Database: extra index (devices_attribs/devices_attribs_device_id_index) [FAIL] Database: missing index (devices_perms/user_id) [FAIL] Database: extra index (devices_perms/devices_perms_user_id_index) [FAIL] Database: missing index (device_graphs/device_id) [FAIL] Database: extra index (device_graphs/device_graphs_device_id_index) [FAIL] Database: missing index (device_groups/name) [FAIL] Database: extra index (device_groups/device_groups_name_unique) [FAIL] Database: missing index (device_perf/device_id) [FAIL] Database: extra index (device_perf/device_perf_device_id_index) [FAIL] Database: missing index (device_relationships/device_relationship_child_device_id_fk) [FAIL] Database: extra index (device_relationships/device_relationships_child_device_id_index) [FAIL] Database: missing index (entityState/entityState_device_id_index) [FAIL] Database: extra index (entityState/entitystate_device_id_index) [FAIL] Database: missing index (entPhysical/device_id) [FAIL] Database: extra index (entPhysical/entphysical_device_id_index) [FAIL] Database: missing index (eventlog/datetime) [FAIL] Database: missing index (eventlog/device_id) [FAIL] Database: extra index (eventlog/eventlog_datetime_index) [FAIL] Database: extra index (eventlog/eventlog_device_id_index) [FAIL] Database: missing index (graph_types/graph_section) [FAIL] Database: missing index (graph_types/graph_subtype) [FAIL] Database: missing index (graph_types/graph_type) [FAIL] Database: extra index (graph_types/graph_types_graph_section_index) [FAIL] Database: extra index (graph_types/graph_types_graph_subtype_index) [FAIL] Database: extra index (graph_types/graph_types_graph_type_index) [FAIL] Database: missing index (hrDevice/device_id) [FAIL] Database: extra index (hrDevice/hrdevice_device_id_index) [FAIL] Database: missing index (ipsec_tunnels/unique_index) [FAIL] Database: extra index (ipsec_tunnels/ipsec_tunnels_device_id_peer_addr_unique) [FAIL] Database: missing index (ipv4_addresses/interface_id) [FAIL] Database: extra index (ipv4_addresses/ipv4_addresses_port_id_index) [FAIL] Database: missing index (ipv4_mac/mac_address) [FAIL] Database: missing index (ipv4_mac/port_id) [FAIL] Database: extra index (ipv4_mac/ipv4_mac_mac_address_index) [FAIL] Database: extra index (ipv4_mac/ipv4_mac_port_id_index) [FAIL] Database: missing index (ipv6_addresses/interface_id) [FAIL] Database: extra index (ipv6_addresses/ipv6_addresses_port_id_index) [FAIL] Database: missing index (juniAtmVp/port_id) [FAIL] Database: extra index (juniAtmVp/juniatmvp_port_id_index) [FAIL] Database: missing index (links/dst_if) [FAIL] Database: missing index (links/src_if) [FAIL] Database: extra index (links/links_local_port_id_index) [FAIL] Database: extra index (links/links_remote_port_id_index) [FAIL] Database: missing index (loadbalancer_vservers/device_id) [FAIL] Database: extra index (loadbalancer_vservers/loadbalancer_vservers_device_id_index) [FAIL] Database: missing index (locations/locations_location_uindex) [FAIL] Database: extra index (locations/locations_location_unique) [FAIL] Database: missing index (mac_accounting/interface_id) [FAIL] Database: missing index (mac_accounting/interface_id_2) [FAIL] Database: extra index (mac_accounting/mac_accounting_port_id_index) [FAIL] Database: missing index (mefinfo/device_id) [FAIL] Database: missing index (mefinfo/mefID) [FAIL] Database: extra index (mefinfo/mefinfo_device_id_index) [FAIL] Database: extra index (mefinfo/mefinfo_mefid_index) [FAIL] Database: missing index (mempools/device_id) [FAIL] Database: extra index (mempools/mempools_device_id_index) [FAIL] Database: missing index (mpls_lsps/device_id) [FAIL] Database: extra index (mpls_lsps/mpls_lsps_device_id_index) [FAIL] Database: missing index (mpls_lsp_paths/device_id) [FAIL] Database: extra index (mpls_lsp_paths/mpls_lsp_paths_device_id_index) [FAIL] Database: missing index (mpls_saps/device_id) [FAIL] Database: extra index (mpls_saps/mpls_saps_device_id_index) [FAIL] Database: missing index (mpls_sdps/device_id) [FAIL] Database: extra index (mpls_sdps/mpls_sdps_device_id_index) [FAIL] Database: missing index (mpls_sdp_binds/device_id) [FAIL] Database: extra index (mpls_sdp_binds/mpls_sdp_binds_device_id_index) [FAIL] Database: missing index (mpls_services/device_id) [FAIL] Database: extra index (mpls_services/mpls_services_device_id_index) [FAIL] Database: missing index (mpls_tunnel_ar_hops/device_id) [FAIL] Database: extra index (mpls_tunnel_ar_hops/mpls_tunnel_ar_hops_device_id_index) [FAIL] Database: missing index (mpls_tunnel_c_hops/device_id) [FAIL] Database: extra index (mpls_tunnel_c_hops/mpls_tunnel_c_hops_device_id_index) [FAIL] Database: missing index (munin_plugins/UNIQUE) [FAIL] Database: missing index (munin_plugins/device_id) [FAIL] Database: extra index (munin_plugins/munin_plugins_device_id_index) [FAIL] Database: extra index (munin_plugins/munin_plugins_device_id_mplug_type_unique) [FAIL] Database: missing index (munin_plugins_ds/splug_id) [FAIL] Database: extra index (munin_plugins_ds/munin_plugins_ds_mplug_id_ds_name_unique) [FAIL] Database: missing index (notifications/checksum) [FAIL] Database: extra index (notifications/notifications_checksum_unique) [FAIL] Database: missing index (ospf_areas/device_area) [FAIL] Database: extra index (ospf_areas/ospf_areas_device_id_ospfareaid_context_name_unique) [FAIL] Database: missing index (ospf_instances/device_id) [FAIL] Database: extra index (ospf_instances/ospf_instances_device_id_ospf_instance_id_context_name_unique) [FAIL] Database: missing index (ospf_nbrs/device_id) [FAIL] Database: extra index (ospf_nbrs/ospf_nbrs_device_id_ospf_nbr_id_context_name_unique) [FAIL] Database: missing index (ospf_ports/device_id) [FAIL] Database: extra index (ospf_ports/ospf_ports_device_id_ospf_port_id_context_name_unique) [FAIL] Database: missing index (packages/device_id) [FAIL] Database: missing index (packages/unique_key) [FAIL] Database: extra index (packages/packages_device_id_index) [FAIL] Database: extra index (packages/packages_device_id_name_manager_arch_version_build_unique) [FAIL] Database: missing index (perf_times/type) [FAIL] Database: extra index (perf_times/perf_times_type_index) [FAIL] Database: missing index (pollers/poller_name) [FAIL] Database: extra index (pollers/pollers_poller_name_unique) [FAIL] Database: extra column (poller_cluster/poller_enabled) [FAIL] Database: extra column (poller_cluster/poller_frequency) [FAIL] Database: extra column (poller_cluster/poller_workers) [FAIL] Database: extra column (poller_cluster/poller_down_retry) [FAIL] Database: extra column (poller_cluster/discovery_enabled) [FAIL] Database: extra column (poller_cluster/discovery_frequency) [FAIL] Database: extra column (poller_cluster/discovery_workers) [FAIL] Database: extra column (poller_cluster/services_enabled) [FAIL] Database: extra column (poller_cluster/services_frequency) [FAIL] Database: extra column (poller_cluster/services_workers) [FAIL] Database: extra column (poller_cluster/billing_enabled) [FAIL] Database: extra column (poller_cluster/billing_frequency) [FAIL] Database: extra column (poller_cluster/billing_calculate_frequency) [FAIL] Database: extra column (poller_cluster/alerting_enabled) [FAIL] Database: extra column (poller_cluster/alerting_frequency) [FAIL] Database: extra column (poller_cluster/ping_enabled) [FAIL] Database: extra column (poller_cluster/ping_frequency) [FAIL] Database: extra column (poller_cluster/update_enabled) [FAIL] Database: extra column (poller_cluster/update_frequency) [FAIL] Database: extra column (poller_cluster/loglevel) [FAIL] Database: extra column (poller_cluster/watchdog_enabled) [FAIL] Database: extra column (poller_cluster/watchdog_log) [FAIL] Database: missing index (poller_cluster_stats/parent_poller_poller_type) [FAIL] Database: extra index (poller_cluster_stats/poller_cluster_stats_parent_poller_poller_type_unique) [FAIL] Database: missing index (ports/device_ifIndex) [FAIL] Database: missing index (ports/if_2) [FAIL] Database: extra index (ports/ports_device_id_ifindex_unique) [FAIL] Database: extra index (ports/ports_ifdescr_index) [FAIL] Database: missing index (ports_adsl/interface_id) [FAIL] Database: extra index (ports_adsl/ports_adsl_port_id_unique) [FAIL] Database: missing index (ports_fdb/mac_address) [FAIL] Database: extra index (ports_fdb/ports_fdb_mac_address_index) [FAIL] Database: missing index (ports_stack/device_id) [FAIL] Database: extra index (ports_stack/ports_stack_device_id_port_id_high_port_id_low_unique) [FAIL] Database: missing index (ports_stp/device_id) [FAIL] Database: extra index (ports_stp/ports_stp_device_id_port_id_unique) [FAIL] Database: missing index (ports_vlans/unique) [FAIL] Database: extra index (ports_vlans/ports_vlans_device_id_port_id_vlan_unique) [FAIL] Database: missing index (processes/device_id) [FAIL] Database: extra index (processes/processes_device_id_index) [FAIL] Database: missing index (processors/device_id) [FAIL] Database: extra index (processors/processors_device_id_index) [FAIL] Database: missing index (proxmox/cluster_vm) [FAIL] Database: extra index (proxmox/proxmox_cluster_vmid_unique) [FAIL] Database: missing index (proxmox_ports/vm_port) [FAIL] Database: extra index (proxmox_ports/proxmox_ports_vm_id_port_unique) [FAIL] Database: missing index (sensors/sensor_class) [FAIL] Database: missing index (sensors/sensor_host) [FAIL] Database: missing index (sensors/sensor_type) [FAIL] Database: extra index (sensors/sensors_device_id_index) [FAIL] Database: extra index (sensors/sensors_sensor_class_index) [FAIL] Database: extra index (sensors/sensors_sensor_type_index) [FAIL] Database: missing index (sensors_to_state_indexes/sensor_id_state_index_id) [FAIL] Database: missing index (sensors_to_state_indexes/state_index_id) [FAIL] Database: extra index (sensors_to_state_indexes/sensors_to_state_indexes_sensor_id_state_index_id_unique) [FAIL] Database: extra index (sensors_to_state_indexes/sensors_to_state_indexes_state_index_id_index) [FAIL] Database: missing index (services/service_host) [FAIL] Database: extra index (services/services_device_id_index) [FAIL] Database: missing index (session/session_value) [FAIL] Database: extra index (session/session_session_value_unique) [FAIL] Database: missing index (slas/device_id) [FAIL] Database: missing index (slas/unique_key) [FAIL] Database: extra index (slas/slas_device_id_index) [FAIL] Database: extra index (slas/slas_device_id_sla_nr_unique) [FAIL] Database: missing index (state_indexes/state_name) [FAIL] Database: extra index (state_indexes/state_indexes_state_name_unique) [FAIL] Database: missing index (state_translations/state_index_id_value) [FAIL] Database: extra index (state_translations/state_translations_state_index_id_state_value_unique) [FAIL] Database: missing index (storage/device_id) [FAIL] Database: missing index (storage/index_unique) [FAIL] Database: extra index (storage/storage_device_id_index) [FAIL] Database: extra index (storage/storage_device_id_storage_mib_storage_index_unique) [FAIL] Database: missing index (stp/stp_host) [FAIL] Database: extra index (stp/stp_device_id_index) [FAIL] Database: missing index (syslog/datetime) [FAIL] Database: missing index (syslog/device_id) [FAIL] Database: missing index (syslog/device_id-timestamp) [FAIL] Database: missing index (syslog/priority_level) [FAIL] Database: missing index (syslog/program) [FAIL] Database: extra index (syslog/syslog_device_id_index) [FAIL] Database: extra index (syslog/syslog_device_id_timestamp_index) [FAIL] Database: extra index (syslog/syslog_priority_level_index) [FAIL] Database: extra index (syslog/syslog_program_index) [FAIL] Database: extra index (syslog/syslog_timestamp_index) [FAIL] Database: missing index (tnmsneinfo/device_id) [FAIL] Database: missing index (tnmsneinfo/neID) [FAIL] Database: extra index (tnmsneinfo/tnmsneinfo_device_id_index) [FAIL] Database: extra index (tnmsneinfo/tnmsneinfo_neid_index) [FAIL] Database: missing index (toner/device_id) [FAIL] Database: extra index (toner/toner_device_id_index) [FAIL] Database: missing index (ucd_diskio/device_id) [FAIL] Database: extra index (ucd_diskio/ucd_diskio_device_id_index) [FAIL] Database: missing index (users/username) [FAIL] Database: extra index (users/users_auth_type_username_unique) [FAIL] Database: missing index (vminfo/device_id) [FAIL] Database: missing index (vminfo/vmwVmVMID) [FAIL] Database: extra index (vminfo/vminfo_device_id_index) [FAIL] Database: extra index (vminfo/vminfo_vmwvmvmid_index) [FAIL] Database: missing index (vrfs/device_id) [FAIL] Database: extra index (vrfs/vrfs_device_id_index) [FAIL] Database: missing index (vrf_lite_cisco/context) [FAIL] Database: missing index (vrf_lite_cisco/device) [FAIL] Database: missing index (vrf_lite_cisco/mix) [FAIL] Database: missing index (vrf_lite_cisco/vrf) [FAIL] Database: extra index (vrf_lite_cisco/vrf_lite_cisco_context_name_index) [FAIL] Database: extra index (vrf_lite_cisco/vrf_lite_cisco_device_id_context_name_vrf_name_index) [FAIL] Database: extra index (vrf_lite_cisco/vrf_lite_cisco_device_id_index) [FAIL] Database: extra index (vrf_lite_cisco/vrf_lite_cisco_vrf_name_index) [FAIL] Database: missing index (widgets/widget) [FAIL] Database: extra index (widgets/widgets_widget_unique) [FAIL] Database: missing index (wireless_sensors/sensor_class) [FAIL] Database: missing index (wireless_sensors/sensor_host) [FAIL] Database: missing index (wireless_sensors/sensor_type) [FAIL] Database: extra index (wireless_sensors/wireless_sensors_device_id_index) [FAIL] Database: extra index (wireless_sensors/wireless_sensors_sensor_class_index) [FAIL] Database: extra index (wireless_sensors/wireless_sensors_sensor_type_index) [FAIL] Database: extra table (availability) [FAIL] Database: extra table (device_outages) [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): [FIX]: Run the following SQL statements to fix. SQL Statements: ALTER TABLE `access_points` DROP INDEX `access_points_deleted_index`; ALTER TABLE `access_points` ADD INDEX `deleted` (`deleted`); ALTER TABLE `alerts` DROP INDEX `alerts_device_id_index`; ALTER TABLE `alerts` DROP INDEX `alerts_device_id_rule_id_unique`; ALTER TABLE `alerts` DROP INDEX `alerts_rule_id_index`; ALTER TABLE `alerts` ADD INDEX `device_id` (`device_id`); ALTER TABLE `alerts` ADD INDEX `rule_id` (`rule_id`); ALTER TABLE `alerts` ADD UNIQUE `unique_alert` (`device_id`,`rule_id`); ALTER TABLE `alert_device_map` DROP INDEX `alert_device_map_rule_id_device_id_unique`; ALTER TABLE `alert_device_map` ADD UNIQUE `alert_device_map_rule_id_device_id_uindex` (`rule_id`,`device_id`); ALTER TABLE `alert_group_map` DROP INDEX `alert_group_map_rule_id_group_id_unique`; ALTER TABLE `alert_group_map` ADD UNIQUE `alert_group_map_rule_id_group_id_uindex` (`rule_id`,`group_id`); ALTER TABLE `alert_log` DROP INDEX `alert_log_device_id_index`; ALTER TABLE `alert_log` DROP INDEX `alert_log_rule_id_index`; ALTER TABLE `alert_log` DROP INDEX `alert_log_time_logged_index`; and 273 more... [WARN] Your local git branch is not master, this will prevent automatic updates. [FIX]: You can switch back to master with git checkout master [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]: sudo chown -R librenms:librenms /opt/librenms sudo setfacl -d -m g::rwx /opt/librenms/rrd /opt/librenms/logs /opt/librenms/bootstrap/cache/ /opt/librenms/storage/ sudo chmod -R ug=rwX /opt/librenms/rrd /opt/librenms/logs /opt/librenms/bootstrap/cache/ /opt/librenms/storage/ Files: /opt/librenms/.git/ORIG_HEAD