How to change a site setting via the Console

[cpradio]

So while investigating

Logout Menu Item

Also reproduced on Chrome 44.0.2403.157 OSX 10.10.5. We are using SSO … not sure if that might make a difference?

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?

[zogstrip]

in your /discourse

bundle exec rails c
SiteSetting.enable_sso = false

[cpradio]

Ah, I did it a different route, but yours is easier.

I ended up doing

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…)

[fefrei]

For future reference, there is also a method that does not need command line access.

[codinghorror]

Yeah just use /users/admin-login

[Svancara]

I did

SiteSetting.enable_sso = false

But I ended up with this login form:

How can I log-in please?

[riking]

Looks like you have no login methods available.

Do SiteSetting.enable_local_logins = true .

[Svancara]

Yes!

Thank you very much!

[ewanly]

After running : "bundle exec rails c"
I’m getting an error : “Could not locate Gemfile”

How to fix it?

[fefrei]

Are you running this from inside your container (./launcher enter app)?

[ewanly]

No I wasn’t since its wasn’t mentioned. Sorry a lot of things to learn yet

[ewanly]

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:innew’
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.

[Alavi1412]

Can we change the discourse language in bundle exec rails c console?
How can we change the language of our site to english?

[Alavi1412]

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

[metakermit]

I had a problem with the force_https option (couldn’t login after enabling it). I fixed it by doing:

cd /var/discourse/
./launcher enter app
rails c
[1] pry(main)> SiteSetting.force_https = false
=> false