Using MySQL as a backend
By default Sockso uses the Java database engine HSQLDB. This provides a nice
fast easy way to get a database up and running in an application and works
excellently for most uses of Sockso.
If you have a very large collection though you may run into some performance
problems and possibly "out of memory" errors when accessing some of the pages.
In these cases you have the option of changing the database engine Sockso uses,
and for this MySQL support is available.
NB: Sockso requires MySQL 5+
1) Download Sockso's Optional Components
You will need to install the optional components
first to use MySQL.
2) Create the database
The first thing you will need to do is create a MySQL database for Sockso
to use. It doesn't need to have any tables in it, Sockso will take care of
creating these when it starts up, but the database does need to exist.
3) Start Sockso with MySQL
When you have created the database just start Sockso with the following
command line switches (changing the values to match your set up obviously)
which tell it to use MySQL, and the connection information for the database.
$> java -jar sockso.jar --dbtype=mysql \
Sockso will now be running with MySQL.
NB: This will be a completely blank database.
If you love using Sockso and would like to give a little back,
try a donation to help out and support open source development.
Latest News & Releases
Bug fix release - fixes broken folder browsing and related artists.
Bug fix for broken local cover art, and updated French translation.
14th March 2012
Bug fixes for path security hole, API access, and encoded pluses. Along with updated Italian translation,
adding ability to extract cover art from ID3 tags.
Added ability to add arbitrary meta tags, JPlayer support, HTTP Range header support, bug fixes, and finalised API v1.0
Fix for fetching cover artwork from Amazon.
Fixes for unicode output issue, and strict JSON API issue with single quotes.
Added a JSON API to support developing
applications on top of Sockso.
Posted screencast of *VERY* early
version of new Sockso iPhone app. Feedback appreciated in the forums.
Fix for problem on OSX where Sockso would not start, other minor bug fixes for Flac handling.
New HTML5 Player for iPad/iOS/etc support from nguillaumin,
new 'tinygreen' skin from Simplify, and some bug fixes.
Album years now shown, Turkish translation added, and MP3 tag library updated (all thanks to badZeppelin!),
some bug fixes to ajax page loading.
Users can now require approval when registering, and updated ajaxified web interface with embedded player now default.
Fix for missing 'colscan' command from console, moved optional libraries location (to upgrade rename
your optionals folder from 'lib-opt' to 'lib/opt', and a bug fix for invalid URL characters
breaking some playlist files.
Created ability to add servers to the new Sockso Community,
and you can now run behind Apache without needing a VirtualHost (thanks to LightGlitch!)
30th January 2011
Sockso 1.2.6 (broken)
Fix for selecting the playlist in some browsers, and added new web admin console.
Minor bug fix for adding items to the playlist when browsing folders.
Patches from Will to improve HTTP/HTTPS streaming performance, and HTML compliance, improved
music tree in GUI to cope with any size collections, hidden files now ignored on indexing,
and some other bugs.
Fixed broken 1.2.2 release.