Using Mysql with Subsonic 6.1

Tutorials, tips and tricks.

Moderator: moderators

Using Mysql with Subsonic 6.1

Postby texxasrulez » Mon Mar 13, 2017 1:18 am

EDIT: I found this page http://www.subsonic.org/pages/database.jsp detailing the external DB setup ...

I searched forums to use mysql and found nothing, so I am posting what I have done on Debian to use a mysql database.

edit /etc/default/subsonic and add --db=JDBC:mysql://localhost:3306/DATABASE?user=DATABASE_USER&password=PASSWORD to SUBSONIC_ARGS= section of file and restart Subsonic (service subsonic restart) and db schema will be created and you should be good to go ...

Have a good day ... :D
Last edited by texxasrulez on Fri Mar 24, 2017 1:05 pm, edited 1 time in total.
texxasrulez
 
Posts: 22
Joined: Thu Nov 25, 2010 11:03 pm

Re: Using Mysql with Subsonic 6.1

Postby acroyear » Mon Mar 13, 2017 12:03 pm

Does it migrate an existing (6.0 and earlier) DB or is it creating things from scratch?
--
Joe Shelby
http://subfiresuite.com/
http://subfireplayer.net/
User avatar
acroyear
 
Posts: 570
Joined: Wed Mar 27, 2013 8:05 pm
Location: Northern, VA

Re: Using Mysql with Subsonic 6.1

Postby texxasrulez » Mon Mar 13, 2017 8:24 pm

Unfortunately it did not migrate everything. I had to manually add users back and starred music. I had to add media folder and rescan it. This process was slower with mysql I noticed than using the default db.

I tried to search for a migration tutorial but I didn't find anything. They way I look at it, this was the last time I had to do it as mysql is backed up more reliable than the internal db from subsonic.
texxasrulez
 
Posts: 22
Joined: Thu Nov 25, 2010 11:03 pm

Re: Using Mysql with Subsonic 6.1

Postby acroyear » Tue Mar 14, 2017 2:46 am

I'm more concerned because my playlist randomizer/generator (SubFire Radio) works by storing the IDs, not the names, of things like other playlists, songs, albums, etc. On a rescan, those IDs will likely change, invaliding the generators. I have an 'export' function that will log the asset ID to its name in order to help reconstruct, but I never finished the re-importer.
--
Joe Shelby
http://subfiresuite.com/
http://subfireplayer.net/
User avatar
acroyear
 
Posts: 570
Joined: Wed Mar 27, 2013 8:05 pm
Location: Northern, VA

Re: Using Mysql with Subsonic 6.1

Postby medilane1 » Tue Apr 10, 2018 7:10 am

Hello,
Thank you very much for the info but I can not: /
Where to configure the
edit /etc/default/subsonic and add --db=JDBC:mysql://localhost:3306/DATABASE?user=DATABASE_USER&password=PASSWORD to SUBSONIC_ARGS=

I looking on the site http://www.subsonic.org/pages/database.jsp
But it's the same not understand or modify the jdbc..

Thank You for your help
medilane1
 
Posts: 9
Joined: Mon Apr 09, 2018 8:24 pm


Return to Tutorials

Who is online

Users browsing this forum: No registered users and 2 guests