PostgreSQL Network Tools

Table of Contents

• PostgreSQL Network Tools
• Table of Contents
• Overview
  • File Breakdown
  • Script Overview
    • collect_eigrp.py
• Usage
  • Notes
  • Setup

Overview

This repo is dedicated to housing some utilities I've built to explore intersections between Python-based network automation and PostgreSQL database interactions.

⚠️ Use these scripts at your own risk. These have not been thoroughly tested against any specific hardware/software releases. See LICENSE for details.

⚠️ Always test code in a safe test environment before using in production environments!

File Breakdown

filename	purpose
.env.template	Use this as a template for filling out your .env file. The .env file is used for storing sensitive variables in your ENV_VARS.
.gitignore	Tells git what files to ignore tracking on.
LICENSE	Legal license for this codebase.
README.md	The file you're reading right now!
collect_eigrp.py	Script used for collecting information from EIGRP-speaking routers and storing metadata in PSQL database.
logging.conf	Logging configuration for the Python logging library. Currently unused, will use in future.
requirements.txt	Used by pip to automatically install all Python dependencies.
sql_test.py	Simple python script to test out custom SQL queries. Handy to use while developing.

Script Overview

collect_eigrp.py

This script collects live EIGRP information from Cisco routers. This is only tested to work on IOS routers, and there are likely many cases that it breaks.

From a high-level, the script:

1. Creates two tables in your PSQL DB - "inventory" and "router_neighbors."
   1. These ultimately track a full inventory of discovered routers and a full table of each router's EIGRP neighborships.
2. The script then SSHs to your "seed" router to discover its neighbors.
   1. The SSH script collects, using the netmiko library, several pieces of information about your router for inventorying.
3. Finally, the script posts that data to the appropriate DBs, and then repeats the process on the seed_router's neighbors, then their neighbors, then their neighbors' neighbors.. ad nauseum.
4. Once complete, both tables will be filled out with some helpful information on your EIGRP environment, assuming you can SSH to every device in the environment.

Usage

Notes

• You must have a dedicated PostgreSQL server built for this code to interact with.
• This code was developed using Python v3.12.5

Setup

1. Clone this repository to your machine.

2. Create a python virtual environment to contain all the code dependencies:

   # Windows CMD
   cd local-path-to-cloned-repo
   python -m venv .
   

3. Active the virtual environment on your machine.

   path/to/cloned/repo/Scripts/activate
   

4. Install all python dependencies:

   pip install -r requirements.txt
   

5. Add all relevant variables to the .env file. Make sure to rename the .env.template file to simply '.env'.

   ⚠️ NEVER share access to this file!

6. Edit the STATIC_VARS in collect_eigrp.py lines 227-232 to your values.

7. Run the python script

   python collect_eigrp.py
   

8. Pray it works! The output from the script in your terminal should give you a clue on it's status. You can also query your PostgreSQL database for results.