[kde-linux] Akonadi and PostgreSQL

Kevin Kempter kevink at consistentstate.com
Wed Mar 17 19:42:39 UTC 2010 

On Wednesday 17 March 2010 01:39:47 pm Kevin Kempter wrote:
> > 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.sock
> et" 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"
> 
> 
> ___________________________________________________
> This message is from the kde-linux mailing list.
> Account management:  https://mail.kde.org/mailman/listinfo/kde-linux.
> Archives: http://lists.kde.org/.
> More info: http://www.kde.org/faq.html.



Note: I do have the QT PostgreSQL driver installed:

# rpm -qa | grep -i postgres                                                           
qt3-PostgreSQL-3.3.8b-28.fc12.x86_64                                                                 
postgresql-odbc-08.04.0200-1.fc12.x86_64                                                             
rekall-postgresql-2.4.6-12.fc12.x86_64                                                               
postgresql-libs-8.4.2-1.fc12.x86_

However I am running a postgres instance that I built from source, will this 
matter?

More information about the kde-linux mailing list