JDBC URL not being accepted by Subsonic

[CaptainRadio5]

My first post ... go gentle on me, good folk ...

Problem Description: I cannot get the JDBC URL to be recognized and work correctly - in the Log below it suggests "Check system property 'subsonic.db'."

Troubleshooting Steps: I am using MariaDB and, as Subsonic docs instructed, I added an "empty" database" named "subsonic". I verified the subsonic.db presence in MariaDB. [Did I need to do something besides "just add" the empty subsonic database?]

I implemented the JDBC_URL line in my Subsonic /etc/default/subsonic file, cutting, pasting, and modifying the string from the Subsonic online document, "Using an External Database". Here is the string as it appears within the /etc/default/subsonic file:

SUBSONIC_ARGS="--max-memory=150 --https-port=4443
--db=user=root&myMdbpassword&characterEncoding=UTF-8"

I then soft re-booted my Linux VM, and also restarted the Subsonic process.

I have searched the Forum for others who might have had the same issue and not found anything that directly approximates what I encountered.

Subsonic Version: 6.1.6 (build 0cfa60) – November 10, 2019

Server Version: jetty-6.1.x, java 1.8.0_312, HSQLDB, Linux (55.5 MB / 145.0 MB)

Hardware Platform: Linux Ubuntu 20.04 imaged virtual machine,2 gig RAM, at least 60 gig of virtual storage -- unsure about the physical host

Java Memory Limit: Unsure on my Linux VM

Problem Filename: /etc/default/subsonic (contains the problem parameter)

Output from ffmpeg -i: "Command 'ffmpeg' not found" (Linux response) [Is this a problem?]

Last ten log file lines:

Code: Select all

[7/10/22 1:42:06 PM UTC]   ERROR   DaoHelperFactory    [b]Unsupported JDBC url:user=root&myMdbpassword&characterEncoding=UTF-8. Reverting to HSQL. Check system property 'subsonic.db'.[/b]
[7/10/22 1:42:06 PM UTC]   INFO   HsqlDaoHelper   Checking database schema.
[7/10/22 1:42:08 PM UTC]   INFO   HsqlDaoHelper   Done checking database schema.
[7/10/22 1:42:09 PM UTC]   INFO   SettingsService   Java: 1.8.0_312, OS: Linux
[7/10/22 1:42:09 PM UTC]   INFO   PlayerDao   Deleted 2 player(s) that haven't been used after Wed May 11 13:42:09 UTC 2022
[7/10/22 1:42:09 PM UTC]   INFO   MediaScannerService   Automatic media library scanning scheduled to run every 1 day(s), starting at Mon Jul 11 03:00:00 UTC 2022
[7/10/22 1:42:09 PM UTC]   INFO   UPnPService   Starting UPnP service...
[7/10/22 1:42:10 PM UTC]   INFO   PodcastService   Automatic Podcast update scheduled to run every 24 hour(s), starting at Sun Jul 10 13:47:10 UTC 2022
[7/10/22 1:42:10 PM UTC]   INFO   UPnPService   Disabling UPnP/DLNA media server
[7/10/22 1:42:10 PM UTC]   INFO   UPnPService   Starting UPnP service - Done!
[7/10/22 1:42:19 PM UTC]   WARN   NetworkService   No UPnP router found.


[CaptainRadio5]

ftr, if anyone else browsing this topic is successfully connecting Subsonic with MariaDB on a Linux host, I'd be very deeply appreciative if that kind soul would simply cut-and-past the text of the SUBSONIC_ARGS "--db" parameter used into a Reply to this post (with the Password suitably masked, of course).

That's really all I need, friends, and I'm sure someone here has a "--db=..." spec working with MariaDB. Hope so, anyway!

I anticipate up to 5,000 entries in my Subsonic database, and I don't know if that would, or would not, overwhelm HSQLDB. Perhaps not.

Thanks - Captain Radio™ ...

[J_T_W]

I'm sure you've already seen this page, http://www.subsonic.org/pages/database.jsp, but just in case....

As for the HSQLDB, my legacy Subsonic instance has over 60k audio files and it handles it just fine. I believe I attempted to switch to MySQL a zillion years ago and the performance was miserable. Could just be my.

All that said, Subsonic is basically abandonware; it isn't open-source and there is no development or active support by the owner. Anyone still using the Subsonic platform is reliant on the community to help with, but that community is pretty small these days. You might consider moving off to a newer implementation of the Subsonic code.

If you're looking for a very lateral move, consider Airsonic Advanced https://github.com/airsonic-advanced/airsonic-advanced - It is in active development with frequent snapshot updates https://github.com/airsonic-advanced/airsonic-advanced/releases . Same feature set as Subsonic (API, Sonos, etc.) with updated code. As it is open source, you also get almost all the features Subsonic Premium gives you, but for free (see my last line).

If you're really more API focused, and looking just for a music streaming service (app over browser), you might consider moving off the Subsonic family of servers altogether. Check out Navidrome https://www.navidrome.org/ . That product is primarily to supply the API with a completely new back-end, and refocuses to just support audio (no video, podcast, internet radio, etc.). There is not yet built in support for Sonos.

Both products will need you to come up with your own DDNS solution for external access. Both support running as a service (platform dependent), and both function well behind a reverse proxy if needed.

[CaptainRadio5]

Thanks, J_T_W,

A lot to parse out here ...

Yes, I copied the MariaDB string from the database.jsp page and modified the necessary specifics for my situation. I was unsure about the root and password parms, but I reasoned they had to be those for MariaDB, so I used that root and the pw I assigned, without success. I don't know if my "error" is the wrong root/pw combo or the format of the --db wording or something else altogether. Also, so far no one actually getting the sample --db parameter to work at their Subsonic/MariaDB installations has gifted me a working string to model mine after -- maybe no one's gotten it to work for MariaDB and they just moved on.

It sounds like HSQLDB may hold up fine for me then with my measly 5k entries. I might just quit worrying about that problem for now, though I would like to get https secure logins working (see my other posting here within HELP).

The two other projects sound intriguing to me, especially Navidrome and its emphasis on AUDIO. I'm creating an AUDIO Drama site with an extensive library built up over nearly two decades at both SonicSociety.org and MutualAudioNetwork.com. I'll have to remember to post a URL here to the Mutual Media Center (MutualMedia.net) which will open very soon (I hope!). There, visitors can branch to the Podcast version, the Internet Radio 24/7 version, and, of course, the Subsonic version which I'm positioning to be our on-demand search/listen/gen playlists puppy.

Thanks again for all the insight, J_T_W ... who knows? I might get bored and download the last Open Source version 5 of Subsonic, scrape the rust off my Java skills, and monkey with it some myself. Thanks again - Captain Radio™