I am having troubles with Kmail after installing Amarok on my Gentoo system. The problem comes up every time I start Kmail and the only thing I can do is saving a copy of the error log file. Closing the error message window closes down Kmail as well.
I have already gone through different steps like updating the system (x11-libs/qt and Kde-meta to version 4.4.5) and this has reduced the number of Error lines in the error log file, but the problem is still there with "Akonadi control process is not registered at D-Bus" being the most significant.

akonadictl status shows this.

Code: Select all

$ akonadictl status
Akonadi Control: stopped
Akonadi Server: stopped
Akonadi Server Search Support: available (backend: Unknown)


I post also the most recent error log file and the output of akonadictl start

Code: Select all

Akonadi Server Self-Test Report
===============================

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

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

File content of '/home/fede/.config/akonadi/akonadiserverrc':
[%General]
Driver=QSQLITE
SizeThreshold=4096
ExternalPayload=false

[QSQLITE]
Name=/home/fede/.local/share/akonadi/akonadi.db
Host=
User=
Password=
Options=
StartServer=false


Test 2:  SKIP
--------

MySQL server executable not tested.
Details: The current configuration does not require an internal MySQL server.

Test 3:  SKIP
--------

MySQL server error log not tested.
Details: The current configuration does not require an internal MySQL server.

Test 4:  SKIP
--------

MySQL server configuration not tested.
Details: The current configuration does not require an internal MySQL server.

Test 5:  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.3.1


Test 6:  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 7:  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 8:  SUCCESS
--------

Nepomuk search service registered at D-Bus.
Details: The Nepomuk search service is registered at D-Bus which typically indicates it is operational.

Test 9:  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 10:  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 /usr/share/akonadi/agents'. The XDG_DATA_DIRS environment variable is set to '/usr/share:/usr/local/share:/usr/share', make sure this includes all paths where Akonadi agents are installed to.

Directory listing of '/usr/share/akonadi/agents':
birthdaysresource.desktop
contactsresource.desktop
icalresource.desktop
imapresource.desktop
kabcresource.desktop
kcalresource.desktop
knutresource.desktop
kolabproxyresource.desktop
localbookmarksresource.desktop
maildirresource.desktop
maildispatcheragent.desktop
mboxresource.desktop
microblog.desktop
mtdummyresource.desktop
nepomukcalendarfeeder.desktop
nepomukcontactfeeder.desktop
nepomuktagresource.desktop
nntpresource.desktop
notesresource.desktop
pop3resource.desktop
vcarddirresource.desktop
vcardresource.desktop
Directory listing of '/usr/share/akonadi/agents':
birthdaysresource.desktop
contactsresource.desktop
icalresource.desktop
imapresource.desktop
kabcresource.desktop
kcalresource.desktop
knutresource.desktop
kolabproxyresource.desktop
localbookmarksresource.desktop
maildirresource.desktop
maildispatcheragent.desktop
mboxresource.desktop
microblog.desktop
mtdummyresource.desktop
nepomukcalendarfeeder.desktop
nepomukcontactfeeder.desktop
nepomuktagresource.desktop
nntpresource.desktop
notesresource.desktop
pop3resource.desktop
vcarddirresource.desktop
vcardresource.desktop

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

Test 11:  ERROR
--------

Current Akonadi server error log found.
Details: The Akonadi server did report error during startup into <a href='/home/fede/.local/share/akonadi/akonadiserver.error'>/home/fede/.local/share/akonadi/akonadiserver.error</a>.

File content of '/home/fede/.local/share/akonadi/akonadiserver.error':
"Unable to add initial data to table 'ResourceTable'.
Query error: 'no such column: true Unable to execute statement'
Query was: INSERT INTO ResourceTable (name,isVirtual) VALUES ('akonadi_search_resource',true)"
Unable to initialize database.
"[
0: akonadiserver(_Z11akBacktracev+0x35) [0x8052605]
1: akonadiserver() [0x8052ad6]
2: [0xb78a3400]
3: [0xb78a3424]
4: /lib/libc.so.6(gsignal+0x51) [0xb718c451]
5: /lib/libc.so.6(abort+0x182) [0xb718db92]
6: /usr/lib/qt4/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8c) [0xb752143c]
7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8053b54]
8: /usr/lib/qt4/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x8e) [0xb75b785e]
9: /usr/lib/qt4/libQtCore.so.4(+0x102ba5) [0xb75c6ba5]
10: /usr/lib/qt4/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3d) [0xb75c80cd]
11: akonadiserver(_ZN6QDebugD1Ev+0x43) [0x804e1f3]
12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x67a) [0xb778b67a]
13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x58) [0xb778c538]
14: akonadiserver(main+0x2c7) [0x804d817]
15: /lib/libc.so.6(__libc_start_main+0xe6) [0xb7178bb6]
16: akonadiserver() [0x804d461]
]
"


