[Bug 676173] Re: kaddressbook fails to show addressbooks contents
fbusse
frank at busse.oche.de
Sun Dec 12 15:11:24 UTC 2010
Indeed, the NFS server appears to be about 2 minutes in the future - I
will try to fix this. - Meanwhile...
$ akonadictl stop
$ rm -r ~/.local/share/akonadi/
$ rm -r ~/.config/akonadi/
$ akonadictl start
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
Starting Akonadi Server...
done.
$ Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
[akonadiserver] search paths: ("/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] "Installing MySQL system tables...
"
"akonadiserver" [out] "OK
"
"akonadiserver" [out] "Filling help tables...
"
"akonadiserver" [out] "OK
"
"akonadiserver" [out] "
"
"akonadiserver" [out] "To start mysqld at boot time you have to copy
"
"akonadiserver" [out] "support-files/mysql.server to the right place for your system
"
"akonadiserver" [out] "
"
"akonadiserver" [out] "PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
"
"akonadiserver" [out] "To do so, start the server, then issue the following commands:
"
"akonadiserver" [out] "
"
"akonadiserver" [out] "/usr/bin/mysqladmin -u root password 'new-password'
"
"akonadiserver" [out] "/usr/bin/mysqladmin -u root -h alpha password 'new-password'
"
"akonadiserver" [out] "
"
"akonadiserver" [out] "Alternatively you can run:
"
"akonadiserver" [out] "/usr/bin/mysql_secure_installation
"
"akonadiserver" [out] "
"
"akonadiserver" [out] "which will also give you the option of removing the test
"
"akonadiserver" [out] "databases and anonymous user created by default. This is
"
"akonadiserver" [out] "strongly recommended for production servers.
"
"akonadiserver" [out] "
"
"akonadiserver" [out] "See the manual for more instructions.
"
"akonadiserver" [out] "
"
"akonadiserver" [out] "You can start the MySQL daemon with:
"
"akonadiserver" [out] "cd /usr ; /usr/bin/mysqld_safe &
"
"akonadiserver" [out] "
"
"akonadiserver" [out] "You can test the MySQL daemon with mysql-test-run.pl
"
"akonadiserver" [out] "cd /usr/mysql-test ; perl mysql-test-run.pl
"
"akonadiserver" [out] "
"
"akonadiserver" [out] "Please report any problems with the /usr/bin/mysqlbug script!
"
"akonadiserver" [out] "
"
"akonadiserver" [out] "The latest information about MySQL is available at http://www.mysql.com/
"
"akonadiserver" [out] "Support MySQL by buying support/licenses from http://shop.mysql.com/
"
"akonadiserver" [out] "
"
[akonadiserver] Failed to use database "akonadi"
[akonadiserver] Query error: "Unknown database 'akonadi' QMYSQL: Unable to execute query"
[akonadiserver] Database error: "Can't connect to local MySQL server through socket '/home/user/.local/share/akonadi/db_misc/mysql.socket' (2) QMYSQL: Unable to connect"
[akonadiserver] Trying to create database now...
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] DbInitializer::run()
[akonadiserver] checking table "SchemaVersionTable"
[akonadiserver] "CREATE TABLE SchemaVersionTable (version INTEGER NOT NULL);"
[akonadiserver] checking table "ResourceTable"
[akonadiserver] "CREATE TABLE ResourceTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255) BINARY NOT NULL UNIQUE, isVirtual BOOL DEFAULT false);"
[akonadiserver] checking table "CollectionTable"
[akonadiserver] "CREATE TABLE CollectionTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, remoteId TEXT , name VARCHAR(255) BINARY character set utf8 collate utf8_bin NOT NULL, parentId BIGINT DEFAULT NULL REFERENCES CollectionTable(id) ON DELETE CASCADE ON UPDATE CASCADE, resourceId BIGINT NOT NULL REFERENCES ResourceTable(id) ON DELETE CASCADE ON UPDATE CASCADE, subscribed BOOL NOT NULL DEFAULT true, cachePolicyInherit BOOL NOT NULL DEFAULT true, cachePolicyCheckInterval INTEGER NOT NULL DEFAULT -1, cachePolicyCacheTimeout INTEGER NOT NULL DEFAULT -1, cachePolicySyncOnDemand BOOL NOT NULL DEFAULT false, cachePolicyLocalParts TEXT );"
[akonadiserver] adding index "CREATE UNIQUE INDEX CollectionTable_parentAndNameIndex ON CollectionTable (parentId,name);"
[akonadiserver] checking table "MimeTypeTable"
[akonadiserver] "CREATE TABLE MimeTypeTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255) NOT NULL UNIQUE);"
[akonadiserver] checking table "PimItemTable"
[akonadiserver] "CREATE TABLE PimItemTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, rev INTEGER NOT NULL DEFAULT 0, remoteId TEXT , collectionId BIGINT REFERENCES CollectionTable(id) ON DELETE CASCADE ON UPDATE CASCADE, mimeTypeId BIGINT REFERENCES MimeTypeTable(id) ON DELETE CASCADE ON UPDATE CASCADE, datetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP, atime TIMESTAMP , dirty BOOL , size BIGINT NOT NULL DEFAULT 0);"
[akonadiserver] adding index "CREATE INDEX PimItemTable_collectionIndex ON PimItemTable (collectionId);"
[akonadiserver] checking table "FlagTable"
[akonadiserver] "CREATE TABLE FlagTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255) NOT NULL UNIQUE);"
[akonadiserver] checking table "PartTable"
[akonadiserver] "CREATE TABLE PartTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, pimItemId BIGINT NOT NULL REFERENCES PimItemTable(id) ON DELETE CASCADE ON UPDATE CASCADE, name VARCHAR(255) NOT NULL, data LONGBLOB , datasize BIGINT NOT NULL, version INTEGER DEFAULT 0, external BOOL , FOREIGN KEY (pimItemId) REFERENCES PimItemTable(id) ON DELETE CASCADE ON UPDATE CASCADE);"
[akonadiserver] adding index "CREATE UNIQUE INDEX PartTable_pimItemIdNameIndex ON PartTable (pimItemId,name);"
[akonadiserver] checking table "CollectionAttributeTable"
[akonadiserver] "CREATE TABLE CollectionAttributeTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, collectionId BIGINT NOT NULL REFERENCES CollectionTable(id) ON DELETE CASCADE ON UPDATE CASCADE, type LONGBLOB NOT NULL, value LONGBLOB );"
[akonadiserver] adding index "CREATE INDEX CollectionAttributeTable_collectionIndex ON CollectionAttributeTable (collectionId);"
[akonadiserver] checking relation "PimItemFlagRelation"
[akonadiserver] "CREATE TABLE PimItemFlagRelation (PimItem_id INTEGER REFERENCES PimItemTable(id) , Flag_id INTEGER REFERENCES FlagTable(id) , PRIMARY KEY (PimItem_id, Flag_id));"
[akonadiserver] checking relation "CollectionMimeTypeRelation"
[akonadiserver] "CREATE TABLE CollectionMimeTypeRelation (Collection_id INTEGER REFERENCES CollectionTable(id) , MimeType_id INTEGER REFERENCES MimeTypeTable(id) , PRIMARY KEY (Collection_id, MimeType_id));"
[akonadiserver] checking relation "CollectionPimItemRelation"
[akonadiserver] "CREATE TABLE CollectionPimItemRelation (Collection_id INTEGER REFERENCES CollectionTable(id) , PimItem_id INTEGER REFERENCES PimItemTable(id) , PRIMARY KEY (Collection_id, PimItem_id));"
[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] Nepomuk QueryServer interface not available!
[akonadiserver] Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
[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", "nepomuktagresource.desktop", "nntpresource.desktop", "notesresource.desktop", "pop3resource.desktop", "vcarddirresource.desktop", "vcardresource.desktop")
search paths: ("/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" 0 ("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" 0 ("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" 0 ("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")
[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] Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
[/usr/bin/akonadi_nepomuk_contact_feeder] "/usr/bin/akonadi_nepomuk_contact_feeder(6727)" Error in thread 3078338352 : "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] "/usr/bin/akonadi_nepomuk_contact_feeder(6727)" Error in thread 3078338352 : "QLocalSocket::connectToServer: Invalid name"
[/usr/bin/akonadi_nepomuk_contact_feeder] "/usr/bin/akonadi_nepomuk_contact_feeder(6727)" Error in thread 3078338352 : "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] "/usr/bin/akonadi_nepomuk_contact_feeder(6727)" Error in thread 3078338352 : "QLocalSocket::connectToServer: Invalid name"
[/usr/bin/akonadi_nepomuk_contact_feeder] "/usr/bin/akonadi_nepomuk_contact_feeder(6727)" Error in thread 3078338352 : "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] "/usr/bin/akonadi_nepomuk_contact_feeder(6727)" Error in thread 3078338352 : "QLocalSocket::connectToServer: Invalid name"
[/usr/bin/akonadi_nepomuk_contact_feeder] "/usr/bin/akonadi_nepomuk_contact_feeder(6727)" Error in thread 3078338352 : "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] "/usr/bin/akonadi_nepomuk_contact_feeder(6727)" Error in thread 3078338352 : "QLocalSocket::connectToServer: Invalid name"
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[/usr/bin/akonadi_nepomuk_contact_feeder] Nepomuk server already running.
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[/usr/bin/akonadi_maildispatcher_agent] akonadi_maildispatcher_agent(6728)/kdecore (KConfigSkeleton) KCoreConfigSkeleton::writeConfig:
$ more ~/.local/share/akonadi/db_data/mysql.err
101212 15:23:53 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
101212 15:23:53 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
101212 15:23:55 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 64 MB
InnoDB: Database physically writes the file full: wait...
101212 15:24:10 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 64 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
101212 15:24:26 InnoDB: Started; log sequence number 0 0
101212 15:24:26 [Note] /usr/sbin/mysqld-akonadi: ready for connections.
Version: '5.1.41-3ubuntu11-log' socket: '/home/user/.local/share/akonadi/db_misc/mysql.socket' port: 0 (Ubuntu)
... still no addressbooks contents in kaddressbook
--
You received this bug notification because you are a member of Kubuntu
Bugs, which is subscribed to kdepim in ubuntu.
https://bugs.launchpad.net/bugs/676173
Title:
kaddressbook fails to show addressbooks contents
More information about the kubuntu-bugs
mailing list