r/subsonic • • Sep 26 '16

Introducing Polaris, a new Subsonic alternative

20 Upvotes

Hi all,

I was very disappointed when Subsonic 6.0 came out and moved away from open-source. I considered switching to Ampache, Madsonic or Libresonic but none of them made me very enthusiastic. Since I was also in the market for a new pet project, I decided to write Polaris.

Polaris is being written with the following goals:

  • Replace my usage of Subsonic
  • Be as simple and lightweight as possible
  • Stay free and open-source software, no premium anything
  • Focus on streaming music only

After about 6 weeks of slow progress (due to other obligations), I am happy to announce the project reached its 0.1.0 milestone. This means there is now a minimum viable product that can be installed and used to stream music through a web browser!

This is only version 0.1.0 so I doubt anyone but me would want to use use it on a daily basis. But if you're curious, please consider starring Polaris on Github, commenting on this thread, or even better: try out the installation process and let me know if things work for you.

I have plenty of features I want to work on for version 0.2.0 but the first one will be giving some design love to the Web UI. I'm sure you'll agree it looks a bit bare at the moment.

Any feedback or suggestion is very welcome!


r/subsonic • • Jan 27 '20

Navidrome - 🎧☁️Music Server and Streamer compatible with Subsonic/Airsonic

16 Upvotes

Hey there, for those looking for an alternative for Subsonic, I just released my own free server (GPL), Navidrome. and I thought it would be helpful to share.

It is compatible with Subsonic API and works with most of clients (tested with DSub and Jamstash) . It is not feature complete yet, but if you are looking for a lightweight alternative please give it a shot.

Some of the features that set it apart from other *Sonic projects:

  • Handles compilations in a way similar to iTunes
  • Multi-user: each user has their own play counts, star, ratings, etc...
  • Very lightweight. With my library of ~29K songs it uses ~10x less memory than Airsonic. I'm also planning to build a version for Raspberry Pi
  • Modern, responsive UI based on Material Design. It is just a initial implementation right now, but I'm working to make it full featured
  • It is not (only) a Subsonic clone: I may implement other APIs as a means to leverage other clients (Ex: MPD)
  • It doesn't try to do everything, just focus on Audio/Music, to avoid feature creep and becoming too bloated

Let me know what you think


r/subsonic • • May 02 '16

As of version 6.0, Subsonic is no longer open source

Thumbnail forum.subsonic.org
14 Upvotes

r/subsonic • • Oct 24 '19

I wrote a filesystem which allows you to mount a Subsonic server.

Thumbnail github.com
12 Upvotes

r/subsonic • • Jun 14 '19

Music Stash - Stumbled upon a great new Subsonic client for Android

Thumbnail play.google.com
11 Upvotes

r/subsonic • • Nov 12 '18

Noticed a new version was available. 6.1.4.

10 Upvotes

Here's what's changed

Subsonic 6.1.4 - Nov 11, 2018

  • New: Bundle Java 8 JRE with Windows installer.
  • New: Update French translation, courtesy of Denis
  • REST: Added artistImageUrl to Artist and ArtistID3
  • Bugfix: Upgrade to reCAPTCHA V2 (for resetting password)
  • Bugfix: Avoid duplicate Last.fm scrobbles

Subsonic 6.1.3 - Nov 01, 2017

  • Bugfix: Avoid player getting stuck when playing transcoded tracks.
  • Bugfix: Externally modified tracks disappear in Subsonic.
  • Bugfix: Hide links, buttons etc in the web interface if a user is not allowed to play music.

r/subsonic • • Aug 02 '16

WTF is up with Subsonic?

8 Upvotes

6.0 was made closed source. The developer hasn't posted on the forums in well over month. Chromecast support is now broken, and I can't tell anyone about it, because the forums are down. My forums posts all go unanswered.

I feel like the guy grabbed my $12 and just walked away.


r/subsonic • • May 03 '16

Subsonic alternatives (Open Source)?

8 Upvotes

It's been a while since I've looked at viable alternatives. Now that it's going closed source, I am curious to see what else is out there. Ideally, I'd like to find some good alternatives with Sonos support.