Test 12:  ERROR
--------

Previous Akonadi server error log found.
Details: The Akonadi server did report error during its previous startup into <a href='/home/fede/.local/share/akonadi/akonadiserver.error.old'>/home/fede/.local/share/akonadi/akonadiserver.error.old</a>.

File content of '/home/fede/.local/share/akonadi/akonadiserver.error.old':
"Unable to add initial data to table 'ResourceTable'.
Query error: 'no such column: true Unable to execute statement'
Query was: INSERT INTO ResourceTable (name,isVirtual) VALUES ('akonadi_search_resource',true)"
Unable to initialize database.
"[
0: akonadiserver(_Z11akBacktracev+0x35) [0x8052605]
1: akonadiserver() [0x8052ad6]
2: [0xb7737400]
3: [0xb7737424]
4: /lib/libc.so.6(gsignal+0x51) [0xb7020451]
5: /lib/libc.so.6(abort+0x182) [0xb7021b92]
6: /usr/lib/qt4/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8c) [0xb73b543c]
7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8053b54]
8: /usr/lib/qt4/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x8e) [0xb744b85e]
9: /usr/lib/qt4/libQtCore.so.4(+0x102ba5) [0xb745aba5]
10: /usr/lib/qt4/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3d) [0xb745c0cd]
11: akonadiserver(_ZN6QDebugD1Ev+0x43) [0x804e1f3]
12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x67a) [0xb761f67a]
13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x58) [0xb7620538]
14: akonadiserver(main+0x2c7) [0x804d817]
15: /lib/libc.so.6(__libc_start_main+0xe6) [0xb700cbb6]
16: akonadiserver() [0x804d461]
]
"


Test 13:  SUCCESS
--------

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

Test 14:  SUCCESS
--------

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


and

Code: Select all

$ akonadictl start
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
Starting Akonadi Server...
   done.
