[kde-linux] Akonadi and PostgreSQL
Kevin Kempter
kevink at consistentstate.com
Wed Mar 17 19:39:47 UTC 2010
> On Wednesday, 2010-03-17, Kevin Kempter wrote:
> > > Since the file still contains the QPSQL specifc settings, this looks a
> > > lot like a bug to me, i.e. something writing the [%General] section but
> > > not having read it correctly.
> > > Could have been missed when Postgres capabilities were introduced.
> > > Strange thing is that it sometimes works, makes it harder to determine
> > > the actual cause :(
> > >
> > > Can you reproduce it everytime you first start KMail after a reboot?
> > >
> > > Cheers,
> > > Kevin
> >
> > Yes ive verified that it reverts to QMYSQL every time I reboot &
> >
> > subsequently start kmail
>
> Reproducible is good.
>
> Can you try rebooting and then starting Akonadi via commandline?
>
> akonadictl start
>
> I.e. if the problem is in Akonadi's startup itself if whether it depends on
> how it is started (explicit vs. on-demand).
>
> Cheers,
> Kevin
I did this:
1) reboot
2) I edited the $HOME/.config/akonadi/akonadiserverrc file to look like this:
[%General]
Driver=QPSQL
SizeThreshold=4096
ExternalPayload=false
[Debug]
Tracer=null
[QPSQL]
Name=akonadi
Host=localhost
User=akonadiuser
Password=akonadi001
Port=5477
[QMYSQL]
Name=akonadi
Host=
User=
Password=
Options="UNIX_SOCKET=/home/kkempter/.local/share/akonadi/db_misc/mysql.socket"
ServerPath=/usr/libexec/mysqld
StartServer=true
3) started the akonadi server via the command line:
$ akonadictl start
It seems the database driver QPSQL not found, see the output of the
akonadictl start below.
Note that if I go to the gui
(system settings->advanced->Akonadi Configuration->Akonadi Server Configuration)
then I can stop the running MySQL config and start the PostgreSQL config without
any errors. However, maybe it's not running the postgres config after all?
$ akonadictl start
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
Starting Akonadi Server...
done.
[/home/kkempter/.config/akonadi]
kkempter at Issac $ Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
[akonadiserver] Database driver "QPSQL" was not found.
[akonadiserver] Available drivers are: ("QSQLITE", "QMYSQL3", "QMYSQL",
"QODBC3", "QODBC")
[akonadiserver] Falling back to database driver "QMYSQL"
[akonadiserver] search paths: ("/stage/pgsql/8.4.2/bin",
"/usr/lib64/qt-3.3/bin", "/usr/kerberos/sbin", "/usr/kerberos/bin",
"/usr/lib64/ccache", "/usr/local/bin", "/usr/bin", "/bin", "/usr/games",
"/usr/local/sbin", "/usr/sbin", "/sbin", "/home/kkempter/bin", "/usr/sbin",
"/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec",
"/opt/local/lib/mysql5/bin")
[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] Nepomuk QueryServer interface not available!
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] DataStore::unhideAllPimItems()
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", "nepomukemailfeeder.desktop",
"nepomuktagresource.desktop", "nntpresource.desktop", "notesresource.desktop",
"pop3resource.desktop", "vcarddirresource.desktop", "vcardresource.desktop")
search paths: ("/stage/pgsql/8.4.2/bin", "/usr/lib64/qt-3.3/bin",
"/usr/kerberos/sbin", "/usr/kerberos/bin", "/usr/lib64/ccache",
"/usr/local/bin", "/usr/bin", "/bin", "/usr/games", "/usr/local/sbin",
"/usr/sbin", "/sbin", "/home/kkempter/bin")
PLUGINS inserting: "akonadi_birthdays_resource" 1 ("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" 3 ("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_nepomuk_email_feeder" 0 ("Unique")
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" 2 ("Resource")
[/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)
[/usr/bin/akonadi_ical_resource] Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[/usr/bin/akonadi_kabc_resource] akonadi_kabc_resource_2(2333)/kresources
KRES::Factory::self:
[/usr/bin/akonadi_kabc_resource] akonadi_kabc_resource_2(2333)/kdecore
(KSycoca) KSycocaPrivate::openDatabase: Trying to open ksycoca from
"/var/tmp/kdecache-kkempter/ksycoca4"
[/usr/bin/akonadi_kabc_resource] akonadi_kabc_resource_2(2333)/kresources
KRES::ManagerImpl::ManagerImpl:
[/usr/bin/akonadi_kabc_resource] akonadi_kabc_resource_2(2333)/kresources
KRES::ManagerImpl::readConfig:
[/usr/bin/akonadi_kabc_resource] akonadi_kabc_resource_2(2333)/kresources
KRES::Factory::self:
[/usr/bin/akonadi_nepomuk_contact_feeder] Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
[/usr/bin/akonadi_nepomuk_contact_feeder]
"/usr/bin/akonadi_nepomuk_contact_feeder(2336)" Error in thread
140224819476544 : "org.freedesktop.DBus.Error.ServiceUnknown - The name
org.kde.nepomuk.services.nepomukstorage was not provided by any .service files"
[/usr/bin/akonadi_nepomuk_contact_feeder]
akonadi_nepomuk_contact_feeder(2336)/nepomuk (library)
<unnamed>::GlobalModelContainer::init: Connecting to local socket
"/home/kkempter/.kde/share/apps/nepomuk/socket"
[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_nepomuk_contact_feeder]
"/usr/bin/akonadi_nepomuk_contact_feeder(2336)" Error in thread
140224819476544 : "QLocalSocket::connectToServer: Invalid name"
[/usr/bin/akonadi_nepomuk_contact_feeder]
akonadi_nepomuk_contact_feeder(2336)/nepomuk (library)
<unnamed>::GlobalModelContainer::init: Failed to connect to Nepomuk server via
local socket "/home/kkempter/.kde/share/apps/nepomuk/socket"
[/usr/bin/akonadi_nepomuk_contact_feeder]
"/usr/bin/akonadi_nepomuk_contact_feeder(2336)" Error in thread
140224819476544 : "org.freedesktop.DBus.Error.ServiceUnknown - The name
org.kde.nepomuk.services.nepomukstorage was not provided by any .service files"
[/usr/bin/akonadi_nepomuk_contact_feeder]
akonadi_nepomuk_contact_feeder(2336)/nepomuk (library)
<unnamed>::GlobalModelContainer::init: Connecting to local socket
"/home/kkempter/.kde/share/apps/nepomuk/socket"
[/usr/bin/akonadi_nepomuk_contact_feeder]
"/usr/bin/akonadi_nepomuk_contact_feeder(2336)" Error in thread
140224819476544 : "QLocalSocket::connectToServer: Invalid name"
[/usr/bin/akonadi_nepomuk_contact_feeder]
akonadi_nepomuk_contact_feeder(2336)/nepomuk (library)
<unnamed>::GlobalModelContainer::init: Failed to connect to Nepomuk server via
local socket "/home/kkempter/.kde/share/apps/nepomuk/socket"
[/usr/bin/akonadi_nepomuk_contact_feeder]
"/usr/bin/akonadi_nepomuk_contact_feeder(2336)" Error in thread
140224819476544 : "org.freedesktop.DBus.Error.ServiceUnknown - The name
org.kde.nepomuk.services.nepomukstorage was not provided by any .service files"
[/usr/bin/akonadi_nepomuk_contact_feeder]
akonadi_nepomuk_contact_feeder(2336)/nepomuk (library)
<unnamed>::GlobalModelContainer::init: Connecting to local socket
"/home/kkempter/.kde/share/apps/nepomuk/socket"
[/usr/bin/akonadi_nepomuk_contact_feeder]
"/usr/bin/akonadi_nepomuk_contact_feeder(2336)" Error in thread
140224819476544 : "QLocalSocket::connectToServer: Invalid name"
[/usr/bin/akonadi_nepomuk_contact_feeder]
akonadi_nepomuk_contact_feeder(2336)/nepomuk (library)
<unnamed>::GlobalModelContainer::init: Failed to connect to Nepomuk server via
local socket "/home/kkempter/.kde/share/apps/nepomuk/socket"
[/usr/bin/akonadi_nepomuk_contact_feeder]
"/usr/bin/akonadi_nepomuk_contact_feeder(2336)" Error in thread
140224819476544 : "org.freedesktop.DBus.Error.ServiceUnknown - The name
org.kde.nepomuk.services.nepomukstorage was not provided by any .service files"
[/usr/bin/akonadi_nepomuk_contact_feeder]
akonadi_nepomuk_contact_feeder(2336)/nepomuk (library)
<unnamed>::GlobalModelContainer::init: Connecting to local socket
"/home/kkempter/.kde/share/apps/nepomuk/socket"
[/usr/bin/akonadi_nepomuk_contact_feeder]
"/usr/bin/akonadi_nepomuk_contact_feeder(2336)" Error in thread
140224819476544 : "QLocalSocket::connectToServer: Invalid name"
[/usr/bin/akonadi_nepomuk_contact_feeder]
akonadi_nepomuk_contact_feeder(2336)/nepomuk (library)
<unnamed>::GlobalModelContainer::init: Failed to connect to Nepomuk server via
local socket "/home/kkempter/.kde/share/apps/nepomuk/socket"
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[/usr/bin/akonadi_maildispatcher_agent]
akonadi_maildispatcher_agent(2335)/libakonadi
Akonadi::DefaultResourceJob::slotResult: "Unknown resource"
[/usr/bin/akonadi_maildispatcher_agent]
akonadi_maildispatcher_agent(2335)/libakonadi
Akonadi::ResourceScanJob::Private::fetchResult: "Unknown resource"
[/usr/bin/akonadi_maildispatcher_agent]
akonadi_maildispatcher_agent(2335)/libakonadi
Akonadi::SpecialCollectionsRequestJobPrivate::resourceScanResult: Failed to
request resource "akonadi_maildir_resource_0" : "Unknown error. (Unknown
resource)"
[/usr/bin/akonadi_maildispatcher_agent] akonadi_maildispatcher_agent(2335)
OutboxQueue::Private::localFoldersRequestResult: Failed to get outbox folder.
[/usr/bin/akonadi_nepomuk_contact_feeder] Nepomuk server already running.
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
More information about the kde-linux
mailing list