{"id":12,"date":"2009-03-29T13:05:00","date_gmt":"2009-03-29T05:16:29","guid":{"rendered":""},"modified":"2009-03-29T13:05:00","modified_gmt":"2009-03-29T13:05:00","slug":"amarok-2-amd64-and-mysql","status":"publish","type":"post","link":"https:\/\/blogs.gentoo.org\/jmbsvicetto\/2009\/03\/29\/amarok-2-amd64-and-mysql\/","title":{"rendered":"amarok-2, amd64 and mysql"},"content":{"rendered":"

As some of you may have noticed, the amarok-2 ebuilds have not been keyworded ~amd64 because of the mysql issue<\/a>. Tonight, we’ve got a step closer to fix that.
\nIve been working on a patch for mysql to get libmysqld to be built as a shared lib for over 2 months now. I’ve added an initial patch<\/a> on January 3rd. Tonight, I was able to finally get a working patch<\/a> for mysql-5.0.76:<\/p>\n

atlantis@lap64 ~\/kde $ ls -la \/usr\/lib64\/mysql\/libmysqld.*
\n-rw-r–r– 1 root root 9447588 Mar 29 01:39 \/usr\/lib64\/mysql\/libmysqld.a
\n-rwxr-xr-x 1 root root 1088 Mar 29 01:38 \/usr\/lib64\/mysql\/libmysqld.la
\nlrwxrwxrwx 1 root root 18 Mar 29 01:39 \/usr\/lib64\/mysql\/libmysqld.so -> libmysqld.so.0.0.0
\nlrwxrwxrwx 1 root root 18 Mar 29 01:39 \/usr\/lib64\/mysql\/libmysqld.so.0 -> libmysqld.so.0.0.0
\n-rwxr-xr-x 1 root root 5054576 Mar 29 01:39 \/usr\/lib64\/mysql\/libmysqld.so.0.0.0<\/strong><\/p><\/blockquote>\n

This patch needs to be properly tested and will likely get some clean-ups, but it’s working locally. This has taken a considerable amount of work and time from me, but has only been possible thanks to Diego E. \u201cFlameeyes\u201d Petten\u00f2 – kudos to him.
\nAFAIK, this means that Gentoo is the first distro to include a shared lib libmysqld and after Robin “robbat2” Johnson, cleans the patch and he’s happy with it, we’ll try to get it upstream.
\nI’ve delayed this post a few hours trying to get amarok-2.0.2 building, but it’s still failing because of qtscriptgenerator. However, it is already linking to libmysqld though:<\/p>\n

lap64 amarok_build # pwd
\n\/var\/tmp\/portage\/media-sound\/amarok-2.0.2\/work\/amarok_build
\nlap64 amarok_build # scanelf -n lib\/libamarok_collection-sqlcollection.so
\n TYPE NEEDED FILE
\nET_DYN libamaroklib.so.1,libamarokpud.so.1,libkdeui.so.5,libkio.so.5,libthreadweaver.so.4,libmysqld.so.0<\/strong>,libpthread.so.0,libkdecore.so.5,libQtDBus.so.4,libQtCore.so.4,libQtGui.so.4,libstdc++.so.6,libc.so.6 lib\/libamarok_collection-sqlcollection.so<\/p><\/blockquote>\n

If you like to see it with a “prettier output”:<\/p>\n

lap64 amarok_build # ls lib\/libamarok_collection-sqlcollection.so | xargs scanelf -L -n -q -F ‘%n #F’ | tr , ‘ ‘ | xargs qfile -C | sort -u
\ndev-db\/mysql (\/usr\/lib64\/libmysqld.so.0)<\/strong>
\nkde-base\/kdelibs (\/usr\/kde\/4.2\/lib64\/libkdecore.so.5)
\nkde-base\/kdelibs (\/usr\/kde\/4.2\/lib64\/libkdeui.so.5)
\nkde-base\/kdelibs (\/usr\/kde\/4.2\/lib64\/libkio.so.5)
\nkde-base\/kdelibs (\/usr\/kde\/4.2\/lib64\/libthreadweaver.so.4)
\nsys-devel\/gcc (\/usr\/lib\/gcc\/x86_64-pc-linux-gnu\/4.2.4\/libstdc++.so.6)
\nsys-libs\/glibc (\/lib64\/libc.so.6)
\nsys-libs\/glibc (\/lib64\/libpthread.so.0)
\nx11-libs\/qt-core (\/usr\/lib64\/qt4\/libQtCore.so.4)
\nx11-libs\/qt-dbus (\/usr\/lib64\/qt4\/libQtDBus.so.4)
\nx11-libs\/qt-gui (\/usr\/lib64\/qt4\/libQtGui.so.4)<\/p><\/blockquote>\n

I’m trying some of the patches in the amarok + qt4.5 bug<\/a> and will hopefully get it to build soon. So it seems we might be able to have a amarok2+amd64 party in Gentoo soon B)<\/p>\n

UPDATE<\/strong><\/p>\n

atlantis@lap64 \/home\/gentoo-cvs\/jmbsvicetto\/media-sound\/amarok $ qlist -IUv amarok
\nmedia-sound\/amarok-1.4.10-r2 (amazon ipod kde mp4 musicbrainz mysql njb opengl python visualization)
\nmedia-sound\/amarok-2.0.2 (cdaudio ipod kdeprefix mp3tunes mp4 njb opengl)<\/p><\/blockquote>\n

I think a party is due in #gentoo-kde!! \ud83d\ude00 I’m going to update the amarok ebuild in the overlay in a minute. So, let’s PARTY<\/strong>!!!<\/p>\n","protected":false},"excerpt":{"rendered":"

As some of you may have noticed, the amarok-2 ebuilds have not been keyworded ~amd64 because of the mysql issue. Tonight, we’ve got a step closer to fix that. Ive been working on a patch for mysql to get libmysqld to be built as a shared lib for over 2 months now. I’ve added an … Continue reading “amarok-2, amd64 and mysql”<\/span><\/a><\/p>\n","protected":false},"author":70,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/blogs.gentoo.org\/jmbsvicetto\/wp-json\/wp\/v2\/posts\/12"}],"collection":[{"href":"https:\/\/blogs.gentoo.org\/jmbsvicetto\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.gentoo.org\/jmbsvicetto\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.gentoo.org\/jmbsvicetto\/wp-json\/wp\/v2\/users\/70"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.gentoo.org\/jmbsvicetto\/wp-json\/wp\/v2\/comments?post=12"}],"version-history":[{"count":0,"href":"https:\/\/blogs.gentoo.org\/jmbsvicetto\/wp-json\/wp\/v2\/posts\/12\/revisions"}],"wp:attachment":[{"href":"https:\/\/blogs.gentoo.org\/jmbsvicetto\/wp-json\/wp\/v2\/media?parent=12"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.gentoo.org\/jmbsvicetto\/wp-json\/wp\/v2\/categories?post=12"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.gentoo.org\/jmbsvicetto\/wp-json\/wp\/v2\/tags?post=12"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}