[gentoo-user] amarok can't use mysql collection

[gentoo-user] amarok can't use mysql collection

[Alan McKinnon]

Does anyone here successfully use amarok-2.2.0 with mysql-5.0.84-r1?

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;"                                                                          

It's not just the above versions, I've tried amarok-1.9.*, various versions of 
mysql-5.0 and mysql-community-5.1.*, always with the same results.

$ 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)

$ 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)

Google and b.g.o don't return much useful info. Moving the amarok db and 
config files out of the way and restarting doesn't correct the error.

-- 
alan dot mckinnon at gmail dot com

[gentoo-user] Re: amarok can't use mysql collection

[Doug Hunley]

On Mon, Nov 16, 2009 at 03:24, Alan McKinnon <alan.mckinnon@gmail.com> wrote:
> Does anyone here successfully use amarok-2.2.0 with mysql-5.0.84-r1?

I haven't had any issues w/ amarok 2.2.0 and mysql 5.0.84-r1 (once I
figured out how to get amarok to _not_ use the embedded mysql)

-- 
Douglas J Hunley, RHCT
doug.hunley@gmail.com : http://douglasjhunley.com : Twitter: @hunleyd

Obsessively opposed to the typical.

Re: [gentoo-user] amarok can't use mysql collection

[Volker Armin Hemmann]

On Montag 16 November 2009, Alan McKinnon wrote:
> Does anyone here successfully use amarok-2.2.0 with mysql-5.0.84-r1?

yes

>
> $ 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)

eix -e amarok
[I] media-sound/amarok
     Installed versions:  2.2.0(4){tbz2}(22:59:03 02.10.2009)(cdda linguas_de 
mtp opengl semantic-desktop -aqua -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)
   
> 
> $ 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)

eix -e mysql
[I] dev-db/mysql
        Installed versions:  5.0.84-r1{tbz2}(22:28:14 09.09.2009)(berkdb 
community embedded perl ssl -big-tables -cluster -debug -extraengine -latin1 -
max-idx-128 -minimal -profiling -selinux -static)

have you built qt with the right flags?

Re: [gentoo-user] amarok can't use mysql collection

[Alex Schuster]

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)

	Wonko

Re: [gentoo-user] Re: amarok can't use mysql collection

[Alan McKinnon]

On Monday 16 November 2009 21:26:02 Doug Hunley wrote:
> On Mon, Nov 16, 2009 at 03:24, Alan McKinnon <alan.mckinnon@gmail.com> 
wrote:
> > Does anyone here successfully use amarok-2.2.0 with mysql-5.0.84-r1?
> 
> I haven't had any issues w/ amarok 2.2.0 and mysql 5.0.84-r1 (once I
> figured out how to get amarok to _not_ use the embedded mysql)

That's a common complaint about amarok lately. The devs reckon they must use 
multi-user mysql because it's almost impossible to get sqlite to do it 
properly and totally impossible to get it to do it remotely.

This puzzles me. How many users out their use their music player in multi-user 
mode with a collection db on a remote machine? Apart from LTSP installs, I'll 
bet it's none. And LTSP is better off using mpd, so why didn't the amarok devs 
simply include mpd support?

To answer your question, does Settings -> Collection -> enable check box & 
fill in bottom half of dialog do what you want?


-- 
alan dot mckinnon at gmail dot com

Re: [gentoo-user] Re: amarok can't use mysql collection

[Volker Armin Hemmann]

On Montag 16 November 2009, Alan McKinnon wrote:
> On Monday 16 November 2009 21:26:02 Doug Hunley wrote:
> > On Mon, Nov 16, 2009 at 03:24, Alan McKinnon <alan.mckinnon@gmail.com>
> 
> wrote:
> > > Does anyone here successfully use amarok-2.2.0 with mysql-5.0.84-r1?
> >
> > I haven't had any issues w/ amarok 2.2.0 and mysql 5.0.84-r1 (once I
> > figured out how to get amarok to _not_ use the embedded mysql)
> 
> That's a common complaint about amarok lately. The devs reckon they must
>  use multi-user mysql because it's almost impossible to get sqlite to do it
>  properly and totally impossible to get it to do it remotely.
> 
> This puzzles me. How many users out their use their music player in
>  multi-user mode with a collection db on a remote machine? Apart from LTSP
>  installs, I'll bet it's none. And LTSP is better off using mpd, so why
>  didn't the amarok devs simply include mpd support?
> 
> To answer your question, does Settings -> Collection -> enable check box &
> fill in bottom half of dialog do what you want?
> 

