KMail throws akonadi self-test error • KDE Community Forums

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

Board index

KMail throws akonadi self-test error

Page 1 of 1 (15 posts)

Tags:

zebulon Registered Member Posts 417 Karma 2 OS	KMail throws akonadi self-test error Sun Sep 19, 2010 8:29 pm I am getting MySQL error messages from KMail, MySQL server log contains errors Akonadi control process not registered at D-Bus Akonadi server process not registered at D-Bus No resource agents found etc. Mysql.err contains: Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist Could not use mysql-bin for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it. akonadiserver.error contains: Can't create test file /home/.../XXX.lower-test I think this is because I reinstalled the OS, but kept my old $HOME files, and ended up with a naming conflict for my hostname (XXX above). How can I fix this?
bcooksley Administrator Posts 19765 Karma 87 OS	Re: KMail throws akonadi self-test error Mon Sep 20, 2010 5:05 am Outside of KDE, open a terminal and run: rm $(kde4-config --localprefix)/cache-* rm $(kde4-config --localprefix)/tmp-* rm $(kde4-config --localprefix)/socket-* KDE Sysadmin [img]content/bcooksley_sig.png[/img]
zebulon Registered Member Posts 417 Karma 2 OS	Re: KMail throws akonadi self-test error Mon Sep 20, 2010 10:55 pm KMail still hangs when sending a message. akonadiserver.error says: Code: Select all Database process exited unexpectedly during initial connection! executable: "/usr/sbin/mysqld-akonadi" arguments: ("--defaults-file=/home/jan/.local/share/akonadi//mysql.conf", "--datadir=/home/jan/.local/share/akonadi/db_data/", "--socket=/home/jan/.local/share/akonadi/db_misc/mysql.socket") stdout: "" stderr: "100920 18:45:32 [Warning] Can't create test file /home/jan/.local/share/akonadi/db_data/Haddock.lower-test 100920 18:45:32 [Warning] Can't create test file /home/jan/.local/share/akonadi/db_data/Haddock.lower-test" exit code: 1 process error: "Process operation timed out" Thanks
bcooksley Administrator Posts 19765 Karma 87 OS	Re: KMail throws akonadi self-test error Tue Sep 21, 2010 4:40 am Please move /home/jan/.local/share/akonadi/db_data/ elsewhere with Akonadi stopped. Afterwards, please start Akonadi. To stop: Code: Select all `akonadictl stop` To start: Code: Select all `akonadictl start` KDE Sysadmin [img]content/bcooksley_sig.png[/img]
zebulon Registered Member Posts 417 Karma 2 OS	Re: KMail throws akonadi self-test error Tue Sep 21, 2010 11:20 pm I'm guessing the missing verb is "move". akonadi was not running (only akonaditray). I moved db_data and started akonadi. It gave several errors, which I assume were caused by the now missing db_data, but it did solve my problem. kMail now sends again. Many thanks.
bcooksley Administrator Posts 19765 Karma 87 OS	Re: KMail throws akonadi self-test error Wed Sep 22, 2010 5:18 am Oops. Yes, I did mean move. I have now fixed that omission. KDE Sysadmin [img]content/bcooksley_sig.png[/img]
zebulon Registered Member Posts 417 Karma 2 OS	Re: KMail throws akonadi self-test error Sat Sep 25, 2010 2:09 pm Every time I open kMail now, I am getting an error message Could not access the outbox folder (Unknown error (Unknown reason)) Should I remove Autostart, as suggested in viewtopic.php?f=20&t=86252 or is there a better solution?
bcooksley Administrator Posts 19765 Karma 87 OS	Re: KMail throws akonadi self-test error Sun Sep 26, 2010 8:51 pm Yes, please follow the steps given by the developer in that thread. KDE Sysadmin [img]content/bcooksley_sig.png[/img]
zebulon Registered Member Posts 417 Karma 2 OS	Re: KMail throws akonadi self-test error Sat Oct 02, 2010 7:33 pm Just to mention that the proposed fix does not really work. I still get the error each time I log on. I do not get it if I quit kMail and re-enter.
bcooksley Administrator Posts 19765 Karma 87 OS	Re: KMail throws akonadi self-test error Sat Oct 02, 2010 9:00 pm Please ensure Akonadi is started before running KMail. It can be started by running: "akonadictl start" in Konsole. KDE Sysadmin [img]content/bcooksley_sig.png[/img]
zebulon Registered Member Posts 417 Karma 2 OS	Re: KMail throws akonadi self-test error Sun Oct 03, 2010 2:05 am I started akonadi first thing after login from a shell and get the exact same error message popup. The akonadi output is quite long, but here are the errors from it: Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) [akonadiserver] search paths: ("/home/jan/bin", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin") [akonadiserver] Found mysql_install_db: "/usr/bin/mysql_install_db" [akonadiserver] Found mysql_upgrade: "/usr/bin/mysql_upgrade" "akonadiserver" [out] "Looking for 'mysql' as: /usr/bin/mysql" "akonadiserver" [out] "Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck" "akonadiserver" [out] "Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' '--socket=/home/jan/.local/share/akonadi/db_misc/mysql.socket' " [akonadiserver] /usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/home/jan/.local/share/akonadi/db_misc/mysql.socket' (2) when trying to connect [akonadiserver] FATAL ERROR: Upgrade failed and at the end [akonadiserver] Database "akonadi" opened using driver "QMYSQL" [/usr/bin/akonadi_maildispatcher_agent] akonadi_maildispatcher_agent(3660)/libakonadi Akonadi::DefaultResourceJob::slotResult: "Unknown resource" [/usr/bin/akonadi_maildispatcher_agent] akonadi_maildispatcher_agent(3660)/libakonadi Akonadi::ResourceScanJob::Private::fetchResult: "Unknown resource" [/usr/bin/akonadi_maildispatcher_agent] akonadi_maildispatcher_agent(3660)/libakonadi Akonadi::SpecialCollectionsRequestJobPrivate::resourceScanResult: Failed to request resource "akonadi_maildir_resource_0" : "Unknown error. (Unknown resource)" [/usr/bin/akonadi_maildispatcher_agent] akonadi_maildispatcher_agent(3660) OutboxQueue::Private::localFoldersRequestResult: Failed to get outbox folder. Thank you for your patience
bcooksley Administrator Posts 19765 Karma 87 OS	Re: KMail throws akonadi self-test error Sun Oct 03, 2010 7:16 am Can you please post the content of ~/.config/akonadi/akonadiserverrc? KDE Sysadmin [img]content/bcooksley_sig.png[/img]
zebulon Registered Member Posts 417 Karma 2 OS	Re: KMail throws akonadi self-test error Sun Oct 03, 2010 12:23 pm Code: Select all `[%General] Driver=QMYSQL SizeThreshold=4096 ExternalPayload=false [QMYSQL] Name=akonadi User= Password= Options="UNIX_SOCKET=/home/jan/.local/share/akonadi/db_misc/mysql.socket" ServerPath=/usr/sbin/mysqld-akonadi StartServer=true Host= [Debug] Tracer=null`
bcooksley Administrator Posts 19765 Karma 87 OS	Re: KMail throws akonadi self-test error Sun Oct 03, 2010 10:27 pm Can you please pastebin the full output from "akonadictl start" just after logging in? It seems that the MySQL server is failing to start. KDE Sysadmin [img]content/bcooksley_sig.png[/img]
zebulon Registered Member Posts 417 Karma 2 OS	Re: KMail throws akonadi self-test error Mon Oct 04, 2010 2:11 am Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) Starting Akonadi Server... done. jan@Haddock:~$ Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) [akonadiserver] search paths: ("/home/jan/bin", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin") [akonadiserver] Found mysql_install_db: "/usr/bin/mysql_install_db" [akonadiserver] Found mysql_upgrade: "/usr/bin/mysql_upgrade" "akonadiserver" [out] "Looking for 'mysql' as: /usr/bin/mysql" "akonadiserver" [out] "Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck" "akonadiserver" [out] "Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' '--socket=/home/jan/.local/share/akonadi/db_misc/mysql.socket' " [akonadiserver] /usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/home/jan/.local/share/akonadi/db_misc/mysql.socket' (2) when trying to connect [akonadiserver] FATAL ERROR: Upgrade failed [akonadiserver] Database "akonadi" opened using driver "QMYSQL" [akonadiserver] DbInitializer::run() [akonadiserver] checking table "SchemaVersionTable" [akonadiserver] checking table "ResourceTable" [akonadiserver] checking table "CollectionTable" [akonadiserver] checking table "MimeTypeTable" [akonadiserver] checking table "PimItemTable" [akonadiserver] checking table "FlagTable" [akonadiserver] checking table "PartTable" [akonadiserver] checking table "CollectionAttributeTable" [akonadiserver] checking relation "PimItemFlagRelation" [akonadiserver] checking relation "CollectionMimeTypeRelation" [akonadiserver] checking relation "CollectionPimItemRelation" [akonadiserver] DbInitializer::run() done [akonadiserver] skipping update 2 [akonadiserver] skipping update 3 [akonadiserver] skipping update 4 [akonadiserver] skipping update 8 [akonadiserver] skipping update 10 [akonadiserver] skipping update 12 [akonadiserver] skipping update 13 [akonadiserver] skipping update 14 [akonadiserver] Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) [akonadiserver] Database "akonadi" opened using driver "QMYSQL" [akonadiserver] DataStore::unhideAllPimItems() [akonadiserver] Database "akonadi" opened using driver "QMYSQL" PLUGINS: "/usr/share/akonadi/agents" PLUGINS: ("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") search paths: ("/home/jan/bin", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games") PLUGINS inserting: "akonadi_birthdays_resource" 0 ("Resource") PLUGINS inserting: "akonadi_contacts_resource" 0 ("Resource") PLUGINS inserting: "akonadi_ical_resource" 1 ("Resource") PLUGINS inserting: "akonadi_imap_resource" 0 ("Resource") PLUGINS inserting: "akonadi_kabc_resource" 0 ("Resource") PLUGINS inserting: "akonadi_kcal_resource" 0 ("Resource") PLUGINS inserting: "akonadi_knut_resource" 0 ("Resource") PLUGINS inserting: "akonadi_kolabproxy_resource" 0 ("Resource", "Unique", "NoConfig") PLUGINS inserting: "akonadi_localbookmarks_resource" 0 ("Resource") PLUGINS inserting: "akonadi_maildir_resource" 1 ("Resource") PLUGINS inserting: "akonadi_maildispatcher_agent" 0 ("Unique", "Autostart", "NoConfig") PLUGINS inserting: "akonadi_mbox_resource" 0 ("Resource") PLUGINS inserting: "akonadi_microblog_resource" 0 ("Resource") PLUGINS inserting: "akonadi_mailtransport_dummy_resource" 0 ("Resource", "MailTransport") PLUGINS inserting: "akonadi_nepomuk_calendar_feeder" 0 ("Unique", "NoConfig") PLUGINS inserting: "akonadi_nepomuk_contact_feeder" 0 ("Unique", "Autostart", "NoConfig") PLUGINS inserting: "akonadi_nepomuktag_resource" 0 ("Resource", "Virtual", "Unique", "NoConfig") PLUGINS inserting: "akonadi_nntp_resource" 0 ("Resource") PLUGINS inserting: "akonadi_notes_resource" 0 ("Resource") PLUGINS inserting: "akonadi_pop3_resource" 0 ("Resource") PLUGINS inserting: "akonadi_vcarddir_resource" 0 ("Resource") PLUGINS inserting: "akonadi_vcard_resource" 3 ("Resource") PLUGINS: "/usr/share/akonadi/agents" PLUGINS: ("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") [/usr/bin/akonadi_nepomuk_contact_feeder] Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) [/usr/bin/akonadi_ical_resource] Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) [akonadiserver] Database "akonadi" opened using driver "QMYSQL" [akonadiserver] Database "akonadi" opened using driver "QMYSQL" [akonadiserver] Database "akonadi" opened using driver "QMYSQL" [akonadiserver] Database "akonadi" opened using driver "QMYSQL" [akonadiserver] Database "akonadi" opened using driver "QMYSQL" [/usr/bin/akonadi_vcard_resource] Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) [/usr/bin/akonadi_vcard_resource] Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) [akonadiserver] Database "akonadi" opened using driver "QMYSQL" [/usr/bin/akonadi_maildispatcher_agent] akonadi_maildispatcher_agent(3189)/libakonadi Akonadi::DefaultResourceJob::slotResult: "Unknown resource" [/usr/bin/akonadi_maildispatcher_agent] akonadi_maildispatcher_agent(3189)/libakonadi Akonadi::ResourceScanJob::Private::fetchResult: "Unknown resource" [/usr/bin/akonadi_maildispatcher_agent] akonadi_maildispatcher_agent(3189)/libakonadi Akonadi::SpecialCollectionsRequestJobPrivate::resourceScanResult: Failed to request resource "akonadi_maildir_resource_0" : "Unknown error. (Unknown resource)" [/usr/bin/akonadi_maildispatcher_agent] akonadi_maildispatcher_agent(3189) OutboxQueue::Private::localFoldersRequestResult: Failed to get outbox folder.

Page 1 of 1 (15 posts)

Bookmarks

Who is online

Registered users: bartoloni, Bing [Bot], Evergrowing, Google [Bot], ourcraft