This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
start [2018/12/06 21:49] abeverley [Random computer notes] |
start [2024/01/28 15:03] abeverley [Building packages from later versions of Debian for earlier releases] |
||
---|---|---|---|
Line 3: | Line 3: | ||
===== About me ===== | ===== 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 ===== | ===== Using iptables and PHP to create a captive portal ===== |