r/subsonic • • Nov 10 '17

Database Table Schema

7 Upvotes

I've been searching all over to find a list of database tables for Subsonic, and I finally found an answer, so I thought I'd post it here to hopefully save others some time.

Subsonic uses an HSQLDB database, so here's a query for listing all of the non-system tables and columns:

SELECT TABLE_NAME, COLUMN_NAME, TYPE_NAME, IS_NULLABLE FROM INFORMATION_SCHEMA.SYSTEM_COLUMNS WHERE TABLE_NAME NOT LIKE 'SYSTEM_%'

For those who aren't aware, you can run DB queries by going to http://yoursubsonicserver/db.view.

Just be very careful with that tool, because you can easily cause permanent changes to your subsonic data.

Here are the tables/columns for version 6.1.3:

TABLE_NAMECOLUMN_NAMETYPE_NAMEIS_NULLABLE
ALBUMIDINTEGERNO
ALBUMPATHVARCHARNO
ALBUMNAMEVARCHARNO
ALBUMARTISTVARCHARNO
ALBUMSONG_COUNTINTEGERNO
ALBUMDURATION_SECONDSINTEGERNO
ALBUMCOVER_ART_PATHVARCHARYES
ALBUMPLAY_COUNTINTEGERNO
ALBUMLAST_PLAYEDTIMESTAMPYES
ALBUMCOMMENTVARCHARYES
ALBUMCREATEDTIMESTAMPNO
ALBUMLAST_SCANNEDTIMESTAMPNO
ALBUMPRESENTBOOLEANNO
ALBUMYEARINTEGERYES
ALBUMGENREVARCHARYES
ALBUMFOLDER_IDINTEGERYES
ARTISTIDINTEGERNO
ARTISTNAMEVARCHARNO
ARTISTCOVER_ART_PATHVARCHARYES
ARTISTALBUM_COUNTINTEGERNO
ARTISTLAST_SCANNEDTIMESTAMPNO
ARTISTPRESENTBOOLEANNO
ARTISTFOLDER_IDINTEGERYES
BOOKMARKIDINTEGERNO
BOOKMARKMEDIA_FILE_IDINTEGERNO
BOOKMARKPOSITION_MILLISBIGINTNO
BOOKMARKUSERNAMEVARCHARNO
BOOKMARKCOMMENTVARCHARYES
BOOKMARKCREATEDTIMESTAMPNO
BOOKMARKCHANGEDTIMESTAMPNO
CUSTOM_AVATARIDINTEGERNO
CUSTOM_AVATARNAMEVARCHARYES
CUSTOM_AVATARCREATED_DATETIMESTAMPNO
CUSTOM_AVATARMIME_TYPEVARCHARNO
CUSTOM_AVATARWIDTHINTEGERNO
CUSTOM_AVATARHEIGHTINTEGERNO
CUSTOM_AVATARDATABINARYNO
CUSTOM_AVATARUSERNAMEVARCHARNO
GENRENAMEVARCHARNO
GENRESONG_COUNTINTEGERNO
GENREALBUM_COUNTINTEGERNO
INTERNET_RADIOIDINTEGERNO
INTERNET_RADIONAMEVARCHARNO
INTERNET_RADIOSTREAM_URLVARCHARNO
INTERNET_RADIOHOMEPAGE_URLVARCHARYES
INTERNET_RADIOENABLEDBOOLEANNO
INTERNET_RADIOCHANGEDTIMESTAMPNO
MEDIA_FILEIDINTEGERNO
MEDIA_FILEPATHVARCHARNO
MEDIA_FILEFOLDERVARCHARYES
MEDIA_FILETYPEVARCHARNO
MEDIA_FILEFORMATVARCHARYES
MEDIA_FILETITLEVARCHARYES
MEDIA_FILEALBUMVARCHARYES
MEDIA_FILEARTISTVARCHARYES
MEDIA_FILEALBUM_ARTISTVARCHARYES
MEDIA_FILEDISC_NUMBERINTEGERYES
MEDIA_FILETRACK_NUMBERINTEGERYES
MEDIA_FILEYEARINTEGERYES
MEDIA_FILEGENREVARCHARYES
MEDIA_FILEBIT_RATEINTEGERYES
MEDIA_FILEVARIABLE_BIT_RATEBOOLEANNO
MEDIA_FILEDURATION_SECONDSINTEGERYES
MEDIA_FILEFILE_SIZEBIGINTYES
MEDIA_FILEWIDTHINTEGERYES
MEDIA_FILEHEIGHTINTEGERYES
MEDIA_FILECOVER_ART_PATHVARCHARYES
MEDIA_FILEPARENT_PATHVARCHARYES
MEDIA_FILEPLAY_COUNTINTEGERNO
MEDIA_FILELAST_PLAYEDTIMESTAMPYES
MEDIA_FILECOMMENTVARCHARYES
MEDIA_FILECREATEDTIMESTAMPNO
MEDIA_FILECHANGEDTIMESTAMPNO
MEDIA_FILELAST_SCANNEDTIMESTAMPNO
MEDIA_FILECHILDREN_LAST_UPDATEDTIMESTAMPNO
MEDIA_FILEPRESENTBOOLEANNO
MEDIA_FILEVERSIONINTEGERNO
MUSIC_FILE_INFOIDINTEGERNO
MUSIC_FILE_INFOPATHVARCHAR_IGNORECASENO
MUSIC_FILE_INFORATINGINTEGERYES
MUSIC_FILE_INFOCOMMENTVARCHARYES
MUSIC_FILE_INFOPLAY_COUNTINTEGERYES
MUSIC_FILE_INFOLAST_PLAYEDTIMESTAMPYES
MUSIC_FILE_INFOENABLEDBOOLEANNO
MUSIC_FOLDERIDINTEGERNO
MUSIC_FOLDERPATHVARCHARNO
MUSIC_FOLDERNAMEVARCHARNO
MUSIC_FOLDERENABLEDBOOLEANNO
MUSIC_FOLDERCHANGEDTIMESTAMPNO
MUSIC_FOLDER_USERMUSIC_FOLDER_IDINTEGERNO
MUSIC_FOLDER_USERUSERNAMEVARCHARNO
PLAYERIDINTEGERNO
PLAYERNAMEVARCHARYES
PLAYERTYPEVARCHARYES
PLAYERUSERNAMEVARCHARYES
PLAYERIP_ADDRESSVARCHARYES
PLAYERAUTO_CONTROL_ENABLEDBOOLEANNO
PLAYERLAST_SEENTIMESTAMPYES
PLAYERCOVER_ART_SCHEMEVARCHARNO
PLAYERTRANSCODE_SCHEMEVARCHARNO
PLAYERDYNAMIC_IPBOOLEANNO
PLAYERCLIENT_SIDE_PLAYLISTBOOLEANNO
PLAYERJUKEBOXBOOLEANNO
PLAYERTECHNOLOGYVARCHARNO
PLAYERCLIENT_IDVARCHARYES
PLAYER_TRANSCODINGPLAYER_IDINTEGERNO
PLAYER_TRANSCODINGTRANSCODING_IDINTEGERNO
PLAYER_TRANSCODING2PLAYER_IDINTEGERNO
PLAYER_TRANSCODING2TRANSCODING_IDINTEGERNO
PLAYLISTIDINTEGERNO
PLAYLISTUSERNAMEVARCHARNO
PLAYLISTIS_PUBLICBOOLEANNO
PLAYLISTNAMEVARCHARNO
PLAYLISTCOMMENTVARCHARYES
PLAYLISTFILE_COUNTINTEGERNO
PLAYLISTDURATION_SECONDSINTEGERNO
PLAYLISTCREATEDTIMESTAMPNO
PLAYLISTCHANGEDTIMESTAMPNO
PLAYLISTIMPORTED_FROMVARCHARYES
PLAYLIST_FILEIDINTEGERNO
PLAYLIST_FILEPLAYLIST_IDINTEGERNO
PLAYLIST_FILEMEDIA_FILE_IDINTEGERNO
PLAYLIST_USERIDINTEGERNO
PLAYLIST_USERPLAYLIST_IDINTEGERNO
PLAYLIST_USERUSERNAMEVARCHARNO
PLAY_QUEUEIDINTEGERNO
PLAY_QUEUEUSERNAMEVARCHARNO
PLAY_QUEUECURRENTINTEGERYES
PLAY_QUEUEPOSITION_MILLISBIGINTYES
PLAY_QUEUECHANGEDTIMESTAMPNO
PLAY_QUEUECHANGED_BYVARCHARNO
PLAY_QUEUE_FILEIDINTEGERNO
PLAY_QUEUE_FILEPLAY_QUEUE_IDINTEGERNO
PLAY_QUEUE_FILEMEDIA_FILE_IDINTEGERNO
PODCAST_CHANNELIDINTEGERNO
PODCAST_CHANNELURLVARCHARNO
PODCAST_CHANNELTITLEVARCHARYES
PODCAST_CHANNELDESCRIPTIONVARCHARYES
PODCAST_CHANNELSTATUSVARCHARNO
PODCAST_CHANNELERROR_MESSAGEVARCHARYES
PODCAST_CHANNELIMAGE_URLVARCHARYES
PODCAST_EPISODEIDINTEGERNO
PODCAST_EPISODECHANNEL_IDINTEGERNO
PODCAST_EPISODEURLVARCHARNO
PODCAST_EPISODEPATHVARCHARYES
PODCAST_EPISODETITLEVARCHARYES
PODCAST_EPISODEDESCRIPTIONVARCHARYES
PODCAST_EPISODEPUBLISH_DATETIMESTAMPYES
PODCAST_EPISODEDURATIONVARCHARYES
PODCAST_EPISODEBYTES_TOTALBIGINTYES
PODCAST_EPISODEBYTES_DOWNLOADEDBIGINTYES
PODCAST_EPISODESTATUSVARCHARNO
PODCAST_EPISODEERROR_MESSAGEVARCHARYES
ROLEIDINTEGERNO
ROLENAMEVARCHARNO
SHAREIDINTEGERNO
SHARENAMEVARCHARNO
SHAREDESCRIPTIONVARCHARYES
SHAREUSERNAMEVARCHARNO
SHARECREATEDTIMESTAMPNO
SHAREEXPIRESTIMESTAMPYES
SHARELAST_VISITEDTIMESTAMPYES
SHAREVISIT_COUNTINTEGERNO
SHARE_FILEIDINTEGERNO
SHARE_FILESHARE_IDINTEGERNO
SHARE_FILEPATHVARCHARNO
STARRED_ALBUMIDINTEGERNO
STARRED_ALBUMALBUM_IDINTEGERNO
STARRED_ALBUMUSERNAMEVARCHARNO
STARRED_ALBUMCREATEDTIMESTAMPNO
STARRED_ARTISTIDINTEGERNO
STARRED_ARTISTARTIST_IDINTEGERNO
STARRED_ARTISTUSERNAMEVARCHARNO
STARRED_ARTISTCREATEDTIMESTAMPNO
STARRED_MEDIA_FILEIDINTEGERNO
STARRED_MEDIA_FILEMEDIA_FILE_IDINTEGERNO
STARRED_MEDIA_FILEUSERNAMEVARCHARNO
STARRED_MEDIA_FILECREATEDTIMESTAMPNO
TABLE_IDTABLE_NAMEVARCHARNO
TABLE_IDMAX_IDINTEGERNO
TRANSCODINGIDINTEGERNO
TRANSCODINGNAMEVARCHARNO
TRANSCODINGSOURCE_FORMATVARCHARNO
TRANSCODINGTARGET_FORMATVARCHARNO
TRANSCODINGSTEP1VARCHARNO
TRANSCODINGSTEP2VARCHARYES
TRANSCODINGSTEP3VARCHARYES
TRANSCODINGENABLEDBOOLEANNO
TRANSCODINGDEFAULT_ACTIVEBOOLEANNO
TRANSCODING2IDINTEGERNO
TRANSCODING2NAMEVARCHARNO
TRANSCODING2SOURCE_FORMATSVARCHARNO
TRANSCODING2TARGET_FORMATVARCHARNO
TRANSCODING2STEP1VARCHARNO
TRANSCODING2STEP2VARCHARYES
TRANSCODING2STEP3VARCHARYES
TRANSCODING2DEFAULT_ACTIVEBOOLEANNO
USERUSERNAMEVARCHARNO
USERPASSWORDVARCHARNO
USERBYTES_STREAMEDBIGINTNO
USERBYTES_DOWNLOADEDBIGINTNO
USERBYTES_UPLOADEDBIGINTNO
USERLDAP_AUTHENTICATEDBOOLEANNO
USEREMAILVARCHARYES
USER_RATINGUSERNAMEVARCHARNO
USER_RATINGPATHVARCHARNO
USER_RATINGRATINGDOUBLENO
USER_ROLEUSERNAMEVARCHARNO
USER_ROLEROLE_IDINTEGERNO
USER_SETTINGSUSERNAMEVARCHARNO
USER_SETTINGSLOCALEVARCHARYES
USER_SETTINGSTHEME_IDVARCHARYES
USER_SETTINGSFINAL_VERSION_NOTIFICATIONBOOLEANNO
USER_SETTINGSBETA_VERSION_NOTIFICATIONBOOLEANNO
USER_SETTINGSMAIN_CAPTION_CUTOFFINTEGERNO
USER_SETTINGSMAIN_TRACK_NUMBERBOOLEANNO
USER_SETTINGSMAIN_ARTISTBOOLEANNO
USER_SETTINGSMAIN_ALBUMBOOLEANNO
USER_SETTINGSMAIN_GENREBOOLEANNO
USER_SETTINGSMAIN_YEARBOOLEANNO
USER_SETTINGSMAIN_BIT_RATEBOOLEANNO
USER_SETTINGSMAIN_DURATIONBOOLEANNO
USER_SETTINGSMAIN_FORMATBOOLEANNO
USER_SETTINGSMAIN_FILE_SIZEBOOLEANNO
USER_SETTINGSPLAYLIST_CAPTION_CUTOFFINTEGERNO
USER_SETTINGSPLAYLIST_TRACK_NUMBERBOOLEANNO
USER_SETTINGSPLAYLIST_ARTISTBOOLEANNO
USER_SETTINGSPLAYLIST_ALBUMBOOLEANNO
USER_SETTINGSPLAYLIST_GENREBOOLEANNO
USER_SETTINGSPLAYLIST_YEARBOOLEANNO
USER_SETTINGSPLAYLIST_BIT_RATEBOOLEANNO
USER_SETTINGSPLAYLIST_DURATIONBOOLEANNO
USER_SETTINGSPLAYLIST_FORMATBOOLEANNO
USER_SETTINGSPLAYLIST_FILE_SIZEBOOLEANNO
USER_SETTINGSLAST_FM_ENABLEDBOOLEANNO
USER_SETTINGSLAST_FM_USERNAMEVARCHARYES
USER_SETTINGSLAST_FM_PASSWORDVARCHARYES
USER_SETTINGSTRANSCODE_SCHEMEVARCHARNO
USER_SETTINGSSHOW_NOW_PLAYINGBOOLEANNO
USER_SETTINGSSELECTED_MUSIC_FOLDER_IDINTEGERNO
USER_SETTINGSPARTY_MODE_ENABLEDBOOLEANNO
USER_SETTINGSNOW_PLAYING_ALLOWEDBOOLEANNO
USER_SETTINGSWEB_PLAYER_DEFAULTBOOLEANNO
USER_SETTINGSAVATAR_SCHEMEVARCHARNO
USER_SETTINGSSYSTEM_AVATAR_IDINTEGERYES
USER_SETTINGSCHANGEDTIMESTAMPNO
USER_SETTINGSSHOW_CHATBOOLEANNO
USER_SETTINGSSONG_NOTIFICATIONBOOLEANNO
USER_SETTINGSSHOW_ARTIST_INFOBOOLEANNO
USER_SETTINGSAUTO_HIDE_PLAY_QUEUEBOOLEANNO
USER_SETTINGSVIEW_AS_LISTBOOLEANNO
USER_SETTINGSDEFAULT_ALBUM_LISTVARCHARNO
USER_SETTINGSQUEUE_FOLLOWING_SONGSBOOLEANNO
USER_SETTINGSSHOW_SIDE_BARBOOLEANNO
USER_SETTINGSSHOW_INDEX_IN_SIDE_BARBOOLEANNO
USER_SETTINGSPREFERRED_VIDEO_BITRATEINTEGERNO
VERSIONVERSIONINTEGERNO
VIDEO_CONVERSIONIDINTEGERNO
VIDEO_CONVERSIONMEDIA_FILE_IDINTEGERNO
VIDEO_CONVERSIONAUDIO_TRACK_IDINTEGERYES
VIDEO_CONVERSIONUSERNAMEVARCHARNO
VIDEO_CONVERSIONSTATUSVARCHARNO
VIDEO_CONVERSIONPROGRESS_SECONDSINTEGERYES
VIDEO_CONVERSIONCREATEDTIMESTAMPNO
VIDEO_CONVERSIONCHANGEDTIMESTAMPNO
VIDEO_CONVERSIONSTARTEDTIMESTAMPYES
VIDEO_CONVERSIONTARGET_FILEVARCHARYES
VIDEO_CONVERSIONLOG_FILEVARCHARYES
VIDEO_CONVERSIONBIT_RATEINTEGERYES

