[opensuse-factory] Akonadi/Kmail with PostgreSQL as backend on Tumbleweed
Hi, Akonadi and Kmail, walking hand in hand, are giving me itches yet again. So I dug around and came across some tutorials and hints for PostgreSQL. Unfortunately I can't find a package for PgSQL as a backend to Akonadi while other distributions have it. I already asked on /r/openSUSE but without any luck. Any hints how and where to start with Tumbleweed? Regards, vinz. -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
Hi,
Akonadi and Kmail, walking hand in hand, are giving me itches yet again. So I dug around and came across some tutorials and hints for PostgreSQL. Unfortunately I can't find a package for PgSQL as a backend to Akonadi while other distributions have it.
I already asked on /r/openSUSE but without any luck. Any hints how and where to start with Tumbleweed?
Regards, vinz. I'm using this config. Here's a forums post on it, if you need help setting
Op woensdag 5 december 2018 22:21:51 CET schreef Vinzenz Vietzke: this up, please move your topic to support@o.o -- Gertjan Lettink a.k.a. Knurpht openSUSE Board Member openSUSE Forums Team -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
Op woensdag 5 december 2018 22:21:51 CET schreef Vinzenz Vietzke:
Hi,
Akonadi and Kmail, walking hand in hand, are giving me itches yet again. So I dug around and came across some tutorials and hints for PostgreSQL. Unfortunately I can't find a package for PgSQL as a backend to Akonadi while other distributions have it.
I already asked on /r/openSUSE but without any luck. Any hints how and where to start with Tumbleweed?
Regards, vinz.
I'm using this config. Here's a forums post on it, if you need help setting this up, please move your topic to support@o.o Sorry, accidently hit the send button, and the forums post doesn't really give
Op woensdag 5 december 2018 22:49:17 CET schreef Knurpht-openSUSE: the proper clues. Install libQt5Sql5-postgresql (Re)move ~/.local/share/akonadi Change ~/.config/akonadi/akonadiserverrc like this [%General] Driver=QPSQL [QPSQL] Host=/tmp/akonadi-USERNAME_HERE.hash InitDbPath=/usr/bin/initdb Name=akonadi Options= ServerPath=/usr/bin/pg_ctl StartServer=true -- Gertjan Lettink a.k.a. Knurpht openSUSE Board Member openSUSE Forums Team -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
Hi,
Install libQt5Sql5-postgresql
Wow, that was the missing bit - thank you so much! Only thing I wonder about is the strange naming of libQt5Sql5-postgresql in contrast to akonadi-server-sqlite. Or - the other way around - why there is both libQt5Sql5-sqlite *and* akonadi-server-sqlite.
(Re)move ~/.local/share/akonadi Change ~/.config/akonadi/akonadiserverrc like this [%General] Driver=QPSQL
[QPSQL] Host=/tmp/akonadi-USERNAME_HERE.hash InitDbPath=/usr/bin/initdb Name=akonadi Options= ServerPath=/usr/bin/pg_ctl StartServer=true
That config works perfectly. Leaving it here on factory@o.o for future references. Regards, vinz. -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
On 05.12.2018 23:30, vinz@vinzv.de wrote:
why there is both libQt5Sql5-sqlite *and* akonadi-server-sqlite.
https://cgit.kde.org/akonadi.git/tree/src/qsqlite/README: "This is a sliglty adjusted version of the QSQLITE driver..." If I remember correctly, Akonadi developers needed to use some internals of the QSQLITE driver that were not exported via the official plugin. -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
Phew, okay. Maybe that's why I couldn't find any details on that issue. Thanks for clarifying! vinz. Am 6. Dezember 2018 00:01:18 MEZ schrieb Christoph Feck <cfeck@kde.org>:
On 05.12.2018 23:30, vinz@vinzv.de wrote:
why there is both libQt5Sql5-sqlite *and* akonadi-server-sqlite.
https://cgit.kde.org/akonadi.git/tree/src/qsqlite/README: "This is a sliglty adjusted version of the QSQLITE driver..."
If I remember correctly, Akonadi developers needed to use some internals of the QSQLITE driver that were not exported via the official plugin. -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
participants (4)
-
Christoph Feck -
Knurpht-openSUSE -
vinz＠vinzv.de -
Vinzenz Vietzke