fatg3erman / rompr Goto Github PK

I secured the site with .htacces with basic auth. When I open Rompr I enter the creds and open the site. Everything works except the downloaded podcasts. I am guessing that it is trying to stream from the server then fails, because the site is hardened with .htaccess.

The original remote streams work fine no problem.

This is what I get

MPD Clearing Player Error Failed to decode http://xx.xx.xx.xx/rompr/prefs/podcasts/248/18784/format=VBR+MP3&ignore=x.mp3; CURL failed: The requested URL returned error: 401 Unauthorized

AuthType Basic
AuthName "Password Protected Area"
AuthUserFile /var/.pass/.htpasswd
Require valid-user

 <Limit GET POST>
 require user USERNAME
 </Limit>

As a user I guess I am fine with it if there is no solution ((prefer security over convenience). I will just listen the stream version, and download for archiving.

I thought I would point it out.

I have been trying to remove some tracks from some reatings but I cant seem to find a way. I tried toggling the stars which did not work, I do not see delete button, I tried dragging them out of their rating pane, that did not work either.

There can be cases where the user might want to reconsider track ratings. I think persoanly think that toggling the current star rating would do it, but you probably will have a better idea if you want to implement it.

Hi

It seems like if there are couple hundreds songs in the playlist, these two skins get quite unresponsive on phones. I tried it them with FIrefox and Chromium on my phone, and both browsers got unresponsive such that pressing buttons were not doing anything. I do not get this issue with playlist with couple songs. I do not have this issue with the same playlists on desktop.

Not sure if it is a bug or a feature but I thought I would report it.

Hi

I have been testing the bleeding edge commits, and I think that something has changed the way album art is/can be added via the Albumart manager. I tried many albums covers, even ones that already have album art assigned and I am getting errors applying it. This was working fine before but when I do not know. It must be a change in recent commits.

Lets say I have an album that has a local cover art that I can see in the Albumart manager, I click on the image (it is listed there already), but when I click on it, the thumbnail turns to generic CD back with "image not found" written on it. And this is the log I get from the log.

21:35:19 :    26089 : GETALBUMCOVER       ------- Searching For Album Art --------
21:35:19 :    26089 :  key                 efe6c6d32b5cac3fc5deafbac955f67d
21:35:19 :    26089 :  artist              
21:35:19 :    26089 :  album               
21:35:19 :    26089 :  imgkey              efe6c6d32b5cac3fc5deafbac955f67d
21:35:19 :    26089 :  source              http://192.168.1.100/rompr/prefs/temp/81f96c24e0bea7f80764ceb45f168af2
21:35:19 :    26089 : GETALBUMCOVER       Found album Cloneo in collection
21:35:19 :    26089 : URL_DOWNLOADER      Downloading http://192.168.1.100/rompr/prefs/temp/81f96c24e0bea7f80764ceb45f168af2 to prefs/temp/efe6c6d32b5cac3fc5deafbac955f67d
21:35:19 :    26089 : URL_DOWNLOADER        ..  Download Failed With Status Code 401
21:35:19 :    26089 : GETALBUMCOVER       No art was found. Try the Tate Modern
21:35:19 :    26089 : GETALBUMCOVER       --------------------------------------------

My server has not changed at all, and I just made sure that my music is 777.

Hi

These are couple issue that I think that can improve the radio experience. Rompr already seems to have some good ideas for radio listening, but ironing out these issues can even make it better.

• http://radio-browser.info/ integration

• Caterories for the Icecast directory

• Removing the station names from the artist or the song or the albums when submitting the current track to the online databases. It seems like some radio names are appended to one of the fields, which naturally makes it impossible to locate the proper media information

• Random radio mode for the personalized radio tab, which pulls from the radio tab.

• Being able to star the currently playing song/artists. Now this is probably sticky situation because at the moment if one stars a playing track from a radio, it is going to star the radio station not the actual media, I am not sure if this is possible but it would be nice. It can even be better to track a separate star field for the stuff from online sources.

These are not my demands or something. I am just bring them up in case the dev or future devs might have interest in these to implement them.

thanks

HI

Thanks for integrating radio-browser. It seems to be natural fit for RompR.

It would be very nice if there is a way to add all search results to the current playlist at once.

Add anything to the Queue with CD Player Mode On. Consume is enabled. Doesn't make sense, was this a design decision?

It would be very useful to see the name of the current player somewhere in the interface in a visible. If possible it is even better to have that in all skins.

thanks

Running the latest rompr on raspbian, it renders fine in chrome and firefox but none of the windows browsers (edge, internet explorer on win 10, IE11 on win 2008)

I get this when I try to add/click/doubleclick/dragndroptoplaylist in the interface. The kind of choice does not seem to matter.

"Player Error: {add} directory or file not found"

I tried it with many Mopidy sources like Dlna/LocalMedia/BeetsServer etc with the same result. However If I enter an erroring folder and just click on a song it just plays. I am not sure if this is a limitation with the Mopidy source.

thanks

Tested with MPD so far. Click the X, the track does get removed from the database but the display doesn't update.

This is because I stopped doing this in the returninfo section. Need to make the UI do it.

Testing to see what happens

HI

I can`t be sure about this but I think that Rompr is not using MusicbrainzID to get info from the MB site.

Here is an example, I played track 7 from it but it was not able to pull any info in the MB tab. The tracks have all the neccessary MB ids created by Picard.

https://musicbrainz.org:443/release/248670a2-2f06-4203-b90f-27635d43a389

I get

"Could not find this artist on Musicbrainz"
"Could not find this album on Musicbrainz"

From the metadata

artist id :9a4bb654-35c5-4c88-8460-39d5bb01aa57; 22872b62-5faa-43f3-8a45-f4386385af1d; 3a9f0e21-5796-4f04-bd4c-3deafd59ad80

racording id: c43eb169-b9e4-4c4d-851f-ae6e5e9cc77f

release id: 248670a2-2f06-4203-b90f-27635d43a389

As title

Hi

I was testing the Itunes search result fix. I am able to subscribe to some but not some others when I tried some searches. Here is one that does not subscribe with error.

It seems to me that the xml exists, so the subscription should happen but it throws and error. I am not sure if this is an issue with Rompr or something about the podcast , maybe I just hit an edge case when testing it.

Searching iTunes for podcasts 'acik%20gazete'
00:04:14 :     6744 : URL_DOWNLOADER      Downloading https://itunes.apple.com/search?term=acik%20gazete&entity=podcast
00:04:15 :     6744 : URL_DOWNLOADER        ..  Download Success
00:04:15 :     6744 : PODCASTS            Search found podcast : Açık Gazete
00:04:16 :     6744 : PODCASTS            Refreshing podcast 319
00:04:16 :     6744 : PODCASTS              Podcast title is Açık Gazete
00:04:16 :     6744 : URL_DOWNLOADER      Downloading http://acikradyo.com.tr/i/rss/Acik_Gazete.xml
00:04:17 :     6744 : URL_DOWNLOADER        ..  Download Success
00:04:17 :     6744 : PODCASTS            Image is http://acikradyo.com.tr/sites/default/files/acikradyo_600X600.jpeg
00:04:17 :     6744 : PODCASTS              Category is News & Politics
00:04:17 :     6744 : PODCASTS            Error 8 A non well formed numeric value encountered in /var/www/rompr/includes/podcastfunctions.php at line 175

Fikret Kızılok = Dünden Bugüne shown as

See the image

Hi

It looks like the Google api slots in the preferences window is missing from the dev branch. The Lastfm one is there but I am not seeing the Google stuff there.

I keep getting 500 internal server error when I try to post anything on the forum. I am really not sure why that is the case, in case you are not aware I am posting it as a bug.

Hi

I am puzzled about this situation. My playlist in the .m3u file does not have dashes, and Mpd does not show the dashes either (in ncmpcpp) but Rompr is showing with dashes

That playlist had dashes before but I edited them out, so they do not look ugly, somehow they survive in Rompr :( Those dashes are still there when added to the current play queue but not in ncmpcpp after added by Rompr :)

The issue is that Rompr shows them with dashes in the song details at the top which I assume also submits to the online queries that way like below

GETALBUMCOVER Trying Google for - 100% Jazz

from .m3u file

#EXTM3U
#EXTINF:0,DeepTechnoFM
http://centauri.shoutca.st:8154
#EXTINF:0,Proton Radio
http://protonradio.com:8000/schedule

from ncmpcpp playlist editor

from ncmpcpp play window details (no dashes)

from Rompr load playlist window (expanded the playlist)

from Rompr play window (dashes are there)

Hi

I imported my podcasts successfully, that part of the podcast stuff feels very functionl. And I started listening some podcasts. One thing that seems to be a bug is that if I draw and drop an episode from a podcast(my imports) into the queue it replaces the queue, so in that repsect it does not seem possible to stack podcast episodes in the queue like the way we can do with regular music stuff.

I am using Cd mode, and both tried single and double click choices. Using the non Cd mode makes stacking episodes, possible.

thanks

It would be nice if the source profile switching is exposed in one of the main menus especially in the mobile uis, instead of going through the preferences. For instance we could have additional icons for each of the Mpd/Mopidy instances under the vertical hamburger menu button thing, with some randomized colors or numbers to differentiate them. That list can be a bit longer with additional stuff like this.

Also it would be nice to have an indidication of the current profile somewhere in the browser.

thanks

Show some kind of icon/name where the starred song from when it was starrred, is it local, is it online radio, name of the radio maybe, date ? I think this can help for relocating the song, and can be like a bit of listening journal thing, see when and how all those stars and wishlist originated.

Hi

This is a feature that I am stealing from Yatse Android app.

In Yatse if you change the player, Yatse asks you if you also want to move the current playlist to the new player therefor, lets you resume your playlist in the new player. I feel like this can be beneficial to the users even if they are using a multiroom setup or not. For instance the user can keep the playlist for the player set for mobile streaming on the go, come home keep listening at home etc.

The resuming of the songs can be tricky I guess depending on the player, but regardless keeping the playlists can be useful

I search for "art" on Itunes podcasts, it returns no visible results but this is what I see in the log

01:52:28 : 31956 : PODCASTS Search found podcast : KUT » Two Guys on Your Head
01:52:28 : 31956 : PODCASTS Search found podcast : State of the Arts
01:52:28 : 31956 : PODCASTS Search found podcast : Philosophy for our times
01:52:28 : 31956 : PODCASTS Search found podcast : PRI: Arts and Entertainment
01:52:28 : 31956 : PODCASTS Search found podcast : San Francisco Chronicle Arts & Entertainment - Spoken Edition
01:52:28 : 31956 : PODCASTS Search found podcast : My Baby Monsters: kids stories, children music, children's books, kid art, & fun storytelling - old time radio movie - podcas
01:52:28 : 31956 : PODCASTS Search found podcast : Dialogues | A podcast from David Zwirner about art, artists, and the creative process
01:52:28 : 31956 : PODCASTS Search found podcast : The Art of Catholic with Matthew Leonard
01:52:28 : 31956 : PODCASTS Search found podcast : The Art of War by Sun Tzu
01:52:28 : 31956 : PODCASTS Search found podcast : Baking & Pastry
01:52:28 : 31956 : PODCASTS Search found podcast : Art Ed Radio
01:52:28 : 31956 : PODCASTS Search found podcast : Art of the Score
01:52:28 : 31956 : PODCASTS Search found podcast : Everyday Ethics
01:52:28 : 31956 : PODCASTS Search found podcast : History of Art
01:52:28 : 31956 : PODCASTS Error 2 DOMDocument::loadHTML(): htmlParseEntityRef: expecting ';' in Entity, line: 2 in var/www/rompr/utils/phpQuery.php at line 327

Hi

Would it be possible to make sure that if all remote services are running over ssl if they were to provide it over https?

For instance I see that some lastfm stuff is done voer http://ws.audioscrobbler.com/ and there seems to be a https version for it.

Musicbrainz lookups are done over http as well " http://musicbrainz.org/ws/2/recording/b2a8675c-cf52-48f3-9f06-08abc5b97f5....."

thanks

Hi

Would not be nice if one can see the number of songs in a given star/wishlish without needing to enter into the section and counting them manually?

I propose that the numbers just shown on the same lines as the stars.

Hi,

Now that we have a much nicer podcast management, I propose that it will be super useful to have a way to mass update and mark all seen to the podcast tab. I set the refresh freq to daily but sometimes a user wants to see if the podcasts have gotten an update before the update freq so the user might want to do a manual refresh on all the podcasts. I think it is a bit tedious to do this one by one.

The other issue is that the user should be able to set all podcast as seen/listened (though I do not want to call listened, because issue at satake is not listening) all at once to make the podcast list clean. The only ways is doing through the Mysql stuff, and like you stated that is not a safe way either.

thanks

Hi

I was trying to figure out why my podcasts were no updating, then I went into settings and I saw that all were set to manual. This can be a hassle like people like me with hundreds of podcasts, I mean trying to edit all this stuff afterwards. It would be nice if there is a way to set a general update frequency that can be applied to all podcasts during import so at least one can choose a rough refresh time for all.

Maybe there is a way to set a cron job? I do not mind doing this through my system's cron.

Hi,

One thing that is a minor annoyance is that the playlist position is reset to the top when the play queue is filled with online radio stations.

Clear your queue
Add a new playlist to the queue that has many online radios
Start the first station
Scroll to the bottom of the list
Click on the last item to play
The the current position is reset and you are back to the top of the queue.

I use (on Desktop)
Mpd
Darkness
Auto-scroll to playlist current track
Double Click to add, Click to select

Hi

At the moment, if an album is missing a cover, it still shows the cover of the last song that had a real cover, which is very very confusing, at least that is how it looks to me.

It would be so nice if one can define a custom cover for missing covers.

Thanks

@fatg3erman

The new podcast import combination with Mpd makes Rompr the best podcast server to me. I do not think if such server exists really. It is just great and new level in podcast litstening, at least so far.

I am wondering what you would think about providing couple extra features. I can list all here or I can open new reports. But one of the thing that can help with dealing with multiple podcasts/episodes is some kind of addiitonal flat list display of episodes that is sorted by the latest episodes at top. That way one could see the latest episodes or lately uploaded first at the top, and this list provides new episodes.

If such display is not possible, then I would propose that the podcast list can be sorted by the latest updates. So lets say any podcast that has updates today will be put at the top of the podcasts sesction, so the listener will know what got updated today.

I am not sure if this functionality exists or not but when I drag and drop songs from my ratings list (ones exists in my library already) to the current playlist, all it does is a "incoming" message in the playlist. No songs can be added it seems.

If this is not an existing functionalty, it would be nice if one could add liked songs from the ratings list to the current playlist.

Empty your queue

Open the ratings and tags window

Expand one of the stars ratings

Drag and drop a song (while pressing on the title) to the current playlist queue

On the other hand dragging and dropping track from the "Top 40" window seems to work.

EDIT:
I was dragging the album names, that does work. If I press on the actual rated track title and drop that one, it works

thanks

Hi

Somehow I am unable to post to the forum, so I am going to ask this one here. I will try not to use github issues as a forum, but until I find out why qitq is broken for me (must be a firewall kind of thing) I need to spot an answer for this.

Does Rompr use the local images automatically if present (cover.jpg) at all? Because when I browse the album cover browser, it shows me some albums that both has local cover and also has embed cover in them. So I am thinking that it is not using it? Weird thing is that, I can load those covers from the local images tab, so images are not missing as far as I can tell.

If it is not using them, is it possible to provide a cover art server that Rompr can try using? For instance Mopidy can already serve cover arts , also I am running a Lightttp server on my server for my covers arts to couple Mpd clients like Malp. It works well and I definetely prefer that Rompr uses my cover arts before going out its own way.

I have gone through huge trouble to add as much cover art (and some are my own covers) as possible and I would like to avoid redoing this work in Rompr. I know I can select local images in the cover browser, but in reality Rompr says , "9402 albums, 4815 albums without a cover" As you can see this is soo much work for me :(

See this page for how Mpd cover art tricks work if you have not came across.

https://github.com/abarisain/dmix/wiki/Album-Art-on-your-LAN

thanks

Hi

Here is a case where Rompr does not seem to locate the info properly from Music brainz. I am using Rompr with MPD here. I believe Picard tagged it properly (as seen in the screenshot) The Release ID seems to be consistent across.

Here is the MB page
https://musicbrainz.org/release/59734c31-c349-4daa-aa23-41c635561652

I tried to install the latest rompr version onto the latest Raspian, with MYSQL, following the linux instructions. The setup page failed with "BADGERS", and that a table .... ERROR 1214 (HY000): The used table type doesn't support FULLTEXT indexes
I changed the Engine param for all tables in specifics.php in the mysql folder from Innodb to MyISAM and reloaded the page. This cured the problem.

Server version: 5.5.60-0+deb8u1 (Raspbian)
PHP 5.6.36-0+deb8u1 (cli) (built: Jun 26 2018 22:52:39)

Not sure if this is the correct way to raise a bug/solution for a particuar Os/MySQL version

thanks

I am sorry but I have to ask for this :)

This is most podcast apps can provide. Basically, when you stop playing an episode from a podcast, the player keeps the resume state (some can even do this when the episode is streamed), so next time you start playing it (unless you do not want that), it will remember where it was stopped and it will resume from that time code.

thanks

Since I enabled logging, Rompry was littering apache error.log with these messages like this, it went up to 25gb in one day. ANd while this is happening apache2 was going nuts with using cpu at %100 (one of the 4 cores)

I was mostly using Mopidy since yesterday.

player/mpd/connection.php on line 88, referer: http://192.168.1.100;gc/rompr/
[Thu Jun 14 10:31:05.996923 2018] [php7:warn] [pid 21778] [client 192.168.1.105:38516] PHP Warning:  fgets() expects parameter 1 to be resource, boolean given in /media/DRIVE/var/www/rompr/player/mpd/sockets.php on line 43, referer: http://192.168.1.100;gc/rompr/
[Thu Jun 14 10:31:05.996931 2018] [php7:warn] [pid 21778] [client 192.168.1.105:38516] PHP Warning:  feof() expects parameter 1 to be resource, boolean given in /media/DRIVE/var/www/rompr/player/mpd/connection.php on line 88, referer: http://192.168.1.100;gc/rompr/
[Thu Jun 14 10:31:05.996938 2018] [php7:warn] [pid 21778] [client 192.168.1.105:38516] PHP Warning:  fgets() expects parameter 1 to be resource, boolean given in /media/DRIVE/var/www/rompr/player/mpd/sockets.php on line 43, referer: http://192.168.1.100;gc/rompr/
[Thu Jun 14 10:31:05.996945 2018] [php7:warn] [pid 21778] [client 192.168.1.105:38516] PHP Warning:  feof() expects parameter 1 to be resource, boolean given in /media/DRIVE/var/www/rompr/player/mpd/connection.php on line 88, referer: http://192.168.1.100;gc/rompr/
[Thu Jun 14 10:31:05.996952 2018] [php7:warn] [pid 21778] [client 192.168.1.105:38516] PHP Warning:  fgets() expects parameter 1 to be resource, boolean given in /media/DRIVE/var/www/rompr/player/mpd/sockets.php on line 43, referer: http://192.168.1.100;gc/rompr/
[Thu Jun 14 10:31:05.996959 2018] [php7:warn] [pid 21778] [client 192.168.1.105:38516] PHP Warning:  feof() expects parameter 1 to be resource, boolean given in /media/DRIVE/var/www/rompr/player/mpd/connection.php on line 88, referer: http://192.168.1.100;gc/rompr/
[Thu Jun 14 10:31:05.996966 2018] [php7:warn] [pid 21778] [client 192.168.1.105:38516] PHP Warning:  fgets() expects parameter 1 to be resource, boolean given in /media/DRIVE/var/www/rompr/player/mpd/sockets.php on line 43, referer: http://192.168.1.100;gc/rompr/
[Thu Jun 14 10:31:05.996973 2018] [php7:warn] [pid 21778] [client 192.168.1.105:38516] PHP Warning:  feof() expects parameter 1 to be resource, boolean given in /media/DRIVE/var/www/rompr/player/mpd/connection.php on line 88, referer: http://192.168.1.100;gc/rompr/
[Thu Jun 14 10:31:05.996980 2018] [php7:warn] [pid 21778] [client 192.168.1.105:38516] PHP Warning:  fgets() expects parameter 1 to be resource, boolean given in /media/DRIVE/var/www/rompr/player/mpd/sockets.php on line 43, referer: http://192.168.1.100;gc/rompr/
[Thu Jun 14 10:31:05.996987 2018] [php7:warn] [pid 21778] [client 192.168.1.105:38516] PHP Warning:  feof() expects parameter 1 to be resource, boolean given in /media/DRIVE/var/www/rompr/player/mpd/connection.php on line 88, referer: http://192.168.1.100;gc/rompr/
[Thu Jun 14 10:31:05.996994 2018] [php7:warn] [pid 21778] [client 192.168.1.105:38516] PHP Warning:  fgets() expects parameter 1 to be resource, boolean given in /media/DRIVE/var/www/rompr/player/mpd/sockets.php on line 43, referer: http://192.168.1.100;gc/rompr/
[Thu Jun 14 10:31:05.997027 2018] [php7:error] [pid 21778] [client 192.168.1.105:38516] PHP Fatal error:  Maximum execution time of 800 seconds exceeded in /media/DRIVE/var/www/rompr/player/mpd/sockets.php on line 43, referer: http://192.168.1.100;gc/rompr/

If CD Player Mode is on, clicking on a track in one of the saved playlists will play the album that track was from. It should play the playlist beginning from that point.

I am guessing this is an issue with imports, I never used the regular podcast adding way.

I manually went through all my podcasts and mark them as listened (using the headphones icon), then I used the sql command UPDATE PodcastTracktable SET Listened = 1; to make sure even the new ones are tagged as listened. After overnight (set to daily update), now all the podcasts with hundreds of episodes are all shown as unlistened.

Hi,

I am not sure if this is an issue with Mpd or Rompr.

The podcast playing seem to be distrupted if the podcast has been paused for sometime. For instance, start playing an episode for a while, then somewhere in the middle pause the playing. Wait about 20 mins then resume the play, the podcast plays for couple minutes then stops/resets play.

I am able to repeat this issue many times, so I thought maybe it is time to bug about it.

I am using Rompr (Debian Testing) with Mpd (Debian Testing).

thanks

If I add a series of http stream into the playlist, and try jump to next song by pressing the next track buttom, I got bad song index error.

Tablet-Darkness-ModernLight-Nunito, the vertical burger icon drop down menu shows nothing. I only see a smal black box when I press on it. I am using Chromium (also tested waterfox) on Android.

The actual "Phone" skin works. It seems to be a Tablet skin thing on 1.16 This was fine prior.

Play a track at the end of the queue. Let it finish. Album cover and now playing info fade out. Start playing same track again, nothing fades back in.

Hi

One thing that might make sense to display the icons of the web services that actually return something that way the user will know what to click, at the the moment, I just click from left to right to see what came up. And sometimes half of those services cant return something.

Would not make sense to maybe turn the icons of the empy/non existing searches to gray or hide them? That way the user wont go for clicking to that service that returns nothing, unless wants to checxk it out anyways.

http://radio-browser.info/

HI

It would be very nice if we could import .opml(standard format for podcast apps) for podcasts and .m3u for the radio stations. At the moment one has to build whole library of podcasts and radio stations that one might have been using in other apps from scratch in Rompr.

Importing radios is no big problem because one can just use with the existing Mpd/Mopidy setup with a simple playlist. But .opml support would be very nice because then I can bring my whole podcast stations library to Rompr. I have almost hundreds of podcast stations subscribed as you can guess this is aan hassle for people like me.

Thanks

HI

One issue I have with online database queries is that the album artists with multiple artists return nothing. By the nature of query, this makes sense but it would be nice if we could find a better way to get this going.

Lets say I have an album artist like "Sainkho Namtchylak & Ned Rothenberg", now for the most web services this returns nothing. Ideally Rompr could search for Sainko and Ned separately and somehow display them separately?

Even the Wikipeda one is a bit better because it returns results for the first artist in the query.

thanks

What Mpc says (Mpd 0.20.20)
Artists: 11700
Albums: 7700
Songs: 78200

What Rompr says (1.15.5)
3300 artists
54800 tracks
6700 albums

Music Player Daemon 0.20.20

Database plugins:
 simple proxy upnp

Storage plugins:
 local smbclient nfs curl

Neighbor plugins:
 smbclient upnp

Decoders plugins:
 [mad] mp3 mp2
 [mpg123] mp3
 [vorbis] ogg oga
 [oggflac] ogg oga
 [flac] flac
 [opus] opus ogg oga
 [sndfile] wav aiff aif au snd paf iff svx sf voc w64 pvf xi htk caf sd2
 [audiofile] wav au aiff aif
 [dsdiff] dff
 [dsf] dsf
 [faad] aac
 [mpcdec] mpc
 [wavpack] wv
 [modplug] 669 amf ams dbm dfm dsm far it med mdl mod mtm mt2 okt s3m stm ult umx xm
 [mikmod] amf dsm far gdm imf it med mod mtm s3m stm stx ult uni xm
 [wildmidi] mid
 [fluidsynth] mid
 [adplug] amd d00 hsc laa rad raw sa2
 [ffmpeg] 16sv 3g2 3gp 4xm 8svx aa3 aac ac3 adx afc aif aifc aiff al alaw amr anim apc ape asf atrac au aud avi avm2 avs bap bfi c93 cak cin cmv cpk daud dct divx dts dv dvd dxa eac3 film flac flc fli fll flx flv g726 gsm gxf iss m1v m2v m2t m2ts m4a m4b m4v mad mj2 mjpeg mjpg mka mkv mlp mm mmf mov mp+ mp1 mp2 mp3 mp4 mpc mpeg mpg mpga mpp mpu mve mvi mxf nc nsv nut nuv oga ogm ogv ogx oma ogg omg opus psp pva qcp qt r3d ra ram rl2 rm rmvb roq rpl rvc shn smk snd sol son spx str swf tak tgi tgq tgv thp ts tsp tta xa xvid uv uv2 vb vid vob voc vp6 vmd wav webm wma wmv wsaud wsvga wv wve
 [gme] ay gbs gym hes kss nsf nsfe sap spc vgm vgz

I was trying to log stuff for the rating and starring online radios but I saw this error there too, while trying to use search from Mopidy. It might be a totally separate issue or a none issue but I thought I should log it here.

The issue also happenign here with Mopidy (after started using sqllite backend for Mopidy), the search never ends in Rompr :( So this log you see here is happening around that time frame.

                   MYSQL Error:  : 1005 : Can't create table `romprdb`.`Croft` (errno: 135 "No more room in record file")
00:50:43 :    29834 : SQL_QUERY           Command Failed : CREATE TEMPORARY TABLE Cruft(Artistindex INT UNSIGNED NOT NULL UNIQUE, PRIMARY KEY(Artistindex)) AS SELECT Artistindex FROM Artisttable WHERE Artistindex NOT IN (SELECT Artistindex FROM Croft)
00:50:43 :    29834 : MYSQL                   MYSQL Error:  : 1146 : Table 'romprdb.Croft' doesn't exist
00:50:43 :    29834 : SQL_QUERY           Command Failed : DELETE Artisttable FROM Artisttable INNER JOIN Cruft ON Artisttable.Artistindex = Cruft.Artistindex
00:50:43 :    29834 : MYSQL                   MYSQL Error:  : 1146 : Table 'romprdb.Cruft' doesn't exist
00:50:43 :    29834 : BACKEND              -- Removing orphaned artists took 0.090620994567871 seconds
00:50:43 :    29834 : MYSQL               Tidying Metadata
00:50:43 :    29834 : SQL_QUERY           Command Failed : CREATE TEMPORARY TABLE used_tags AS SELECT DISTINCT Tagindex FROM TagListtable
00:50:43 :    29834 : MYSQL                   MYSQL Error:  : 1005 : Can't create table `romprdb`.`used_tags` (errno: 135 "No more room in record file")
00:50:43 :    29834 : SQL_QUERY           Command Failed : DELETE FROM Tagtable WHERE Tagindex NOT IN (SELECT Tagindex FROM used_tags)
00:50:43 :    29834 : MYSQL                   MYSQL Error:  : 1146 : Table 'romprdb.used_tags' doesn't exist
00:50:43 :    29834 : BACKEND              -- Tidying metadata took 0.0010831356048584 seconds

I can totally hear @fatg3erman screaming "nayn nayn, noooo, naaaaa", but please take a deep breath for a sec before crushing this bug to death.

One of the main issue with MPD based setups is that it is purely streaming, meaning that no offline stuff especially for the mobile users. Subsonic(and derivatives) have good mobile/desktop clients that offer various features, one of them is letting user download music.

I personally use Dsub just to download some songs to my phone/tablet before going out, because I do not have constant internet and sizable data connection is still expensive for me and many users around the world. The nice thing about Dsub is that (though not much updated) I can star/rate while offline, and they get synced to Airsonic server(Subsonic derivative) later.

Another nice thing about Dsub is that, it offers casting to Dlna/Upnp devices (like Kodi) which is very convenient, so one does not have to stream on Mpd and setup listening clients. It is a bit clunky because what plays music is different than what controls music and what streams the music (though powerful), though in some occasions Rompr offers nice controls.

By offering a Subsonic API compatible API, one might be able to use all those clients with Rompr against Mpd/Mopidy.

I like the mobile Rompr interface it is as good as it gets, though still can use some optimisation on the cpu side. But it does not offer offline content. So that is one of the reason I am opening this feature.

If the dev(s) plan to implement this in like 1.000.000 years which is not bad of a wait time, please take a look at Ampache, it offers a decent compatible API that I used to use. Maybe it can give you an idea to see what it takes to implement, or see the positive sides of having it.

I realize maybe this is an impossible thing to do given that Mpd does not offer downloads itself, but Ampache does with ffmpeg transcoding I think.

https://github.com/ampache/ampache/wiki/API#subsonic-api