Subsonic Forum

On the evening of April, 16th, while enjoying streaming from subsonic over sonos, the music abruptly stopped. I've not since succeeded in resolving the problem as I've detailed in this thread: viewtopic.php?f=2&t=15555

I now think I've discovered the reason but not sure how to fix it. Since I was getting no useful information from the web interface (aside from nothing happening when I hit play in the flash player), I figured I'd try the API. So I first used a rest call to browse my collection and identify a song ID and then made another call to stream.view using that song ID. This is what gets returned...

Code: Select all

<subsonic-response xmlns="http://subsonic.org/restapi" status="failed" version="1.12.0">
<error code="50" message="admin is not authorized to play files."/>
</subsonic-response>


So it appears that somehow on 4/16, my account lost streaming privileges. And also admin privileges, it seems. I believe there used to be an "settings" tab in the web interface but that is gone now. Strangely, most everything else seems normal, aside from not being able to actually stream anything.

I should point out that I personally installed subsonic on my home server to play my song files. And my premium subscription is good through June. My point is, if I'm not admin, who is? I've only ever granted one other person access, and that access was limited to streaming only.

Has anyone else seen this happen and/or have any suggestions for fixing? I have full access to the server where subsonic lives so should be able to do whatever is necessary to restore privileges. Really looking forward to getting this fixed. Thanks for any advice.

Looks like I was finally able to solve this problem. Here are the steps I followed:

(1) Stop Subsonic Service
(2) Open subsonic.script (in windows it is located within C:\subsonic\db)
(3) Look for this line:
INSERT INTO USER VALUES('username-for-account-with-lost-privileges',...) (rest of this line doesn't matter for our purposes)
In my case, my user name was 'admin'.
(4) Add these lines below the one identified above (replacing 'admin' with your actual user name) assuming they are not already there:
INSERT INTO USER_ROLE VALUES('admin',1)
INSERT INTO USER_ROLE VALUES('admin',2)
INSERT INTO USER_ROLE VALUES('admin',3)
INSERT INTO USER_ROLE VALUES('admin',4)
INSERT INTO USER_ROLE VALUES('admin',5)
INSERT INTO USER_ROLE VALUES('admin',6)
INSERT INTO USER_ROLE VALUES('admin',7)
INSERT INTO USER_ROLE VALUES('admin',8)
INSERT INTO USER_ROLE VALUES('admin',9)
INSERT INTO USER_ROLE VALUES('admin',10)
INSERT INTO USER_ROLE VALUES('admin',11)

(5) Save and close subsonic.script
(6) Restart the subsonic service

I now once again have both streaming (can actually play music) and admin (can access the settings) privileges.

I have no idea why suddenly on the evening of 4/16, my privileges got removed. Presumably, subsonic.script was somehow editid. Hopefully this is useful to someone else so they don't have to spend nearly a month without use of subsonic as I did.