# How to change a site setting via the Console
**URL:** https://meta.discourse.org/t/how-to-change-a-site-setting-via-the-console/32761
**Category:** Support
**Created:** [August 31, 2015, 9:29pm UTC](https://meta.discourse.org/t/how-to-change-a-site-setting-via-the-console/32761 "2015-08-31T21:29:26Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@cpradio](https://meta.discourse.org/u/cpradio)
#### Post date: [August 31, 2015, 9:29pm UTC](https://meta.discourse.org/t/how-to-change-a-site-setting-via-the-console/32761/1 "2015-08-31T21:29:26Z")
So while investigating
[https://meta.discourse.org/t/logout-menu-item/32731/21?u=cpradio](https://meta.discourse.org/t/logout-menu-item/32731/21)
I enabled SSO, then logged out (yikes!), and now I can’t log back in, as it wants me to use SSO to do so ☹
How can I disable the `enable_sso` site setting so I can get back into my local environment?
---
### Author:  [@zogstrip](https://meta.discourse.org/u/zogstrip)
#### Post date: [August 31, 2015, 9:31pm UTC](https://meta.discourse.org/t/how-to-change-a-site-setting-via-the-console/32761/2 "2015-08-31T21:31:06Z")
in your `/discourse`
```plaintext
bundle exec rails c
SiteSetting.enable_sso = false
```
😉
---
### Author:  [@cpradio](https://meta.discourse.org/u/cpradio)
#### Post date: [August 31, 2015, 9:33pm UTC](https://meta.discourse.org/t/how-to-change-a-site-setting-via-the-console/32761/3 "2015-08-31T21:33:34Z")
Ah, I did it a different route, but yours is easier. 😄
I ended up doing
```plaintext
s = SiteSetting.find_by(name: 'enable_sso')
s.value = 'f'
s.save!
```
I was just about to post that here and saw your response. Thanks! Now I can at least constantly get back to a good state between tests 😄 (or maybe I should setup an actual SSO…)
---
### Author:  [@fefrei](https://meta.discourse.org/u/fefrei)
#### Post date: [August 31, 2015, 9:42pm UTC](https://meta.discourse.org/t/how-to-change-a-site-setting-via-the-console/32761/4 "2015-08-31T21:42:34Z")
For future reference, visit `/u/admin-login`
---
### Author:  [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [August 31, 2015, 10:13pm UTC](https://meta.discourse.org/t/how-to-change-a-site-setting-via-the-console/32761/5 "2015-08-31T22:13:06Z")
Yeah just use `/users/admin-login`
---
### Author:  [@Svancara](https://meta.discourse.org/u/Svancara)
#### Post date: [September 2, 2015, 3:13pm UTC](https://meta.discourse.org/t/how-to-change-a-site-setting-via-the-console/32761/6 "2015-09-02T15:13:26Z")
I did
`SiteSetting.enable_sso = false`
But I ended up with this login form:
How can I log-in please?
---
### Author:  [@riking](https://meta.discourse.org/u/riking)
#### Post date: [September 2, 2015, 5:35pm UTC](https://meta.discourse.org/t/how-to-change-a-site-setting-via-the-console/32761/7 "2015-09-02T17:35:55Z")
Looks like you have no login methods available.
Do `SiteSetting.enable_local_logins = true` .
---
### Author:  [@Svancara](https://meta.discourse.org/u/Svancara)
#### Post date: [September 2, 2015, 5:48pm UTC](https://meta.discourse.org/t/how-to-change-a-site-setting-via-the-console/32761/8 "2015-09-02T17:48:41Z")
Yes!
Thank you very much!
---
### Author:  [@ewanly](https://meta.discourse.org/u/ewanly)
#### Post date: [October 19, 2016, 1:02pm UTC](https://meta.discourse.org/t/how-to-change-a-site-setting-via-the-console/32761/9 "2016-10-19T13:02:52Z")
After running : “bundle exec rails c”
I’m getting an error : “Could not locate Gemfile”
How to fix it?
---
### Author:  [@fefrei](https://meta.discourse.org/u/fefrei)
#### Post date: [October 19, 2016, 1:46pm UTC](https://meta.discourse.org/t/how-to-change-a-site-setting-via-the-console/32761/10 "2016-10-19T13:46:08Z")
Are you running this from inside your container (`./launcher enter app`)?
---
### Author:  [@ewanly](https://meta.discourse.org/u/ewanly)
#### Post date: [October 19, 2016, 1:52pm UTC](https://meta.discourse.org/t/how-to-change-a-site-setting-via-the-console/32761/11 "2016-10-19T13:52:46Z")
No I wasn’t 😊 since its wasn’t mentioned. Sorry a lot of things to learn yet 👽
---
### Author:  [@ewanly](https://meta.discourse.org/u/ewanly)
#### Post date: [October 19, 2016, 2:46pm UTC](https://meta.discourse.org/t/how-to-change-a-site-setting-via-the-console/32761/12 "2016-10-19T14:46:20Z")
So I did these commands:
```
cd /var/discourse
./launcher enter app
```
then
`bundle exec rails c`
and I’ve got the following errors:
> URGENT: FATAL: Peer authentication failed for user “discourse”
> Failed to initialize site default
> /var/www/discourse/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active\_record/connection\_adapters/postgresql\_adapter.rb:651:in `initialize': FATAL: Peer authentication failed for user "discourse" (PG::ConnectionBad) from /var/www/discourse/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:651:in `new’
> from /var/www/discourse/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active\_record/connection\_adapters/postgresql\_adapter.rb:651:in `connect’
> …
> … many folders list
> …
I did `./launcher rebuild app` and tried again. The same errors!
* * *
After I’d pissed of these problems. I did restored my droplet from a previous snapshot I had and started from scratch.
I did enabled FORCE\_HTTPS without a problem.
---
### Author:  [@Alavi1412](https://meta.discourse.org/u/Alavi1412)
#### Post date: [December 29, 2016, 4:03pm UTC](https://meta.discourse.org/t/how-to-change-a-site-setting-via-the-console/32761/14 "2016-12-29T16:03:05Z")
Can we change the discourse language in `bundle exec rails c` console?
How can we change the language of our site to english?
---
### Author:  [@Alavi1412](https://meta.discourse.org/u/Alavi1412)
#### Post date: [December 31, 2016, 7:45am UTC](https://meta.discourse.org/t/how-to-change-a-site-setting-via-the-console/32761/15 "2016-12-31T07:45:39Z")
changing language can be done in database in site\_settings column.
just search the current language and replace new language:
below code change language from Farsi to english:
`UPDATE site_setting SET value = 'en' where value = 'fa_IR'`
I have typed this code after typing : `rails db`
---
### Author:  [@metakermit](https://meta.discourse.org/u/metakermit)
#### Post date: [April 4, 2018, 12:36pm UTC](https://meta.discourse.org/t/how-to-change-a-site-setting-via-the-console/32761/16 "2018-04-04T12:36:05Z")
I had a problem with the `force_https` option (couldn’t login after enabling it). I fixed it by doing:
```plaintext
cd /var/discourse/
./launcher enter app
rails c
[1] pry(main)> SiteSetting.force_https = false
=> false
```
---
### Author:  [@Dannii](https://meta.discourse.org/u/Dannii)
#### Post date: [September 12, 2019, 4:01am UTC](https://meta.discourse.org/t/how-to-change-a-site-setting-via-the-console/32761/17 "2019-09-12T04:01:57Z")
I believe a setting regex needs updating, and want to test with a new value, but when I go `SiteSetting.key = value` it blocks me because of the regex. Is there a way to force update a value even if it doesn’t match the setting’s regex?
Edit: this worked, though be very careful!
```plaintext
cd /var/discourse/
./launcher enter app
rails db
discourse=> update site_settings set value='newvalue' where name='settingname';
```
And then exit out, and restart the app:
```plaintext
./launcher stop app
./launcher start app
```
---
### Author:  [@zogstrip](https://meta.discourse.org/u/zogstrip)
#### Post date: [September 28, 2019, 3:59pm UTC](https://meta.discourse.org/t/how-to-change-a-site-setting-via-the-console/32761/18 "2019-09-28T15:59:41Z")
`./launcher restart app` is slightly faster to restart the app 😉
---
### Author:  [@Artem\_Vasiliev](https://meta.discourse.org/u/Artem_Vasiliev)
#### Post date: [April 1, 2020, 2:55pm UTC](https://meta.discourse.org/t/how-to-change-a-site-setting-via-the-console/32761/19 "2020-04-01T14:55:11Z")
Just in case, here’s a shell script oneliner not requiring to restart Discourse: `bundle exec rails runner "SiteSetting.set('enable_sso', false)"`. It works just like it would from Discourse Admin UI.
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [July 4, 2024, 9:49pm UTC](https://meta.discourse.org/t/how-to-change-a-site-setting-via-the-console/32761/23 "2024-07-04T21:49:43Z")
---
### Author:  [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [July 4, 2024, 9:52pm UTC](https://meta.discourse.org/t/how-to-change-a-site-setting-via-the-console/32761/24 "2024-07-04T21:52:18Z")