Differences

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

--- start [2023/08/22 13:04] – [Build MariaDB with readline support] abeverley
+++ start [2024/09/04 08:23] (current) – abeverley
@@ Line 7: / Line 7: @@
 ===== Build MariaDB with readline support =====
-I've been frustrated with the use of editline (libedit) instead of readline that the MariaDB is now built with in Debian 11. I have found editline to be buggy with its implementation of Ctrl-R and editing of wrapped lines, and Ctrl-W not mapping to delete a word is infuriating!
+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 instead I am starting to build my own packages using these instructions:
-  apt install build-essential devscripts
-  apt build-dep mariadb-client-core-10.5
-  apt install libreadline-dev
-  su andrew
-  apt source mariadb-client-core-10.5
-  cd mariadb-10.5-10.5.19/
-Edit ''debian/changelog'' and add new line at top. Version number should be incremented by adding a letter on the end. E.g.
-Edit ''debian/control'' and change:
-  libedit-dev,
-  libedit-dev:native,
-To
-  libreadline-dev,
-  libreadline-dev:native,
-Edit ''debian/rules'' and add ''-DNOT_FOR_DISTRIBUTION=1'' below ''-DWITH_INNODB_SNAPPY=ON''. Then run:
-  debuild -uc -us -b
+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 48: / 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) =====