On Thursday, November 12, 2015 07:30:49 AM Mick wrote:
> On Thursday 12 Nov 2015 04:48:49 J. Roeleveld wrote:
> > On 11 November 2015 23:07:41 CET, Mick <michaelkintz...@gmail.com> wrote:
> > >On Wednesday 11 Nov 2015 20:28:07 Marc Joliet wrote:
> > >> On Wednesday 11 November 2015 20:37:24 J. Roeleveld wrote:
> > >> >I saw plenty of errors with mysql.
> > >> >
> > >> >After switching to Postgresql, they seem to have disappeared.
> > >> 
> > >> FWIW, I use mariadb myself, which is also the virtual/mysql default
> > >> provider, last I checked.
> > >> 
> > >> Greetings
> > >
> > >@Mark: Yes, same here, but the errors are produced by mariadb too.
> > >
> > >@Joost: Is postgresql starting as a process by akonadi, or are you
> > >running it
> > >independently and pointing akonadi to it?
> > >
> > >PS. I read somewhere that if mysql is running independently of akonadi,
> > >then
> > >the akonadi errors/corruptions are fewer, or not happen at all.
> > 
> > As I use Postgresql also for other stuff, it's started seperately.
> > 
> > I also found this performs better, having it run "embedded" only had a
> > slightly better performance when compared to mysql (or mariadb, don't
> > remember) "embedded".
> > 
> > A framework like akonadi should, IMO, also be able to be run on a server
> > with clients connecting to there to allow different machines to all use
> > the same data.
> > 
> > The current solution makes running with a shared home and logged in from
> > different clients simultaneously problematic  (to say the least)
> > 
> > --
> > Joost
> 
> Can you please explain how you have akonadi configured to use an existing db
> instance?  Did you have to set up an akonadi db user and passwd?

Yes.
You need to create a user with password on the database where akonadi can 
create the tables.

Here is my akonadi-config:
***
% cat .config/akonadi/akonadiserverrc 
[%General]
Driver=QPSQL

[QPSQL]
Name=joost-akonadi
Host=localhost
Options=
ServerPath=/usr/bin/pg_ctl
InitDbPath=/usr/bin/initdb
StartServer=false
User=<username>
Password=<password>
Port=5432

[Debug]
Tracer=null

***

It also works with the database running on a different machine.

--
Joost

Attachment: signature.asc
Description: This is a digitally signed message part.

Reply via email to