fede@Nexus ~ $ Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
[akonadiserver] QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
[akonadiserver] Database "/home/fede/.local/share/akonadi/akonadi.db" opened using driver "QSQLITE"
[akonadiserver] DbInitializer::run()
[akonadiserver] checking table  "SchemaVersionTable"
[akonadiserver] checking table  "ResourceTable"
[akonadiserver] "Unable to add initial data to table 'ResourceTable'.
[akonadiserver] Query error: 'no such column: true Unable to execute statement'
[akonadiserver] Query was: INSERT INTO ResourceTable (name,isVirtual) VALUES ('akonadi_search_resource',true)"
[akonadiserver] Unable to initialize database.
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x35) [0x8052605]
[akonadiserver] 1: akonadiserver() [0x8052ad6]
[akonadiserver] 2: [0xb77ed400]
[akonadiserver] 3: [0xb77ed424]
[akonadiserver] 4: /lib/libc.so.6(gsignal+0x51) [0xb70d6451]
[akonadiserver] 5: /lib/libc.so.6(abort+0x182) [0xb70d7b92]
[akonadiserver] 6: /usr/lib/qt4/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8c) [0xb746b43c]
[akonadiserver] 7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8053b54]
[akonadiserver] 8: /usr/lib/qt4/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x8e) [0xb750185e]
[akonadiserver] 9: /usr/lib/qt4/libQtCore.so.4(+0x102ba5) [0xb7510ba5]
[akonadiserver] 10: /usr/lib/qt4/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3d) [0xb75120cd]
[akonadiserver] 11: akonadiserver(_ZN6QDebugD1Ev+0x43) [0x804e1f3]
[akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x67a) [0xb76d567a]
[akonadiserver] 13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x58) [0xb76d6538]
[akonadiserver] 14: akonadiserver(main+0x2c7) [0x804d817]
[akonadiserver] 15: /lib/libc.so.6(__libc_start_main+0xe6) [0xb70c2bb6]
[akonadiserver] 16: akonadiserver() [0x804d461]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
[akonadiserver] QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
[akonadiserver] Database "/home/fede/.local/share/akonadi/akonadi.db" opened using driver "QSQLITE"
[akonadiserver] DbInitializer::run()
[akonadiserver] checking table  "SchemaVersionTable"
[akonadiserver] checking table  "ResourceTable"
[akonadiserver] "Unable to add initial data to table 'ResourceTable'.
[akonadiserver] Query error: 'no such column: true Unable to execute statement'
[akonadiserver] Query was: INSERT INTO ResourceTable (name,isVirtual) VALUES ('akonadi_search_resource',true)"
[akonadiserver] Unable to initialize database.
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x35) [0x8052605]
[akonadiserver] 1: akonadiserver() [0x8052ad6]
[akonadiserver] 2: [0xb77f7400]
[akonadiserver] 3: [0xb77f7424]
[akonadiserver] 4: /lib/libc.so.6(gsignal+0x51) [0xb70e0451]
[akonadiserver] 5: /lib/libc.so.6(abort+0x182) [0xb70e1b92]
[akonadiserver] 6: /usr/lib/qt4/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8c) [0xb747543c]
[akonadiserver] 7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8053b54]
[akonadiserver] 8: /usr/lib/qt4/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x8e) [0xb750b85e]
[akonadiserver] 9: /usr/lib/qt4/libQtCore.so.4(+0x102ba5) [0xb751aba5]
[akonadiserver] 10: /usr/lib/qt4/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3d) [0xb751c0cd]
[akonadiserver] 11: akonadiserver(_ZN6QDebugD1Ev+0x43) [0x804e1f3]
[akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x67a) [0xb76df67a]
[akonadiserver] 13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x58) [0xb76e0538]
[akonadiserver] 14: akonadiserver(main+0x2c7) [0x804d817]
[akonadiserver] 15: /lib/libc.so.6(__libc_start_main+0xe6) [0xb70ccbb6]
[akonadiserver] 16: akonadiserver() [0x804d461]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
[akonadiserver] QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
[akonadiserver] Database "/home/fede/.local/share/akonadi/akonadi.db" opened using driver "QSQLITE"
[akonadiserver] DbInitializer::run()
[akonadiserver] checking table  "SchemaVersionTable"
[akonadiserver] checking table  "ResourceTable"
[akonadiserver] "Unable to add initial data to table 'ResourceTable'.
[akonadiserver] Query error: 'no such column: true Unable to execute statement'
[akonadiserver] Query was: INSERT INTO ResourceTable (name,isVirtual) VALUES ('akonadi_search_resource',true)"
[akonadiserver] Unable to initialize database.
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x35) [0x8052605]
[akonadiserver] 1: akonadiserver() [0x8052ad6]
[akonadiserver] 2: [0xb78a3400]
[akonadiserver] 3: [0xb78a3424]
[akonadiserver] 4: /lib/libc.so.6(gsignal+0x51) [0xb718c451]
[akonadiserver] 5: /lib/libc.so.6(abort+0x182) [0xb718db92]
[akonadiserver] 6: /usr/lib/qt4/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8c) [0xb752143c]
[akonadiserver] 7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8053b54]
[akonadiserver] 8: /usr/lib/qt4/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x8e) [0xb75b785e]
[akonadiserver] 9: /usr/lib/qt4/libQtCore.so.4(+0x102ba5) [0xb75c6ba5]
[akonadiserver] 10: /usr/lib/qt4/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3d) [0xb75c80cd]
[akonadiserver] 11: akonadiserver(_ZN6QDebugD1Ev+0x43) [0x804e1f3]
[akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x67a) [0xb778b67a]
[akonadiserver] 13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x58) [0xb778c538]
[akonadiserver] 14: akonadiserver(main+0x2c7) [0x804d817]
[akonadiserver] 15: /lib/libc.so.6(__libc_start_main+0xe6) [0xb7178bb6]
[akonadiserver] 16: akonadiserver() [0x804d461]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
[akonadiserver] QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
[akonadiserver] Database "/home/fede/.local/share/akonadi/akonadi.db" opened using driver "QSQLITE"
[akonadiserver] DbInitializer::run()
[akonadiserver] checking table  "SchemaVersionTable"
[akonadiserver] checking table  "ResourceTable"
[akonadiserver] "Unable to add initial data to table 'ResourceTable'.
[akonadiserver] Query error: 'no such column: true Unable to execute statement'
[akonadiserver] Query was: INSERT INTO ResourceTable (name,isVirtual) VALUES ('akonadi_search_resource',true)"
[akonadiserver] Unable to initialize database.
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x35) [0x8052605]
[akonadiserver] 1: akonadiserver() [0x8052ad6]
[akonadiserver] 2: [0xb77ce400]
[akonadiserver] 3: [0xb77ce424]
[akonadiserver] 4: /lib/libc.so.6(gsignal+0x51) [0xb70b7451]
[akonadiserver] 5: /lib/libc.so.6(abort+0x182) [0xb70b8b92]
[akonadiserver] 6: /usr/lib/qt4/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8c) [0xb744c43c]
[akonadiserver] 7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8053b54]
[akonadiserver] 8: /usr/lib/qt4/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x8e) [0xb74e285e]
[akonadiserver] 9: /usr/lib/qt4/libQtCore.so.4(+0x102ba5) [0xb74f1ba5]
[akonadiserver] 10: /usr/lib/qt4/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3d) [0xb74f30cd]
[akonadiserver] 11: akonadiserver(_ZN6QDebugD1Ev+0x43) [0x804e1f3]
[akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x67a) [0xb76b667a]
[akonadiserver] 13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x58) [0xb76b7538]
[akonadiserver] 14: akonadiserver(main+0x2c7) [0x804d817]
[akonadiserver] 15: /lib/libc.so.6(__libc_start_main+0xe6) [0xb70a3bb6]
[akonadiserver] 16: akonadiserver() [0x804d461]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!


