I recently installed Slack 12 and switched from XMMS to Amarok.  I would prefer to use MySQL for the collection database. 

I got the Amarok source package, modified the SlackBuild script to add the --enable-mysql option. Checked and confirmed the presence of the libmysqlclient libraries and the /usr/include/mysql/ headers  and built a new package.  The results of the build are here.  Of interest are these lines:

Code: Select all

checking for mysql_config... yes
 . . .
 = The following extra functionality will be included:
 =   + libvisual Support

The build looks good and seems to have included MySQL support.  I removepkg the original version and installpkg the new version I just built. 

Next, I created a MySQL database called Amarok and using a GRANT statement added a user named "amarok" with all the *_priv set to 'Y' for host 'localhost'.

Then I deleted the ~/kde/share/apps/amarok directory and ~/kde/share/config/amarokrc run-control file.

I checked that /etc/my.cnf did not contain a skip-networking entry, and that the startup scripts were not using --skip-networking and used netstat to confirm that mysqld was listening on 3306 (in case TCP/IP is necessary) and started up Amarok with the --wizard option.  I de-selected all directories so Amarok would not construct a collection, and selected Settings->Configure Amarok->Collection.  At the bottom was a "Collection Database" area (new) containing a "Database:" pull-down, set to SQLite.  When I pull this down to select MySQL, there *IS* no MySQL option on the list, only SQLite.

I would really like to get to the bottom of this, so if anybody can suggest what to try next, I would be glad to hear it.  And if you can state that this definitely will work or definitely won't work with Slack 12, that would be good to know as well.

Whoops!  Obviously, that should be:

Code: Select all

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

Sorry -- buggered up the cut'n'paste.

While I'm at it let me ask this:  Does anybody actually have a functioning MySQL database collection?  Anybody using Slackware, particularly?  Or any other distro?

Well yes. My mysql db is working fine gentoo here.

I assume you have a mysql-dev package installed?
mysqld running?
Oh, try uninstalling the amarok binary package if you haven't already, and make sure the version of amarok you compiled is installed in the right place.
That's all I can think of.