Fork me on GitHub

“A personal music server
for everyone”

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.

Comments

  • Narb Support said:
    I just made a registration @ my sockso and via phpadmin i edited the users line and set admin to 1. This make the console appears when logged in to the webinterface.
    2014-01-26 12:53:44
  • rizal said:
    I get ERROR too
    this my environment
    -sockso 1.5.1
    -java v1.6.0_25
    -optional component on ../lib/opt/
    -mysql 5.1.61
    --dbhost=localhost
    --dbuser=test
    --dbpass=testing
    --dbname=socksodb

    when i run
    java -verbose -jar sockso.jar --dbtype mysql --dbhost=localhost --dbname =socksodb --dbuser=test --dbpass=testing

    then it showing error:
    SocksoModule: Using MySQL Database
    Main: com.pugh.sockso.db.DatabaseConnectionException: com.mysql.jdbc.Driver
    Main: Shutting Down
    MySQLDatabase: java.lang.NullPointerException
    Main: Thank you for your attention, bye!

    Anyone can help?
    2012-04-08 03:55:15
  • straywasp said:
    Same problem as uarradiu. Cannot get sockso to use MySQL. Not sure if the error lies with my MySQL setup, or elsewhere.

    Also, is there a way to check that sockso sees the optionals? I wonder if it's a permissions problem or they need to be somewhere else?
    2012-04-04 10:39:01
  • uarradiu said:
    I followed the instructions literally and my optional components are located in sockso-1.5.1/lib/opt/ but I always I get the following error:

    SocksoModule: Using MySQL Database
    Main: com.pugh.sockso.db.DatabaseConnectionException: com.mysql.jdbc.Driver
    Main: Shutting Down
    MySQLDatabase: java.lang.NullPointerException
    Main: Thank you for your attention, bye!

    Googling for fix this trouble, the only page I found is:

    http://forums.pu-gh.com/viewtopic.php?t=768

    but is not very helpfull

    Anyone have any ideas? TVM!
    2012-04-01 20:57:30
  • vadim s. sabinich said:
    look at "--dbtype=mysql" key
    2012-02-18 01:26:57
  • Toni Appelqvist said:
    Hi
    I use MYSQL as A backend.
    And it is working fine.
    But when I start sockso it says that it use HSQL Database.
    Is this a bug ?

    Best regards from Sweden.
    2011-06-07 09:50:39

Post Comment

Just enter your name, fill out the easy captcha and enter your comments - it'll appear on the site right away. If you enter your email it will just be linked from your name so people can get in touch with you about your comment, so it's optional.

Sockso Community!

Sockso comes with the ability to be instantly part of the Sockso Community. So install now to to take part!

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 RSS Icon

12th May

Sockso 1.5.3 - Bug fix release - fixes broken folder browsing and related artists.

29th April

Sockso 1.5.2 - Bug fix for broken local cover art, and updated French translation.

14th March 2012

Sockso 1.5.1 - 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.

10th December

Sockso 1.5 - Added ability to add arbitrary meta tags, JPlayer support, HTTP Range header support, bug fixes, and finalised API v1.0

25th July

Sockso 1.4.2 - Fix for fetching cover artwork from Amazon.

24th July

Sockso 1.4.1 - Fixes for unicode output issue, and strict JSON API issue with single quotes.

23rd July

Sockso 1.4 - Added a JSON API to support developing applications on top of Sockso.

8th July

Posted screencast of *VERY* early version of new Sockso iPhone app. Feedback appreciated in the forums.

2nd July

Sockso 1.3.5 - Fix for problem on OSX where Sockso would not start, other minor bug fixes for Flac handling.

26th June

Sockso 1.3.4 - New HTML5 Player for iPad/iOS/etc support from nguillaumin, new 'tinygreen' skin from Simplify, and some bug fixes.

4th May

Sockso 1.3.3 - Album years now shown, Turkish translation added, and MP3 tag library updated (all thanks to badZeppelin!), some bug fixes to ajax page loading.

2nd April

Sockso 1.3.2 - Users can now require approval when registering, and updated ajaxified web interface with embedded player now default.

23rd March

Sockso 1.3.1 - 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.

17th March

Sockso 1.3 - Created ability to add servers to the new Sockso Community, and you can now run behind Apache without needing a VirtualHost (thanks to LightGlitch!)

5th February

Sockso 1.2.7 - Fix for broken javascript in 1.2.6.

30th January 2011

Sockso 1.2.6 (broken) - Fix for selecting the playlist in some browsers, and added new web admin console.

17th December

Sockso 1.2.5 - Minor bug fix for adding items to the playlist when browsing folders.

10th April

Sockso 1.2.4 - 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.

8th February

Sockso 1.2.3 - Fixed broken 1.2.2 release.

Linux Logo Windows Logo OSX Logo