If anyone is interested in using MySQL as the server instead of SQLITE (I cannot guarantee how this will work but I've tested out basic functionality so far - use at your own risk):
# Enter your jail
jls
jexec 1 tcsh
#Install MySQL Server
pkg install mysql51-server
# enable mysql in rc.conf
ee /etc/rc.conf
#Type in
mysql_enable="YES"
# Start MySQL
service mysql-server start
# Update password for root
mysql -u root -p
(Enter - no password set as of yet)
UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';
FLUSH PRIVILEGES;
CREATE DATABASE slimserver;
GRANT ALL ON slimserver.* to slimserver IDENTIFIED BY 'slimserver_password';
FLUSH PRIVILEGES;
Exit
#Turn off LMS
sh /usr/local/etc/rc.d/lms onestop
#Edit preferences file
ee /usr/local/lms/prefs/server.prefs
# Add in:
dbpassword: slimserver_password
dbsource: dbi:mysql:hostname=127.0.0.1;port=3306;database=slimserver
dbtype: mysql
dbusername: slimserver
#Install DBD/mysql.pm
pkg install p5-DBD-mysql
#Configure SlimServer so that it only starts after your MySQL instance has been started.
ee /usr/local/etc/rc.d/lms
#Add mysql to the end of require in the rc.s/lms file e.g.
# REQUIRE: LOGIN mysql
# Start LMS server
sh /usr/local/etc/rc.d/lms onestart
I then installed and tested with
http://sourceforge.net/projects/softsqueeze/files/softsqueeze/softsqueeze-3.9b2/ for OS X and used the web interface to check functionality.
I then tested on my SqueezeBox radio.