Maximilian Thoma lanbugs

## 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)

## 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 = ""

## 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__)

## 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/


## 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

## 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()

## 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()

## 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

## 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

## multiprocessing_with_result.py
#!/usr/bin/env python
# -*- encoding: utf-8; py-indent-offset: 4 -*-

import os
from multiprocessing import Pool


def worker(job):
    x, y = job
    result = x ** y