Since Akonadi from Ubuntu's Precise repositories is working quite well of late, I thought I'd experiment with reducing the number of databases required. I noticed the package akonadi-backend-odbc, which I installed. It's just some documentation, but does pull in a dependency, namely libqt4-sql-odbc. That package installed the library /usr/lib/x86_64-linux-gnu/qt4/plugins/sqldrivers/libqsqlodbc.so.

I stopped Akonadi, deleted all my resource files (everything's up on Gmail anyway), and changed ~/.config/akonadi/akonaidserverrc to this:

Code: Select all

[%General]
Driver=QODBC

[Debug]
Tracer=null


Restarting Akonadi from a console threw some errors:

Code: Select all

ASSERT: "database.driver()->hasFeature( QSqlDriver::LastInsertId )"
in file ../../server/src/storage/dbconfigvirtuoso.cpp, line 81
"[
0: akonadiserver() [0x4168d4]
1: akonadiserver() [0x416c6c]
2: /lib/x86_64-linux-gnu/libc.so.6(+0x36430) [0x7f49d4adc430]
3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35) [0x7f49d4adc3b5]
4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x17b) [0x7f49d4adfb1b]
5: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x11b) [0x7f49d678657b]
6: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x6b92f) [0x7f49d678692f]
7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z6qFatalPKcz+0x94) [0x7f49d6786ad4]
8: akonadiserver() [0x418861]
9: akonadiserver() [0x41aa95]
10: akonadiserver() [0x41b567]
11: akonadiserver() [0x411ae2]
12: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xed) [0x7f49d4ac730d]
13: akonadiserver() [0x412371]
]
"

akonadiserverrc gets modified; the following bit is added:

Code: Select all

[QODBC]
Name="host=localhost:1111;uid=dba;pwd=dba;driver=/opt/virtuoso/lib/virtodbc.so"
Options="SQL_ATTR_ODBC_VERSION=SQL_OV_ODBC3"


But virtodbc.so is not in the default path that Akonadi created, so I changed it to the correct location: /usr/lib/odbc/virtodbc.so. Trying to restart Akonadi still failed, with the same error output as before.

I'm aware of the TechBase mention that Virtuoso isn't working, but I'm left wondering whether that's true, given the existence of the ODBC backend package. Is there perhaps some other way of configuring akonadiserverrc that Google can't help me find, or is Akonadi + Virtuoso still a ways off?

Based on the backtrace output by Akonadi Server, it seems that the SQL backend which connects to Virtuoso does not support all the features Akonadi requires from a SQL backend, so it cannot be used for now.