Skip to content

Instantly share code, notes, and snippets.

Timotheus Pokorra tpokorra

View GitHub Profile
@tpokorra
tpokorra / profile_db_generator.rb
Last active Oct 3, 2018
Discourse generator of a test database
View profile_db_generator.rb
# can be used to generate a mock db for profiling purposes
# we want our script to generate a consistent output, to do so
# we monkey patch array sample so it always uses the same rng
class Array
RNG = Random.new(1098109928029800)
def sample
self[RNG.rand(size)]
end
View exporting-documents-knowledgetree.py
import MySQLdb
import os
import shutil
# KnowledgeTree default place to store documents
ktdocument = '/var/www/ktdms/Documents/'
conn = MySQLdb.connect(user='', passwd='',db='', charset="utf8", use_unicode=True)
cursor = conn.cursor()
@tpokorra
tpokorra / cleanupcyrusmailboxes.sh
Created Jan 17, 2018
only use this as a reference, don't run it
View cleanupcyrusmailboxes.sh
#!/bin/bash
if [ -z "$1" ]
then
echo "$0 <user> <domain> <folder>"
echo "for example: $0"' "my.user" mydomain.com "Anfragen"'
echo "for a deleted mailbox: $0"' "test.test" test.tbits.net "test" "test" 1'
exit
fi
@tpokorra
tpokorra / reverseSEPA.php
Last active May 5, 2017
Reverse a SEPA direct debit file to a direct credit file / Lastschriften in Überweisungen konvertieren
View reverseSEPA.php
<?php
require __DIR__ . '/vendor/autoload.php';
use AbcAeffchen\Sephpa\SephpaCreditTransfer;
$xmlstring = file_get_contents("201704.xml");
$executiondate ='2017-05-08';
$creationdate='2017-05-05:T00:38:44';
$records = new SimpleXMLElement($xmlstring, LIBXML_NOCDATA);
@tpokorra
tpokorra / msbuild.spec
Last active Mar 31, 2017
msbuild spec file for RPM package
View msbuild.spec
# Note: this only works if you are able to modify /etc/os-release!
# for some reason, we cannot build on CentOS7, but only if we pretend to be Ubuntu 16.04!
Name: msbuild
Version: 15.1
Release: 1%{?dist}
Summary: The Microsoft Build Engine is a platform for building applications.
License: MIT
URL: https://github.com/Microsoft/msbuild
View dplyKolab16.sh
#!/bin/bash
branch=Kolab16
# we need a fully qualified domain name
hostnamectl set-hostname $branch.demo.example.org
yum install -y wget which bzip2 mailx selinux-policy-targeted
# disable SELinux
sed -i 's/enforcing/permissive/g' /etc/selinux/config
View createkolabusers.py
import pykolab
from pykolab.translate import _
from pykolab import utils
log = pykolab.getLogger('pykolab.cli')
conf = pykolab.getConf()
def run():
from pykolab import wap_client
wap_client.authenticate()
View timesheetng_mysqli.patch
--- mysql.db.inc.orig 2016-04-25 09:40:40.329052075 +0200
+++ mysql.db.inc 2016-04-25 09:58:47.650099683 +0200
@@ -5,10 +5,14 @@
//Should have plug in compatibility.
function dbConnect() {
+ global $dbh;
$GLOBALS["CONNECTED_MYSQL_DB_INC"] = 1;
global $DATABASE_HOST, $DATABASE_USER, $DATABASE_PASS, $DATABASE_DB;
- $dbh = mysql_pconnect("$DATABASE_HOST","$DATABASE_USER","$DATABASE_PASS") or die("Unable to connect to SQL server: ". mysql_error());
View NAnt.exe.config
<?xml version="1.0"?>
<configuration>
<!-- Leave this alone. Sets up configsectionhandler section -->
<configSections>
<section name="nant" type="NAnt.Core.ConfigurationSection, NAnt.Core" />
<section name="log4net" type="System.Configuration.IgnoreSectionHandler" />
</configSections>
<appSettings>
<!-- Used to indicate the location of the cache folder for shadow files -->
<add key="shadowfiles.path" value="%temp%\nunit20\ShadowCopyCache" />
@tpokorra
tpokorra / lxc-pi
Created Jan 20, 2016
lxc container Raspberry Pi
View lxc-pi
#!/bin/bash
#
# lxc: linux Container library
# Authors:
# Original Debian:
# Daniel Lezcano <daniel.lezcano@free.fr>
# Changes for Raspberry Pi by:
# Oliver Heller <oliver@d24m.de>
You can’t perform that action at this time.