Skip to content

Instantly share code, notes, and snippets.

View tpokorra's full-sized avatar

Timotheus Pokorra tpokorra

35 followers · 1 following
View GitHub Profile
@tpokorra
tpokorra / session.aspx
Last active July 21, 2019 18:54
Testing Sessions with aspx on Mono
<%@ Page Language="C#" src="session.aspx.cs" %>
<html xmlns="www.w3.org/1999/xhtml">
<%@ Import Namespace="System.Threading" %>
<head runat="server">
<title></title>
</head>
<body>
<div>
<%
Response.Write( "Hello World<br/>");
@tpokorra
tpokorra / profile_db_generator.rb
Last active October 3, 2018 03:17
Discourse generator of a test database
# 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
@tpokorra
tpokorra / exporting-documents-knowledgetree.py
Last active September 21, 2018 04:38
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 January 17, 2018 14:55
only use this as a reference, don't run it
#!/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 08:31
Reverse a SEPA direct debit file to a direct credit file / Lastschriften in Überweisungen konvertieren
<?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 March 31, 2017 07:40
msbuild spec file for RPM package
# 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
@tpokorra
tpokorra / dplyKolab16.sh
Last active December 14, 2016 12:05
#!/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
@tpokorra
tpokorra / createkolabusers.py
Last active June 6, 2019 09:21
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()
@tpokorra
tpokorra / timesheetng_mysqli.patch
Created April 25, 2016 07:59
--- 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());
@tpokorra
tpokorra / NAnt.exe.config
Last active February 8, 2022 16:14
<?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" />