Vyatta is fantastic as a routing product, but one thing I always hate is having to maintain firewall rules. The web interface makes managing rules cumbersome and the command line, whilst the best way to create rules, is hopeless if you need to re-order, re-number or do any of these types of tasks. To be fair, this is a problem on most routers and is not specific to Vyatta itself.
To ease my pain, I have put together an excel spreadsheet with supporting macros that reduces the burden of creating, maintaining and adding firewall rules. It allows you to create most rules straight through the spreadsheet, with a fair degree of input validation built right in. I have tried to encompass as much of the firewall configuration options available from the Vyatta CLI straight into the spreadsheet.
The best part is the macro behind the scenes that will present a form and text box with your CLI commands ready to copy and paste into your console window.
Please test and give me any feedback on bugs, irritations or suggestions in the comments area. I must confess that I have never done any Excel VBA programming before, so there may be better or more efficient ways to code the back end. If you have any suggestions on the VBA code, let me know
Note 1: I created this in Excel 2010, but it should be backwards compatible with Excel 2007. If there is enough demand, I’ll port it back to the Office 97-2003 format as well.
Note 2: I have protected the worksheet, preventing any changes to any part of the spreadsheet, except for data entry positions. There is no password however, so feel free to un-protect and mess around. Please send me any changes or suggestions you come up with and I’ll incorporate into the next release.
Download: Vyatta Firewall Generator, 0.1