This forum has been archived. All content is frozen. Please use KDE Discuss instead.

Can't start Akonadi with PostgreSQL

Tags: None
(comma "," separated)
wolftune
Registered Member
Posts
41
Karma
0

Can't start Akonadi with PostgreSQL

Thu Jul 16, 2015 4:23 am
I know it affects thing long-term to start Akonadi with a particular database server. I'd prefer to use Postgres as I am no database expert but know postgres more than mysql. I understand postgres may be faster too. I choose postgres and regardless of internal or external (I have no feelings about that setting), it won't start.

What do I need to do? I've searched and searched and tried a few things, no solutions yet. I tried making an "akonadi" user and postgresql database, specifying that as the user and password, but that didn't work.

Code: Select all
Akonadi Server Self-Test Report
===============================

Test 1:  SUCCESS
--------

Database driver found.
Details: The QtSQL driver 'QPSQL' is required by your current Akonadi server configuration and was found on your system.

File content of '/home/aaron/.config/akonadi/akonadiserverrc':
[QMYSQL]
StartServer=true
ServerPath=
Name=akonadi
Host=
User=
Password=
Options=

[QPSQL]
StartServer=false
Name=akonadi
Host=
User=
Password=
Port=5432
Options=
ServerPath=/usr/lib/postgresql/9.3/bin/pg_ctl
InitDbPath=/usr/lib/postgresql/9.3/bin/initdb

[SQLITE]
Name=akonadi

[%General]
Driver=QPSQL

[Debug]
Tracer=null


Test 2:  ERROR
--------

Cannot connect to PostgreSQL server.
Details: FATAL:  Peer authentication failed for user "aaron"
QPSQL: Unable to connect

Test 3:  SUCCESS
--------

akonadictl found and usable
Details: The program '/usr/bin/akonadictl' to control the Akonadi server was found and could be executed successfully.
Result:
Akonadi 1.12.1


Test 4:  ERROR
--------

Akonadi control process not registered at D-Bus.
Details: The Akonadi control process is not registered at D-Bus which typically means it was not started or encountered a fatal error during startup.

Test 5:  ERROR
--------

Akonadi server process not registered at D-Bus.
Details: The Akonadi server process is not registered at D-Bus which typically means it was not started or encountered a fatal error during startup.

Test 6:  SKIP
--------

Protocol version check not possible.
Details: Without a connection to the server it is not possible to check if the protocol version meets the requirements.

Test 7:  ERROR
--------

No resource agents found.
Details: No resource agents have been found, Akonadi is not usable without at least one. This usually means that no resource agents are installed or that there is a setup problem. The following paths have been searched: '/usr/share/akonadi/agents'. The XDG_DATA_DIRS environment variable is set to '/usr/share:/usr/share/kde-plasma:/usr/local/share/:/usr/share/'; make sure this includes all paths where Akonadi agents are installed.

Directory listing of '/usr/share/akonadi/agents':
akonadinepomukfeederagent.desktop
akonotesresource.desktop
archivemailagent.desktop
birthdaysresource.desktop
contactsresource.desktop
davgroupwareresource.desktop
facebookresource.desktop
folderarchiveagent.desktop
googlecalendarresource.desktop
googlecontactsresource.desktop
icaldirresource.desktop
icalresource.desktop
imapresource.desktop
invitationsagent.desktop
kabcresource.desktop
kalarmdirresource.desktop
kalarmresource.desktop
kcalresource.desktop
kdeaccountsresource.desktop
kolabproxyresource.desktop
localbookmarksresource.desktop
maildirresource.desktop
maildispatcheragent.desktop
mailfilteragent.desktop
mboxresource.desktop
migrationagent.desktop
mixedmaildirresource.desktop
mtdummyresource.desktop
newmailnotifieragent.desktop
nntpresource.desktop
notesagent.desktop
notesresource.desktop
openxchangeresource.desktop
pop3resource.desktop
sendlateragent.desktop
vcarddirresource.desktop
vcardresource.desktop

Environment variable XDG_DATA_DIRS is set to '/usr/share:/usr/share/kde-plasma:/usr/local/share/:/usr/share/'

Test 8:  ERROR
--------

