HELP Using Mysql with Subsonic

[medilane1]

Hello,
I can not configure Subsonic on an external MYSQL server.
I followed the tutorial http://www.subsonic.org/pages/database.jsp
but I do not understand or change jdbc url: /

thanks for the help

I love Subsonic

[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?

[medilane1]

thanks for your answer, i'm using a synology + mariadb


I count on you

[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.

[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

[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.

[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 !!

[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=ca6d3f229ed21da9c0a93c589922f214

On 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.

[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?

[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

[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 !!

[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.

[medilane1]

I succeeded !!!!!


MySQL + phpmyadmin + php7.0 installation + root account configuration



Thank you very much for your help !!!

[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.

[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'