Category: Snippet

  • Snippet/Techy: Fixing Debian Signatures were invalid – Key Expired

    If you are running Debian/Ubuntu and you are getting “The following signatures are invalid” when running apt-get commands (such as apt-get upgrade) and the error looks like: Reading package lists… Done W: An error occurred during the signature verification. The repository is not updated and the previous index files will be used. GPG error: http://repo.mysql.com […]

  • What a broken week

    With my car already being a bit broken (a wall jumped out of it on the 15th of June and it’s not getting repaired until the 14th of August), my wife broke on Sunday, the washing machine keeps breaking down and now the kettle has gone kaput. On the plus side, the boiler (in the […]

  • Extract referers from Apache logs

    This quick awk one-liner (tested on Linux) will extract all referer (referrer) entries from a combined Apache log file (called LOGFILE) excluding entries such as “”, “-“, (empty) and ones containing DOMAIN. Useful if you want to check where external referers are coming from awk ‘($11 !~ /^”?-?”?$/ && $11 !~ /DOMAIN/) {print $11}’ LOGFILE

  • What I’d like from a Sat-Nav system

    Just a few bullet points about some features which would encourage me to buy a new Sat Nav: Able to set route via computer I can tweak a route via Google Maps to avoid areas I don’t like for whatever reason, or to “swing by” places – I’d love to be able to just then […]

  • Snippet: Define “TV Show: Knightmare”

    Knightmare: The TV show where a strange man blinds children, puts them in hazardous situations and makes them get food and “potions” from strangers after manipulating them – all whilst keeping the kid’s friends hostage. When it’s put like that, no wonder it was taken off TV!