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 \
      --dbhost=localhost \
      --dbuser=myuser \
      --dbpass=secret \
      --dbname=socksodb

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

8th February 2010

Sockso 1.2.3 - Fixed broken 1.2.2 release.

7th February 2010

Sockso 1.2.2 (BROKEN) - Users can now change their passwords via the web interface, added property to disable checking for the latest version, new manual scheduler, and bug fixes for quotes in track names and amazon cover fetching.

30th December

Sockso 1.2.1 - New cron scheduling support for collection scanning, streaming improvement (by mrave), and added palm pre support.

26th September

Sockso 1.2 - New faster track indexing, AAC support (by mrave), CPU usage improvements, updated Dutch translation, lots of other fixes.

2nd May

Sockso 1.1.8 - Bug fixes for 'connection closed' issue.

19th February

Sockso 1.1.7 - Bug fixes for MySQL, reduced CPU usage with toggleable buffering options when streaming, and removed remaining hard coded text from web interface.

19th January

Sockso 1.1.6 - Bug fixes for indexing and properties, a smarter 404 page, updated german translation, and upgraded to jQuery 1.3

11th January

Sockso 1.1.5 - Bug fixes for MySQL backend, and some javascript issues.

4th January 2009

Sockso 1.1.4 - Bug fixes for searching and logging in / uploading. Added unpacked javascript, restyled album and artist pages to better fit long names (and added a new 'JS Player' - unstable).

7th December

Sockso 1.1.3 - Bug fixes.

25th November

Sockso 1.1.2 - Fixed file uploading (hopefully all platforms).

20th October

Sockso 1.1.1 - Added french translation, ability to scan collection on demand, and fixed bugs with --datadir, indexing Ogg files, a missing image, and the name of the scrobble log.

7th October

Sockso 1.1 - MySQL and (some) SQLite support added, Sockso is now more easily customizable, new WMA to MP3 encoding option.

19th September

Sockso 1.0.9 - Added SSL support, streaming can now require authentication, users can get their scrobble log for tracks they've listened to, added a new flash player, fixed some bugs.

6th September

Sockso 1.0.7 - Add 'related artists' information to pages, improved unicode support and fixed Windows indexing bug (hidden folders now ignored)

30th July

Sockso 1.0.6 - Bug fix release for problems losing colors when resizing local cover art.

27th July

Sockso 1.0.5 - Added resizing of user artwork, random playing of artists/albums, ability to import playlists, fixed imageflow squashing bug, dutch and german translations, and informs user if new versions are available.

older news...

Sockso