Page 1 of 1
HELP Using Mysql with Subsonic

Posted:
Tue Apr 10, 2018 7:50 pm
by medilane1
Hello,
I can not configure Subsonic on an external MYSQL server.
I followed the tutorial
http://www.subsonic.org/pages/database.jspbut I do not understand or change jdbc url: /
thanks for the help
I love Subsonic

Re: HELP Using Mysql with Subsonic

Posted:
Tue Apr 10, 2018 8:23 pm
by toolman
On that page you'll find:
The JDBC URL must be given as a start-up option. This is done differently depending on how you installed Subsonic.
Windows Add -Dsubsonic.db=<JDBC URL> in C:\Program Files (x86)\Subsonic\subsonic-service.exe.vmoptions
Mac Add -Dsubsonic.db=<JDBC URL> in /Applications/Subsonic.app/Contents/Info.plist
Linux Add --db=<JDBC URL> to SUBSONIC_ARGS in /etc/default/subsonic (Ubuntu/Debian) or /etc/sysconfig/subsonic (Fedora/RPM).
So what OS are you using?
Re: HELP Using Mysql with Subsonic

Posted:
Tue Apr 10, 2018 10:54 pm
by medilane1
thanks for your answer, i'm using a synology + mariadb
I count on you

Re: HELP Using Mysql with Subsonic

Posted:
Wed Apr 11, 2018 7:38 am
by toolman
The OS synology uses is based on Linux so I guess that you'll have to follow the guidelines for Linux to get MariaDB working.
Which means that the JDBC Url = user=root&password=mysecretpassword&characterEncoding=UTF-8 (Of course you'll edit this line to hold your password for user root.)
Next you'll have add this line to SUBSONIC_ARGS which is in /etc/default/subsonic (Ubuntu/Debian) or /etc/sysconfig/subsonic (Fedora/RPM).
And that's about all I know about Linux.
But why would you choose for an external DB if you're having so much troubles to get it working?
Remember that with every new release you will have to configure Subsonic again to use MariaDB.
Re: HELP Using Mysql with Subsonic

Posted:
Wed Apr 11, 2018 8:17 am
by medilane1
Thank you ,
I can not find SUBSONIC_ARGS / etc / default / subsonic on synology
I would like to use an external database to be able to create a page registry account
Can be another solution?
If I can not do it with synology I'll go to linux
sorry for my english :/
thanks a lot for your help
Re: HELP Using Mysql with Subsonic

Posted:
Wed Apr 11, 2018 9:19 am
by toolman
I just downloaded the SPK-file from
https://github.com/ghenry22/Subsonic_Sy ... ster/build .
After unpacking it using 7-zip I couldn't find subsonic_args either. So I unpacked the file Package.tar which is in the package-folder. There I found the file Subsonic.sh which contains the line:
" --db=JDBC_URL Use alternate database. MySQL and HSQL are currently supported."I think that running Subsonic with an external database on your Synology-nas won't be easy. ( If it even can be done.)
Perhaps Linux would be a better choice, since there are a lot more users running Subsonic on Linux who can help you.
Re: HELP Using Mysql with Subsonic

Posted:
Wed Apr 11, 2018 5:06 pm
by medilane1
It does not work: /
SUBSONIC_DB = jdbc: mysql: // localhost: 3306 / subsonic? user = root & PASSE = mysecretpassword & characterEncoding = UTF-8
in the subsonic.sh file
i reboot the syno but nothing ..
In the BDD I created Subsonic utf8_general_ci
i have to create the tables in the bdd?
The best linux or Windows for Subsonic ?
Thank you !!
Re: HELP Using Mysql with Subsonic

Posted:
Wed Apr 11, 2018 6:09 pm
by toolman
Hi,
I'm sorry you can't get it to work on your Synology.
Maybe you should visit a synology forum:
https://forum.synology.com/enu/search.php?keywords=Subsonic&sid=ca6d3f229ed21da9c0a93c589922f214On your question what's best for Subsonic I would say that you'd better choose the OS you are most familiar with.
I'd like to think I know my way around in Windows so I have no problems installing, configuring and troubleshooting Subsonic on a Windows pc.
Others might advise you to choose Linux or even get a Mac, but in the end it comes down to what you know best.
Re: HELP Using Mysql with Subsonic

Posted:
Thu Apr 12, 2018 8:47 pm
by medilane1
Good evening,
I just changed I installed Debian Linux

Now I have to find out how to run MYSQL + BDD on Linux ^^
I have to create each table?
Re: HELP Using Mysql with Subsonic

Posted:
Thu Apr 12, 2018 9:17 pm
by toolman
I don't think so.
You just need to create a new empty database called subsonic.
The Subsonic.script file in folder subsonic\db will create all neccesary tables once you set the correct jdbc url
Just follow the directions on
http://www.subsonic.org/pages/database.jsp
Re: HELP Using Mysql with Subsonic

Posted:
Fri Apr 13, 2018 8:12 am
by medilane1
Hello

I managed to change the file with --db=jdbc:mysql://localhost:3306/subsonic?user=root&password=administrateur&characterEncoding=UTF-8
When I do that I have an error localhost:4040
HTTP ERROR: 503
SERVICE_UNAVAILABLE
RequestURI=/index.view
Do you have an idea ?
I go through Mariadb on debian can be the problem?
I'm really sorry to bother you! I love so much subsonic that I want to find !!

Re: HELP Using Mysql with Subsonic

Posted:
Fri Apr 13, 2018 10:37 am
by toolman
Did you check if MariaDB is compatible with Debian?
Does user root for Mariadb indeed have the password "administrateur" ?
Did you restart the Subsonic process after changing the database?
The error you are getting means that Subsonic wasn't able to start in a decent way.
Usually it means the database is corrupt or non existent.
Re: HELP Using Mysql with Subsonic

Posted:
Fri Apr 13, 2018 4:50 pm
by medilane1
I succeeded !!!!!
MySQL + phpmyadmin + php7.0 installation + root account configuration
Thank you very much for your help !!!
Re: HELP Using Mysql with Subsonic

Posted:
Fri Apr 13, 2018 7:11 pm
by toolman
Ok. Great!
Now that you've done it it may be a good idea to document the steps you've taken for future reference.
Have lots of fun with Subsonic.
Re: HELP Using Mysql with Subsonic

Posted:
Tue Aug 14, 2018 7:32 pm
by bahman2000
I found that on Linux at least, the JDBC URL needs to be wrapped in quotes, so using the example above, it would need to look like this to work:
- Code: Select all
--db='jdbc:mysql://localhost:3306/subsonic?user=root&password=administrateur&characterEncoding=UTF-8'