Keep Yourself Alive (Long Lost Re-Take)

I just heard this edit of Queen’s Keep Yourself Alive for the first time and I love it. It’s longer than the original and definitely worth listening to if you know the original.

Apparently it was recorded in 1975 as a possible radio edit according to this post but it was finally released in 1991 by Hollywood Records.

This acetate first was thought to be from circa 1972. But some years ago in an interview Brian confirmed that in 1975 it was re-recorded as new version for a possibly new release. Interestingly, the “long” track is refered to as a “long lost retake” on the hollywood version.

I’d love to know what other material is in the Queen vaults waiting to be heard..

Pi-hole missing SQLite3

Pi-Hole is an ad blocker you run on a Raspberry Pi on your local network to provide ad blocking services to all the devices in your home.

A new install of Pi-Hole

When installed normally it uses Lighttpd but I already had Apache2 on my Raspberry Pi. There are a few threads and this doc about migrating to Apache2 but none of them mention SQLite3.

If you don’t have that module installed the ad blocking part will still work but the web admin will show an almost empty page. Look in /var/log/apache2/error.log and you’ll see an error like this:

PHP Fatal error: Uncaught Error: Class 'SQLite3' not found in /var/www/html/admin/scripts/pi-hole/php/database.php

It’s easy to install the SQLite3 mod for PHP:

sudo apt install php-sqlite3

Then restart Apache2

sudo service apache2 restart 

I’ve had Pi-Hole installed for years but I think I ran into the read-only problem mentioned here too. As stated in the doc above, the fix is simple. Add the Apache user to the pihole group. That will allow you to update various settings from the web admin.

sudo usermod -a -G pihole www-data