Bug 417721

Summary:	akonadi-backend-postgresql: Initialisation of database fail if locale en_US.UTF8 is not avalaible systemwide
Product:	[Frameworks and Libraries] Akonadi	Reporter:	roucaries <roucaries.bastien+bugs>
Component:	server	Assignee:	kdepim bugs <kdepim-bugs>
Status:	RESOLVED FIXED
Severity:	major	CC:	roucaries.bastien+bugs, sknauss
Priority:	NOR
Version:	GIT (master)
Target Milestone:	---
Platform:	Debian testing
OS:	Linux
URL:	https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=951389
Latest Commit:	https://invent.kde.org/pim/akonadi/commit/268bfc0830bee2012ab05f3a6055fff27a8c9010	Version Fixed In:	5.15.2
Sentry Crash Report:

Description roucaries 2020-02-15 20:33:54 UTC

The creation of database fail if locale en_US.UTF8 is not installed systemwise (by pulling
locale-all package for instance).

Indeed akonadi create database by using --locale en_US.UTF8
(see https://github.com/KDE/akonadi/blob/8aca730125ad247014868ba6e4cc530f4209619a/src/server/storage/dbconfigpostgresql.cpp#L297)

correct flags will be: -E UTF8 --no-locale   
that does not need to install a locale systemwise and is safe

Thanks

Bastien

Comment 1 roucaries 2020-02-15 20:36:35 UTC

NB: they are two place where you pass the flags also here:
https://github.com/KDE/akonadi/blob/8aca730125ad247014868ba6e4cc530f4209619a/src/server/storage/dbconfigpostgresql.cpp#L484

May be refactor ?

Comment 2 roucaries 2020-02-15 20:44:54 UTC

Debian bug here:
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=951389

Comment 3 Sandro Knauß 2020-09-07 17:36:27 UTC

Git commit 268bfc0830bee2012ab05f3a6055fff27a8c9010 by Sandro Knauß.
Committed on 07/09/2020 at 17:29.
Pushed by knauss into branch 'hefee/bugfix_417721'.

Fix(postgresql): Initialise database without locale en_US.UTF8 avalaible systemwide

Currently postgres rely on en_US.UTF8 locale to be available for the
current machine. But it is possible to to initialise the database
without this locale to be available.

M  +5    -2    src/server/storage/dbconfigpostgresql.cpp

https://invent.kde.org/pim/akonadi/commit/268bfc0830bee2012ab05f3a6055fff27a8c9010

Comment 4 Sandro Knauß 2020-09-07 17:39:22 UTC

Well currently there is only a MR open:
https://invent.kde.org/pim/akonadi/-/merge_requests/30

(not merged)

Comment 5 Sandro Knauß 2020-10-19 21:40:58 UTC

Now the MR is accepted and merged.