Author: geekworker
-
Easy-RSA: “failed to update database”
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 […]
