[kdepim-users] [Akonadi + PostgreSQL] akonadictl tries to start outdated version of PostgreSQL server

[Martin Steigerwald]

Am Mittwoch, 25. Januar 2012 schrieb Ingo Klöcker:
> On Wednesday 25 January 2012, Martin Steigerwald wrote:
> > Hi!
> > 
> > Reported as:
> > 
> > Bug 292393 - [PostgreSQL backend] akonadictl tries to start outdated
> > version of PostgreSQL server and crashes
> > 
> > https://bugs.kde.org/292393
> > 
> > but I thought I ask here - maybe there is an easy workaround.
> > 
> > I tried setting Akonadi-Server to start the database server itself.
> > 
> > Currently I do use a central PostgreSQL server that works fine. But
> > to have the Akonadi data in my home directory or central backup of
> > all user data and to have akonadictl stop all whats being needed to
> > make Akonadi data consistent in that it also stops the PostgreSQL
> > server, I tried setting it to Startserver=true like this:
> > 
> > [QPSQL]
> > Name=
> > Host=
> > Options=
> > StartServer=true
> > 
> > 
> > But then Akonadi fails to start the PostgreSQL server since it tries
> > with an outdated version thats not installed. I have:
> > 
> > merkaba:~> apt-show-versions | grep postgresql
> > akonadi-backend-postgresql/experimental uptodate 1.6.2-1
> > postgresql/wheezy uptodate 9.1+128
> > postgresql-9.1/sid uptodate 9.1.2-4
> > postgresql-client-9.1/sid uptodate 9.1.2-4
> > postgresql-client-common/wheezy uptodate 128
> > postgresql-common/wheezy uptodate 128
> > postgresql-contrib-9.1/sid uptodate 9.1.2-4
> > 
> > 
> > The output of akonadictl start:
> > 
> > martin at merkaba:~/.config/akonadi> akonadictl start
> > Starting Akonadi Server...
> > 
> >    done.
> > 
> > Connecting to deprecated signal
> > QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString
> > ) martin at merkaba:~/.config/akonadi> search paths:  ("~/bin",
> > "/usr/local/bin", "/usr/bin", "/bin", "/usr/bin/X11", "/usr/games",
> > "/usr/sbin", "/usr/local/sbin", "/usr/lib/postgresql/8.4/bin")
> 
> This looks suspiously like the contents of $PATH. What does 'echo
> $PATH' say? Did you grep ~/.kde for "/usr/lib/postgresql/8.4/bin"?

martin at merkaba:~> echo $PATH
~/bin:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games

martin at merkaba:~> su -
Passwort: 
merkaba:~> echo $PATH
~/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin

(but that should not matter, since Akonadi is started from the user)

I bet Akonadi changes the path prior trying to start the database server.

martin at merkaba:~> grep -I --devices=skip -ir "/usr/lib/postgresql/8.4/bin" 
.kde
.kde/share/apps/kmail/autosave/cur/1327566532.2597.VSpi2:> > "/usr/sbin", 
"/usr/local/sbin", "/usr/lib/postgresql/8.4/bin")
.kde/share/apps/kmail/autosave/cur/1327566532.2597.VSpi2:> $PATH' say? Did 
you grep ~/.kde for "/usr/lib/postgresql/8.4/bin"?
martin at merkaba:~>

But I found:

[QPSQL]
StartServer=true
Name=akonadi
Host=/home/alvanx/.local/share/akonadi/socket-alvanx
Options=
ServerPath=/usr/bin/postgres #same results with pg_ctl, I do believe 
"postgres" was preset though
InitDbPath=/usr/bin/initdb
User=
Password=
Port=5432

http://forum.kde.org/viewtopic.php?f=20&t=97306


So I think it should be possible to override the default path and I will 
try this.

Thanks,
-- 
Martin 'Helios' Steigerwald - http://www.Lichtvoll.de
GPG: 03B0 0D6C 0040 0710 4AFA  B82F 991B EAAC A599 84C7
_______________________________________________
KDE PIM users mailing list
Subscription management: https://mail.kde.org/mailman/listinfo/kdepim-users