Re: [gentoo-user] Kmail2 - I have not given up ... yet

[J. Roeleveld]

On Tuesday, December 29, 2015 04:34:33 PM Mick wrote:
> On Tuesday 29 Dec 2015 14:18:20 J. Roeleveld wrote:
> > sqlite is nice, for single threaded applications.
> > For anything more advanced, either a wrapper is required or something more
> > advanced needs to be used.
>
> I like sqlite because it is self-contained, embedded in the application that
> uses it and accesses the data directly with functional calls, rather than
> looping around port/socket interfaces to speak to a server.  This is why I
> kept it, since with Kmail1 it is not used much.

SQLite never was reliable with akonadi. That might be why so many people had 
all those issues.

> With Kmail2 the database will be hammered so as you say will need something
> that can process things in parallel at speed and in higher volumes. So, I'm
> planning to install postgresql for this purpose, since in my experience
> mysql has had a number of hickups with akonadi.

My experience as well, which is why I switched to Postgresql.

> Can you please advise what GRANTS did you use to create a dedicated
> postgresql user for akonadi?

Grants?
I did the following:
% createuser -P <akonadiuser>
(NOTE: You need to set a password, which is why I use the "-P" option)

% createdb -E UTF8 -O <akonadiuser> <akonadidb>

My config for this is:

% cat .config/akonadi/akonadiserverrc 
[%General]
Driver=QPSQL

[QPSQL]
Name=<akonadidb>
Host=localhost
Options=
ServerPath=/usr/bin/pg_ctl
InitDbPath=/usr/bin/initdb
StartServer=false
User=<akonadiuser>
Password=<akonadipassword>
Port=5432

[Debug]
Tracer=null

> Will the same user be used for Baloo indexing, or is this an additional
> database role?

Afaik, no. Baloo uses it's own database engine.

For the USE-flags:

app-office/akonadi-server postgresql qt4
(all other USE-flags disabled)

--
Joost