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 1NADRk-0004uK-F7 for garchives@archives.gentoo.org; Tue, 17 Nov 2009 02:05:32 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 18A42E04EB for ; Tue, 17 Nov 2009 02:05:31 +0000 (UTC) Received: from ey-out-1920.google.com (ey-out-1920.google.com [74.125.78.148]) by pigeon.gentoo.org (Postfix) with ESMTP id E78CFE0A7E for ; Tue, 17 Nov 2009 00:45:30 +0000 (UTC) Received: by ey-out-1920.google.com with SMTP id 3so1739789eyh.40 for ; Mon, 16 Nov 2009 16:45:30 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:from:to:subject:date :user-agent:references:in-reply-to:mime-version:content-type :content-transfer-encoding:message-id; bh=7+WOwfE1UVtGkHfKaOi03/baaSpVMlVVnHZSnUIAZeI=; b=kSLtxqX9/MbZsA8nzuupk3cwcjwzQTY8FVcHGa3+cgcZ+govkMVQa0MkFBttADyX7K 4Do7op3jJoNrFGWBAb3K8iblfVDMrSw62loadIBMfaQDg23LF17pZhzojc11Og1ALVkf H6G8guNLbaG3ObYArUvM9tTdwyKaeDNldUBSY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=from:to:subject:date:user-agent:references:in-reply-to:mime-version :content-type:content-transfer-encoding:message-id; b=NY4cfc2y2Zt4IwuGVAdrwObLc51rmuPeOchbEm1nbcyCgv/82XRlur7qlIbd+h7SBJ HtGaoebL0ZlHy2JTwYYqdDlLzcB4pdgWgQFUHdrkjcpv5YaffpZXWhDo83OB4GHJMBRi RQUNhMvC2ZZOvfB5c73xSISmN8S9KvELGPbsc= Received: by 10.213.96.83 with SMTP id g19mr4829994ebn.20.1258418730288; Mon, 16 Nov 2009 16:45:30 -0800 (PST) Received: from nazgul.localnet (196-210-153-114-rrdg-esr-2.dynamic.isadsl.co.za [196.210.153.114]) by mx.google.com with ESMTPS id 24sm139380eyx.29.2009.11.16.16.45.29 (version=TLSv1/SSLv3 cipher=RC4-MD5); Mon, 16 Nov 2009 16:45:29 -0800 (PST) From: Alan McKinnon To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] amarok can't use mysql collection Date: Tue, 17 Nov 2009 02:44:26 +0200 User-Agent: KMail/1.12.90 (Linux/2.6.31-zen7; KDE/4.3.75; x86_64; ; ) References: <200911161024.22573.alan.mckinnon@gmail.com> <200911162040.44215.wonko@wonkology.org> In-Reply-To: <200911162040.44215.wonko@wonkology.org> 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: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200911170244.26548.alan.mckinnon@gmail.com> X-Archives-Salt: ff941847-23ec-4785-a0b5-26966b2ec39a X-Archives-Hash: 1ed7d4905f0b8b0d23439605383b8faa On Monday 16 November 2009 21:40:42 Alex Schuster wrote: > Alan McKinnon writes: > > Does anyone here successfully use amarok-2.2.0 with mysql-5.0.84-r1? > > Sort of. > > > I get errors like this whenever amarok updates the collection: > > > > amarok: [ERROR!] GREPME MySQL query failed! No database > > selected on "INSERT INTO images SELECT * FROM images_temp;" > > Not here. Sometimes the collection gets screwed up a little, but I do not > get any output when re-scanning the collection. > > > $ eix -e amarok > > Installed versions: 2.2.0(4)(20:08:42 15/11/09)(cdda ipod > > linguas_en_GB mp3tunes mtp opengl semantic-desktop -aqua -daap -debug > > -lastfm -linguas_bg - linguas_ca -linguas_cs -linguas_da -linguas_de > > -linguas_es -linguas_et - linguas_eu -linguas_fi -linguas_fr > > -linguas_it -linguas_ja -linguas_km - linguas_nb -linguas_nds > > -linguas_nl -linguas_pa -linguas_pl -linguas_pt - linguas_pt_BR > > -linguas_ru -linguas_sl -linguas_sr -linguas_sr@latin - linguas_sv > > -linguas_th -linguas_tr -linguas_uk -linguas_wa -linguas_zh_TW) > > 2.2.0(4)(10:58:59 10.10.2009)(linguas_de opengl > semantic-desktop -aqua -cdda -daap -debug -ipod -lastfm -linguas_bg - > linguas_ca -linguas_cs -linguas_da -linguas_en_GB -linguas_es -linguas_et > -linguas_eu -linguas_fi -linguas_fr -linguas_it -linguas_ja -linguas_km - > linguas_nb -linguas_nds -linguas_nl -linguas_pa -linguas_pl -linguas_pt - > linguas_pt_BR -linguas_ru -linguas_sl -linguas_sr -linguas_sr@latin - > linguas_sv -linguas_th -linguas_tr -linguas_uk -linguas_wa -linguas_zh_TW > -mp3tunes -mtp) > > > $ eix -e mysql > > Installed versions: 5.0.84-r1(04:18:46 14/11/09)(community > > embedded perl ssl -berkdb -big-tables -cluster -debug -extraengine > > -latin1 -max-idx-128 - minimal -profiling -selinux -static) > > Installed versions: 5.0.84-r1(15:58:02 12.11.2009)(berkdb community > embedded perl ssl -big-tables -cluster -debug -extraengine -latin1 -max- > idx-128 -minimal -profiling -selinux -static) My stuff is similar to yours and Volker's, didn't work with mysqle. Even tried downgrading binutils, which fixed one error and revealed another. I have now made a decision. I was a faithful amarok user for 5 years. In the kde-3.5 days it worked flawlessly and never gave a day's trouble. The switch to KDE-4 has been fraught with problems from day 1 - all the decent features went away, then the devs spent two years fiddling with the gui while the palyer didn't *actually* play music (gee whizz, whodathunkedit? That a user might actually play music on his media player). Then the monumental cock-up with MySQL and -fPIC, the jumping through hoops that caused with every single distro out there, mysql-5.1.* is still not in the tree un-hardmasked, and now this crap. Amarok, it was nice knowing you. One day you might build and play music again on all sane systems out there. Meanwhile, I think I want to hear songs play so some other player is going on this machine and you are coming off. Bye bye now, and don't bump your head on the door when you leave. -- alan dot mckinnon at gmail dot com