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

[Mick]

On Tuesday 29 Dec 2015 18:49:03 J. Roeleveld wrote:
> On 29 December 2015 19:40:58 CET, Mick <michaelkintzios@×××××.com> wrote:
> >On Tuesday 29 Dec 2015 17:51:32 J. Roeleveld wrote:
> >> 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
> >
> >Thank you very much Joost for holding my hand on this.  Last question
> >for the
> >day:  It seems that postgresql wants to install xemacs as a dependency
> >... o_O
> >
> >========================================
> ># emerge -uaDv emerge dev-db/postgresql
> >
> >These are the packages that would be merged, in order:
> >
> >Calculating dependencies... done!
> >[ebuild  N     ] app-eselect/eselect-postgresql-1.2.1::gentoo  4 KiB
> >[ebuild  N     ] app-eselect/eselect-ctags-1.18::gentoo  9 KiB
> >[ebuild  N     ] app-eselect/eselect-emacs-1.18::gentoo  0 KiB
> >[ebuild  N     ] dev-db/postgresql-9.4.5-r1:9.4::gentoo  USE="ldap nls
> >pam
> >readline server ssl xml zlib -doc -kerberos (-libressl) -perl -
> >pg_legacytimestamp -python (-selinux) -static-libs -tcl -threads -uuid"
> >
> >LINGUAS="en -af -cs -de -es -fa -fr -hr -hu -it -ko -nb -pl -pt_BR -ro
> >-ru -sk
> >-sl -sv -tr -zh_CN -zh_TW" PYTHON_SINGLE_TARGET="python2_7 -python3_4"
> >PYTHON_TARGETS="python2_7 python3_4" 17,248 KiB
> >[ebuild  N     ] app-editors/xemacs-21.4.24::gentoo  USE="X berkdb gdbm
> >gif
> >gpm jpeg ldap png tiff -Xaw3d -athena -canna -dnd -eolconv -freewnn
> >-motif -
> >mule -nas -neXt -pop -postgres -xface -xim" 8,383 KiB
> >[ebuild  N     ] app-xemacs/xemacs-base-2.27::gentoo  524 KiB
> >[ebuild  N     ] app-xemacs/emerge-1.11::gentoo  60 KiB
> >
> >Total: 7 packages (7 new), Size of downloads: 26,225 KiB
> >
> >Would you like to merge these packages? [Yes/No]
> >================================================
> >
> >Why is this?
>
> No. You are trying to emerge 'emerge'.
> (Check the commandline :) )
>
> --
> Joost


Oops!  Apologies for the noise.

Against my wife's advice (she knows better of course) I am trying to multi-
task a number of chores which have suddenly descended upon me ... I'll get on 
with completing the tax return first, before I return to Kmail2.

-- 
Regards,
Mick