Differences

This shows you the differences between two versions of the page.

--- start [2018/12/06 21:48] – abeverley
+++ start [2024/09/04 08:23] (current) – abeverley
@@ Line 3: / Line 3: @@
 ===== About me =====
-Please either check out my [[http://uk.linkedin.com/pub/andy-beverley/15/162/941|LinkedIn]] page, or email me for my CV.
+Please either check out my [[http://uk.linkedin.com/pub/andy-beverley/15/162/941|LinkedIn]] page.
+===== Build MariaDB with readline support =====
+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]].
+===== Building packages from later versions of Debian for earlier releases =====
+I had a problem recently whereby [[https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=982998|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
+==== Example: building openarc package from experimental ====
+Add experimental sources to ''/etc/apt/sources.list'':
+  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/
+  # Download additional patches
+  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
+  wget https://github.com/trusteddomainproject/OpenARC/pull/173.patch
+  # Apply
+  cd ../..
+  patch -p1 < debian/patches/167.patch
+  patch -p1 < debian/patches/168.patch
+  patch -p1 < debian/patches/170.patch
+  patch -p1 < debian/patches/173.patch
+  dch --bpo # Add letter to suggested version
+  dpkg-source --commit
+  debuild -uc -us
+==== References ====
+https://ostechnix.com/how-to-build-debian-packages-from-source/
+https://unix.stackexchange.com/questions/112157/
+Versioning info: https://www.debian.org/doc/debian-policy/ch-controlfields.html#version
+===== Building Debian packages of Perl modules =====
+On production servers, I much prefer to use Perl modules from Debian repositories, rather than installing from CPAN or using some sort of pinning technique. The advantage is that they are maintained upstream, are more stable, faster to install and easier overall to manage.
+Sometimes a Perl module is either not available in the main Debian repositories, or the version is too old (or I need a patch that has not made it upstream yet). In these circumstances I build my own Debian packages of Perl modules. Normally building a package is easy, but sometimes it can be a bit of an art. Read more about [[building Debian packages of Perl modules]].
+===== JSON Web Tokens with Perl =====
+Some examples of [[how to use JWTs with Perl]]
+===== Bulk resizing images =====
+  # Maximum width 400px and max height 700px
+  mogrify -resize '400x700>' *.png
+  # Maximum width 400px
+  mogrify -resize '400>' *.png
+===== Using Overlay (OpenStreetMap) =====
+[[overlay|Using Overlay to extract data from OpenStreetMap]]
 ===== Using iptables and PHP to create a captive portal =====
@@ Line 51: / Line 124: @@
 ===== Customise live Ubuntu for internet cafe environment =====
-  * 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! [[cubuntu|Customise live Ubuntu for internet cafe environment]]
+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! [[cubuntu|Customise live Ubuntu for internet cafe environment]]
 ===== Setup SMTP authentication with Postfix running on Debian =====
@@ Line 64: / Line 137: @@
 ===== Tomatina tomato festival =====
-  * A page with advice about the Tomatina festival that I attended in 2006. [[http://files.andybev.com/tomatina/|La Tomatina Tomato Festival - photos and advice]]
+A page with advice about the Tomatina festival that I attended in 2006. [[http://files.andybev.com/tomatina/|La Tomatina Tomato Festival - photos and advice]]
-===== Random computer notes =====
-  * A page with some random notes. [[Computer_notes|Computer notes]]
 andy@andybev.com