I’m trying to change some forum settings through the console. I didn’t do that a lot yet so I searched for similar questions on the forum. Unfortunately when executing ‘bundle exec rails c’ i get an error trace that ends with this line /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/activerecord-6.1.4.7/lib/active_record/connection_adapters/postgresql_adapter.rb:81:in `rescue in new_client': connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: Peer authentication failed for user "discourse" (ActiveRecord::NoDatabaseError) Any idea what’s going on there? Forum itself runs fine - just updated to the latest version the other day.

I get to the rails console from the server by using: cd /var/discourse ./launcher enter app rails c There’s an example of changing a site setting in this topic, Enable setting to allow admins to permanently delete data (this one is a hidden one, but the method is the same)

Thanks, I guess I mixed up both - I was doing bundle exec from within the app. Still struggling though. I’m looking to change the IP regex for the prometheus exporter plugin. Not sure which syntax is good to use. I tried SiteSetting.prometheus_trusted_ip_allowlist_regex=1.2.3.4 with escaping backslashes and quotes around it but nothing worked. 1.2.3.4 being a placeholder of my real IP.

Actually I just noticed it’s probably not a syntax issue SiteSetting.prometheus_trusted_ip_allowlist_regex="123.145.167.189" NoMethodError: undefined method `prometheus_trusted_ip_allowlist_regex=' for # Maybe @sam can help with that. Or I’m really just making a mistake here. :thinking:

You must set DISCOURSE_PROMETHEUS_TRUSTED_IP_ALLOWLIST_REGEX and a ENV variable on your app.yml file.

Correct me if I’m wrong but I thought I could set it on runtime first. So I need to set it on app.yml first to then be able to modify it on runtime? The forum is quite busy so I was hoping to be able to set it on runtime first before setting it permanently in the ENV. Any hints about the syntax? Can this just be DISCOURSE_PROMETHEUS_TRUSTED_IP_ALLOWLIST_REGEX: 123.145.167.189

[image] helmi: I thought I could set it on runtime first. So I need to set it on app.yml first to then be able to modify it on runtime? No runtime changes, only via the ENV. [image] helmi: Any hints about the syntax It’s a Ruby Regex object, see https://rubular.com/ [image] helmi: Can this just be DISCOURSE_PROMETHEUS_TRUSTED_IP_ALLOWLIST_REGEX: 123.145.167.189 Yes, that works.

Postgres connection error on 'bundle exec rails c'

Product Support Self-hosting

Falco (Falco) March 28, 2022, 2:24pm 7

No runtime changes, only via the ENV.

It’s a Ruby Regex object, see https://rubular.com/

Yes, that works.

Topic		Replies	Views
How to change a site setting via the Console Product Support	17	8848	April 1, 2020
Setting up RubyMine for debugging Development	4	1552	August 13, 2021
Install Failed - email not configured Self-hosting	4	2347	February 28, 2017
How to get into Rails Console Product Support	3	3122	March 20, 2020
Can't start localhost server -- file was built for x86_64 which is not the architecture being linked (i386) Development	10	2416	April 1, 2022

Postgres connection error on 'bundle exec rails c'

Related topics