Skip to content

Instantly share code, notes, and snippets.

View derekmurawsky's full-sized avatar

Derek Murawsky derekmurawsky

19 followers · 18 following
View GitHub Profile
@derekmurawsky
derekmurawsky / commands.sh
Last active July 23, 2021 15:21
Do a rudimentary transcription using vosk
# Largely followed this post https://itectec.com/ubuntu/ubuntu-speech-recognition-app-to-convert-mp3-to-text/
# Download the show, https://selfhosted.show/49
wget https://aphid.fireside.fm/d/1437767933/7296e34a-2697-479a-adfb-ad32329dd0b0/1cbfb286-6182-404e-a59b-e969e60c7a44.mp3
# Convert it into the format vosk is epxecting
ffmpeg -i downloaded-mp3-file.mp3 -ar 16000 -ac 1 file.wav
# Install vosk
pip3 install vosk
@derekmurawsky
derekmurawsky / .gitmessage.txt
Created October 24, 2019 14:34
git commit message template
# < declarative subject > (Max 50 char)
# One of ["feat","fix","docs","style","refactor","perf","test","chore"]:
# |<---- Using a Maximum Of 50 Characters ---->|
# Explain why this change is being made
# |<---- Try To Limit Each Line to a Maximum Of 72 Characters ---->|
# More detailed explanatory text, if necessary. The blank line
@derekmurawsky
derekmurawsky / setupMacEnvironment.sh
Last active March 19, 2019 19:23
Environment Setup
# Install homebrew
/usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
# Install basics
brew install git python nmap docker node nvm wget jq cookiecutter curl git nano
brew cask install iterm2 google-chrome
# Manually configure iterm2 with pro theme from the below clone
git clone https://github.com/mbadolato/iTerm2-Color-Schemes.git
@derekmurawsky
derekmurawsky / gist:0324e36e6fdfc58ca4a934302b8cc78e
Created March 1, 2017 17:27
keybase.md
### Keybase proof
I hereby claim:
* I am derekmurawsky on github.
* I am dmurawsky (https://keybase.io/dmurawsky) on keybase.
* I have a public key whose fingerprint is D0A7 74AE F15D 01B7 DA66 39E9 05F7 5B3B 7816 E0AE
To claim this, I am signing this object:
@derekmurawsky
derekmurawsky / get-sslSigningAlgorithm.ps1
Last active May 9, 2016 22:38
Check for certificate signing algorithm from a web server using powershell. Based on the Test-WebServerSSL cmdlet from http://en-us.sysadmins.lv/Lists/Posts/Post.aspx?List=332991f0-bfed-4143-9eea-f521167d287c&ID=60 which is the same as https://pspki.codeplex.com/wikipage?title=Test-WebServerSSL I think. Modified with input from the Philly Powers…
function get-SSLSigningAlgorithm {
[CmdletBinding()]
param(
[Parameter(Mandatory = $true, ValueFromPipeline = $true, Position = 0)]
[string]$URL,
[Parameter(Position = 1)]
[ValidateRange(1,65535)]
[int]$Port = 443,
[Parameter(Position = 2)]
[Net.WebProxy]$Proxy,
@derekmurawsky
derekmurawsky / forfiles.bat
Created February 25, 2014 14:43
A simple way to delete files older than X days in windows. This command is native and works as far back as server 2003.
REM Deletes files in specified path older than X days.
forfiles -p "C:\path\to\files" -s -m *.* -d -360 -c "cmd /c del @path"
REM Alternate way to do it. Deletes all files in current directory older than X days.
forfiles -s -m *.* -d -360 -c "cmd /c del @path"
@derekmurawsky
derekmurawsky / gist:8651988
Created January 27, 2014 16:35
MSSQL statement to add a user to all databases on a server as a datareader.
sp_msforeachdb 'use [?]; CREATE USER [MyDBUser] FOR LOGIN [MyDBLogin];EXEC sp_addrolemember ''db_datareader'', ''[MyDBUser]'''
@derekmurawsky
derekmurawsky / gist:7991224
Last active December 31, 2015 13:09
Show which DB backups go with which databases. By Ryan K https://gist.github.com/rkucsera, not me. Just very useful and I want to track it here.
SELECT
CONVERT(CHAR(100), SERVERPROPERTY('193199-WEB1')) AS Server,
msdb.dbo.backupset.database_name,
msdb.dbo.backupset.backup_start_date,
msdb.dbo.backupset.backup_finish_date,
msdb.dbo.backupset.expiration_date,
CASE msdb..backupset.type
WHEN 'D' THEN 'Database'
WHEN 'L' THEN 'Log'
END AS backup_type,
@derekmurawsky
derekmurawsky / gist:7873501
Created December 9, 2013 14:58
When you renew a certificate through the GoDaddy control panel, you will need to manually assign the private key to the certificate after import. This is the command to do so. From: http://support.microsoft.com/kb/889651
certutil -repairstore my "SerialNumber"
@derekmurawsky
derekmurawsky / gist:7758750
Last active December 30, 2015 01:49
There is an easier way: https://pspki.codeplex.com/discussions/567710#post1305701 Rackspace generates CSRs and Private keys as encoded text. To create a Windows compatible cert with embedded key, you need to use OpenSSL. This is the command to package them together. Originally from http://pic.dhe.ibm.com/infocenter/idshelp/v117/index.jsp?topic=%…
# CertUtil - Key must be in a .KEY file and must have the same base file name as the cert.
certutil –MergePFX certfile.cer certfile.pfx
# Old method, using OpenSSL
openssl pkcs12 -export -inkey MyCert.pem -in MyCert.crt -out MyCert.p12