amarok with mysql

erklaerbaer · 05-03-2007, 06:05 AM

hi,

i have some troubles with building amarok with mysql. ./configure claims to have found mysql , compilation doesn't give any errors, but still when i start the new amarok i can't select mysql ( there is a dropdown menu with sqllite though). i am using -current, mysql 5.0.37. any ideas?

if you have some spare time at your hands and either -11.0 or -current, could you run this slackbuild and report, wether it works for you? you'll need of course the source and the .options files.

Code:

#!/bin/sh
CWD=`pwd`
TMP=/tmp
PKG=$TMP/package-amarok

# Set the config option variables if they are not already set:
if [ -r ./KDE.options ]; then
  . ./KDE.options
fi

# The global options may be overridden here (if needed):
if [ -r ./local.options ]; then
  . ./local.options
fi

rm -rf $PKG
mkdir -p $PKG/usr

# Avoid a version number in .la files:
if [ -d /usr/lib/qt ]; then
  QTDIR=/usr/lib/qt
fi
cd $TMP
echo "Building amarok-$VERSION.tar.bz2..."
tar xjvf $CWD/amarok-$VERSION.tar.bz2

# I *hate* it when an "a" release blows off updating the directory name.  Grrrrrrrrrrrrrrrr.
# Commented out post 1.4.0a...
#cd amarok-1.4.0 || exit 1
cd amarok-$VERSION
chown -R root:root .
CFLAGS=$CPUOPT \
CXXFLAGS=$CPUOPT \
./configure \
  --prefix=/usr \
  --sysconfdir=/etc/kde \
  --enable-mysql \
  --without-arts \
  --without-libvisual \
  --without-ifp \
  --without-libmtp \
  --without-libgpod \
  --without-libkarma \
  --without-libnjb \
  --disable-debug \
  --without-daap \
  --program-prefix="" \
  --program-suffix="" \
  --build=$TARGET-slackware-linux

sleep 30

make $NUMJOBS || exit 1
make install DESTDIR=$PKG
mkdir -p $PKG/usr/doc/amarok-$VERSION
cp -a \
  AUTHORS COPYING INSTALL README TODO \
  $PKG/usr/doc/amarok-$VERSION
mkdir -p $PKG/install
cat $CWD/slack-desc > $PKG/install/slack-desc

( cd $PKG
  find . | xargs file | grep "executable" | grep ELF | cut -f 1 -d : | xargs strip --strip-unneeded 2> /dev/null
  find . | xargs file | grep "shared object" | grep ELF | cut -f 1 -d : | xargs strip --strip-unneeded 2> /dev/null
)
if [ -d $PKG/usr/man ]; then
  gzip -9 $PKG/usr/man/man?/*
fi

cd $PKG
makepkg -l y -c n ../amarok-$VERSION-$ARCH-$BUILD.tgz

thanks,
Andreas

erklaerbaer · 05-03-2007, 12:51 PM

i rebuild as myself and now the mysql option shows up.
it's a mystery to me...

amcleod · 07-26-2007, 09:29 PM

Quote:

Originally Posted by erklaerbaer

i have some troubles with building amarok with mysql. ./configure claims to have found mysql , compilation doesn't give any errors, but still when i start the new amarok i can't select mysql ( there is a dropdown menu with sqllite though). i am using -current, mysql 5.0.37. any ideas?

Same here. Amarok 1.4.6 with MySQL 5.0.37 (basic Slack12).

I rebuilt with --enable-mysql and got

Code:

= The following extra functionality will be included:
=   + MySql Support

I removepkg'd the original package, and installpkg'd my new build. I also deleted my ~/.kde/share/apps/amarok directory and ~/.kde/share/config/amarokrc file. Now when I go to the Settings->Configure Amarok->Collection there is a new "Collection Database" item at the bottom, but when I pull down the list only SQLite is available.

Yes, I have done

Code:

create database amarok;
grant all on amarok.* to amarok@localhost identified by 'password';
flush privileges;

I can't think what else I should do. Any suggestions welome.