Current Akonadi server error log found.
Details: The Akonadi server reported errors during its current startup. The log can be found in <a href='/home/aaron/.local/share/akonadi/akonadiserver.error'>/home/aaron/.local/share/akonadi/akonadiserver.error</a>.

File content of '/home/aaron/.local/share/akonadi/akonadiserver.error':
Database error: Cannot open database.
  Last driver error: "QPSQL: Unable to connect"
  Last database error: "FATAL:  Peer authentication failed for user "akonadi"
"
Unable to open database "FATAL:  Peer authentication failed for user "akonadi"
QPSQL: Unable to connect"
"[
0: akonadiserver() [0x419cb7]
1: akonadiserver() [0x419f12]
2: /lib/x86_64-linux-gnu/libc.so.6(+0x36d40) [0x7fc237749d40]
3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x39) [0x7fc237749cc9]
4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x148) [0x7fc23774d0d8]
5: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x102) [0x7fc239230c92]
6: akonadiserver() [0x41bdbd]
7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xb0) [0x7fc2392cb470]
8: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x11ab3d) [0x7fc2392dab3d]
9: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x31) [0x7fc2392e3721]
10: akonadiserver() [0x41f658]
11: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x24e) [0x7fc239355c1e]
12: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x6d) [0x7fc23933d4dd]
13: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1ed) [0x7fc239340b3d]
14: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x1aaf83) [0x7fc23936af83]
15: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x254) [0x7fc236e18e04]
16: /lib/x86_64-linux-gnu/libglib-2.0.so.0(+0x49048) [0x7fc236e19048]
17: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7fc236e190ec]
18: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x71) [0x7fc23936a7a1]
19: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x2f) [0x7fc23933c0af]
20: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x175) [0x7fc23933c3a5]
21: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x89) [0x7fc239341b79]
22: akonadiserver() [0x4142e7]
23: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf5) [0x7fc237734ec5]
24: akonadiserver() [0x414c48]
]
"


Test 9:  ERROR
--------

Previous Akonadi server error log found.
Details: The Akonadi server reported errors during its previous startup. The log can be found in <a href='/home/aaron/.local/share/akonadi/akonadiserver.error.old'>/home/aaron/.local/share/akonadi/akonadiserver.error.old</a>.

File content of '/home/aaron/.local/share/akonadi/akonadiserver.error.old':
Database error: Cannot open database.
  Last driver error: "QPSQL: Unable to connect"
  Last database error: "FATAL:  Peer authentication failed for user "akonadi"
"
Unable to open database "FATAL:  Peer authentication failed for user "akonadi"
QPSQL: Unable to connect"
"[
0: akonadiserver() [0x419cb7]
1: akonadiserver() [0x419f12]
2: /lib/x86_64-linux-gnu/libc.so.6(+0x36d40) [0x7fce6cd5fd40]
3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x39) [0x7fce6cd5fcc9]
4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x148) [0x7fce6cd630d8]
5: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x102) [0x7fce6e846c92]
6: akonadiserver() [0x41bdbd]
7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xb0) [0x7fce6e8e1470]
8: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x11ab3d) [0x7fce6e8f0b3d]
9: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x31) [0x7fce6e8f9721]
10: akonadiserver() [0x41f658]
11: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x24e) [0x7fce6e96bc1e]
12: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x6d) [0x7fce6e9534dd]
13: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1ed) [0x7fce6e956b3d]
14: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x1aaf83) [0x7fce6e980f83]
15: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x254) [0x7fce6c42ee04]
16: /lib/x86_64-linux-gnu/libglib-2.0.so.0(+0x49048) [0x7fce6c42f048]
17: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7fce6c42f0ec]
18: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x71) [0x7fce6e9807a1]
19: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x2f) [0x7fce6e9520af]
20: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x175) [0x7fce6e9523a5]
21: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x89) [0x7fce6e957b79]
22: akonadiserver() [0x4142e7]
23: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf5) [0x7fce6cd4aec5]
24: akonadiserver() [0x414c48]
]
"


Test 10:  SUCCESS
--------

No current Akonadi control error log found.
Details: The Akonadi control process did not report any errors during its current startup.

Test 11:  SUCCESS
--------

No previous Akonadi control error log found.
Details: The Akonadi control process did not report any errors during its previous startup.



Bookmarks



Who is online

Registered users: Bing [Bot], Google [Bot]