Good morning,
when I open the statistic page in my zammad GUI, I get the following error message:
{“error”:“Unable to process GET request to elasticsearch URL ‘http://127.0.0.1:9200/zammad_production/Ticket/_search’. Elasticsearch is not reachable, probably because it’s not running or even installed.\n\nResponse:\n#\u003cUserAgent::Result:0x000055edc972e360 @success=false, @Body=nil, @DaTa=nil, @code=0, @content_type=nil, @error=”#\u003cErrno::ECONNREFUSED: Failed to open TCP connection to 127.0.0.1:9200 (Connection refused - connect(2) for “127.0.0.1” port 9200)\u003e"\u003e\n\nPayload:\n{:query=\u003e{:bool=\u003e{:must=\u003e[{:range=\u003e{“created_at”=\u003e{:from=\u003e"2018-01-01", :to=\u003e"2018-12-31"}}}], :must_not=\u003e[{:term=\u003e{“state”=\u003e"merged"}}]}}, :size=\u003e0, :aggs=\u003e{:time_buckets=\u003e{:date_histogram=\u003e{:field=\u003e"created_at", :interval=\u003e"month"}}}}\n\nPayload size: 0M"}
I’m opening the zammad GUI on my client, zammad is running on a server with IP 192.168.75.63.
When I login to a console as root and enter the following statement:
zammad run rails r “Setting.set(‘es_url’, ‘http://192.168.75.63:9200’)”
everything is working fine and I can open the statistic pages.
But after the next zammad update, it is starting at the beginning and I get the error message again.
Is there a possibility to set es_url to http://192.168.75.63:9200 permanently?
In my /etc/elasticsearch/elasticsearch.yml, I already entered the lines:
---------------------------------- Network -----------------------------------
Set the bind address to a specific IP (IPv4 or IPv6):
network.host: 192.168.75.63
Set a custom port for HTTP:
http.port: 9200
For more information, consult the network module documentation.