there had been other reasons. Many people have huge collections - and sqlite 
sucks with huge collections.

Re: [gentoo-user] Re: amarok can't use mysql collection

[Alan McKinnon]

On Tuesday 17 November 2009 00:22:57 Volker Armin Hemmann wrote:
> On Montag 16 November 2009, Alan McKinnon wrote:
> > On Monday 16 November 2009 21:26:02 Doug Hunley wrote:
> > > On Mon, Nov 16, 2009 at 03:24, Alan McKinnon <alan.mckinnon@gmail.com>
> >
> > wrote:
> > > > Does anyone here successfully use amarok-2.2.0 with mysql-5.0.84-r1?
> > >
> > > I haven't had any issues w/ amarok 2.2.0 and mysql 5.0.84-r1 (once I
> > > figured out how to get amarok to _not_ use the embedded mysql)
> >
> > That's a common complaint about amarok lately. The devs reckon they must
> >  use multi-user mysql because it's almost impossible to get sqlite to do
> > it properly and totally impossible to get it to do it remotely.
> >
> > This puzzles me. How many users out their use their music player in
> >  multi-user mode with a collection db on a remote machine? Apart from
> > LTSP installs, I'll bet it's none. And LTSP is better off using mpd, so
> > why didn't the amarok devs simply include mpd support?
> >
> > To answer your question, does Settings -> Collection -> enable check box
> > & fill in bottom half of dialog do what you want?
> 
> there had been other reasons. Many people have huge collections - and
>  sqlite sucks with huge collections.

I misread his post - I though he wanted to know how to disable mysqle (he'd 
figured that out already), then my train of though went off into other (even 
wronger) directions with embedded vs non-embedded mysql for amarok.

Meanwhile I compared by flags to yours and tried rebuilding mysql with 
-community -berkdb then rebuilding Amarok. This didn't change anything.

Busy downgrading binutils (#290662) now and trying again

 

-- 
alan dot mckinnon at gmail dot com

Re: [gentoo-user] amarok can't use mysql collection

[Alan McKinnon]

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)

<sigh>

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

Re: [gentoo-user] amarok can't use mysql collection

[Volker Armin Hemmann]

On Dienstag 17 November 2009, Alan McKinnon wrote:
> 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)
> 
> <sigh>
> 
> 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.
> 

qmmp
is nice
alsaplayer
is my favorite for 'keep it simple'

Re: [gentoo-user] amarok can't use mysql collection

[Alex Schuster]

Alan McKinnon writes:

> On Monday 16 November 2009 21:40:42 Alex Schuster wrote:
> > Alan McKinnon writes:

> > > 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.

It just happened again. I added a new folder to my /data/mp3 hierarchy 
(metal), put some folders of music into it, marked it as collection folder 
and told amarok to re-scan the collection. When I search for 'metallica', 
it finds 'Rapoon'. When I drag a metallica album folder directly into 
amarok, it shows the album's name correctly, but the artist is 'Rapoon'.

I unmarked all of my collection's folders, let amarok re-scan, and now the 
collection is empty. I added all the folders again, scanned, and I have 
the same problem.

I deleted ~/.kde4/share/apps/amarok/mysqle, started amarok and let it 
scan, now all is fine again. Seems I have to do this once in a while.


> 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.

I had my bunch of problems with the new amarok, too. And still, I like it. 
I got used to it, I like the new layout, it gets song texts fine (which 
stopped working for the old amarok some time ago).

> 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.

What about using amarok 1.4, until 2.x works fine for you?

Mine does not work any longer, though. Just noted this when I started it 
to compare with the 2.2 one, did not do this a while ago. 
/usr/kde/3.5/bin/amarok immediately throws an 'illegal instruction' error. 
Huh? I did not change my CFLAGS, they are "-march=k8-sse3 -mfpmath=sse -O2 
-pipe -fomit-frame-pointer" on a AMD Athlon 4850e. The k8-sse3 should be 
sane, gcc -Q --help=target -march=native lists it. I am not sure where I 
got the -mfpmath=sse from. I rebuilt amarok 1.4, and get the same error, 
probably somewhere in kdelibs or such stuff. Strange. Let's see if this 
happens with other stuff, too.

	Wonko

Re: [gentoo-user] amarok can't use mysql collection

[Alan McKinnon]

