Skip to content

Instantly share code, notes, and snippets.

View rjaeckel's full-sized avatar

Robert Jäckel rjaeckel

3 followers · 1 following
  • Germany
View GitHub Profile
@rjaeckel
rjaeckel / PoSh_Basics.ps1
Last active February 20, 2026 22:41
PowerShell error handling
# language spec alá openApi:
# https://github.com/OpenAPITools/openapi-generator/blob/master/modules/openapi-generator/src/main/java/org/openapitools/codegen/languages/PowerShellClientCodegen.java
$WUServices = "wuauserv","bits","cryptsvc"
$WUServices | Stop-Service -Name {$_}
<# clear registry and files #>
$WUSerices[-1..-3] | Start-Service { $_ }
@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