Wednesday, April 24, 2024
 Popular · Latest · Hot · Upcoming
2
rated 0 times [  2] [ 0]  / answers: 1 / hits: 3845  / 3 Years ago, fri, may 28, 2021, 2:59:38

I would like to obtain ARP tables from a switch to a syslog server (Ubuntu 12.04 LTS). I have done some research on how to do it and I decided to use SNMP. I have done some research and I know that my server will be the manager whereas the switch will act as an agent. My problem is, i am not quite sure of the process of getting the arp tables and having them directed to the mysql database in my server.


More From » server

 Answers
6

There are a number of software solutions that can poll network devices via SNMP and store their MAC address tables in a SQL database. Generally, their functionality includes a great deal more than what you are asking for in your question.



Before installing the software on a server, it is important to note that you should have administrative access to the network devices, or at the very least, permission to query the devices in question. Either you, or your IT support folks, will need to configure the switches with permit SNMP string as well as permit SNMP queries from the server IP/subnet that it resides on. How these device are configured is vendor dependant and beyond the apparent scope of your question.



One example of such a tool available for Ubuntu is Netdisco.



Per their website, Netdisco is a software package that maintains "Configuration information and connection data for network devices [that is] ... retrieved via SNMP. Data is stored using a SQL database for scalability and speed. Layer-2 topology protocols such as CDP and LLDP provide automatic discovery of the network topology."





While there is a package available for install from the Ubuntu repositories (see netdiso-common, netdisco-backend, and netdisco-frontend) it is somewhat outdated. A more recent version can be installed from source on their site.



Another example would be IPPlan which focuses on IP Address Management(IPAM), DNS and circuit management. IPPLAN polls via the ucd-snmp package and NMAP and can map IP addresses to MAC addresses in a variety of SQL databases.





Also, you may want to take a look at Switchmap.





While it does not store its data in SQL, it creates CSV files which can then be poured into a SQL database, if desired.



There are a number of other solutions out there (both commercial and free). I only mention these as I have had direct experience installing, configuring, and managing these software packages.


[#29858] Sunday, May 30, 2021, 3 Years  [reply] [flag answer]
Only authorized users can answer the question. Please sign in first, or register a free account.
sweetrifiabl

Total Points: 422
Total Questions: 94
Total Answers: 120

Location: Bonaire
Member since Sat, Sep 24, 2022
2 Years ago
sweetrifiabl questions
Mon, Apr 4, 22, 16:02, 2 Years ago
Sat, Jul 17, 21, 01:40, 3 Years ago
Thu, Nov 18, 21, 17:36, 2 Years ago
Mon, Jan 17, 22, 19:02, 2 Years ago
;