I have also removed all files and directories from ~/.local/share/akonadi/ with command rm -Rf ~/.local/share/akonadi/ hoping that this could remove some pre-existing configuration file but this was of no help.

Thanks in advance.

This is probably caused by the "SQLITE" driver you are trying to use with Akonadi. In order for it to function properly with SQLite databases, you need to use the "SQLITE3" driver instead.

You need to remove your database and edit the Akonadi server configuration file located in ~/.config/akonadi/ to reflect this.

Excellent. I have edited my ~/.config/akonadi/akonadiserverrc file and changed these lines from

[%General]
Driver=QSQLITE
....
[QSQLITE]
into
[%General]
Driver=SQLITE3
....
[SQLITE3]

I have then restarted Kmail which now works fine. After restarting Kmail file ~/.config/akonadi/akonadiserverrc has been changed as follows

Code: Select all

[%General]
Driver=QMYSQL
SizeThreshold=4096
ExternalPayload=false

[SQLITE3]
Name=/home/fede/.local/share/akonadi/akonadi.db
Host=
User=
Password=
Options=
StartServer=false

[QMYSQL]
Name=akonadi
Host=
User=
Password=
Options="UNIX_SOCKET=/home/fede/.local/share/akonadi/db_misc/mysql.socket"
ServerPath=/usr/sbin/mysqld
StartServer=true

[Debug]
Tracer=null


and the directory ~/.local/share/akonadi/ has been automatically populated again and looks like this:

Code: Select all

$ ls -al ~/.local/share/akonadi/
total 40
drwxr-xr-x 5 fede users 4096 Jan 15 22:54 .
drwx------ 8 fede users 4096 Jan 10 00:09 ..
-rw-r--r-- 1 fede users 5120 Jan 10 00:09 akonadi.db
-rw-r--r-- 1 fede users  141 Jan 15 22:54 akonadiserver.error
-rw-r--r-- 1 fede users 1185 Jan 10 17:22 akonadiserver.error.old
srwxr-xr-x 1 fede users    0 Jan 15 22:54 akonadiserver.socket
drwxr-xr-x 3 fede users 4096 Jan 15 22:54 db_data
drwxr-xr-x 2 fede users 4096 Jan 15 22:54 db_misc
drwxr-xr-x 2 fede users 4096 Jan 15 22:54 file_db_data
-rw-r--r-- 1 fede users 2033 Jan 15 22:54 mysql.conf


The problem appears to be solved.
I am surprised to notice that akonadi seems to be "stopped"

Code: Select all

# akonadictl status
Akonadi Control: stopped
Akonadi Server: stopped
Akonadi Server Search Support: not available


Anyway the awful akonadi error does not show up anymore and Kmail goes fine.
Thanks a lot.

No problem, however the notice that Akonadi is stopped and Nepomuk search is unavailable is slightly concerning.

Hi, I had the same issue in Kubuntu 12.04 and solved it in a different way , I had mysql as the DB . heres what i did

• Using Muon package manager i installed the all Akonadi - mysql related stuff there aren't many (akonadi-backend-mysql, akonadi-server, akonadi-dbg )
• And still after that Akonadi gave the same error - so i knew it not an issue with lack of dependencies but the configuration , so ran Akonadi Configuration tool and under the

  Akonadi Server Configuration tab->MySQL sever executable

  was

  /usr/sbin/mysqld

• As guided in the http://userbase.kde.org/Akonadi_4.4/Troubleshooting i edited the "/etc/apparmor.d/usr.sbin.mysqld-akonadi" file below the line

  Code: Select all

  @{HOME}/.local/share/akonadi/** rwk,

  i added

  Code: Select all

  @{HOME}/.Private/** rwk,

• So I tried to locate all mysql related stuff with

  Code: Select all

  locate mysql

  just to check whether I could find a related config file or something and I got a long list
  while scanning that i came across the answer

  Code: Select all

  /usr/sbin/mysqld-akonadi

  . I just copy it and paste as the MySQL server executable and start the Akonadi
  

  Code: Select all

  akonadictl start

  and restart the apparmor as well

  Code: Select all

  sudo service apparmor restart

  or

  Code: Select all

  sudo /etc/init.d/apparmor restart

  
  

hope this helps someone and save some time as well cheers