| Summary: | akonadi-server-1.3.1 fails to start with sqlite use flag in both qt-sql and akonadi-server | ||
|---|---|---|---|
| Product: | Gentoo Linux | Reporter: | lumbrius |
| Component: | [OLD] KDE | Assignee: | Gentoo KDE team <kde> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | minor | CC: | nikoli, ross |
| Priority: | High | Flags: | tampakrap:
Bugday+
|
| Version: | unspecified | ||
| Hardware: | AMD64 | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Package list: | Runtime testing required: | --- | |
| Attachments: |
akonadi-server self-test log
Output from akonadictl start command |
||
|
Description
lumbrius
2010-03-04 19:12:19 UTC
Created attachment 222083 [details]
akonadi-server self-test log
a emerge qt-sql did the trick for me (as described here: http://bugs.gentoo.org/show_bug.cgi?id=306539) I think you're missing one important thing mentioned explicitly in post_install message - sqlite backend is experimental and known to be broken (in 1.2.x and 1.3.x releases). Not sure that helps, but on my system the problem was that the akonadi db needs sqlite 3, but akonadi looks for the executable "sqlite" when starting up, which on Gentoo points to sqlite 2. Created attachment 237033 [details]
Output from akonadictl start command
Output from akonadictl start command
(In reply to comment #4) > Not sure that helps, but on my system the problem was that the akonadi db needs > sqlite 3, but akonadi looks for the executable "sqlite" when starting up, which > on Gentoo points to sqlite 2. > the link "ln -s /usr/bin/sqlite /usr/bin/sqlite3" does not cear this problem for me I think there's also a syntax error in the SQL statement it tries to execute (something about false being unquoted IIRC). If you run "akonadictl start" by hand it'll tell you what it is. Once you've seen it, connect to the sqlite db manually using sqlite3, and enter the statement with the correct syntax (ie, 'false' in single quotes). Exit and try to start akonadi again. I think that did the trick for me. (In reply to comment #7) > I think there's also a syntax error in the SQL statement it tries to execute > (something about false being unquoted IIRC). If you run "akonadictl start" by > hand it'll tell you what it is. Once you've seen it, connect to the sqlite db > manually using sqlite3, and enter the statement with the correct syntax (ie, > 'false' in single quotes). Exit and try to start akonadi again. I think that > did the trick for me. > I arrived at similar solution independently from Etaoin. Sqlite stores boolean values as integers, 0=false 1=true. My akonanadiserver.error file said; "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. I ran the sqlite3 application to connect to the akonadi.db file and ran the INSERT query after substituting the word true with integer 1. After I did this kmail started without any errors. https://bugs.kde.org/show_bug.cgi?id=238773 http://forums.gentoo.org/viewtopic-t-815342-start-0.html I think the summary of this report should be something like "akonadi-server should require qt-sql with mysql use flag enabled" according to the docs: http://userbase.kde.org/Akonadi_4.4/Troubleshooting#Missing_Prerequisite and also the mentioned KDE bug #238773, mysql is really needed for akonadi (at least for now) Sqlite backend in 1.3 is marked as experimental (and it's visibly communicated in pkg_postinst) and unsupported so I don't know why anyone expects it to work flawlessly. If you want to try sqlite backend, upgrade to akonadi-server 1.4. Also a note for those irresponsible using full ~arch. I've fixed akonadi-server-1.4 so that it doesn't bail out on too new sqlite version. *** This bug has been marked as a duplicate of bug 306539 *** |
