Skip to content

Instantly share code, notes, and snippets.

View wneessen's full-sized avatar

Winni Neessen wneessen

63 followers · 41 following
View GitHub Profile
@wneessen
wneessen / gist:774496
Created January 11, 2011 14:48
CASE COALESCE(HistoryGeneric.handle,0)
WHEN 0 THEN
CASE substring(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE
(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
Documents.Destination,' ',''),')',''),'(',''),
'-',''),'/',''),'.',''),'*',''),',',''),';',''),
'\',''),'-',''),1,1)
WHEN '1' THEN substring(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE(REPLACE(REPLACE( REPLACE(REPLACE(
REPLACE(Documents.Destination,' ',''),')',
@wneessen
wneessen / setMacDNS.sh
Created January 24, 2011 14:00
Set your MacOS X resolver using scutil for all interfaces
INTERFACES=`echo "list State:/Network/Service/[^/]+/DNS" | scutil | awk -F= '{print $2}'`
SERVER=<yourDNS>
for INTERFACE in ${INTERFACES}
do
echo "get ${INTERFACE}\nd.add ServerAddresses * ${SERVER}\nset ${INTERFACE}" | sudo scutil
done
@wneessen
wneessen / gist:809275
Created February 3, 2011 09:42
[10:39:01] sys: Available commands:
/me [text]
/topic [text]
/add [skypename]
/history
/find [text]
/fa or /
/alertson [text]
/alertsoff
/leave
@wneessen
wneessen / restart skype.cmd
Created February 14, 2011 15:33
Little Skype restart script
@ECHO OFF
:: Skype-Restart script
:: (C) 2011 by Winfried Neessen
:: Kill current skype process
taskkill /IM Skype.exe /f
:: Delete shared.xml file
del %appdata%\Skype\shared.*
@wneessen
wneessen / gist:1195161
Created September 5, 2011 14:49
[wneessen@tiger3 ~]$ ping google.de
PING google.de (209.85.148.147) 56(84) bytes of data.
64 bytes from fra07s07-in-f147.1e100.net (209.85.148.147): icmp_seq=1 ttl=56 time=8.72 ms
64 bytes from fra07s07-in-f147.1e100.net (209.85.148.147): icmp_seq=2 ttl=56 time=8.74 ms
64 bytes from fra07s07-in-f147.1e100.net (209.85.148.147): icmp_seq=3 ttl=56 time=8.55 ms
64 bytes from fra07s07-in-f147.1e100.net (209.85.148.147): icmp_seq=4 ttl=56 time=8.58 ms
64 bytes from fra07s07-in-f147.1e100.net (209.85.148.147): icmp_seq=5 ttl=56 time=8.46 ms
64 bytes from fra07s07-in-f147.1e100.net (209.85.148.147): icmp_seq=6 ttl=56 time=8.63 ms
64 bytes from fra07s07-in-f147.1e100.net (209.85.148.147): icmp_seq=7 ttl=56 time=8.57 ms
64 bytes from fra07s07-in-f147.1e100.net (209.85.148.147): icmp_seq=8 ttl=56 time=8.43 ms
@wneessen
wneessen / gist:1423596
Created December 2, 2011 15:14
1. Glühwein bestellen
Einen Glühwein bestellen geht schon mal gar nicht. Damit sagt man, dass man
'ne knickrige Sau ist, keine Freunde hat oder Antialkoholiker ist, quasi das
Allerletzte. Also immer mindestens zehn Stück bestellen.
Nie vorher abzählen, wie viele Leute um einen herum stehen und dann genau
die Anzahl bestellen!
Einfach irgendeine Zahl über die Theke grölen.
Ganz falsch: Die Umstehenden fragen, ob sie überhaupt noch einen Glühwein
haben wollen.
Wichtige Regel: Gefragt wird nicht - saufen ist schließlich kein Spaß.
@wneessen
wneessen / keybase.md
Created February 27, 2015 23:08

Keybase proof

I hereby claim:

  • I am wneessen on github.
  • I am winni (https://keybase.io/winni) on keybase.
  • I have a public key whose fingerprint is 6E9E 3C6E 8A2E B99C 3AB3 D9DD 949E 0A1B A1C6 865E

To claim this, I am signing this object:

@wneessen
wneessen / test.hcl
Last active April 17, 2020 15:58
path "*" {
capabilities = [
"create",
"update",
"read",
"delete",
"list",
"sudo"
]
}
@wneessen
wneessen / gist:1ff74ad40e492782e5881d2352b16e2c
Created July 5, 2020 09:04
info 2020-07-04 14:19:48: Logging to console and directory: '/app/data/log/2020-07-04.14-19-48' filename: log.txt
debug 2020-07-04 14:19:48: Removing old log directory '/app/data/log/2020-06-28.15-32-36'
debug 2020-07-04 14:19:48: Loaded state from file /app/data/state.json
info 2020-07-04 14:19:48: Starting zigbee2mqtt version 1.14.1-dev (commit #8f725d3)
info 2020-07-04 14:19:48: Starting zigbee-herdsman...
debug 2020-07-04 14:19:48: Using zigbee-herdsman with settings: '{"network":{"panID":6754,"extendedPanID":[221,221,221,221,221,221,221,221],"channelList":[11],"networkKey":"HIDDEN"},"databasePath":"/app/data/database.db","databaseBackupPath":"/app/data/database.db.backup","backupPath":"/app/data/coordinator_backup.json","serialPort":{"baudRate":115200,"rtscts":true,"path":"/dev/ttyACM0","adapter":"deconz"},"adapter":{"concurrent":null}}'
info 2020-07-04 14:19:48: zigbee-herdsman started
info 2020-07-04 14:19:48: Coordinator firmware version: '{"type":"ConBee2","meta":{"transportrev":0,"product":0,"m
@wneessen
wneessen / log.txt
Created July 7, 2020 14:13
info 2020-07-07 14:02:02: Logging to console and directory: '/app/data/log/2020-07-07.14-02-02' filename: log.txt
debug 2020-07-07 14:02:02: Removing old log directory '/app/data/log/2020-06-28.17-19-41'
debug 2020-07-07 14:02:02: Loaded state from file /app/data/state.json
info 2020-07-07 14:02:02: Starting zigbee2mqtt version 1.14.1-dev (commit #8f725d3)
info 2020-07-07 14:02:02: Starting zigbee-herdsman...
debug 2020-07-07 14:02:02: Using zigbee-herdsman with settings: '{"network":{"panID":6754,"extendedPanID":[221,221,221,221,221,221,221,221],"channelList":[11],"networkKey":"HIDDEN"},"databasePath":"/app/data/database.db","databaseBackupPath":"/app/data/database.db.backup","backupPath":"/app/data/coordinator_backup.json","serialPort":{"baudRate":115200,"rtscts":true,"path":"/dev/ttyACM0","adapter":"deconz"},"adapter":{"concurrent":null}}'
info 2020-07-07 14:02:02: zigbee-herdsman started
info 2020-07-07 14:02:02: Coordinator firmware version: '{"type":"ConBee2","meta":{"transportrev":0,"product":0,"m