MariaDB or MySQL support when using the WAR deployment

[redranger]

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

[redranger]

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?

[redranger]

Anyone?

[redranger]

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

Thank you so much.

[lonesomerider]

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.

[redranger]

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