Differences

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

--- start [2022/06/21 18:29] – [Using Overlay (OpenStreetMap)] 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 =====
@@ Line 18: / Line 24: @@
   debuild -uc -us
-References:
+==== 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) =====
-[[Using Overlay to extract data from OpenStreetMap|overlay]]
+[[overlay|Using Overlay to extract data from OpenStreetMap]]
 ===== Using iptables and PHP to create a captive portal =====