Skip to content

Instantly share code, notes, and snippets.

View rjaeckel's full-sized avatar

Robert Jäckel rjaeckel

3 followers · 1 following
  • IT-Servicezentrum, Uni Halle
View GitHub Profile
@rjaeckel
rjaeckel / era_api.cs
Last active January 12, 2023 13:14
ESET Protect Server API c#
using System;
using System.IO;
using System.Runtime.InteropServices;
using System.Text.Json;
using System.Text.Json.Nodes;
namespace ERA_Api {
public class Program {
public static void Main() {
try {
@rjaeckel
rjaeckel / keybase.md
Last active April 27, 2018 09:12

Keybase proof

I hereby claim:

  • I am rjaeckel on github.
  • I am jackkill (https://keybase.io/jackkill) on keybase.
  • I have a public key ASAe83YCRv5YuNIqTMCQIgSHgNNNz3K_7jSv8YkIECGuoQo

To claim this, I am signing this object:

@rjaeckel
rjaeckel / smtp-verify.sh
Created April 18, 2016 12:40
#!/bin/bash
#
# smtp email address verification
# using dig and netcat
#
# authored by robert.jaeckel@itz.uni-halle.de
#
checkaddr=$1
@rjaeckel
rjaeckel / lazydb.vb
Created October 14, 2015 11:45
Visual Basic DB Interface implemening IDisposable to connect and disconnect the Database
Imports System.Data.OleDb, Type = System.Data.OleDb.OleDbType
Public Class lazyDb
Implements IDisposable
Public Shared conCfg As String
Private db As OleDbConnection
Sub New()
db = New OleDbConnection(conCfg)
db.Open()
@rjaeckel
rjaeckel / lddcopy.sh
Last active August 29, 2015 14:27
When chroot-ing a program, you have to copy the necessary libraries for it under the chroot-ed directories. It is sometimes a troublesome task as some libraries may have some dependencies on other libraries as the program itself does. This script, lddcopy.sh, is a convenient shell script which copies all the necessary libraries recursively and p…
#!/bin/sh
########################################################################
# lddcopy - A shell script to copy libraries for chrooted applications #
# Yu Yagi (miriyagi@miriyagi.jp) #
########################################################################
chroot=
opterr=
dryrun=
silent=false
@rjaeckel
rjaeckel / convert2inno.sql
Last active August 29, 2015 14:18
MySQL MyISAM2InnoDB
# define schema to be updated
SET @scheme2mod="SCHEMA_XYZ";
# create queries to drop fulltext indexes, which InnoDB is no capable of
Select concat("Alter Table ",TABLE_SCHEMA,".",TABLE_NAME," DROP INDEX ",INDEX_NAME,";") as rmIdx
FROM INFORMATION_SCHEMA.STATISTICS
WHERE
TABLE_SCHEMA=@scheme2mod
and INDEX_TYPE="FULLTEXT"
GROUP BY rmIdx
LIMIT 0,10000;
@rjaeckel
rjaeckel / oc-userstat.sql
Created November 21, 2014 10:15
SELECT Distinct a.configvalue, from_unixtime( b.configvalue ) FROM oc_preferences a
inner join oc_preferences b on b.userid=a.userid and b.configkey="lastLogin"
where a.configkey="email";
@rjaeckel
rjaeckel / update-geoip.sh
Created November 7, 2014 09:46
Maxmind GeoIP Database download
#!/bin/bash
base="http://geolite.maxmind.com/download/geoip/database/"
files="GeoLiteCountry/GeoIP GeoIPv6 GeoLiteCity GeoLiteCityv6-beta/GeoLiteCityv6 asnum/GeoIPASNum asnum/GeoIPASNumv6"
ext="dat.gz"
output="$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )"
#download
waitFor=""
for file in $files ; do
wget -q "$base$file.$ext" &
@rjaeckel
rjaeckel / webserv-sources.md
Last active August 29, 2015 14:07
Sources für Webserv Win
@rjaeckel
rjaeckel / 0_info.md
Last active April 29, 2020 06:26
Apache and nginx ciphersuite settings

  • generic cipher suites to be used:

    For Apache2.2: this enables FS on all clients ALL:!COMPLEMENTOFDEFAULT:!EXPORT:!LOW:!MD5:!aNull:!eNull:!RC4:-3DES:+ECDHE:+RSA:!DH

    Apache 2.4 with Current openssl:

    SSLCipherSuite aRSA+CHACHA20:aRSA:!kPSK:!kRSAPSK:!SHA:!NULL:!CAMELLIA:+kECDH:+kEDH:+SHA384:+SHA256:!kRSA EECDH+CHACHA20:EDH+CHACHA20:EECDH+AESGCM:EDH+AESGCM:EECDH+AES256