Common
SSH Key Management
20. May 2014

As it is with passwords, one may also have multiple ssh keys on multiple pc’s. I use subdirs in the ssh folder to maintain multiple ssh keys. The following example examines this for my github ssh key.

Common

Sometimes one may want to define a specific OU as default location for newly joined computers in an Active Directory Domain. This can be done very easy: redircmd <OU> redircmd OU=Clientrechner,OU=main-location,DC=my,DC=domain,DC=de  

Common
Deploy Acrobat Reader via MS-AD GPO
25. April 2014

Download Adobe Reader: ftp://ftp.adobe.com/pub/adobe/reader/win/11.x/11.0.06/de_DE/ Adobe Reader Customization Wizard: ftp://ftp.adobe.com/pub/adobe/acrobat/win/11.x/11.0.00/misc/ Extract Acrobat Reader AdbeRdr11006_de_DE.exe -nos_o”MyFolder” -nos_ne Customize load msi package in Customization Wizard define your settings write transform-file by “Transform–>Write Transform” menu  Set GPO Add MSI package to software installation GPO add mst package as modification in advanced deployment step    

Common
Analyse MySQL diskusage
20. March 2014

It may happen that your mysql instances face some diskspace problems. Usually this is an application-side problem. Following steps may help to identify the bogus points. Show databases and their sizes SELECT table_schema “DB Name”, Round(Sum(data_length + index_length) / 1024 / 1024, 1) “DB Size in MB” FROM information_schema.tables GROUP BY table_schema; Display table information […]

Common

If you use curl to get some json in your shell and try to read what you got, this is no fun. I discovered jq as a very nice commandline tool to format json output. Fetching graphite time-series data is a good example on how to use jq. curl -s “http://graphite_host/render?target=my.host.system.cpu.total.*&format=json&from=-5min” | jq ‘.’ [ { “datapoints”: […]