MariaDB or MySQL support when using the WAR deployment

General discussions.

Moderator: moderators

MariaDB or MySQL support when using the WAR deployment

Postby redranger » Mon Dec 18, 2017 10:33 pm

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 8)
Thank you for your help.
Regards!
/Redranger
redranger
 
Posts: 30
Joined: Thu Aug 19, 2010 7:04 pm
Location: Denmark

Re: MariaDB or MySQL support when using the WAR deployment

Postby redranger » Tue Dec 19, 2017 9:14 pm

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?
Thank you for your help.
Regards!
/Redranger
redranger
 
Posts: 30
Joined: Thu Aug 19, 2010 7:04 pm
Location: Denmark

Re: MariaDB or MySQL support when using the WAR deployment

Postby redranger » Sat Dec 23, 2017 7:38 pm

Anyone?
Thank you for your help.
Regards!
/Redranger
redranger
 
Posts: 30
Joined: Thu Aug 19, 2010 7:04 pm
Location: Denmark

Re: MariaDB or MySQL support when using the WAR deployment

Postby redranger » Tue Jan 02, 2018 11:04 pm

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

Thank you so much.
Thank you for your help.
Regards!
/Redranger
redranger
 
Posts: 30
Joined: Thu Aug 19, 2010 7:04 pm
Location: Denmark

Re: MariaDB or MySQL support when using the WAR deployment

Postby lonesomerider » Wed Jan 03, 2018 11:24 pm

Hi,

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

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.
/lonesomerider

Image
lonesomerider
 
Posts: 26
Joined: Fri Oct 20, 2017 9:09 am
Location: Switzerland

Re: MariaDB or MySQL support when using the WAR deployment

Postby redranger » Thu Jan 04, 2018 10:00 pm

Thank you so very very much @lonesomerider ... it works :-) ... loving it!
Thank you for your help.
Regards!
/Redranger
redranger
 
Posts: 30
Joined: Thu Aug 19, 2010 7:04 pm
Location: Denmark


Return to General

Who is online

Users browsing this forum: No registered users and 3 guests