No BGP info for Juniper BGP peers #5531

Closed
BradHooper opened this Issue Jan 20, 2017 · 3 comments

Projects

None yet

2 participants

@BradHooper
BradHooper commented Jan 20, 2017 edited

After recent SQL changes ( #5420 ) all BGP peers have been removed from the bgpPeers_cbgp table for all Juniper devices.

This is happening on 20+ devices. Can provide full debug via email/IRC.

DO NOT DELETE THIS INFORMATION.

Please read this information carefully.

GitHub issues is for feature requests or bugs, please do not post issues asking for help or how to do X, Y or Z.
You can use our irc channel ##librenms on freenode to ask questions or our community site.

Please confirm each of the sections below by putting an x in the box like [x].

  • Is your install up to date? Updating your install
    Please do not submit an issue if your install is not up to date within the last 24 hours or on a stable monthly release.
  • Please include all of the information between the ==================================== section of ./validate.php which you can run from the cli.
  • Unless your issue is for a WebUI fix or feature then please provide ALL info asked for here.
  • Please provide as much detail as possible.
  • Please do NOT post more than 10 lines of debug information here, use a pastebin service or GitHub Gists.
Component Version
LibreNMS d83d08e
DB Schema 156
PHP 7.0.12
MySQL 5.5.50-MariaDB
RRDTool 1.4.8
SNMP NET-SNMP 5.7.2

-bash-4.2$ cat bgpdebug | grep 1.1.1.1
Found peer 1.1.1.1 (AS666)
[7.ipv4.210.9.30.254.1.1.1.1.1] => Array
peerindex for ipv4 1.1.1.1 is 2
SQL[SELECT COUNT() from bgpPeers WHERE device_id = '63' AND bgpPeerIdentifier = '1.1.1.1']
SQL[UPDATE bgpPeers set bgpPeerRemoteAs ='666',astext ='' WHERE device_id='63' AND bgpPeerIdentifier='1.1.1.1']
.SQL[SELECT COUNT(
) from bgpPeers_cbgp WHERE device_id = '63' AND bgpPeerIdentifier = '1.1.1.1' AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO bgpPeers_cbgp (device_id,bgpPeerIdentifier,afi,safi) VALUES ('63','1.1.1.1','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE device_id = '63' AND bgpPeerIdentifier = '1.1.1.1']
SQL[DELETE FROM bgpPeers_cbgp WHERE device_id = '63' AND bgpPeerIdentifier = '1.1.1.1' AND afi='ipv4' AND safi='unicast']

@laf
Member
laf commented Jan 20, 2017

Can you try reverting to this commit pls:

9fa8485

If that works I think what's happened is that this has always been broken but the data could not be deleted before, now that's fixed it is :)

@BradHooper

Yeah understand the delete now works correctly. I've just rolled back and now bgpPeers_cbgp is populating.

@laf
Member
laf commented Jan 20, 2017

Can you post a debug output for this, an snmpwalk would be ace as well.

@laf laf added a commit to laf/librenms that referenced this issue Jan 21, 2017
@laf laf fix: Fixed JunOS bgpPeers_cbgp mistakenly removed + better support fo…
…r mysql strict mode #5531
a8b8a39
@laf laf removed the Needs-Info label Jan 21, 2017
@laf laf closed this in #5536 Jan 22, 2017
@laf laf added a commit that referenced this issue Jan 22, 2017
@laf laf fix: Fixed JunOS bgpPeers_cbgp mistakenly removed + better support fo…
…r mysql strict mode #5531 (#5536)
53df1d0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment