I’m looking at the steps to take to create a development copy of a busy Discourse site that can be used for training and testing by administrators but which won’t send any emails to non-administrators. Am I correct in understanding that if all non-administrators are suspended then this would have the result I’m after? And if this would work can anyone point me in the right direction for how to do this using the rails console?

To sum up the above in case anyone else ever wants to do this, to disable all non-admin users: ./launcher enter app su - postgres psql \c discourse UPDATE users SET silenced_till='3019-02-01 13:00:00', suspended_till='3019-02-01 13:00:00' WHERE admin='f'; \q exit exit

You could do something like: UPDATE users SET silenced_till = '3019-02-01 13:00:00,' SET suspended_till = '3019-02-01 13:00:00' WHERE RETURNING id, username_lower

[image] slackmoehrle: You could do something like: UPDATE users Thanks, I don’t have a huge amount of experience of using the rails console so I’m afraid I didn’t get past that first line: [1] pry(main)> UPDATE users NameError: undefined local variable or method `users' for main:Object Did you mean? user_mask from (pry):1:in `__pry__' Any suggestions? For the criteria would it be something like this to only edit non-admins? WHERE not(admin: true) [image] pfaffman: There is a site setting that will disable mail for non admins. Another thing that I do is to just configure the site with invalid email credentials. Yes, I have used the option to disable all outgoing emails in the past but the plan for this site is to have a test version of a site that can send out and receive emails but only admins can use it.

[image] chrisc: Thanks, I don’t have a huge amount of experience of using the rails console That is a SQL statement, you need to use psql. If you are not familiar with SQL, please exercise caution as you can really hose your setup. Your steps would be something like: cd /var/discourse ./launcher enter app sudo postgres psql \c discourse now execute SQL \q when done

[image] chrisc: the plan for this site is to have a test version of a site that can send out and receive emails but only admins can use it. Perhaps you missed that there is a new “staff only” setting for “disable emails”.

Cheers, I know my way around MySQL… [image] slackmoehrle: sudo postgres FWIW that should be: su - postgres Or: sudo -iu postgres So I worked out how to select admin users: discourse=# SELECT FROM users WHERE admin='t'; -- (6 rows) And then tried: discourse=# UPDATE users discourse-# SET silenced_till = '3019-02-01 13:00:00,' discourse-# SET suspended_till = '3019-02-01 13:00:00' discourse-# WHERE admin='f' discourse-# RETURNING id, username_lower; ERROR: syntax error at or near "SET" LINE 3: SET suspended_till = '3019-02-01 13:00:00' ^ However this works: discourse=# UPDATE users discourse-# SET silenced_till = '3019-02-01 13:00:00', suspended_till = '3019-02-01 13:00:00' discourse-# WHERE admin='f' discourse-# RETURNING id, username_lower; Thanks for your help with this @slackmoehrle :slight_smile: . [image] pfaffman: Perhaps you missed that there is a new “staff only” setting for “disable emails”. Ahh! Yes, I had missed that, this is perfect, thanks.

Suspend all users apart from admin users for development copy

Product Support

pfaffman (Jay Pfaffman) April 3, 2019, 1:21pm 3

There is a site setting that will disable mail for non admins. Another thing that I do is to just configure the site with invalid email credentials.

Topic		Replies	Views
How to disable access without emailing user Product Support	8	879	April 12, 2021
Please eval short Ruby script to suspend inactive users Development	3	210	September 4, 2024
Bulk deactivate users with SQL query Product Support	1	796	May 31, 2018
Bulk suspend users based on criteria Product Support	17	3780	June 7, 2019
Edit a user preference for everyone or a subset of users Self-Hosting how-to	0	14315	February 12, 2015

Suspend all users apart from admin users for development copy

Related topics