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