On Tuesday 29 Dec 2015 18:49:03 J. Roeleveld wrote: > On 29 December 2015 19:40:58 CET, Mick <[email protected]> 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
signature.asc
Description: This is a digitally signed message part.
