View previous topic :: View next topic |
Author |
Message |
snakeo2 Veteran
Joined: 01 Jan 2006 Posts: 1237
|
Posted: Wed Sep 15, 2010 12:55 am Post subject: Mysql Blocking Amarok [ SOLVED ] |
|
|
As the title of my thread reads, mysql is blocking amarok or vice versa. I was doing some maintenance and tried emerge system & emerge world and got the following errors:
emerge -uDN system
* IMPORTANT: 14 news items need reading for repository 'gentoo'.
* Use eselect news to read news items.
Calculating dependencies... done!
[ebuild R ] media-libs/jpeg-8b USE="-static-libs%"
[ebuild U ] sys-devel/autoconf-2.65-r1 [2.65]
[ebuild U ] dev-libs/libgcrypt-1.4.6 [1.4.5]
[ebuild U ] sys-apps/debianutils-3.2.3 [3.1.3]
[ebuild U ] sys-process/psmisc-22.12 [22.10]
[ebuild R ] dev-libs/glib-2.24.1-r1 USE="(-hardened%)"
[ebuild U ] net-misc/iputils-20100418 [20071127] USE="ssl%* -SECURITY_HAZARD% -idn%"
[ebuild U ] net-misc/wget-1.12-r2 [1.12]
[ebuild U ] net-nds/openldap-2.4.23 [2.4.19-r1] USE="gnutls*"
[ebuild U ] net-misc/openssh-5.5_p1-r2 [5.3_p1-r1]
[ebuild R ] net-print/cups-1.3.11-r2 USE="gnutls*"
[ebuild R ] net-misc/curl-7.20.0-r2 USE="gnutls*"
[ebuild U ] dev-db/mysql-5.1.50-r1 [5.0.90-r2] USE="-pbxt% -xtradb%"
[ebuild U ] virtual/mysql-5.1 [5.0]
[blocks B ] media-sound/amarok[embedded] ("media-sound/amarok[embedded]" is blocking dev-db/mysql-5.1.50-r1)
* 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-r1', 'merge') pulled in by
=dev-db/mysql-5.1* required by ('ebuild', '/', 'virtual/mysql-5.1', 'merge')
('installed', '/', 'media-sound/amarok-2.3.1-r2', 'nomerge') pulled in by
media-sound/amarok required by world
emerge -uDN world
* IMPORTANT: 14 news items need reading for repository 'gentoo'.
* Use eselect news to read news items.
Calculating dependencies... done!
!!! Multiple package instances within a single package slot have been pulled
!!! into the dependency graph, resulting in a slot conflict:
dev-db/mysql:0
('ebuild', '/', 'dev-db/mysql-5.1.50-r1', 'merge') pulled in by
dev-db/mysql required by world
('installed', '/', 'dev-db/mysql-5.0.90-r2', 'nomerge') pulled in by
<dev-db/mysql-5.1[embedded,-minimal] required by ('installed', '/', 'media-sound/amarok-2.3.1-r2', 'nomerge')
dev-db/mysql required by world
app-office/abiword:2
('ebuild', '/', 'app-office/abiword-2.8.6', 'merge') pulled in by
app-office/abiword required by world
('installed', '/', 'app-office/abiword-2.6.8', 'nomerge') pulled in by
=app-office/abiword-2.6.8* required by ('installed', '/', 'app-office/abiword-plugins-2.6.8', 'nomerge')
app-office/abiword required by world
It may be possible to solve this problem by using package.mask to
prevent one of those packages from being selected. However, it is also
possible that conflicting dependencies exist such that they are
impossible to satisfy simultaneously. If such a conflict exists in the
dependencies of two different packages, then those packages can not be
installed simultaneously. You may want to try a larger value of the
--backtrack option, such as --backtrack=30, in order to see if that will
solve this conflict automatically.
For more information, see MASKED PACKAGES section in the emerge man page
or refer to the Gentoo Handbook.
emerge: there are no ebuilds built with USE flags to satisfy ">=media-libs/jpeg-6b:0[static-libs]".
!!! One of the following packages is required to complete your request:
- media-libs/jpeg-8b (Change USE: +static-libs)
(dependency required by "media-gfx/splashutils-1.5.4.3-r3" [installed])
(dependency required by "media-gfx/splash-themes-gentoo-20100302" [installed])
(dependency required by "world" [argument])
I'm not sure if amarok uses mysql or postgresql...so any idea or suggestions are welcomed. Thanks in advance. _________________ Gigabyte MA790X-UD4P Motherboard
AMD Phenom II X4 940 Black Edition
MSI ATI R4650 PCIe2
250GB SATA Drive
4GB Corsair DDR2
Last edited by snakeo2 on Sat Sep 18, 2010 10:05 pm; edited 1 time in total |
|
Back to top |
|
|
audiodef Watchman
Joined: 06 Jul 2005 Posts: 6639 Location: The soundosphere
|
|
Back to top |
|
|
titanofold Developer
Joined: 30 Dec 2003 Posts: 235 Location: Bryson City, NC USA
|
|
Back to top |
|
|
audiodef Watchman
Joined: 06 Jul 2005 Posts: 6639 Location: The soundosphere
|
Posted: Wed Sep 15, 2010 2:24 am Post subject: |
|
|
I was going to suggest that if you're not otherwise using MySQL, to unmerge it and see if Amarok pulls it back in without a conflict.
But if you want a trouble-free audio/video player, ditch Amarok and use other things like VLC, smplayer, audacious, etc. I have NEVER been able to get Amarok working properly. I like the ideas behind it, but it's never worked on all the systems I've ever tried it on. Maybe it works in Ubuntu. I dunno. Never got it working under Gentoo. _________________ decibel Linux: https://decibellinux.org
Github: https://github.com/Gentoo-Music-and-Audio-Technology
Facebook: https://www.facebook.com/decibellinux
Discord: https://discord.gg/73XV24dNPN |
|
Back to top |
|
|
Angrychile Apprentice
Joined: 27 Oct 2009 Posts: 235
|
Posted: Wed Sep 15, 2010 5:21 am Post subject: |
|
|
I masked the virtual to get rid of this...was that a good idea? (I had dev-db/mysql too) |
|
Back to top |
|
|
Veldrin Veteran
Joined: 27 Jul 2004 Posts: 1945 Location: Zurich, Switzerland
|
Posted: Wed Sep 15, 2010 7:21 am Post subject: |
|
|
Well, there are several solutions...
one is just to mask mysql (dev-db/mysql) as you did. (for some reason, I would mask the real package rather than the virtual one - but that is another story)
another is to remove the embedded flag (I never quite understood why it was needed) from mysql and amarok, and then uses a fullblown mysql db on amarok.
HTH
V.
PS. I already used the full blown mysqldb with amarok-1.x, and ATM I see little advantage in switching. except for borked setup, which happened once or twice with the embedded db, but never with the full one. |
|
Back to top |
|
|
snakeo2 Veteran
Joined: 01 Jan 2006 Posts: 1237
|
Posted: Wed Sep 15, 2010 11:00 pm Post subject: |
|
|
audiodef,
I do use Mysql in conjunction with Joomla. As far as getting Amarok to work properly, not sure what your definition of working properly is, but for me it has done the job thus far. I'm probably not using to its full capacity, but currently I dont need to. It manages my mp3 collection and can play and listen to it, which is all I need for now.
Veldrin
Quote: |
another is to remove the embedded flag (I never quite understood why it was needed) from mysql and amarok, and then uses a fullblown mysql db on amarok.
|
would you mind elaborating? Thanks in advance. _________________ Gigabyte MA790X-UD4P Motherboard
AMD Phenom II X4 940 Black Edition
MSI ATI R4650 PCIe2
250GB SATA Drive
4GB Corsair DDR2 |
|
Back to top |
|
|
Veldrin Veteran
Joined: 27 Jul 2004 Posts: 1945 Location: Zurich, Switzerland
|
Posted: Thu Sep 16, 2010 8:16 am Post subject: |
|
|
read the entire post before taking any action!
remove those useflags, and rebuild amarok and mysql. then restart mysql.
Code: | # echo "media-sound/amarok -embedded" >> /etc/portage/package.use
# echo "dev-db/mysql -embedded" >> /etc/portage/package.use
# emerge -a1 mysql amarok
# /etc/init.d/mysql restart |
next time you run amarok, it asks you to define where the database is located, and howto configure mysql (i.e create the database + permissions).
alternatively, you can use this howto (though it is for 1.4, it is still valid, how to create the database)
caveats: I am not sure whether you can migrate you current embedded database to new one. (maybe you could copy it over? it is located in ~/.kde4/share/apps/amarok/mysqle or similar)
the database contains the entire collection info + playtime/count info, but not the ratings (stars)
creating a new database will probably destroy your ratings.
the workaround I use, it to save/export the playlist sorted by rating and tracknumber, and the then re-rate after the database has been rebuilt.
be sure, that you export the file to your harddrive, and not to the database.
I am not a expert in mysql. so i do not know, how it is going to react in the change of the useflags. be sure, that you have backups of your databases.
cheers
V.
PS. Don't hesitate to ask, of there are any questions.
PPS. I did this only on a empty database, or i did not care if i lost some database. |
|
Back to top |
|
|
Erdie Advocate
Joined: 20 May 2004 Posts: 2576 Location: Heidelberg - Germany
|
Posted: Thu Sep 16, 2010 10:43 am Post subject: |
|
|
This conflict was a welcome reason for me to remove Amarok completly. |
|
Back to top |
|
|
snakeo2 Veteran
Joined: 01 Jan 2006 Posts: 1237
|
Posted: Fri Sep 17, 2010 12:39 am Post subject: |
|
|
Veldrin,
Which use flags? I guess this will rebuild Mysql and break any current databases in my box? I guess I can always re-install Joomla if need be. _________________ Gigabyte MA790X-UD4P Motherboard
AMD Phenom II X4 940 Black Edition
MSI ATI R4650 PCIe2
250GB SATA Drive
4GB Corsair DDR2 |
|
Back to top |
|
|
snakeo2 Veteran
Joined: 01 Jan 2006 Posts: 1237
|
Posted: Fri Sep 17, 2010 1:47 am Post subject: |
|
|
I removed the "embedded" use flag and tried "emerge world" again, but now it's complaining about jpeg.
emerge -uDN world
* IMPORTANT: 14 news items need reading for repository 'gentoo'.
* Use eselect news to read news items.
Calculating dependencies... done!
emerge: there are no ebuilds built with USE flags to satisfy ">=media-libs/jpeg-6b:0[static-libs]".
!!! One of the following packages is required to complete your request:
- media-libs/jpeg-8b (Change USE: +static-libs)
(dependency required by "media-gfx/splashutils-1.5.4.3-r3" [installed])
(dependency required by "media-gfx/splash-themes-gentoo-20100302" [installed])
(dependency required by "world" [argument]) _________________ Gigabyte MA790X-UD4P Motherboard
AMD Phenom II X4 940 Black Edition
MSI ATI R4650 PCIe2
250GB SATA Drive
4GB Corsair DDR2 |
|
Back to top |
|
|
dol-sen Retired Dev
Joined: 30 Jun 2002 Posts: 2805 Location: Richmond, BC, Canada
|
Posted: Fri Sep 17, 2010 2:12 am Post subject: |
|
|
Code: | emerge: there are no ebuilds built with USE flags to satisfy ">=media-libs/jpeg-6b:0[static-libs]" |
That says what you need to do right there.
So...
Code: | # echo ">=media-libs/jpeg-6b static-libs" >> /etc/portage/package.use # or a subfile if it is a directory
# emerge -1v media-libs/jpeg
|
_________________ Brian
Porthole, the Portage GUI frontend irc@freenode: #gentoo-guis, #porthole, Blog
layman, gentoolkit, CoreBuilder, esearch... |
|
Back to top |
|
|
Sujao l33t
Joined: 25 Sep 2004 Posts: 677 Location: Germany
|
Posted: Fri Sep 17, 2010 2:42 pm Post subject: |
|
|
I like amarok and would like to keep it. Isn't this more of a portage bug when you put in packages that don't work together properly? |
|
Back to top |
|
|
snakeo2 Veteran
Joined: 01 Jan 2006 Posts: 1237
|
Posted: Fri Sep 17, 2010 10:15 pm Post subject: |
|
|
I like amarok as well, not sure why it's not playing nice my mysql. Anyhow, i was able to update my system, however after re-starting amarok, as veldrin predicted, all my collection was lost. I tried creating a new database "amarok" following the tutorial provided, granted all rights to my local user and still complains that dabase is either not found or created incorrectly.
show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| amarok |
| joomla |
| mysql |
| test |
+--------------------+
5 rows in set (0.00 sec)
mysql> use amarok
Database changed
mysql> show tables;
Empty set (0.00 sec)
any suggestions? _________________ Gigabyte MA790X-UD4P Motherboard
AMD Phenom II X4 940 Black Edition
MSI ATI R4650 PCIe2
250GB SATA Drive
4GB Corsair DDR2 |
|
Back to top |
|
|
step Apprentice
Joined: 16 May 2002 Posts: 198
|
Posted: Sun Sep 19, 2010 10:07 am Post subject: |
|
|
amarok started to be real PITA after it required mysql to operate. I mean... a fkn music player needs a database engine!?... What a joke!
emerge -C media-sound/amarok is the way to go. I have better thing to do than waste my time on some idiotic requirements of amarok.
emerge -C media-sound/amarok and done. |
|
Back to top |
|
|
keikoz n00b
Joined: 14 Feb 2006 Posts: 29
|
Posted: Sun Sep 19, 2010 11:26 am Post subject: |
|
|
step wrote: | amarok started to be real PITA after it required mysql to operate. I mean... a fkn music player needs a database engine!?... What a joke!
emerge -C media-sound/amarok is the way to go. I have better thing to do than waste my time on some idiotic requirements of amarok.
emerge -C media-sound/amarok and done. |
Same considerations, same solution. |
|
Back to top |
|
|
psdasilva Apprentice
Joined: 03 Sep 2005 Posts: 239
|
Posted: Sun Sep 19, 2010 11:01 pm Post subject: |
|
|
step wrote: | amarok started to be real PITA after it required mysql to operate. I mean... a fkn music player needs a database engine!?... What a joke!
emerge -C media-sound/amarok is the way to go. I have better thing to do than waste my time on some idiotic requirements of amarok.
emerge -C media-sound/amarok and done. |
After that ... which is the simplest music player that:
1. Plays in seq. or random at choice several dirs of music.
2. kde oriented.
3. Shows lyrics (not much important)
?
Thanks |
|
Back to top |
|
|
ArneBab Guru
Joined: 24 Jan 2006 Posts: 429 Location: Graben-Neudorf, Germany
|
Posted: Tue Sep 28, 2010 11:44 pm Post subject: solved? |
|
|
I don’t really consider this solved…
Amarok should by default be used with the embedded MySQL database. So why can’t I emerge mysql and amarok with embedded?
Code: | $ USE="embedded" emerge -1a dev-db/mysql amarok
[ebuild R ] dev-db/mysql-5.1.50-r1
[ebuild N ] virtual/mysql-5.1
[ebuild R ] media-sound/amarok-2.3.2
[blocks B ] media-sound/amarok[embedded] ("media-sound/amarok[embedded]" is blocking dev-db/mysql-5.1.50-r1) |
Code: | $ USE="-embedded" emerge -1a dev-db/mysql amarok
[ebuild R ] dev-db/mysql-5.1.50-r1
[ebuild N ] virtual/mysql-5.1
[ebuild R ] media-sound/amarok-2.3.2
[blocks b ] media-sound/amarok[embedded] ("media-sound/amarok[embedded]" is blocking dev-db/mysql-5.1.50-r1)
|
I’m now remerging without embedded, but it’s a very substandard solution to have to depart from the upstream default. I don’t really need mysql for anything but amarok (I hope… I didn’t doublecheck every program). _________________ Being unpolitical means being political without realizing it. - Arne Babenhauserheide ( http://draketo.de )
pkgcore: So fast that it feels unreal - by doing only what is needed. |
|
Back to top |
|
|
optiluca Guru
Joined: 16 Jan 2006 Posts: 545 Location: Rivergaro, Italy
|
Posted: Wed Sep 29, 2010 10:28 am Post subject: |
|
|
Solution to this mess is very close, patch was released on bugzilla just a few days ago https://bugs.gentoo.org/show_bug.cgi?id=306315 . I personally have just masked recent mysql versions and kept the embedded database, soon we will have all mysql versions functioning correctly. Anyway my package.mask at the moment reads..
Quote: | >=dev-db/mysql-5.1
>=virtual/mysql-5.1
|
_________________ # "Hmm, sounds like your system froze up."
# "I don't know why. It's about 80 degrees in here!"
http://www.rinkworks.com/stupid/cs_mincing.shtml |
|
Back to top |
|
|
ArneBab Guru
Joined: 24 Jan 2006 Posts: 429 Location: Graben-Neudorf, Germany
|
Posted: Fri Oct 22, 2010 7:50 pm Post subject: |
|
|
Thanks for the update! _________________ Being unpolitical means being political without realizing it. - Arne Babenhauserheide ( http://draketo.de )
pkgcore: So fast that it feels unreal - by doing only what is needed. |
|
Back to top |
|
|
wlchase Tux's lil' helper
Joined: 04 Jul 2003 Posts: 81 Location: Texas
|
Posted: Thu Nov 18, 2010 10:22 pm Post subject: |
|
|
FWIW, it works with 5.1.51.
One step that seems to have been left out of all the blogs & HOWTOs is to create the amarokuser account.
HTH!
Bill |
|
Back to top |
|
|
|