Skip to content

Instantly share code, notes, and snippets.

View lanbugs's full-sized avatar

Maximilian Thoma lanbugs

15 followers · 2 following
View GitHub Profile
@lanbugs
lanbugs / search_and_replace_p2.py
Created June 22, 2018 22:46
Search and replace in file with python 2.x
#!/usr/bin/env python
import fileinput
import re
import sys
file = fileinput.FileInput("/etc/ssh/sshd_config", inplace=True, backup=".bak")
for line in file:
line = re.sub(r".*Banner.*","Banner /etc/issue.net", line)
sys.stdout.write(line)
file.close()
@lanbugs
lanbugs / search_linenumber.py
Created June 22, 2018 22:48
Search in file and get line number with python
#!/usr/bin/env python
filename = 'test.txt'
search = 'foobar'
with open(filename) as f:
for num, line in enumerate(f, 1):
if search in line:
print '%s - found at line:' % search, num
@lanbugs
lanbugs / flask_write_put_to_file.py
Created June 27, 2018 21:19
Backup Cisco configuration by write event to external server - Example for Flask
#!/usr/bin/env python
# -*- coding: utf-8 -*-
# write config to file with cisco archive command
# see more in blog article: https://lanbugs.de/netzwerktechnik/hersteller/cisco/cisco-python-backup-der-konfiguration-bei-write-event-auf-externen-server/
from flask import Flask
from flask import request
app = Flask(__name__)
@lanbugs
lanbugs / transport_generator.py
Created July 5, 2018 17:42
Export email aliases and domains from plesk backend database to build own transport map for Postfix
#!/usr/bin/env python
import mysql.connector
cnx = mysql.connector.connect(user='psa_readonly', password='securepassword', host='127.0.0.1', database='psa')
target = "smtp:[plesk_beckend_server.xxxx.xxx]:25"
buffer = ""
@lanbugs
lanbugs / cisco_ap_clients_grabber.py
Created June 22, 2018 21:51
Commandline Tool to export current registered users at APs from an Cisco Wireless LAN Controller (WLC)
#!/usr/bin/env python
# Need following pip packages
# - easysnmp
# - tabulate
# Checkout blog article to tool
# https://lanbugs.de/netzwerktechnik/commandline-tool-to-export-current-registered-users-at-aps-from-an-cisco-wireless-lan-controller-wlc/
from easysnmp import Session
@lanbugs
lanbugs / read_postfix_db.py
Created July 5, 2018 17:47
Read postfix databases / lookup tables with python
#!/usr/bin/env python
from bsddb3 import db
filename = "/var/spool/postfix/plesk/virtual.db"
target = "smtp:[backend_plesk_server]:25"
postfix_db = db.DB()
postfix_db.open(filename, None, db.DB_HASH, db.DB_DIRTY_READ)
@lanbugs
lanbugs / cisco_inventory.py
Created June 26, 2018 07:37
Commandline Tool for exporting Cisco Hardware Inventory via SNMP
#!/usr/bin/env python
# Need following pip packages
# - easysnmp
# - tabulate
# Checkout blog article to tool
# https://lanbugs.de/netzwerktechnik/hersteller/cisco/commandline-tool-for-exporting-cisco-hardware-inventory-via-snmp/
@lanbugs
lanbugs / SQLiteToMemory.py
Last active August 26, 2019 15:34
SQLiteDB from file to memory and back to file
#!/usr/bin/env python3
#
# SQLiteToMemory
# Python class to load sqlite3 database to memory and back to file
# Written by Maximilian Thoma 2019
# Version 0.1
#
import sqlite3
@lanbugs
lanbugs / paloalto_xmlapi.py
Created June 22, 2018 22:16
Palo Alto Networks XML API with python and beautifulsoup, example prints ARP table
#!/usr/bin/env python
# required pip packages: lxml, beautifulsoup4, tabulate
from bs4 import BeautifulSoup as BS
import urllib2
import ssl
import urllib
from tabulate import tabulate
@lanbugs
lanbugs / cisco_wlc_ap_grabber.py
Created June 22, 2018 21:45
Commandline Tool to export AP inventory from an Cisco Wireless LAN Controller WLC
#!/usr/bin/env python
# Need following pip packages
# - easysnmp
# - tabulate
# Checkout blog article to tool
# https://lanbugs.de/netzwerktechnik/hersteller/cisco/cli-tool-export-ap-inventory-from-an-cisco-wireless-lan-controller-wlc/