This is the web page of Andy Beverley, where I have put a variety of information that is either difficult to find on the web, or that I want as a handy reference for the future. There are also a couple of other pages at the end that do not fall into these categories! Feel free to email me email@example.com
Please either check out my LinkedIn page.
I've been frustrated with the use of editline (libedit) instead of readline that MariaDB is now built with in Debian 11. I have found editline to be buggy: its implementation of Ctrl-R and editing of wrapped lines do not work well, plus Ctrl-W not being mapping to delete a word by default is infuriating!
As I understand it, Debian is no longer able to distribute MariaDB built against readline as the former is GPL2 and the latter GPL3, and apparently the 2 are incompatible for distribution. So I have written instructions for how to rebuild MariaDB against readline in Debian.
I had a problem recently whereby a bug was fixed in a testing version of Debian (Bookworm) but had not been released to the current stable version (Bullseye). I decided to build the Bookworm version of the package for Bullseye:
apt-get install dpkg-dev devscripts vim /etc/apt/sources.list # Enable source packages apt-get update apt source chkrootkit apt build-dep chkrootkit cd chkrootkit-0.55 dch --bpo # Update package version so as not to conflict debuild -uc -us
Add experimental sources to
deb-src http://httpredir.debian.org/debian/ experimental main contrib
apt-get build-dep openarc apt-get source openarc cd openarc-1.0.0~beta3+dfsg/ cd debian/patches wget https://github.com/trusteddomainproject/OpenARC/pull/167.patch wget https://github.com/trusteddomainproject/OpenARC/pull/168.patch wget https://github.com/trusteddomainproject/OpenARC/pull/170.patch dch --bpo # Add letter to suggested version debuild -uc -us
Some examples of how to use JWTs with Perl
# Maximum width 400px and max height 700px mogrify -resize '400x700>' *.png # Maximum width 400px mogrify -resize '400>' *.png
There are various captive portal software packages available (both free and open source). None of the packages I tried did what I wanted and were not particularly customisable. Therefore I created my own using a few iptables rules and PHP (along with a handful of other standard packages). The page below details the steps taken. Using iptables and PHP to create a captive portal
These are a few notes that I made to do the above. It needs testing and writing up properly.
This page describes how to use Latex to create a PDF photo slideshow. This is a good halfway house between simply displaying photos using a picture viewer, and creating a Powerpoint-type slideshow with text and so on. The advantage of Latex, of course, is that the whole presentation can be created automatically from a template - no fidgety Powerpoint formatting to worry about.
Traffic shaping a standard ADSL link in order to share it with a couple of hundred users is a common problem. There are dozens of bits of software and firewall scripts out there already to do this. This particular page details a method that I have used successfully for several years. It aims to be as simple as possible, is easily customised, and uses connlimit to identify P2P users. Although the latter is not 100% reliable, it seems to work pretty well and does not fall foul of any new/changed P2P software that happens to some of the other scripts. The page is written as more of a tutorial; if you would like to use this in practice, then I recommend you check out the scripts in the “captive portal from scratch” page below. Fair traffic shaping an ADSL line for a local network using Linux
The link below gives the full details from start to finish of installing the Debian operating system, setting up a captive portal and shaping traffic fairly for dozens of users. Setting up a captive portal from scratch using Debian
PortalShaper is a set of scripts to:
DBAN is a popular and easy to use disk wiping program. I have extracted the dwipe program that it uses and created a new project called nwipe. This is essentially the same as dwipe, but can be compiled and used in most modern Linux distributions. If you are having trouble running or booting DBAN, then nwipe is for you.
met4perl is a re-spin of the MET4NET software published by Instromet, but implemented in a very simple Perl interface. Currently it is only written for Linux, but it would be easy to add other platforms.
Backup2l is an excellent and efficient backup tool. The documentation is sparse though. The following page provides some quick and dirty instructions for getting it working. Setting up backup2l with Debian
A page with instructions on how to customise a copy of Ubuntu and make it network bootable in order to use within an internet cafe environment. In my opinion this is vastly superior to most arrangements in internet cafes that I use! Customise live Ubuntu for internet cafe environment
The original idea of this page was a quick and dirty howto on how to setup SMTP authentication on Postfix. However, it turned out that there was no quick way to achieve what I wanted (encrypted passwords over an unencrypted link, using Courier IMAP as the password database). It also turned out that I was running a non-standard Postfix (it wasn't chrooted). Therefore, as SMTP AUTH and SASL have always been something of a black art to me, I have written a few things down that I have discovered, as well as a quick and dirty howto on setting up a basic SASL database. SMTP authentication and Postfix
Some quick steps showing something that's quite easy but not immediately obvious. Setup clamav with Postfix on Debian Lenny in a chroot
A page with advice about the Tomatina festival that I attended in 2006. La Tomatina Tomato Festival - photos and advice