start

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
start [2023/08/22 14:09]
abeverley [Build MariaDB with readline support]
start [2024/02/18 15:51]
abeverley [Example: building openarc package from experimental]
Line 7: Line 7:
 ===== Build MariaDB with readline support ===== ===== 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 buggyits implementation of Ctrl-R and editing of wrapped lines do not work wellplus 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 libreadline-dev +
-  apt build-dep mariadb-client-core-10.5 +
-  su <unpriv user> +
-  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. +
- +
-  mariadb-10.5 (1:​10.5.19-0+deb11u2c) bullseye; urgency=medium +
- +
-    * Build against readline instead of libedit +
- +
-   -- Andy Beverley <​andy@andybev.com> ​ Tue, 22 Aug 2023 14:08:00 +0100 +
- +
-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 ===== ===== Building packages from later versions of Debian for earlier releases =====
Line 53: Line 24:
   debuild -uc -us   debuild -uc -us
  
-References:+==== Examplebuilding 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/​ 
 +  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 
 +  dch --bpo # Add letter to suggested version 
 +  debuild -uc -us 
 + 
 +==== References ====
  
 https://​ostechnix.com/​how-to-build-debian-packages-from-source/​ https://​ostechnix.com/​how-to-build-debian-packages-from-source/​
 https://​unix.stackexchange.com/​questions/​112157/​ https://​unix.stackexchange.com/​questions/​112157/​
  
 +Versioning info: https://​www.debian.org/​doc/​debian-policy/​ch-controlfields.html#​version
 ===== JSON Web Tokens with Perl ===== ===== JSON Web Tokens with Perl =====
  
 Some examples of [[how to use JWTs 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 (OpenStreetMap) =====
start.txt · Last modified: 2024/02/18 15:51 by abeverley