- ====================================
- Component | Version
- --------- | -------
- LibreNMS | 1.62-111-gd4225806a
- DB Schema | 2020_04_13_150500_add_last_error_fields_to_bgp_peers (164)
- PHP | 7.3.11-0ubuntu0.19.10.4
- MySQL | 8.0.19-0ubuntu0.19.10.3
- RRDTool | 1.7.1
- SNMP | NET-SNMP 5.7.3
- ====================================
- [[32mOK[0m] Composer Version: 1.10.5
- [[32mOK[0m] Dependencies up-to-date.
- [[0;32mOK[0m] Database connection successful
- [[1;31mFAIL[0m] Database: incorrect column (alert_location_map/id)
- [[1;31mFAIL[0m] Database: incorrect column (alert_location_map/rule_id)
- [[1;31mFAIL[0m] Database: incorrect column (alert_location_map/location_id)
- [[1;31mFAIL[0m] Database: incorrect column (bgpPeers/bgpPeer_id)
- [[1;31mFAIL[0m] Database: incorrect column (bgpPeers/device_id)
- [[1;31mFAIL[0m] Database: incorrect column (bgpPeers/vrf_id)
- [[1;31mFAIL[0m] Database: incorrect column (bgpPeers/bgpPeerRemoteAs)
- [[1;31mFAIL[0m] Database: incorrect column (bgpPeers/bgpPeerLastErrorCode)
- [[1;31mFAIL[0m] Database: incorrect column (bgpPeers/bgpPeerLastErrorSubCode)
- [[1;31mFAIL[0m] Database: incorrect column (bgpPeers/bgpPeerInUpdates)
- [[1;31mFAIL[0m] Database: incorrect column (bgpPeers/bgpPeerOutUpdates)
- [[1;31mFAIL[0m] Database: incorrect column (bgpPeers/bgpPeerInTotalMessages)
- [[1;31mFAIL[0m] Database: incorrect column (bgpPeers/bgpPeerOutTotalMessages)
- [[1;31mFAIL[0m] Database: incorrect column (bgpPeers/bgpPeerFsmEstablishedTime)
- [[1;31mFAIL[0m] Database: incorrect column (bgpPeers/bgpPeerInUpdateElapsedTime)
- [[1;31mFAIL[0m] Database: incorrect column (devices/device_id)
- [[1;31mFAIL[0m] Database: incorrect column (devices/port)
- [[1;31mFAIL[0m] Database: incorrect column (devices/timeout)
- [[1;31mFAIL[0m] Database: incorrect column (devices/retries)
- [[1;31mFAIL[0m] Database: incorrect column (devices/bgpLocalAs)
- [[1;31mFAIL[0m] Database: incorrect column (devices/location_id)
- [[1;31mFAIL[0m] Database: incorrect column (devices/uptime)
- [[1;31mFAIL[0m] Database: incorrect column (devices/agent_uptime)
- [[1;31mFAIL[0m] Database: incorrect column (devices/poller_group)
- [[1;31mFAIL[0m] Database: incorrect column (devices/port_association_mode)
- [[1;31mFAIL[0m] Database: incorrect column (devices/max_depth)
- [[1;31mFAIL[0m] Database: incorrect column (device_graphs/device_id)
- [[1;31mFAIL[0m] Database: incorrect column (device_graphs/id)
- [[1;31mFAIL[0m] Database: incorrect column (mpls_lsp_paths/lsp_path_id)
- [[1;31mFAIL[0m] Database: incorrect column (mpls_lsp_paths/lsp_id)
- [[1;31mFAIL[0m] Database: incorrect column (mpls_lsp_paths/path_oid)
- [[1;31mFAIL[0m] Database: incorrect column (mpls_lsp_paths/device_id)
- [[1;31mFAIL[0m] Database: incorrect column (mpls_lsp_paths/mplsLspPathLastChange)
- [[1;31mFAIL[0m] Database: incorrect column (mpls_lsp_paths/mplsLspPathBandwidth)
- [[1;31mFAIL[0m] Database: incorrect column (mpls_lsp_paths/mplsLspPathOperBandwidth)
- [[1;31mFAIL[0m] Database: incorrect column (mpls_lsp_paths/mplsLspPathMetric)
- [[1;31mFAIL[0m] Database: incorrect column (mpls_lsp_paths/mplsLspPathOperMetric)
- [[1;31mFAIL[0m] Database: incorrect column (mpls_lsp_paths/mplsLspPathTimeUp)
- [[1;31mFAIL[0m] Database: incorrect column (mpls_lsp_paths/mplsLspPathTimeDown)
- [[1;31mFAIL[0m] Database: incorrect column (mpls_lsp_paths/mplsLspPathTransitionCount)
- [[1;31mFAIL[0m] Database: incorrect column (mpls_lsp_paths/mplsLspPathTunnelARHopListIndex)
- [[1;31mFAIL[0m] Database: incorrect column (mpls_lsp_paths/mplsLspPathTunnelCHopListIndex)
- [[1;31mFAIL[0m] Database: incorrect column (ports/port_id)
- [[1;31mFAIL[0m] Database: incorrect column (ports/device_id)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifIndex)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifSpeed)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifSpeed_prev)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifHighSpeed)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifHighSpeed_prev)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifMtu)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifLastChange)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifVrf)
- [[1;31mFAIL[0m] Database: incorrect column (ports/counter_in)
- [[1;31mFAIL[0m] Database: incorrect column (ports/counter_out)
- [[1;31mFAIL[0m] Database: incorrect column (ports/pagpPartnerIfIndex)
- [[1;31mFAIL[0m] Database: incorrect column (ports/pagpPartnerGroupIfIndex)
- [[1;31mFAIL[0m] Database: incorrect column (ports/pagpGroupIfIndex)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifInUcastPkts)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifInUcastPkts_prev)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifInUcastPkts_delta)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifInUcastPkts_rate)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifOutUcastPkts)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifOutUcastPkts_prev)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifOutUcastPkts_delta)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifOutUcastPkts_rate)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifInErrors)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifInErrors_prev)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifInErrors_delta)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifInErrors_rate)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifOutErrors)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifOutErrors_prev)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifOutErrors_delta)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifOutErrors_rate)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifInOctets)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifInOctets_prev)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifInOctets_delta)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifInOctets_rate)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifOutOctets)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifOutOctets_prev)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifOutOctets_delta)
- [[1;31mFAIL[0m] Database: incorrect column (ports/ifOutOctets_rate)
- [[1;31mFAIL[0m] Database: incorrect column (ports/poll_time)
- [[1;31mFAIL[0m] Database: incorrect column (ports/poll_prev)
- [[1;31mFAIL[0m] Database: incorrect column (ports/poll_period)
- [[1;31mFAIL[0m] 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):
- [[1;34mFIX[0m]:
- [1;34mRun the following SQL statements to fix.[0m
- SQL Statements:
- ALTER TABLE `alert_location_map` CHANGE `id` `id` int(10) unsigned NOT NULL auto_increment;
- ALTER TABLE `alert_location_map` CHANGE `rule_id` `rule_id` int(10) unsigned NOT NULL ;
- ALTER TABLE `alert_location_map` CHANGE `location_id` `location_id` int(10) unsigned NOT NULL ;
- ALTER TABLE `bgpPeers` CHANGE `bgpPeer_id` `bgpPeer_id` int(10) unsigned NOT NULL auto_increment;
- ALTER TABLE `bgpPeers` CHANGE `device_id` `device_id` int(10) unsigned NOT NULL ;
- ALTER TABLE `bgpPeers` CHANGE `vrf_id` `vrf_id` int(10) unsigned NULL ;
- ALTER TABLE `bgpPeers` CHANGE `bgpPeerRemoteAs` `bgpPeerRemoteAs` bigint(20) NOT NULL ;
- ALTER TABLE `bgpPeers` CHANGE `bgpPeerLastErrorCode` `bgpPeerLastErrorCode` int(11) NULL ;
- ALTER TABLE `bgpPeers` CHANGE `bgpPeerLastErrorSubCode` `bgpPeerLastErrorSubCode` int(11) NULL ;
- ALTER TABLE `bgpPeers` CHANGE `bgpPeerInUpdates` `bgpPeerInUpdates` int(11) NOT NULL ;
- ALTER TABLE `bgpPeers` CHANGE `bgpPeerOutUpdates` `bgpPeerOutUpdates` int(11) NOT NULL ;
- ALTER TABLE `bgpPeers` CHANGE `bgpPeerInTotalMessages` `bgpPeerInTotalMessages` int(11) NOT NULL ;
- ALTER TABLE `bgpPeers` CHANGE `bgpPeerOutTotalMessages` `bgpPeerOutTotalMessages` int(11) NOT NULL ;
- ALTER TABLE `bgpPeers` CHANGE `bgpPeerFsmEstablishedTime` `bgpPeerFsmEstablishedTime` int(11) NOT NULL ;
- ALTER TABLE `bgpPeers` CHANGE `bgpPeerInUpdateElapsedTime` `bgpPeerInUpdateElapsedTime` int(11) NOT NULL ;
- and 69 more...
- [[1;33mWARN[0m] Your local git contains modified files, this could prevent automatic updates.
- [[1;34mFIX[0m]:
- [1;34mYou can fix this with ./scripts/github-remove[0m
- Modified Files:
- LibreNMS/Alert/AlertUtil.php
- html/.htaccess