Bug 303109 – amarok 2.2.2 fails to compile with mysql 5.1.43

• Status: RESOLVED FIXED
• Product: Gentoo Linux

[Description Hanno Böck 2010-02-01 15:29:10 UTC]

I'm not sure if this is a mysql or an amarok issue. If that's interesting, the same happens on mysql 5.5.

[ 88%] Building CXX object src/collection/mysqlecollection/CMakeFiles/amarok_collection-mysqlecollection.dir/SqlCollectionAdaptor.o                                                                                                         
Linking CXX shared module ../../../lib/amarok_collection-mysqlservercollection.so                                     
Linking CXX shared module ../../../lib/amarok_collection-mysqlecollection.so                                          
/usr/lib/gcc/x86_64-pc-linux-gnu/4.4.2/../../../../x86_64-pc-linux-gnu/bin/ld: /usr/lib64/mysql/libmysqld.a(client.o): relocation R_X86_64_32 against `mysql_server_last_error' can not be used when making a shared object; recompile with -fPIC                                                                                                                 
/usr/lib64/mysql/libmysqld.a: could not read symbols: Bad value

[Comment 1 Jorge Manuel B. S. Vicetto (RETIRED) 2010-02-01 15:50:33 UTC]

The mysql ebuild in the tree should have a blocker against amarok.
This is our old friend bug 238487 - I've started working again on a patch to build libmysqld as a shared lib, but we're having new issues.

[Comment 2 Robin Johnson 2010-02-01 19:54:54 UTC]

Sorry, I forgot the blocker, added now.

[Comment 3 Andrei Slavoiu 2010-02-21 07:00:58 UTC]

(In reply to comment #2)
> Sorry, I forgot the blocker, added now.
> 

That blocker doesn't seem o work very well. My "emerge -NDatuv world" ends this way:
 * 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.44', 'merge') pulled in by
    =dev-db/mysql-5.1* required by ('ebuild', '/', 'virtual/mysql-5.1', 'merge')
    >=dev-db/mysql-5.0.76-r1[-minimal,embedded] required by ('ebuild', '/', 'media-sound/amarok-2.2.2.90', 'merge')
    dev-db/mysql required by ('installed', '/', 'www-plugins/gnash-0.8.6', 'nomerge')

  ('ebuild', '/', 'media-sound/amarok-2.2.2.90', 'merge') pulled in by
    media-sound/amarok required by @world

My "emerge --info":
Portage 2.2_rc63 (default/linux/amd64/10.0/desktop, gcc-4.4.3, glibc-2.11-r1, 2.6.32-gentoo-r5 x86_64)
=================================================================                                     
System uname: Linux-2.6.32-gentoo-r5-x86_64-AMD_Phenom-tm-_9350e_Quad-Core_Processor-with-gentoo-2.0.1
Timestamp of tree: Sun, 21 Feb 2010 06:15:01 +0000                                                    
ccache version 2.4 [enabled]                                                                          
app-shells/bash:     4.1_p2                                                                           
dev-java/java-config: 2.1.10                                                                          
dev-lang/python:     2.6.4-r1, 3.1.1-r1                                                               
dev-util/ccache:     2.4-r8                                                                           
dev-util/cmake:      2.8.0-r2                                                                         
sys-apps/baselayout: 2.0.1                                                                            
sys-apps/openrc:     0.6.0-r1                                                                         
sys-apps/sandbox:    2.2                                                                              
sys-devel/autoconf:  2.65                                                                             
sys-devel/automake:  1.8.5-r4, 1.9.6-r3, 1.10.3, 1.11.1                                               
sys-devel/binutils:  2.20                                                                             
sys-devel/gcc:       4.4.3                                                                            
sys-devel/gcc-config: 1.4.1                                                                           
sys-devel/libtool:   2.2.6b                                                                           
virtual/os-headers:  2.6.32                                                                           
ACCEPT_KEYWORDS="amd64 ~amd64"                                                                        
ACCEPT_LICENSE="* -@EULA"                                                                             
CBUILD="x86_64-pc-linux-gnu"                                                                          
CFLAGS="-march=native -ggdb -O2 -pipe"                                                                
CHOST="x86_64-pc-linux-gnu"                                                                           
CONFIG_PROTECT="/etc /usr/share/X11/xkb /usr/share/config"                                            
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/env.d/java/ /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/sandbox.d /etc/splash /etc/terminfo /etc/texmf/language.dat.d /etc/texmf/language.def.d /etc/texmf/updmap.d /etc/texmf/web2c"                                                         
CXXFLAGS="-march=native -ggdb -O2 -pipe"                                                                                                       
DISTDIR="/usr/portage/distfiles"                                                                                                               
EMERGE_DEFAULT_OPTS="--with-bdeps y"                                                                                                           
FEATURES="assume-digests buildpkg ccache collision-protect distlocks fixpackages news parallel-fetch preserve-libs preserved-rebuild protect-owned sandbox sfperms splitdebug strict unmerge-logs unmerge-orphans userfetch userpriv usersandbox"                                             
GENTOO_MIRRORS="http://mirrors.evolva.ro/gentoo http://ftp.roedu.net/pub/mirrors/gentoo.org http://mirrors.xservers.ro/gentoo http://distfiles.gentoo.org"                                                                                                                                    
LANG="ro_RO.UTF-8"                                                                                                                             
LC_ALL="ro_RO.UTF-8"                                                                                                                           
LDFLAGS="-Wl,-O1,--enable-new-dtags,-z,combreloc,--as-needed"                                                                                  
LINGUAS="ro en eo"                                                                                                                             
MAKEOPTS="-j5 -l8"
PKGDIR="/usr/portage/packages"
PORTAGE_CONFIGROOT="/"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/portage /var/lib/layman/sunrise /var/lib/layman/openmoko/trunk/openmoko-target"
SYNC="rsync://rsync.ro.gentoo.org/gentoo-portage"
USE="3dnow 3dnowext 3ds 7zip X a52 aac aalib accessibility acl acpi aesicm agg aiglx akonadi alsa amd64 amr amrnb amrwb apache2 asf aspell audiofile autotrace bash-completion berkdb bonjour branding bzip2 calendar caps captury cddb cdinstall cdparanoia cdr chdir cisco clamav consolekit cracklib crypt css cups curl cxx dba dbus dga djvu dmi doc dpms dri dts dv dvd dvdr ebook eds emboss encode erandom evo examples exif expat faac faad fam fbcon fbcondecor festival ffmpeg fftw firefox flac fontconfig fortran ftp gcj gcrypt gd gdbm geoip gif git glib glut gmp gnokii gnutls gpm gps graphviz gsm hal hbci hddtemp hou htmlhandbook iconv icu id3tag idn imagemagick imlib inotify iodbc ipv6 jadetex java javascript jingle jpeg jpeg2k justify kde kdehiddenvisibility kerberos kig-scripting kipi kvm lame lcms ldap libcaca libclamav libffi libgcrypt libnl libnotify libsamplerate libssh2 libwww live llvm-gcc lm_sensors lua lzma lzo mad maildir matroska mbrola melt metric mikmod mjpeg mmap mmx mmxext mng modules mp3 mp4 mplayer mppe-mppc mpx mudflap multilib musepack musicbrainz mysql mythtv ncurses network nls nodrm nowin nptl nptlonly odbc offensive ofx ogg openal opencore-amr openexr opengl openmp pam passwdqc pch pcre pdf perl phonon php physfs plasma plugins png policykit posix povray ppds pppd pth python python3 qt3support qt4 qthelp quicktime rdesktop readline reflection reiserfs rss rtc ruby samba sasl schroedinger sdl semantic-desktop session slang sms sockets sou sound sox speex spell spl sql sqlite sqlite3 srtp sse sse2 ssl startup-notification subversion svg symlink sysfs syslog sysvipc taglib tcpd theora threads thumbnail thunar tidy tiff timidity truetype tunepimp unicode usb vhook video videos visualization vnc voice vorbis webkit wifi wmf x264 xattr xcb xcomposite xine xml xml2 xmlrpc xmp xorg xpm xsl xulrunner xv xvid xvmc yahoo zeroconf zip zlib zvbi" ALSA_CARDS="bt87x via82xx" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="actions alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias" ELIBC="glibc" INPUT_DEVICES="keyboard mouse evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="ro en eo" LIRC_DEVICES="kworld" QEMU_SOFTMMU_TARGETS="arm i386 x86_64" QEMU_USER_TARGETS="arm armeb i386 x86_64" RUBY_TARGETS="ruby18" USERLAND="GNU" VIDEO_CARDS="radeon radeonhd vesa"
Unset:  CPPFLAGS, CTARGET, FFLAGS, INSTALL_MASK, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS

[Comment 4 Jorge Manuel B. S. Vicetto (RETIRED) 2010-02-21 19:07:10 UTC]

You have 2 choices for now:

 * mask the mysql-5.1 ebuilds
 * disable the embedded use flag in amarok and use mysql as a "full fledged" db

Until we get a new patch to enable building libmysqld as a shared lib, there's no option to allow amarok to work with an embedded mysql db.

[Comment 5 Patrizio Bassi 2010-03-20 13:14:18 UTC]

Jorge, are we tracking the 5.1 shared object lib patch in any bug entry? couldn't find any...

[Comment 6 Jorge Manuel B. S. Vicetto (RETIRED) 2010-03-20 18:16:50 UTC]

You can follow bug 306315.