robin-collins / dhcp_static_host_list_creator Goto Github PK

Scripts to create and convert DHCP static host assignments for pfSense, OPNsense, Edgerouter, and VyOS devices.

It is painstaking to add static dhcp hosts to firewalls/routers when you have lots of MAC addresses, IPs, and Hostnames to work with. These scripts can help. Currently there are two -

1. pfSense dhcp static host list creator - csv2pf_dhcp_statics.py
2. pfSense/OPNSense config file to Edgerouter/VyOS config script converter - pf2vy_dhcp_statics.py

This is a script to create a pfSense config from a CSV file list in the following format on each line of the CSV file -

mac,IP,hostname,description

This will import the file 'host-list.csv' from the current directory and output the file 'static-dhcp-maps.xml' that can be imported into pfSense using the GUI Backup & Restore page. There is an example host-list.csv file in the repo.

There are several variables at the top of the script that can be modified to suit your environment. Any other DHCP options can be added or modified between the <> and </> tags further down in the script. NOTE: Importing this file into pfSense WILL overwrite ALL DHCP server settings! So make sure you know what you are doing. Always make config backups!

This script takes a config backup file from pfSense or OPNSense and converts it to a configuration script that can be copied and pasted into an Edgerouter or VyOS command line configuration prompt. The config backup file from pfSense or OPNSense can be a full config backup or just a config backup of the DHCP Server. Save the file in the same directory as the script and run the script. The script will output a text file. The contents of this file can be pasted into the configuration prompt of your Edgerouter or VyOS device to configure all of your static dhcp hosts.

The DHCP subnet, input file name, and output file name can easily be modified at the top of the script before running to fit your environment.