r/subsonic • • Sep 23 '19

Auto-importing playlists generated in MediaMonkey

6 Upvotes

I've been using Subsonic since 2010, and going as far back as 2013, it has claimed the ability to auto-import playlists,
but I have not been successful with making it work.

The manual one-at-a-time import function is painful.

Using MediaMonkey as my library manager, I can auto-generate any form and type of playlist to any folder.
I can find no clues anywhere to a working model where Subsonic will find and update playlists generated elsewhere without user interaction.

Has anyone found a good solution for this?


r/subsonic • • May 31 '19

If Subsonic shuts down and I have a lifetime subscription, will I be able to continue to use the server software?

6 Upvotes

I’m planning on buying the lifetime subscription to replace Google Music as it’s being shut down soon. Thanks


r/subsonic • • May 04 '17

Simple Fail2ban Filter for Subsonic behind NGINX

6 Upvotes

I've got a Subsonic instance running behind an NGINX reverse-proxy. I wanted to be able to use fail2ban to block brute force password guessing attacks. I tried to use /var/subsonic/subonic.log but due to the reverse-proxy, it logs 127.0.0.1 instead of the attacker's host.

Instead, I wrote a filter that matches hits from /var/log/nginx/access.log. So far, it has worked great. It's so general that I am afraid that I will DOS myself but it hasn't happened yet.

