Global settings to override individual user settings?

[mockingbrd]

Apologies if this has already been asked but I did try to search before posting.

I am rapidly approaching my ISP's bandwidth limit this month and want to temporarily disable everyone's ability to DL and also throttle their transcoding settings. The only way I know how to do that would be to go user-by-user and adjust their settings, which seems rather tedious. Is there any way to temporarily override settings for all users with some sort of global settings? Any info would be helpful, thanks!

[bushman4]

To remove their rights to download:

• First, make a list of people that CAN download. You will need this if you ever want to restore their ability to download... to do so:
  
  • Navigate to http://Your.Subsonic.IP.Address:Port/db.view
  • Enter the following command:
    

    Code: Select all

    select USERNAME from USER_ROLE where ROLE_ID=2

  • Copy and paste the resulting list into a text document to keep it for backup
• Run the following command to remove everyone's download rights (except the admin):
  

  Code: Select all

  Delete from USER_ROLE where ROLE_ID=2 and USERNAME<>'Admin'

To change everyone's max bit rate is a bit different...

• First you need to find out what value you need to enter into the TRANSCODING_SCHEME field... to do so:
  
  • First choose an account to test with. Set that account to the bitrate that you want to limit everyone to. For sample purposes let's say that account's name is "Bob."
  • On the db.view screen, type the following command:
    

    Code: Select all

    Select TRANSCODE_SCHEME from USER_SETTINGS where USERNAME='Bob'

  • Make a note of the value displayed... for example, a 128 kbps limit has the value of "MAX_128"
• Run the following command to limit everyone to that limit except the admin:
  

  Code: Select all

  Update USER_SETTINGS set TRANSCODING_SCHEME='ValueFromLastCommand' where USERNAME<>'Admin'

Hope this helps,

[GJ51]

You can also set limits on the Settings Advanced page. This is also where the Downsample string is located.

I also use a slightly different approach for managing users. I have two accounts that I hand out for users outside of my family. The first is a "Guest" account that is set up just for browse and listen priveleges. The Second is a "Visitor" account that has download privileges enabled. This makes it much easier to manage multiple users IMO.

YMMV

[mockingbrd]

Hate to bump such an old topic, but I just realized I never thanked you all for your helpful replies!