Subsonic Forum

Hi there....

I would like to run Subsonic on the MariaDB server v.15.1 Distrib 5.5.57, that comes with my QNAP TS251+ firmware v.4.3.3. Is that supported? If so, how can I configure the JDBC URL as described here > http://www.subsonic.org/pages/database.jsp

Any help is highly appreciated. Thank you very much.

Props

This looks promising > https://stackoverflow.com/questions/348 ... with-mysql <-- However. Trying it does not make Subsonic use MySQL. Any advice on how to make Subsonic on QNAP (WAR deployment in Tomcat) or another Busybox using device utilize MySQL?

Anyone?

Is there really no one that has bumped into this challenge before. Any help would be highly appreicated.

Thank you so much.

Hi,

Took my a while to have some time to try this myself

and found that by putting a setenv.sh file in the Tomcat bin folder does what you need (This is for linux, on Windows you would have a setenv.bat and a SET CATALINA_OPTS= line)

Code: Select all

#!/bin/sh
echo $CATALINA_OPTS
export CATALINA_OPTS="$CATALINA_OPTS -Dsubsonic.db=jdbc:mysql://localhost:3306/subsonic\?user=subsonicDbUser\&password=VeryStrangePasswordNobodyWillEverFindOut\&characterEncoding=UTF-8"
echo $CATALINA_OPTS


the echos are just for testing, not really needed.
You have to do additionally the following steps:

Code: Select all

chmod +x setenv.sh
chown UserUsedForTomcat setenv.sh


and then restart the Tomcat server.

If you use something different than Tomcat, pls. post YOur results, too.

Thank you so very very much @lonesomerider ... it works ... loving it!