I lost admin privileges!

[Rinaldus]

I don't know why but my admin account on Subsonic lost its admin privileges. I can't neither add users nor change transcode settings. How can I fix it through editing database?

[jserum]

I had the same issue just now. On my Windows box I stopped the Subsonic service and edited the C:\Subsonic\db\subsonic.script. My username was 'admin' so I added this line near the other similar lines:

Code: Select all

INSERT INTO USER_ROLE VALUES('admin',1)

I did have an issue saving the file. I had to save it as another file name in the same directory, rename the old and then rename the new file to match the old.

After I restarted the service I had admin privileges again.

Hope this helps.