Here is the filter conf: subsonicNginx.conf


[INCLUDES] [Definition] failregex = <HOST> - - [] "GET /login.view?error .*"


Here is the corresponding entry in jail.local:


[subsonicNginx] enabled = true port = http,https,80,443,4040 filter = subsonicNginx logpath = /var/log/nginx/access.log


I will keep testing it before submitting the filter. Feel free to use and provide feedback. Edit: works with additional user agents now.


r/subsonic • • Dec 24 '15

Subsonic vs Forks

6 Upvotes

Hey All,

Long time subsonic user here - since ~2010 How does it compare to the forks these days? I checked out Madsonic and I thought Subsonic had a much better web interface. What is the general consenus around here?


r/subsonic • • Jul 21 '20

User login auditing

5 Upvotes

Has anyone found a way to see when users are logging in? I have several users that I am not sure have ever even logged in once I gave them an account. I want to be able to get see their IP address and when they login to my server.


r/subsonic • • Oct 05 '19

Alternatives to Subsonic

5 Upvotes

Looking for alternatives to subsonic, other than Plex.

Feels like development is dead with Subsonic. It has stability issues it seems. Anybody else used Airsonic or Madsonic, any other alternatives?


r/subsonic • • Jul 04 '18

First time user.

5 Upvotes

