Differences

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

--- start [2018/12/06 21:49] – [Random computer notes] abeverley
+++ start [2024/01/28 15:03] – [Building packages from later versions of Debian for earlier releases] 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
+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
+===== 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 =====