Re: Untitled

From Jittery Lechwe, 3 Years ago, written in Plain Text.
This paste is a reply to Untitled from rmorris - go back
URL https://p.libren.ms/view/4e3f6ead
Embed
Viewing differences between Untitled and Re: Untitled
====================================
====================================
Component | Version
Version
--------- | -------
-------
LibreNMS  | 1.62-111-gd4225806a
62-111-gd4225806a
DB Schema | 2020_04_13_150500_add_last_error_fields_to_bgp_peers (164)
(164)
PHP       | 7.3.11-0ubuntu0.19.10.4
4
MySQL     | 8.0.19-0ubuntu0.19.10.3
3
RRDTool   | 1.7.1
1
SNMP      | NET-SNMP 5.7.3
====================================

3
====================================

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


Reply to "Re: Untitled"