Subsonic Forum

Starting from an empty user database, is there a way to change the default user settings for all LDAP users that get created in Subsonic? For example when I click on the checkbox "User is allowed to download files" and hit save it tells me I am missing a username and password but I am using LDAP to create the new users automatically (In "Advanced") so just want this setting to be the default state.

This can be changed in the backend by inserting the appropriate user_role number into the database. In this case I'm adding each user the ability to download files (id=2)

Access the /db.view page from your domain

Enter the following commands into the text box:

1) delete from user_role where role_id = 2
2) Press "ok" then type
3) insert into user_role (username, role_id) select distinct(username), 2 from user_role
4) Press "ok"

All users will then have the ability to download files. Since new LDAP users will be continuously created over time, this procedure needs to be repeated regularly to keep the appropriate settings up to date.

This procedure can only be done if no music is playing on the server otherwise it will bring up an error in the third step.