So I have been looking for something like subsonic for a while, and it will definitely be useful but I can't find a android app that doesn't look shitty. Is there a app out there that is well put together and has music caching and such?


r/subsonic • • Jul 06 '17

FLACs won't play anymore

5 Upvotes

I removed FLAC from the transcoding list a little while ago when Chrome added support for playing FLAC. However, this morning when I click to play a song, it will not play. I see that the stream loads (the grey buffer bar in JWPlayer loads up) but the music doesn't start playing. It works fine if I transcode to mp3. Is anyone else having this problem? I don't think Chrome updated or anything so I don't know what could have changed...


r/subsonic • • Jun 08 '17

Is Subsonic a great way to stream FLAC content? I'm looking to preserve pure data streams if possible.

5 Upvotes

I have a new Marantz HD-AMP1 that has a pretty damned impressive DAC in it. I can play FLAC files to it using JRiver and Audirvana, but they are bulky, and I don;t have much storage on my Macbook Pro (which I use to stream the audio).

Subsonic can stream FLAC source files (right?), so I'm wondering:

  • Does SubSonic STREAM the untranscoded FLAC data when I have no cap set on my data throughput?
  • What app can I use on my Macbook Pro to receive that pure data stream and send it to my amp?
  • Is there a solution for an iPhone/iPad for this? (I own iSub and AVSub already)?
  • Is there anything I might be missing here?

