Press "Enter" to skip to content

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 jessie InRelease: The following signatures were invalid: KEYEXPIRED 1487236823 KEYEXPIRED 1487236823 KEYEXPIRED 1487236823

W: GPG error: http://nginx.org jessie InRelease: The following signatures were invalid: KEYEXPIRED 1471427554
W: Failed to fetch http://repo.mysql.com/apt/debian/dists/jessie/InRelease

W: Some index files failed to download. They have been ignored, or old ones used instead.

As root run:
for K in $(apt-key list | grep expired | cut -d'/' -f2 | cut -d' ' -f1); do sudo apt-key adv --recv-keys --keyserver keys.gnupg.net $K; done

Source: http://serverfault.com/a/615362/12514

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 property we are renting) seems to be semi working again. *sigh*

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 click “Send to Satnav” and for it to be picked up
Traffic planning
Will it be quicker for me to go via the A50 or the M1 tomorrow morning and what time should I leave to be at my destination for 8.50am? Surely Satnavs can get traffic reports, trend them over time, and then suggest the best route for the time of day (and flag if the traffic flow is already appearing different today as opposed to yesterday/last week)
Alternative transportation options
Could it even be faster for me to not drive to my destination, but to drive to one of Leicester’s Park and Ride facilities and then catch the bus in from there? How about drive to Loughborough train station and then catch the train in? If I could set a “Petrol costs XX much, a day parking costs XX, trains from YY costs XX, park and rides cost XX: which would be the cheapest/quickest/most reliable routes?”

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!