Amarok and Mysql 5.1 problem !

[sleepingsun]

Amarok and Mysql 5.1 problem !

Code: Select all

emerge -av mysql 

These are the packages that would be merged, in order:

Calculating dependencies... done!
[ebuild     U ] dev-db/mysql-5.1.50 [5.0.90-r2] USE="community embedded perl ssl -big-tables -cluster -debug -extraengine -latin1 -max-idx-128 -minimal -pbxt% -profiling (-selinux) -static -test -xtradb% (-berkdb%*)" 0 kB
[ebuild     U ] virtual/mysql-5.1 [5.0] 0 kB
[blocks B     ] media-sound/amarok[embedded] ("media-sound/amarok[embedded]" is blocking dev-db/mysql-5.1.50)

Total: 2 packages (2 upgrades), Size of downloads: 0 kB
Conflict: 1 block (1 unsatisfied)

 * Error: The above package list contains packages which cannot be
 * installed at the same time on the same system.

  ('ebuild', '/', 'dev-db/mysql-5.1.50', 'merge') pulled in by
    =dev-db/mysql-5.1* required by ('ebuild', '/', 'virtual/mysql-5.1', 'merge')
    mysql

  ('installed', '/', 'media-sound/amarok-2.3.1-r2', 'nomerge') pulled in by
    media-sound/amarok required by world


For more information about Blocked Packages, please refer to the following
section of the Gentoo Linux x86 Handbook (architecture is irrelevant):

http://www.gentoo.org/doc/en/handbook/handbook-x86.xml?full=1#blocked

[Veldrin]

remove the embedded useflag, and you should be fine.

[der bastler]

Well, I ran into this problem, too.

remove the embedded useflag, and you should be fine.

I do not need a standalone MySQL server idling in the background just to listen to some music.

So I tried media-sound/clementine, was pleased to have found a good music player just playing music, adjusted my system daemon to access org.mpris.clementine instead of org.kde.amarok and unmerged amarok. Bye bye.

This akonadi Etwas slowing down startup is next on my list -- I just have to find an alternative to KMail...

[WilliamHeuts]

Amarok doesn't work with MySQL 5.1. This has something to do with a change in MySQL coding. Don't ask me precisely what. Just mask 5.1 and use a previous version and it will work fine.

[sleepingsun]

Well, I ran into this problem, too.

remove the embedded useflag, and you should be fine.

I do not need a standalone MySQL server idling in the background just to listen to some music.

So I tried media-sound/clementine, was pleased to have found a good music player just playing music, adjusted my system daemon to access org.mpris.clementine instead of org.kde.amarok and unmerged amarok. Bye bye.

This akonadi Etwas slowing down startup is next on my list -- I just have to find an alternative to KMail...

Clementine is masked for 64bit Gentoo !

But i loved to setup amarok becouse i have music database and lot of playlist also i use mysql for my site hope so that amarok soon made upgrade to work with mysql 5.1 ! Till than i back to mysql 5.0 !

[Veldrin]

I need to check back home, but IIRC amarok works perfectly /w mysql-5.1, just not with the embedded version. and even without it, you are still able to run a 'local db, instead of a system wide one, as it was on 1.4.

[der bastler]

Clementine is masked for 64bit Gentoo !

Yes, I know, and I try to keep my /etc/portage/package.keywords/keywords.base rather short.

But Clementine works, and has no annoying flaws when it comes to file tagging etc...

[BitJam]

Running Clementine 0.4 here on amd64. Works great! LIke Amarok 1.4 only better in some ways, such as much faster startup and no MySQL. Still missing a few features such as transferring songs to an mp3 player but even as it is now, it is better, much better, than all the others I've tried. It's great now and it should be getting even better in the near future.

[forkboy]

Isn't mysql 5.0 vulnerable to security bugs? How vulnerable are we if we just want to use it for amarok? I've no idea how to set the now stable version up to use for my amarok collection.

[codestation]

Amarok works perfectly with mysql-5.1.x and embedded USE flag, if you just care about having Amarok running without starting the mysql server then add the mysql and amarok ebuilds to a local overlay then change the following:

In the amarok ebuild:

Code: Select all

embedded? ( <dev-db/mysql-5.1[embedded,-minimal] )

for

Code: Select all

embedded? ( >=dev-db/mysql-5.1[embedded,-minimal] )

In the mysql ebuild delete or comment the following line:

Code: Select all

RDEPEND="!media-sound/amarok[embedded]"

And finally create the following file

Code: Select all

# cat /etc/portage/env/dev-db/mysql 
CFLAGS="${CFLAGS} -fPIC"
CXXFLAGS="${CXXFLAGS} -fPIC"

That asumption in http://bugs.gentoo.org/show_bug.cgi?id=335433 saying that nodoby wants amarok statically linked to mysql is false. At least we arent stuck with that and can edit the ebuilds, but updating those ebuilds every version bump is a pain .......

[forkboy]

This is the most fucking stupidest thing that I've ever had to deal with all the years I've been using gentoo.

[joaopft]

That asumption in http://bugs.gentoo.org/show_bug.cgi?id=335433 saying that nodoby wants amarok statically linked to mysql is false.

I second that. I don't want to run the mysql deamon on my netbook. When mysql is only used by amarok, it is perfectly fine to have amarok statically linked to mysql.

[iandoug]

Dunno if this is a separate issue ... I got it working by removing the 'embedded' option.

Today, system updated 2 packages (gpm and glib, IIRC), and I renamed a folder while Amarok was playing from it.

Now Amarok refuses to start.

Code: Select all

~ $ amarok
Calling appendChild() on a null node does nothing.
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
amarok(4813)/kdecore (KConfigSkeleton) KCoreConfigSkeleton::writeConfig:
amarok(4813)/kdecore (KConfigSkeleton) KCoreConfigSkeleton::writeConfig:
amarok(4813)/kdecore (KConfigSkeleton) KCoreConfigSkeleton::writeConfig:
QGraphicsLinearLayout::removeAt: invalid index 1
amarok(4813)/kdecore (KConfigSkeleton) KCoreConfigSkeleton::writeConfig:
<unknown program name>(4812)/: Communication problem with  "amarok" , it probably crashed. 
Error message was:  "org.freedesktop.DBus.Error.NoReply" : " "Did not receive a reply. Possible causes include: the remote application did not send a reply, the message bus security policy blocked the reply, the reply timeout expired, or the network connection was broken." " 

Now what?

thanks, Ian

[metalus]

If you remove the embedded flag and go straight for emerge world, portage is able to remove the block. So the solution is:

Code: Select all

remove the embedded flag for amarok
emerge world #which recompiles amarok without embedded

[iandoug]

Guess I should have been clearer.

I *HAD* it working for a few days after recompiling it, but today it decided to break, right after I renamed a folder it was playing music from.

Recompiled it anyway but still the same problem.

Should I go muck about in the database?

thanks, Ian

[iandoug]

fixed by
rm current.xspf

in .kde4/share/apps/amarok

guess it barfs when it can't find a dir in it's list of tracks to play.