Categories
Linux

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

Categories
Linux

Infinite Bunner

Don’t need A PS5 or the latest Xbox, whatever it’s called, to have fun. Playing around with the Pi400. 🙂

Categories
Amiga

PiMIGA: Amiga on the Pi

UPDATE on Feb 15, 2021! Chris Edwards has released version 1.5 of PiMIGA. It now comes in two forms and works (sort of) on the RPI3b as well as RPi4 and 400. The two versions are a 32GB “lite” version and a 128GB “MF” version:

Lite edition, all programs and games, no videos , no mp3, all mods. MF edition, 65,000 + ADFs from the complete Commodore Amiga Tosec archive (de-duped /cleaned / virus scanned ) 128,000 executables in a 13 cd pack of stuff from eab archives of yesteryear. emulations, music, videos all sorts of goodies.

More details are to be found on his release video, including links to the torrent files for both.

UPDATE! Chris Edwards released version 1.4 of PiMIGA for the RPI4 or 400. More info in his release video here.

UPDATE! As of November 23rd 2020 there is now a PiMIGA 1.3 Pi 400 Edition thanks to Chris Edwards. This version has been cleaned up so the happynewyear96 virus has been removed, and it now works out of the box on the Raspberry Pi 400! It works on the Raspberry Pi 4 too of course. Pi3 owners will want to download the original 1.2b version. Here’s a teaser trailer.

PiMIGA 1.3 is available as a torrent, so download it with your favourite torrent client. The password on the archive is still pimiga but I haven’t tested it yet, it’s still downloading. This Reddit thread has more info and a useful comment linking to PiShrink that will reduce the size of the image from 32GB to 20GB. I am very excited about trying this on my Raspberry Pi 400!

The Commodore Amiga was an amazing 16 bit computer of the 80’s and 90’s and is still used today by people who love the system.

WinUAE is the best Amiga emulator for modern systems and it has been ported to many operating systems. FS-UAE is a great port I use on Mac and Amiberry or Amibian use the uae4arm port that runs on Raspberry Pi boards.

To load games and apps on the Amiga you used 3.5 inch discs but if you had a hard disk back then the Amiga supported it. I never did so I put up with the relatively slow loading of the discs.

As I have been spoiled by much faster loading of modern systems, loading games from discs in an emulator soon became a bore. Many games used to (slowly) load an intro with thumping music and an animation, but after hitting fire on my joystick I’d be prompted to “Enter disc 2” for yet more loading.

Enter WHDLoad, a system that patched games so they could be loaded from a hard disk image. It sounds great in theory but over the years I could never get it working the way I wanted. I just wanted to see a nice Workbench desktop UI with an disk image of games to play around in.

I’m not the only one apparently. Through this video on alternative operating systems for the Raspberry PI I found out about PiMIGA. It’s a 32GB disk image you burn to SD card for RPI 3 and 4 and when booted up presents a rather nice Workbench desktop with lots of games and apps. BTW, the password is ViWsC7oU3.

It’s based on Amiberry, and uses WHDLoad of course and everything is set up for you!

I haven’t tested it yet myself. My RPI3 is busy running Plex, Backuppc and Pihole but I want to get an RPI4 to give it a go!

Here’s a word of warning however. The video above shows a virus checker running and it finds a couple of viruses that are removed (in Amiga apps) so I would isolate the Raspberry PI device from the rest of your network if you can. Use the guest network of your router perhaps or just leave the device offline.

An alternative to PiMIGA is AmiKit which appears to do something similar but runs on Windows, Linux and Mac (and RPI4 with some fiddling around) and even lets you launch Windows, Linux or Mac apps from within Workbench. It looks rather nice!

Categories
Linux

One of those rare bugs

I can’t login to my Raspberry PI3. When I ssh into it the password is rejected. When I plugged a keyboard and HDMI cable in the login would fail silently at first and then after reboot it would tell me the password was wrong.

Fearing the worst, that the small machine had been hacked, I plugged it out and attempted to go into single user mode but even that didn’t work. I tried various cmdline.txt changes, I saw an odd message saying:

sh: can't access tty; job control turned off

That wasn’t the worst. I even managed to generate a kernel panic once!

When I was just about ready to give up I plugged in the HDMI cable again and saw a strange libcrypt error show up.

/sbin/sulogin error while loading shared libraries: libcrypt.so.1: cannot open shared object file: no such file or directory

A quick search for that message brings me to the one thread on the Internet about it.

Unfortunately, I don’t have another Linux machine handy to copy libc6 from but I do have a backup of the SD card and that worked. I made a backup with Disk Utility (yes, don’t sneer, I can use dd too) and after making a new backup I restored the old backup with Etcher.

The last time I did an apt upgrade was just before a recent trip where I was depending on the RPI3 for my Plex music. Luckily the Plex server hadn’t restarted in that time and must have been using the old libc6!

Another tool that was useful here was ext4fuse which I installed through Homebrew. It’s even possible to mount an ext4 partition from an SD card image by first mounting the boot partition with Disk Utility, checking the device with df -h and then using the very next device number like this:

ext4fuse /dev/disk9s2 /Volumes/rpi -o allow_other

Read only access to the Raspberry PI/Linux part of the image! Strangely enough it doesn’t show in Finder but df shows it is mounted.

Now to make a new SD card backup before I update anything else with apt.