On Tuesday 17 November 2009 18:52:00 Alex Schuster wrote:
> Alan McKinnon writes:
> > On Monday 16 November 2009 21:40:42 Alex Schuster wrote:
> > > Alan McKinnon writes:
> > > > 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.
> 
> It just happened again. I added a new folder to my /data/mp3 hierarchy
> (metal), put some folders of music into it, marked it as collection folder
> and told amarok to re-scan the collection. When I search for 'metallica',
> it finds 'Rapoon'. When I drag a metallica album folder directly into
> amarok, it shows the album's name correctly, but the artist is 'Rapoon'.
> 
> I unmarked all of my collection's folders, let amarok re-scan, and now the
> collection is empty. I added all the folders again, scanned, and I have
> the same problem.
> 
> I deleted ~/.kde4/share/apps/amarok/mysqle, started amarok and let it
> scan, now all is fine again. Seems I have to do this once in a while.

To me, that is intolerable on production code with a version number of 2.2.0. 
It' supposed to be mature, it's not supposed to trash it's own data store! 
What o you think would happen if Firefox dumped it's browser history and 
cookies once a week in sync with phases of the moon?

If any vendor tried to sell me crap code like that at work, they would be out 
the door on their arse
 
[snip]

> > 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.
> 
> What about using amarok 1.4, until 2.x works fine for you?

1.4 links to kdelibs-3.5 right? I just spent nearly a year getting rid of 3.5 
apps...

> Mine does not work any longer, though. Just noted this when I started it
> to compare with the 2.2 one, did not do this a while ago.
> /usr/kde/3.5/bin/amarok immediately throws an 'illegal instruction' error.
> Huh? I did not change my CFLAGS, they are "-march=k8-sse3 -mfpmath=sse -O2
> -pipe -fomit-frame-pointer" on a AMD Athlon 4850e. The k8-sse3 should be
> sane, gcc -Q --help=target -march=native lists it. I am not sure where I
> got the -mfpmath=sse from. I rebuilt amarok 1.4, and get the same error,
> probably somewhere in kdelibs or such stuff. Strange. Let's see if this
> happens with other stuff, too.

that looks like you built amarok with binutils-2.20. It affects many apps. Try 
downgrade binutils, rebuild offending apps and see if it makes a difference.
Or you could try rebuild current binutils with USE=gold. I have no idea what 
it does, but there's a few references on b.g.o. about this working in some 
cases.


-- 
alan dot mckinnon at gmail dot com

[gentoo-user] Re: amarok can't use mysql collection

[Doug Hunley]

On Mon, Nov 16, 2009 at 17:19, Alan McKinnon <alan.mckinnon@gmail.com> wrote:
> On Monday 16 November 2009 21:26:02 Doug Hunley wrote:
>> On Mon, Nov 16, 2009 at 03:24, Alan McKinnon <alan.mckinnon@gmail.com>
> wrote:
>> > Does anyone here successfully use amarok-2.2.0 with mysql-5.0.84-r1?
>>
>> I haven't had any issues w/ amarok 2.2.0 and mysql 5.0.84-r1 (once I
>> figured out how to get amarok to _not_ use the embedded mysql)
>
> That's a common complaint about amarok lately. The devs reckon they must use
> multi-user mysql because it's almost impossible to get sqlite to do it
> properly and totally impossible to get it to do it remotely.
>
> This puzzles me. How many users out their use their music player in multi-user
> mode with a collection db on a remote machine? Apart from LTSP installs, I'll
> bet it's none. And LTSP is better off using mpd, so why didn't the amarok devs
> simply include mpd support?
>
> To answer your question, does Settings -> Collection -> enable check box &
> fill in bottom half of dialog do what you want?

I had done that actually, and it completely *ignored* it until I
killed all amarok processes and removed the mysqle directory (I think
that was the name). Thankfully, I found this solution on some random
blog somewhere that google pointed me to


-- 
Douglas J Hunley, RHCT
doug.hunley@gmail.com : http://douglasjhunley.com : Twitter: @hunleyd

Obsessively opposed to the typical.

Re: [gentoo-user] amarok can't use mysql collection

[James Ausmus]

[-- Attachment #1: Type: text/plain, Size: 698 bytes --]

On Mon, Nov 16, 2009 at 4:44 PM, Alan McKinnon <alan.mckinnon@gmail.com>wrote:
<snip>
>
> 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.
>
>
I've been fairly happy with Juk - it's already installed if you are running
KDE (depended on by the kde-base/kdemultimedia-meta package). It's fairly
simple, not nearly as powerful as Amarok, but it's been a decent substitute
while Amarok has been having its growing pains... I haven't tried 2.2 yet,
but it sounds like there are still a few too many issues... :(

-James

[-- Attachment #2: Type: text/html, Size: 1043 bytes --]