mysql setup?

[mrdrew]

I'd like to setup subsonic to use an external mysql database to (hopefully?) speed it up.

I'm currently running subsonic server, donation/registered, on unRaid NAS. It's a slackware based reiserfs NAS behind a firewall. I've opened a port in the firewall, and can use the web GUI no problemo.

I didn't see any options for an external database anywhere in the user, or admin account web GUI. Any ideas? Thank you!
drew


Version 4.7 (build 3105) – September 11, 2012
Server jetty-6.1.x, java 1.7.0_02, Linux (60.8 MB / 96.7 MB)

[hakko]

There's no option to use an external database in Subsonic 4.x. I haven't seen anyone tweak it to run on MySQL. Personally, I run a highly modified Subsonic server with a PostgreSQL backend, but I had to write a lot of code to make that work.

[mrdrew]

Out of curiosity, do you know what kind of database it natively uses?

[hakko]

Last time I checked it was hsqldb 1.8.0.7 released 2006-09-27 (http://hsqldb.org/doc/1.8/changelist_1_8_0.txt). Not the exact solution I would recommend.

[tsquillario]

There's no option to use an external database in Subsonic 4.x. I haven't seen anyone tweak it to run on MySQL. Personally, I run a highly modified Subsonic server with a PostgreSQL backend, but I had to write a lot of code to make that work.

Does MusicCabinet run 100% off of Postgres? I guess I'm not really understanding the add-on part. Does Subsonic still need to run using it's built-in database?

[daneren2005]

Yes and yes. Hakko only wrote a PostgreSQL back end, and main Subsonic still only works with its built in db.

Sent from my HTC One X using Tapatalk