View SQLiteToMemory.py
#!/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 |
View read_postfix_db.py
#!/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) |
View transport_generator.py
#!/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 = "" |
View flask_write_put_to_file.py
#!/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__) |
View cisco_inventory.py
#!/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/ |
View search_linenumber.py
#!/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 |
View search_and_replace_p2.py
#!/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() |
View search_and_replace_p3.py
#!/usr/bin/env python3 | |
import fileinput | |
import re | |
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) | |
print(line, end='') | |
file.close() |
View age_of_file.py
#!/usr/bin/env python | |
import datetime | |
import os | |
file_mod_time = datetime.datetime.fromtimestamp(os.path.getmtime('foobar.txt')) | |
today = datetime.datetime.today() | |
age = today - file_mod_time |
View damaged_utf8.py
#!/usr/bin/env python | |
name_kaputt = 'Gesch\xc3\xa4ftsstelle' | |
name = ''.join(chr(ord(c)) for c in name_kaputt).decode("utf-8") | |
print name_kaputt | |
print name | |
# Before: Geschäftsstelle | |
# Result: Geschäftsstelle |
NewerOlder