<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body>A new request with request id 16176 has been created by koha-devel-request@lists.koha-community.org. Short info on the request is : <br><br>Title : Koha-devel Digest, Vol 189, Issue 15<br>Category : <br>Description : <div>Send Koha-devel mailing list submissions to<br> koha-devel@lists.koha-community.org<br><br>To subscribe or unsubscribe via the World Wide Web, visit<br> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>or, via email, send a message with subject or body 'help' to<br> koha-devel-request@lists.koha-community.org<br><br>You can reach the person managing the list at<br> koha-devel-owner@lists.koha-community.org<br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of Koha-devel digest..."<br><br><br>Today's Topics:<br><br> 1. Re: Character sets in MariaDB 10.5 (Michael Kuhn)<br> 2. Installing Koha 21.05.03-1 but Koha gives 21.05.02.003 as the<br> installed version (Michael Kuhn)<br> 3. Re: Installing Koha 21.05.03-1 but Koha gives 21.05.02.003 as<br> the installed version (Jonathan Druart)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Thu, 26 Aug 2021 14:31:48 +0200<br>From: Michael Kuhn <mik@adminkuhn.ch><br>To: Tomas Cohen Arazi <tomascohen@gmail.com><br>Cc: koha-devel <koha-devel@lists.koha-community.org>, koha<br> <koha@lists.katipo.co.nz><br>Subject: Re: [Koha-devel] Character sets in MariaDB 10.5<br>Message-ID: <04cc99a7-dfaa-10ec-bb4e-6cb0fd7ea10e@adminkuhn.ch><br>Content-Type: text/plain; charset=utf-8; format=flowed<br><br>Hi Tomas<br><br>Today you wrote:<br><br> > Those are just defaults in the OS distribution, that can be changed at<br> > will.<br> ><br> > Koha, internally, sets the character set correctly on connection time<br> > [1].<br> ><br> > You should always check when they drop support for our used encodings.<br> > Which is not the case (for now?). We have the test suite run against<br> > the latest versions of MariaDB for that purpose.<br> ><br> > I recommend you set that defaults correctly so they are picked when<br> > you use the CLI.<br><br>I have now added the following line in both files <br>"/etc/mysql/mariadb.conf.d/50-client.cnf" /section [client]) and <br>"/etc/mysql/mariadb.conf.d/50-mysql-clients.cnf" (section [mysql]):<br><br>default-character-set = utf8mb4<br><br>Now as in Debian 9 and 10 the character sets in MariaDB running on <br>Debian 11 look as follows:<br><br>MariaDB [(none)]> SHOW VARIABLES LIKE 'character_set_%';<br>+--------------------------+----------------------------+<br>| Variable_name | Value |<br>+--------------------------+----------------------------+<br>| character_set_client | utf8mb4 |<br>| character_set_connection | utf8mb4 |<br>| character_set_database | utf8mb4 |<br>| character_set_filesystem | binary |<br>| character_set_results | utf8mb4 |<br>| character_set_server | utf8mb4 |<br>| character_set_system | utf8 |<br>| character_sets_dir | /usr/share/mysql/charsets/ |<br>+--------------------------+----------------------------+<br><br>Thank you very much for your recommendation!<br><br>Best wishes: Michael<br>-- <br>Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis<br>Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz<br>T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch<br><br><br><br><br>> El mié., 25 ago. 2021 17:54, Michael Kuhn <mik@adminkuhn.ch <br>> <mailto:mik@adminkuhn.ch>> escribió:<br>> <br>> Hi<br>> <br>> 1. In the last few years when installing Koha on Debian GNU/Linux 9 or<br>> 10 the character sets in MariaDB were as follows:<br>> <br>> MariaDB [(none)]> SHOW VARIABLES LIKE '%char%';<br>> +--------------------------+----------------------------+<br>> | Variable_name | Value |<br>> +--------------------------+----------------------------+<br>> | character_set_client | utf8mb4 |<br>> | character_set_connection | utf8mb4 |<br>> | character_set_database | utf8mb4 |<br>> | character_set_filesystem | binary |<br>> | character_set_results | utf8mb4 |<br>> | character_set_server | utf8mb4 |<br>> | character_set_system | utf8 |<br>> | character_sets_dir | /usr/share/mysql/charsets/ |<br>> +--------------------------+----------------------------+<br>> <br>> Today I installed Koha 21.05.03 on Debian GNU/Linux 11 with MariaDB<br>> 10.5.11 where the character sets are as follows:<br>> <br>> MariaDB [(none)]> SHOW VARIABLES LIKE '%char%';<br>> +--------------------------+----------------------------+<br>> | Variable_name | Value |<br>> +--------------------------+----------------------------+<br>> | character_set_client | utf8 |<br>> | character_set_connection | utf8 |<br>> | character_set_database | utf8mb4 |<br>> | character_set_filesystem | binary |<br>> | character_set_results | utf8 |<br>> | character_set_server | utf8mb4 |<br>> | character_set_system | utf8 |<br>> | character_sets_dir | /usr/share/mysql/charsets/ |<br>> +--------------------------+----------------------------+<br>> <br>> I'm not sure what is going on here. Does anyone know why the character<br>> sets for client, connection and results have changed from utf8mb4 to<br>> utf8? Is this correct with Koha or should these character sets be<br>> changed?<br>> <br>> 2. Today I came upon an installation of Koha 18.11.05 using MariaDB<br>> 10.0.32 which has the following character sets:<br>> <br>> MariaDB [(none)]> SHOW VARIABLES LIKE '%char%';<br>> +--------------------------+----------------------------+<br>> | Variable_name | Value |<br>> +--------------------------+----------------------------+<br>> | character_set_client | utf8 |<br>> | character_set_connection | utf8 |<br>> | character_set_database | latin1 |<br>> | character_set_filesystem | binary |<br>> | character_set_results | utf8 |<br>> | character_set_server | latin1 |<br>> | character_set_system | utf8 |<br>> | character_sets_dir | /usr/share/mysql/charsets/ |<br>> +--------------------------+----------------------------+<br>> <br>> This seems quite wrong to me - as far as I know "latin1" was never a<br>> supported character set in Koha... as far as I know the character sets<br>> should be set as shown in topic 1.<br>> <br>> However, is it still possible to update such a database with these<br>> character sets to Koha 21.05.03 without destroying the data completely?<br>> <br>> Best wishes: Michael<br>> -- <br>> Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis<br>> Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz<br>> T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch<br>> <mailto:mik@adminkuhn.ch> · W www.adminkuhn.ch <http://www.adminkuhn.ch><br>> _______________________________________________<br>> Koha-devel mailing list<br>> Koha-devel@lists.koha-community.org<br>> <mailto:Koha-devel@lists.koha-community.org><br>> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>> <https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel><br>> website : https://www.koha-community.org/<br>> <https://www.koha-community.org/><br>> git : https://git.koha-community.org/ <https://git.koha-community.org/><br>> bugs : https://bugs.koha-community.org/<br>> <https://bugs.koha-community.org/><br>> <br><br><br><br><br>------------------------------<br><br>Message: 2<br>Date: Thu, 26 Aug 2021 15:50:34 +0200<br>From: Michael Kuhn <mik@adminkuhn.ch><br>To: Koha-devel <koha-devel@lists.koha-community.org><br>Subject: [Koha-devel] Installing Koha 21.05.03-1 but Koha gives<br> 21.05.02.003 as the installed version<br>Message-ID: <f86d8da3-3e30-95fe-503e-3a0d45c7410c@adminkuhn.ch><br>Content-Type: text/plain; charset=utf-8; format=flowed<br><br>Hi<br><br>Yesterday/today I was installing the most current Koha:<br><br>$ sudo apt-cache show koha-common | grep Version<br>Version: 21.05.03-1<br><br>During the installation of Debian package "koha-common" it says:<br><br>Holen:62 http://debian.koha-community.org/koha 21.05/main amd64 <br>koha-common all 21.05.03-1 [41,1 MB]<br>...<br>Vorbereitung zum Entpacken von .../485-koha-common_21.05.03-1_all.deb ...<br>Entpacken von koha-common (21.05.03-1) ...<br>...<br>koha-common (21.05.03-1) wird eingerichtet ...<br><br><br>But after the installation I see the following in Koha menu "About Koha":<br><br>Koha version: 21.05.02.003<br><br>Also in the source text of the OPAC main page it says:<br><br><meta name="generator" content="Koha 21.0502003" /><br><br><br>This happened on a completely new machine with Debian GNU Linux 11.0.<br><br>Best wishes: Michael<br>-- <br>Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis<br>Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz<br>T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch<br><br><br>------------------------------<br><br>Message: 3<br>Date: Thu, 26 Aug 2021 16:17:25 +0200<br>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org><br>To: Michael Kuhn <mik@adminkuhn.ch><br>Cc: Koha-devel <koha-devel@lists.koha-community.org><br>Subject: Re: [Koha-devel] Installing Koha 21.05.03-1 but Koha gives<br> 21.05.02.003 as the installed version<br>Message-ID:<br> <CAJzKNY44OHWHG-VhJ0gZ5YXFrayeSkk3P4HU-qv3ee9EfGS+Cw@mail.gmail.com><br>Content-Type: text/plain; charset="UTF-8"<br><br>Indeed, it's coming from<br><br>commit 8ea80995c590dad86c43df636456640d3aa84bab<br> Increment version for 21.05.03 release<br><br>-$VERSION = "21.05.02.002";<br>+$VERSION = "21.05.02.003";<br><br>Le jeu. 26 août 2021 à 15:50, Michael Kuhn <mik@adminkuhn.ch> a écrit :<br>><br>> Hi<br>><br>> Yesterday/today I was installing the most current Koha:<br>><br>> $ sudo apt-cache show koha-common | grep Version<br>> Version: 21.05.03-1<br>><br>> During the installation of Debian package "koha-common" it says:<br>><br>> Holen:62 http://debian.koha-community.org/koha 21.05/main amd64<br>> koha-common all 21.05.03-1 [41,1 MB]<br>> ...<br>> Vorbereitung zum Entpacken von .../485-koha-common_21.05.03-1_all.deb ...<br>> Entpacken von koha-common (21.05.03-1) ...<br>> ...<br>> koha-common (21.05.03-1) wird eingerichtet ...<br>><br>><br>> But after the installation I see the following in Koha menu "About Koha":<br>><br>> Koha version: 21.05.02.003<br>><br>> Also in the source text of the OPAC main page it says:<br>><br>> <meta name="generator" content="Koha 21.0502003" /><br>><br>><br>> This happened on a completely new machine with Debian GNU Linux 11.0.<br>><br>> Best wishes: Michael<br>> --<br>> Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis<br>> Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz<br>> T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch<br>> _______________________________________________<br>> Koha-devel mailing list<br>> Koha-devel@lists.koha-community.org<br>> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>> website : https://www.koha-community.org/<br>> git : https://git.koha-community.org/<br>> bugs : https://bugs.koha-community.org/<br><br><br>------------------------------<br><br>Subject: Digest Footer<br><br>_______________________________________________<br>Koha-devel mailing list<br>Koha-devel@lists.koha-community.org<br>https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>website : https://www.koha-community.org/<br>git : https://git.koha-community.org/<br>bugs : https://bugs.koha-community.org/<br><br><br>------------------------------<br><br>End of Koha-devel Digest, Vol 189, Issue 15<br>*******************************************<br></div><br><br>NOTE: You are receiving this mail because, the Requester/Technician wanted you to get notified on this request creation.<br></body></html>