From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from pigeon.gentoo.org ([208.92.234.80] helo=lists.gentoo.org) by finch.gentoo.org with esmtp (Exim 4.60) (envelope-from ) id 1QZN0B-00049o-PU for garchives@archives.gentoo.org; Wed, 22 Jun 2011 12:57:52 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 5D3D41C0F2; Wed, 22 Jun 2011 12:56:13 +0000 (UTC) Received: from mail-ww0-f53.google.com (mail-ww0-f53.google.com [74.125.82.53]) by pigeon.gentoo.org (Postfix) with ESMTP id 135E91C0F2 for ; Wed, 22 Jun 2011 12:56:12 +0000 (UTC) Received: by wwf26 with SMTP id 26so700935wwf.10 for ; Wed, 22 Jun 2011 05:56:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:from:reply-to:to:subject:date:user-agent :references:in-reply-to:mime-version:content-type :content-transfer-encoding:message-id; bh=Wl8Cz5s1AJEiqjBtZdugLSbDZzFTR6O9splR4GISR+8=; b=QRi9EmJ9UeaPL3GBN2baUaz1dNarEHcHmyLeuSg++OJTqOlY60FGydAb/sx/a2XziQ hhQQGZwWc4rGAW0YtktnRzO6ceJwHRS7T0ssQy/hA3y0SG7m+QjU3gW5PINP++St3m8N 4d/BVKU2SwMhzii5aDfArcltlnZRj5GvBzAE0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=from:reply-to:to:subject:date:user-agent:references:in-reply-to :mime-version:content-type:content-transfer-encoding:message-id; b=mRkemfEPK+84XL+LVsp37HzeZlLWR09GPBS2Wv+T5+syOAl/ghY5dHnCK7NQTh/Au3 NcqAGOLZK/jiWJDmaeiUBEf+Bd3gRMthx8+z0Zoq1fF0A6V/Noopmwzcw5JwBBmjCopv 2apuAGHKeYjjKIvcIWdAzyBRc6fVb5BL9o2+8= Received: by 10.216.142.165 with SMTP id i37mr665624wej.106.1308747372177; Wed, 22 Jun 2011 05:56:12 -0700 (PDT) Received: from dell_xps.localnet ([213.123.142.221]) by mx.google.com with ESMTPS id g2sm290659wes.34.2011.06.22.05.56.10 (version=TLSv1/SSLv3 cipher=OTHER); Wed, 22 Jun 2011 05:56:11 -0700 (PDT) From: Mick To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] kdepim-4.6.0 woes Date: Wed, 22 Jun 2011 13:56:39 +0100 User-Agent: KMail/1.13.7 (Linux/2.6.38-gentoo-r6; KDE/4.6.3; x86_64; ; ) References: <1370928.tS5hQM40xH@nazgul> <201106221305.41476.michaelkintzios@gmail.com> <2259486.maH7REsZTc@nazgul> In-Reply-To: <2259486.maH7REsZTc@nazgul> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@lists.gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart1519636.Ryo9XlBPgv"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <201106221356.50300.michaelkintzios@gmail.com> X-Archives-Salt: X-Archives-Hash: da858ee596504155bbe9e8a0a295180a --nextPart1519636.Ryo9XlBPgv Content-Type: Text/Plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable On Wednesday 22 Jun 2011 13:16:05 you wrote: > On Wednesday 22 June 2011 13:05:31 Mick did opine thusly: > > Anyway, I noticed that a KDE machine which is using MySQL as a > > backend for Akonadi is not showing any contacts in its address > > book. All other boxen use sqlite3 instead and they do not seem to > > have any noticeable problems. > >=20 > > Could this be a MySQL issue? > >=20 > > PS. All of these PCs run stable KDE. >=20 > A while ago I eventually got my contacts back. I forget the actual > cause now, but I strongly suspect it involved tinkering with mysql, > and this may have broken in turn my calendar. >=20 > I'm going to do one last test before consigning kdepim to the > trashbin: migrate everything to a new user and start with a default > config. If it works, I can migrate the data at my leisure. >=20 > But now, stupid question incoming: >=20 > How you you get akonadi to use sqlite as the backend? There's no, erm, > gui tickbox for that. Yes, that's right, no GUI box to tick because the KDE devs did not like to= =20 support sqlite (some of the things they wanted to do were not straight forw= ard=20 under sqlite). The way I did it was to set it up manually in=20 ~/.config/akonadi/akonadiserverrc. This old thread describes how I went ab= out=20 it: http://article.gmane.org/gmane.linux.gentoo.user/224044 This is what my akonadiserverrc looks like today: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D [%General] Driver=3DQSQLITE SizeThreshold=3D4096 ExternalPayload=3Dfalse [QSQLITE] Name=3D/home/michael/.local/share/akonadi/akonadi.db Host=3D User=3D Password=3D Options=3D StartServer=3Dfalse [Debug] Tracer=3Dnull =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D No MYSQL section in there at all. However, I must issue a Health Warning here. I never had mysql on this=20 machine and did not have to migrate my PIM resources from mysql to sqlite. = So=20 YMMV. =2D-=20 Regards, Mick --nextPart1519636.Ryo9XlBPgv Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.17 (GNU/Linux) iEYEABECAAYFAk4B5pIACgkQVTDTR3kpaLZs5QCaAvAIhAZyTJLDYE21JKeP3LnI 6nUAoMuHPET7B3R5qlQfWqhQN7RzuRue =/FD4 -----END PGP SIGNATURE----- --nextPart1519636.Ryo9XlBPgv--