Skip to content

Instantly share code, notes, and snippets.

View tpokorra's full-sized avatar

Timotheus Pokorra tpokorra

View GitHub Profile
tpokorra /
Created November 29, 2022 14:46
# run in a cronjob, once a week
# see conditions at
# see country codes at
# use space to separate multiple country codes
tpokorra /
Last active August 12, 2022 05:12
Update WKD for PGP/GnuPG Keys on Hostsharing
if [ -z $1 ]
echo "Bitte den Pfad für die Datei mit dem öffentlichen Key mitgeben: z.B. $0 ~/public.txt"
publickeyfile=$(realpath $1)
if [ ! -f $publickeyfile ]
tpokorra /
Created October 26, 2021 15:13
get closed issues from a milestone as preparation for OpenPetra release
import requests
import json
url = ""
milestone = "17"
S = requests.Session()
headers = {'Accept': 'application/vnd.github.v3+json'}
# see
tpokorra / dyndns.php
Last active June 2, 2021 04:11
dyndns mit Hostsharing
// zum Aktualisieren der IP Adresse:
if (!isset($_GET['domain'])) {
die('Die Angabe der Domain fehlt.');
$domain = $_GET['domain'];
$filename = "/home/pacs/xyz00/users/dyndns/doms/";
tpokorra /
Created April 3, 2021 04:26
fix mediawiki mysql database, replace Umlaut, when converting from latin1 to utf-8
# first call:
# mysqldump --add-drop-table database_to_correct | replace CHARSET=latin1 CHARSET=utf8 | iconv -f latin1 -t utf8 | mysql database_to_correct --default_character_set utf8 > fixed.sql
# then run this script
out = open("converted.sql", "w")
with open('fixed.sql', encoding='utf8') as f:
for line in f:
line = line.replace('CHARACTER SET latin1 COLLATE latin1_bin', 'CHARACTER SET utf8 COLLATE utf8_bin')
line = line.replace('â<80><93>', '-')
tpokorra /
Last active March 25, 2021 21:35
Arrange Photos into directories per day
import os
import pathlib
from datetime import datetime
for file in os.listdir("."):
if file.endswith(".jpg") or file.endswith(".3gp"):
if '_' in file:
date = datetime.strptime(file.split("_", 2)[1], '%Y%m%d')
datestr = date.strftime('%m/%d/%Y')
tpokorra / builder.cs
Last active October 18, 2019 19:37
simple c# build tool as alternative to xbuild
// a simple alternative to xbuild
// parse sln and csproj files, and call mcs to compile the projects.
// can only build libraries at the moment
// Copyright: Timotheus Pokorra <>
// License: MIT
// to build: mcs builder.cs -r:System.Xml.Linq
using System;
using System.IO;
using System.Diagnostics;
using System.Xml.Linq;
tpokorra / testSendMail.cs
Created October 8, 2019 05:19
Test sending Mail with Ict.Common.IO and MimeKit
// mcs testSendMail.cs -r:System.Data -r:delivery/bin/Ict.Common.IO.dll -r:delivery/bin/Ict.Common.dll -r:delivery/bin/MimeKit.dll
using System;
using System.Runtime.InteropServices;
using System.Threading;
using System.Collections;
using System.Collections.Specialized;
using System.Dynamic;
using System.Globalization;
tpokorra / Dockerfile.test
Last active August 19, 2019 20:40
Fedora Docker image with systemd inside
# see
FROM fedora:30
ENV container docker
RUN dnf -y install net-tools openssh-server glibc-locale-source passwd
RUN mkdir /var/run/sshd
# create host ssh key
RUN ssh-keygen -t rsa -f /etc/ssh/ssh_host_rsa_key -N ''
# SSH login fix. Otherwise user is kicked off after login
tpokorra /
Last active July 15, 2019 20:38
Build NuGet 5 with Mono and mcs compiler for Fedora
if [ 1 -eq 1 ]; then
cd $path/build/Shared
echo "**** building `pwd`/ ****"
for f in *.cs
sed -i "s/internal/public/g" $f