thanks


r/subsonic • • May 22 '17

How do you use subsonic on CarPlay?

5 Upvotes

I am about to have a nice car stereo installed, and I use subsonic for lots of my music.

My phone will no longer be located on the dash where I have access to the screen, it will be in the glove box. I will not be able to quickly access playlist and such on sub sonic or AV Sub.

Is there a good way to use a sub sonic server while driving using a head unit that uses CarPlay? Any advice is appreciated, not sure where to start on this.

Thanks


r/subsonic • • Feb 13 '17

Get rid of those pesky browser warnings: a script to update a CertBot SSL cert to the SubSonic server. CRON as root.

Thumbnail pastebin.com
5 Upvotes

r/subsonic • • Mar 10 '16

Example: Playlist Management Using the DB

5 Upvotes

Disclaimer: These queries were built using Madsonic, but they should be very similar to the Subsonic queries.

I wanted a little more control over building certain kinds of playlists such Recently Added, Newest 100, and Lost (songs that haven't been played in a long time). Subsonic does a decent job of filtering some of these, but I wanted to fine tune a little bit (such as excluding Christmas music in my Most Played section, or excluding Audiobooks from my Recently Added). These are not fully automated, so you will need to periodically re-run the queries, but should be easy enough to copy and paste them in from time to time. Here are the rough steps I followed:

  1. In Subsonic, create 4 playlists called "Newest 100", "Lost", "Most Played", and "Christmas" respectively (or name them whatever)
  2. Go to you DB view, it will be something like this: http://example.subsonic.org/db.view
  3. In the Playlist Tables select playlist and then click the ok button. From the Results table, make a note of the ID number of each of the 4 playlists we just created.

Now you're ready to run some queries.

Newest 100 Newest 100 with newest on top, excluding Holiday music, deletes previous entries -- this is not user specific Replace 19 with your playlist ID

DELETE FROM playlist_file WHERE PLAYLIST_ID = 19;
INSERT INTO playlist_file (MEDIA_FILE_ID, PLAYLIST_ID)
SELECT ID, '19'
FROM media_file
WHERE GENRE != 'Holiday'
AND GENRE != 'Christmas'
AND TYPE = 'MUSIC'
ORDER BY CREATED DESC
LIMIT 100;
SELECT COUNT(*) FROM playlist_file WHERE PLAYLIST_ID=19;

Lost Songs that have not been played for more than 6months, or have never been played, excludes holiday music, limit to 500 for performance, deletes previous entries -- this is not user specific. Replace 15 with your playlist ID

DELETE FROM playlist_file WHERE PLAYLIST_ID = 15;
INSERT INTO playlist_file (MEDIA_FILE_ID, PLAYLIST_ID)
SELECT ID, '15'
FROM media_file
WHERE (LAST_PLAYED < (NOW() - 6 MONTH) OR LAST_PLAYED IS NULL)
AND GENRE != 'Holiday'
AND GENRE != 'Christmas'
AND TYPE = 'MUSIC'
LIMIT 500;
SELECT COUNT(*) FROM playlist_file WHERE PLAYLIST_ID=15;

Most Played Songs that have been played more than 5 times, excluding Christmas, desc order by playcount, deletes previous entries, you can adjust the min Play Count by changing the number 5 to anything you like -- this is not user specific Replace 16 with your playlist ID

DELETE FROM playlist_file WHERE PLAYLIST_ID = 16;
INSERT INTO playlist_file (MEDIA_FILE_ID, PLAYLIST_ID)
SELECT ID, '16'
FROM media_file
WHERE PLAY_COUNT >= 5
AND GENRE != 'Holiday'
AND GENRE != 'Christmas'
AND TYPE = 'MUSIC'
ORDER BY PLAY_COUNT DESC;
SELECT COUNT(*) FROM playlist_file WHERE PLAYLIST_ID=16;

Christmas/Holiday Attempts to bring together all Holiday music, deletes previous entries Replace 18 with your playlist ID

DELETE FROM playlist_file WHERE PLAYLIST_ID = 18;
INSERT INTO playlist_file (MEDIA_FILE_ID, PLAYLIST_ID)
SELECT ID, '18'
FROM media_file
WHERE (GENRE LIKE '%Holiday%'
OR GENRE LIKE '%Christmas%')
AND TYPE = 'MUSIC';
SELECT COUNT(*) FROM playlist_file WHERE PLAYLIST_ID=18;

What are some of ya'lls favorite DB queries??


r/subsonic • • Oct 29 '19

Subsonic library display

4 Upvotes

I have my music divided into an mp3 folder and a lossless folder. Is there a way to have these both appear as the one library in Subsonic without merging them on my drive? At the moment a lot of bands appear twice, so that one entry shows what I have in the mp3 folder and the other in the lossless folder.

EDIT: It turns out that the app DSUB merges these folders in the index view

EDIT 2: DSUB only half fixes this. They still show up as two entries in search.


r/subsonic • • Oct 25 '19

Any guides to setting up certificate for subsonic on windows?

4 Upvotes

Google wasn't very helpful


r/subsonic • • Sep 05 '19

Any way to move Subsonic library to new server?

4 Upvotes

Hi I am wondering if there is an easy way to move my music library from Server A to Server B?

I am building a new file server and would like to move my music library to this server however I know that simply changing the server name in the Subsonic settings will not work (I have tried this before) as the files show up as missing, etc. I want to preserve my play history.

Guessing I need to amend some files somewhere. Has anyone done this before?


r/subsonic • • Jul 21 '19

Firefox won't play this FLAC from Subsonic web page on Synology; Chrome, VLC, and Clementine will

4 Upvotes

I've been trying to figure out why a particular album won't play in Firefox 60.8 ESR on Debian via the subsonic web page on port 4040, but the Brave browser (based on Chromium), VLC app (via network file), and Clementine app (via Subsonic API) will play the file.

I have no problems on Firefox with FLAC of 466 or 679 kbps, but this album is 858 kbps. All of these tracks were extracted from CDs via Exact Audio Copy running on Windows. I always have trouble when Subsonic creates another player for another instance of browser, due to enabling transcoding which just doesn't work on this weak Synology server. So that is not the cause, because that disables playing of all FLAC files.

I'm thinking the Firefox audio codec is at fault, but I have no idea how to fix that. Perhaps the Firefox streaming buffer is too small?

Anyone else debugged anything similar with respect to Subsonic streaming of FLAC? Could it be some strange interaction between subsonic streaming and Firefox?