akonadi postgres configuration ignores port number

[Randall Leeds]

I have PostgreSQL installed on my machine and have configured akonadi to use the standalone pg server.

I have postgres running on port 5433 and experience a problem where it appears that the akonadi postgresql backend is ignoring the port number from the configuration. Even if my configuration has the port configuring to 5433, I get the following error running "akonadictl start"

> Database error: Cannot open database.
> Last driver error: "QPSQL: Unable to connect"
> Last database error: "could not connect to server: Connection refused
> Is the server running on host "localhost" (::1) and accepting
> TCP/IP connections on port 5432?

Switching my postgres server to 5432 (the default) is a workaround.

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[Jens Wilke (jw-launchpad)]

Same here on kde 4.11 backport to kubuntu 12.04, akonadi version 1.10.1-0ubuntu1~ubuntu12.04~ppa1

[Rainer Feigl (rainer-feigl-4)]

can confirm that ... kde 4.11 via backports ppa on 13.04 ... amd64

akonadi-server 1.10.1-0ubuntu1~ubuntu13.04~pp amd64
akonadi-backend-postgresql 1.10.1-0ubuntu1~ubuntu13.04~pp all
libqt4-sql-psql 4:4.8.4+dfsg-0ubuntu14~ubuntu1

btw... what about connecting via socket, after all postgres and akonadi are running on the same machine

[Harald Sitter (apachelogger)]

Hi there!

Thanks for reporting this bug! Your bug seems to be a problem with the KDE program itself, and not with our KDE packages. While we appreciate your issue, it would be better if it was tracked at https://bugs.kde.org, so that the KDE developers can deal with this speedily and have direct communication with you as the reporter for more effective debugging.

Thanks!

[KDEUSER56 (kdeuser56)]

The Akonadi developers are aware and I expect the issue to be fixed in the next time.
You can workaround that problem quite easily:
In .local/share/akonadi/db_data/postgresql.conf set
listen_addresses = ' ' to be empty instead of localhost (do not forget to uncomment the line.)
Then delete everything in .config/akonadi/akonadiserverrc apart from the [%General] section. Now akonadi will start.

[KDEUSER56 (kdeuser56)]

Okay is fixed upstream in master (as of Akonadi 1.12.44 revision: adf3db2) now, thanks to the amazing work of Dan Vrátil.