Attempted to create a new certificate using the EasyRSA suite and got the following error: “failed to update database” Unfortunately the script is pretty laconic, but some quick testing showed this was due to trying to re-use the default display name: Name [EasyRSA]: Picked a different name and the script committed my certificate correctly.
How to Hide and Unhide Cells in Microsoft Excel
This is a great little how-to on hiding and unhiding cells in Microsoft Excel: http://spreadsheets.about.com/od/excelformatting/qt/070814unhidecol.htm
Geekworker has a new home
Please excuse the mess: We’ve moved! I got tired of my (self-hosted) wordpress site for several reasons, the main ones being: Having my own hardware in a datacenter is way too expensive WordPress ran way too slowly and I felt like I do not have the time to properly optimise it So, I’ve migrated the […]
Sony Vegas and Sony Movie Studio: No Audio Tracks In mp4 video filefound
I use OBS Studio to record videos, and would ideally like to record multiple audio tracks (so that I might balance audio levels in post-production). Unfortunately, when I import these MP4 videos into Sony Movie Studio Platinum, it detects no audio tracks. The problem is a buggy DLL file. To fix this, go to your […]
Livestreamer: Downloading Twitch Streams Results in 400 Client Error:Bad Request
I use Livestreamer to download my own VOD files when I dun goofed and break my local recordings. This used to work perfectly, but as I write this, the software is broken due to an update in the Twitch API that enforces authentication. error: Unable to open URL: https://api.twitch.tv/api/channels/havejoystick/access_token.json (400 Client Error: Bad Request) There […]
OpenVPN: IP packet with unknown IP version seen
While setting up a new OpenVPN, I got this message: Sep 23 21:05:25 ascalon openvpn[18770]: krynn/aaa.bbb.ccc.ddd:xxxxx IP packet with unknown IP version=3 seen The cause was that I had set my OpenVPN server to “dev tun”, while setting my Windows client to “dev tap” in the configuration. Changing the client to also be “dev tun” […]
Easy-RSA Jabber SSL Certificate Problems
I’m currently setting up a new server and ran into something odd. Connecting to ejabberd with Pidgin, the later would reject the SSL certificate outright. At first I thought I had messed up the hostnames, or used an outdated Hash algorithm or whatever. The errors I saw in the debug window were: (22:17:42) nss: ERROR […]
How to Disable WordPress “Prove your Humanity” captcha code question
A while back, WordPress introduced an annoying little feature, where you have to solve a simple math question in order to log in to your site: I ignored this for a while, but decided it was too much of a hassle wile offering no real benefit. However, finding a way to disable it is not […]
How to get the previous month in OpenOffice
If you need to derive the previous month from a known date, use this formula: =DATE(YEAR(A1);MONTH(A1)-1;1) This works in OpenOffice (and LibreOffice), which do not seem to have a native function to do the job, and should work in MS Office Excel as well.
iOS iTunes Remote can’t find iTunes Library
The iTunes Remote software on my iPad worked flawlessly with my Macbook Air, but not with my Windows PC. I finally decided to investigate why, and after much search and trial-and-error, I found a solution. It turns out that it gets confused by IPv6 on Windows (interestingly the same is not a problem on my […]