Elasticsearch service is running but zammad will not display any search result

Trenga · April 5, 2018, 7:14am

Infos:

Used Zammad version: 2.4
Installation method (source, package, …): deb
Operating system: Debian 8.8
Database + version: 9.4+165+deb8u3
Elasticsearch version: 5.6.8
Browser + version: Firefox actual
Java + version: openjdk-8-jre:amd64 8u162-b12-1~bpo8+1

Hi zammad community

The mayor mistake was to install the newest Elasticsearch engine.
So I had a lot cleaning work on my system.

Actual I have installed elasticsearch via the zammad manual.
The elasticsearch service is running again.

The problem now is:
After restarting the services etc. Rebuilding the indexes etc as the manual.
I can’t see a search result in zammad.
Also I can’t find a user via search.

What can I do to analyse this problem?

Thanks in advance.

Greetings

Trenga · April 5, 2018, 9:02am

The plug-in [ingest-attachment] is loaded.
And I have rebuild the search index as defined in the manual.

But the problem still exist.

Please see the actually elasticsearch log:

[2018-04-06T11:15:52,294][INFO ][o.e.n.Node [2018-04-06T11:15:52,322][INFO ][o.e.n.Node [2018-04-06T11:15:52,323][INFO ][o.e.n.Node [2018-04-06T11:15:52,338][INFO ][o.e.n.Node [2018-04-06T11:15:54,678][INFO ][o.e.n.Node [2018-04-06T11:15:54,767][INFO ][o.e.e.NodeEnvironment [2018-04-06T11:15:54,768][INFO ][o.e.e.NodeEnvironment [2018-04-06T11:15:54,770][INFO ][o.e.n.Node [2018-04-06T11:15:54,771][INFO ][o.e.n.Node [2018-04-06T11:15:54,771][INFO ][o.e.n.Node [2018-04-06T11:15:55,880][INFO ][o.e.p.PluginsService [2018-04-06T11:15:55,880][INFO ][o.e.p.PluginsService [2018-04-06T11:15:55,880][INFO ][o.e.p.PluginsService [2018-04-06T11:15:55,880][INFO ][o.e.p.PluginsService [2018-04-06T11:15:55,881][INFO ][o.e.p.PluginsService [2018-04-06T11:15:55,881][INFO ][o.e.p.PluginsService [2018-04-06T11:15:55,881][INFO ][o.e.p.PluginsService [2018-04-06T11:15:55,881][INFO ][o.e.p.PluginsService [2018-04-06T11:15:55,881][INFO ][o.e.p.PluginsService [2018-04-06T11:15:55,881][INFO ][o.e.p.PluginsService [2018-04-06T11:15:55,881][INFO ][o.e.p.PluginsService [2018-04-06T11:15:55,881][INFO ][o.e.p.PluginsService [2018-04-06T11:15:57,415][INFO ][o.e.d.DiscoveryModule [2018-04-06T11:15:58,017][INFO ][o.e.n.Node [2018-04-06T11:15:58,017][INFO ][o.e.n.Node [2018-04-06T11:15:58,231][INFO ][o.e.t.TransportService [2018-04-06T11:16:01,344][INFO ][o.e.c.s.ClusterService [2018-04-06T11:16:01,375][INFO ][o.e.h.n.Netty4HttpSe [2018-04-06T11:16:01,375][INFO ][o.e.n.Node [2018-04-06T11:16:01,389][INFO ][o.e.g.GatewayService ] [Ty7y5OU] stopping …
] [Ty7y5OU] stopped
] [Ty7y5OU] closing …
] [Ty7y5OU] closed
] [] initializing …
] [Ty7y5OU] using [1] data paths, mounts [[/ (rootfs)]], net usable_space [446.3gb], net total_space [476.2gb], s$
] [Ty7y5OU] heap size [1.9gb], compressed ordinary object pointers [true]
] node name [Ty7y5OU] derived from node ID [Ty7y5OU-TBu8bfIWKOtBCg]; set [node.name] to override
] version[5.6.8], pid[13354], build[688ecce/2018-02-16T16:46:30.010Z], OS[Linux/3.16.0-4-amd64/amd64], JVM[Oracle$
] JVM arguments [-Xms2g, -Xmx2g, -XX:+UseConcMarkSweepGC, -XX:CMSInitiatingOccupancyFraction=75, -XX:+UseCMSIniti$
] [Ty7y5OU] loaded module [aggs-matrix-stats]
] [Ty7y5OU] loaded module [ingest-common]
] [Ty7y5OU] loaded module [lang-expression]
] [Ty7y5OU] loaded module [lang-groovy]
] [Ty7y5OU] loaded module [lang-mustache]
] [Ty7y5OU] loaded module [lang-painless]
] [Ty7y5OU] loaded module [parent-join]
] [Ty7y5OU] loaded module [percolator]
] [Ty7y5OU] loaded module [reindex]
] [Ty7y5OU] loaded module [transport-netty3]
] [Ty7y5OU] loaded module [transport-netty4]
] [Ty7y5OU] loaded plugin [ingest-attachment]
] [Ty7y5OU] using discovery type [zen]
] initialized
] [Ty7y5OU] starting …
] [Ty7y5OU] publish_address {127.0.0.1:9300}, bound_addresses {[::1]:9300}, {127.0.0.1:9300}
] [Ty7y5OU] new_master {Ty7y5OU}{Ty7y5OU-TBu8bfIWKOtBCg}{z7-jB_n6Rnaq4SAGPSMJPQ}{127.0.0.1}{127.0.0.1:9300}, reas$
rverTransport] [Ty7y5OU] publish_address {127.0.0.1:9200}, bound_addresses {[::1]:9200}, {127.0.0.1:9200}
] [Ty7y5OU] started
] [Ty7y5OU] recovered [0] indices into cluster_state

Trenga · April 6, 2018, 8:38am

Good Morning

I found an error in the zammad.log
E, [2018-04-06T10:18:54.567474 #510] ERROR – : Unable to process GET request to elasticsearch URL 'http://localhost:9200/DV-TicketCenter_zammad_production/Organization/_se$

So the service is running the plugin is installed
Have anyone an idea what the problem is???

Trenga · April 6, 2018, 8:44am

For example search for “test”:

I, [2018-04-06T10:18:54.454538 #510] INFO – : Started GET “/api/v1/search?query=test&limit=50&=1523001793673" for 127.0.0.1 at 2018-04-06 10:18:54 +0200
I, [2018-04-06T10:18:54.461985 #510] INFO – : Processing by TaskbarController#create as JSON
I, [2018-04-06T10:18:54.462133 #510] INFO – : Parameters: {“key”=>“Search”, “client_id”=>123, “callback”=>“Search”, “params”=>{“query”=>“test”, “shown”=>true}, “prio”=>$
I, [2018-04-06T10:18:54.469878 #510] INFO – : Processing by SearchController#search_generic as JSON
I, [2018-04-06T10:18:54.469996 #510] INFO – : Parameters: {“query”=>“test”, “limit”=>“50”, "”=>“1523001793673”}
I, [2018-04-06T10:18:54.496500 #510] INFO – : # curl -X POST “http://localhost:9200/DV-TicketCenter_zammad_production/User/_search”
I, [2018-04-06T10:18:54.523712 #510] INFO – : # 404
E, [2018-04-06T10:18:54.524231 #510] ERROR – : Unable to process GET request to elasticsearch URL ‘http://localhost:9200/DV-TicketCenter_zammad_production/User/_search’. C$

Response:
#<UserAgent::Result:0x00007fac08184438 @success=false, @body=nil, @data=nil, @code=“404”, @content_type=nil, @error="No such file http://localhost:9200/DV-TicketCenter_zamm$

Trenga · April 6, 2018, 9:04am

The same if I search for a user “test”:

Payload size: 0M
I, [2018-04-06T10:56:13.497144 #510] INFO – : Completed 200 OK in 28ms (Views: 0.4ms | ActiveRecord: 4.5ms)
I, [2018-04-06T10:56:13.502299 #508] INFO – : 2018-04-06T10:56:13+0200: [Worker(host:DV-TicketCenter pid:508)] Job Observer::UserDeviceLogJob (id=22972) RUNNING
I, [2018-04-06T10:56:13.711056 #510] INFO – : Started GET “/api/v1/users/search?query=test&limit=140&full=true&=1523001793682" for 127.0.0.1 at 2018-04-06 10:56:13 +0200
I, [2018-04-06T10:56:13.716721 #508] INFO – : 2018-04-06T10:56:13+0200: [Worker(host:DV-TicketCenter pid:508)] Job Observer::UserDeviceLogJob (id=22972) COMPLETED after $
I, [2018-04-06T10:56:13.719288 #510] INFO – : Processing by UsersController#search as JSON
I, [2018-04-06T10:56:13.719391 #510] INFO – : Parameters: {“query”=>“test”, “limit”=>“140”, “full”=>“true”, "”=>“1523001793682”}
I, [2018-04-06T10:56:13.734784 #510] INFO – : # curl -X POST “http://localhost:9200/DV-TicketCenter_zammad_production/User/_search”
I, [2018-04-06T10:56:13.738018 #510] INFO – : # 404
E, [2018-04-06T10:56:13.738410 #510] ERROR – : Unable to process GET request to elasticsearch URL ‘http://localhost:9200/DV-TicketCenter_zammad_production/User/_search’. $

Response:
#<UserAgent::Result:0x00007fac4014fbb0 @success=false, @body=nil, @data=nil, @code=“404”, @content_type=nil, @error="No such file http://localhost:9200/DV-TicketCenter_zam$

MrGeneration · April 6, 2018, 9:17am

Hey,

you’ll need to downgrade elasticsearch to version 5.5.x .
Currentely zammad does not support elasticsearch 6.x

Please refer to:
https://docs.zammad.org/en/latest/install-elasticsearch.html

Trenga · April 6, 2018, 9:24am

Hi
Thanks
But I did it already.

Trenga · April 9, 2018, 10:11am

zammad run rake searchindex:rebuild --trace
** Invoke searchindex:rebuild (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute searchindex:rebuild
** Execute searchindex:drop
drop indexes…done
** Execute searchindex:drop_pipeline
** Execute searchindex:create
create indexes…rake aborted!
Unable to process PUT request to elasticsearch URL ‘http://localhost:9200/DV-TicketCenter_zammad_production’. Check the response and payload for detailed information:

Response:
#<UserAgent::Result:0x0000559c7a7113f0 @success=false, @body=nil, @data=nil, @code=“400”, @content_type=nil, @error=“Client Error: #<Net::HTTPBadRequest 400 Bad Request readbody=true>!”>

Payload:
{:mappings=>{:Ticket=>{:_source=>{:excludes=>[“article.attachment”]}}}}

Payload size: 0M
/opt/zammad/lib/search_index_backend.rb:182:in index' /opt/zammad/lib/tasks/search_index_es.rake:57:inblock (2 levels) in <top (required)>’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/task.rb:251:in block in execute' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/task.rb:251:ineach’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/task.rb:251:in execute' /opt/zammad/lib/tasks/search_index_es.rake:166:inblock (2 levels) in <top (required)>’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/task.rb:251:in block in execute' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/task.rb:251:ineach’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/task.rb:251:in execute' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/task.rb:195:inblock in invoke_with_call_chain’
/opt/zammad/vendor/ruby-2.4.2/lib/ruby/2.4.0/monitor.rb:214:in mon_synchronize' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/task.rb:188:ininvoke_with_call_chain’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/task.rb:181:in invoke' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/application.rb:160:ininvoke_task’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/application.rb:116:in block (2 levels) in top_level' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/application.rb:116:ineach’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/application.rb:116:in block in top_level' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/application.rb:125:inrun_with_threads’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/application.rb:110:in top_level' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/application.rb:83:inblock in run’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/application.rb:186:in standard_exception_handling' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/application.rb:80:inrun’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/exe/rake:27:in <top (required)>' /opt/zammad/vendor/bundle/ruby/2.4.0/bin/rake:22:inload’
/opt/zammad/vendor/bundle/ruby/2.4.0/bin/rake:22:in <top (required)>' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli/exec.rb:74:inload’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli/exec.rb:74:in kernel_load' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli/exec.rb:27:inrun’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli.rb:360:in exec' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/vendor/thor/lib/thor/command.rb:27:inrun’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in invoke_command' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/vendor/thor/lib/thor.rb:369:indispatch’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli.rb:20:in dispatch' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/vendor/thor/lib/thor/base.rb:444:instart’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli.rb:10:in start' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/exe/bundle:35:inblock in <top (required)>’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/friendly_errors.rb:121:in with_friendly_errors' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/exe/bundle:27:in<top (required)>’
/opt/zammad/bin/bundle:3:in load' /opt/zammad/bin/bundle:3:in’
Tasks: TOP => searchindex:rebuild

Trenga · April 9, 2018, 10:18am

Hi
Could tell me anyone what that means?
#<UserAgent::Result:0x0000559c7a7113f0 @success=false, @body=nil, @data=nil, @code=“400”, @content_type=nil, @error=“Client Error: #<Net::HTTPBadRequest 400 Bad Request readbody=true>!”>

Trenga · April 9, 2018, 11:05am

Now I have disabled the elasticsearch with:
zammad run rails r "Setting.set(‘es_url’, ‘’)"
So I can find something.

I’m still hoping I get answer here.

Trenga · April 10, 2018, 12:03pm

Dear community
I do not know how many times I have uninstall elasticsearch with:
*systemctl stop elasticsearch
*systemctl disable elasticsearch

dpkg -P --force-depends elasticsearch

and install elasticsearch:

as the manual (with loaded plugin [ingest-attachment])

But I get still the searchindex:rebuild error:
Response:
#<UserAgent::Result:0x0000559c7a7113f0 @success=false, @body=nil, @data=nil, @code=“400”, @content_type=nil, @error=“Client Error: #<Net::HTTPBadRequest 400 Bad Request readbody=true>!”>

Has nobody an idea what I could try to locate the problem?

HELP

Trenga · April 11, 2018, 11:12am

irb(main):001:0> Delayed::Job.where.not(last_error: nil)
=> #<ActiveRecord::Relation [#<Delayed::Backend::ActiveRecord::Job id: 28491, pr iority: 0, attempts: 3, handler: “— !ruby/object:BackgroundJobSearchIndex\nobj ect: …”, last_error: “Unable to process POST request to elasticsearch UR…”, run_at: “2018-04-11 10:29:34”, locked_at: nil, failed_at: nil, locked_by: nil, q ueue: nil, created_at: “2018-04-11 10:25:59”, updated_at: “2018-04-11 10:28:08”> , #<Delayed::Backend::ActiveRecord::Job id: 27638, priority: 0, attempts: 7, han dler: “— !ruby/object:BackgroundJobSearchIndex\nobject: …”, last_error: “Una ble to process POST request to elasticsearch UR…”, run_at: “2018-04-11 10:31:1 3”, locked_at: nil, failed_at: nil, locked_by: nil, queue: nil, created_at: “201 8-04-11 09:08:50”, updated_at: “2018-04-11 09:51:07”>, #<Delayed::Backend::Activ eRecord::Job id: 27271, priority: 0, attempts: 7, handler: “— !ruby/object:Bac kgroundJobSearchIndex\nobject: …”, last_error: “Unable to process POST request to elasticsearch UR…”, run_at: “2018-04-11 10:30:16”, locked_at: nil, failed_ at: nil, locked_by: nil, queue: nil, created_at: “2018-04-11 09:08:44”, updated_ at: “2018-04-11 09:50:10”>, #<Delayed::Backend::ActiveRecord::Job id: 27039, pri ority: 0, attempts: 7, handler: “— !ruby/object:BackgroundJobSearchIndex\nobje ct: …”, last_error: “Unable to process POST request to elasticsearch UR…”, r un_at: “2018-04-11 10:29:31”, locked_at: nil, failed_at: nil, locked_by: nil, qu eue: nil, created_at: “2018-04-11 09:08:31”, updated_at: “2018-04-11 09:49:25”>, #<Delayed::Backend::ActiveRecord::Job id: 27676, priority: 0, attempts: 7, hand ler: “— !ruby/object:BackgroundJobSearchIndex\nobject: …”, last_error: “Unab le to process POST request to elasticsearch UR…”, run_at: "2018-04-11 10:41:25 ", locked_at: nil, failed_at: nil, locked_by: nil, queue: nil, created_at: “2018 -04-11 09:21:23”, updated_at: “2018-04-11 10:01:19”>, #<Delayed::Backend::Active Record::Job id: 27672, priority: 0, attempts: 7, handler: “— !ruby/object:Back groundJobSearchIndex\nobject: …”, last_error: “Unable to process POST request to elasticsearch UR…”, run_at: “2018-04-11 10:41:24”, locked_at: nil, failed_a t: nil, locked_by: nil, queue: nil, created_at: “2018-04-11 09:21:23”, updated_a t: “2018-04-11 10:01:18”>, #<Delayed::Backend::ActiveRecord::Job id: 28013, prio rity: 0, attempts: 7, handler: “— !ruby/object:BackgroundJobSearchIndex\nobjec t: …”, last_error: “Unable to process POST request to elasticsearch UR…”, ru n_at: “2018-04-11 10:46:32”, locked_at: nil, failed_at: nil, locked_by: nil, que ue: nil, created_at: “2018-04-11 09:25:50”, updated_at: “2018-04-11 10:06:26”>, #<Delayed::Backend::ActiveRecord::Job id: 27181, priority: 0, attempts: 7, handl er: “— !ruby/object:BackgroundJobSearchIndex\nobject: …”, last_error: “Unabl e to process POST request to elasticsearch UR…”, run_at: “2018-04-11 10:30:00” , locked_at: nil, failed_at: nil, locked_by: nil, queue: nil, created_at: “2018- 04-11 09:08:40”, updated_at: “2018-04-11 09:49:54”>, #<Delayed::Backend::ActiveR ecord::Job id: 27283, priority: 0, attempts: 7, handler: “— !ruby/object:Backg roundJobSearchIndex\nobject: …”, last_error: “Unable to process POST request t o elasticsearch UR…”, run_at: “2018-04-11 10:30:17”, locked_at: nil, failed_at : nil, locked_by: nil, queue: nil, created_at: “2018-04-11 09:08:44”, updated_at : “2018-04-11 09:50:11”>, #<Delayed::Backend::ActiveRecord::Job id: 27526, prior ity: 0, attempts: 7, handler: “— !ruby/object:BackgroundJobSearchIndex\nobject : …”, last_error: “Unable to process POST request to elasticsearch UR…”, run _at: “2018-04-11 10:30:55”, locked_at: nil, failed_at: nil, locked_by: nil, queu e: nil, created_at: “2018-04-11 09:08:48”, updated_at: “2018-04-11 09:50:49”>, . …]>

Trenga · April 11, 2018, 11:18am

root@DV-TicketCenter:/var/log/zammad# zammad run rails r “Setting.set(‘es_url’, ‘http://localhost:9200/DV-TicketCenter_zammad_production’)”
root@DV-TicketCenter:/var/log/zammad# zammad run rake searchindex:rebuild --trace
** Invoke searchindex:rebuild (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute searchindex:rebuild
** Execute searchindex:drop
drop indexes…done
** Execute searchindex:drop_pipeline
rake aborted!
Unable to process GET request to elasticsearch URL ‘http://localhost:9200/DV-TicketCenter_zammad_production’. Check the response and payload for detailed information:

Response:
#<UserAgent::Result:0x0000562198ee2540 @success=false, @body=nil, @data=nil, @code=“404”, @content_type=nil, @error=“No such file http://localhost:9200/DV-TicketCenter_zammad_production, 404!”>

Payload:
nil

Payload size: 0M
/opt/zammad/lib/search_index_backend.rb:37:in info' /opt/zammad/lib/tasks/search_index_es.rake:128:inblock (2 levels) in <top (required)>’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/task.rb:251:in block in execute' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/task.rb:251:ineach’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/task.rb:251:in execute' /opt/zammad/lib/tasks/search_index_es.rake:14:inblock (2 levels) in <top (required)>’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/task.rb:251:in block in execute' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/task.rb:251:ineach’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/task.rb:251:in execute' /opt/zammad/lib/tasks/search_index_es.rake:165:inblock (2 levels) in <top (required)>’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/task.rb:251:in block in execute' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/task.rb:251:ineach’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/task.rb:251:in execute' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/task.rb:195:inblock in invoke_with_call_chain’
/opt/zammad/vendor/ruby-2.4.2/lib/ruby/2.4.0/monitor.rb:214:in mon_synchronize' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/task.rb:188:ininvoke_with_call_chain’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/task.rb:181:in invoke' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/application.rb:160:ininvoke_task’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/application.rb:116:in block (2 levels) in top_level' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/application.rb:116:ineach’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/application.rb:116:in block in top_level' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/application.rb:125:inrun_with_threads’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/application.rb:110:in top_level' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/application.rb:83:inblock in run’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/application.rb:186:in standard_exception_handling' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/lib/rake/application.rb:80:inrun’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.0/exe/rake:27:in <top (required)>' /opt/zammad/vendor/bundle/ruby/2.4.0/bin/rake:22:inload’
/opt/zammad/vendor/bundle/ruby/2.4.0/bin/rake:22:in <top (required)>' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli/exec.rb:74:inload’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli/exec.rb:74:in kernel_load' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli/exec.rb:27:inrun’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli.rb:360:in exec' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/vendor/thor/lib/thor/command.rb:27:inrun’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in invoke_command' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/vendor/thor/lib/thor.rb:369:indispatch’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli.rb:20:in dispatch' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/vendor/thor/lib/thor/base.rb:444:instart’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/cli.rb:10:in start' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/exe/bundle:35:inblock in <top (required)>’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/lib/bundler/friendly_errors.rb:121:in with_friendly_errors' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.1/exe/bundle:27:in<top (required)>’
/opt/zammad/bin/bundle:3:in load' /opt/zammad/bin/bundle:3:in’
Tasks: TOP => searchindex:rebuild

Trenga · April 11, 2018, 11:49am

curl -X GET ‘http://localhost:9200’
{
“name” : “BNt_Mqy”,
“cluster_name” : “elasticsearch”,
“cluster_uuid” : “haL7sg2oQZurlzcjjYpDwg”,
“version” : {
“number” : “5.6.8”,
“build_hash” : “688ecce”,
“build_date” : “2018-02-16T16:46:30.010Z”,
“build_snapshot” : false,
“lucene_version” : “6.6.1”
},
“tagline” : “You Know, for Search”
}

MrGeneration · April 11, 2018, 12:47pm

Sorry for nothing positive from my side - will test your setup later this week as I’m not sure where the problem lies.

Trenga · April 11, 2018, 1:11pm

Hi
Yeah Thanks for feedback.
But do you have an idea?

MrGeneration · April 13, 2018, 3:49pm

Sorry now that took me long to notice, your seeting.set (es.url[…] is invalid and not what stands inside the wiki.

Please run the following command without changing:

zammad run rails r "Setting.set('es_url', 'http://localhost:9200')"

For your reference, after isntalling zammad, elasticsearch and the needed dependencies I run the following commands:

33 /usr/share/elasticsearch/bin/elasticsearch-plugin install ingest-attachment
34 systemctl restart elasticsearch
35 systemctl status elasticsearch
36 zammad run rails r "Setting.set('es_url', 'http://localhost:9200')"
37 zammad run rake searchindex:rebuild
38 zammad run rails r "Setting.set('es_user', 'elasticsearch')"
39 zammad run rails r "Setting.set('es_password', 'zammad')"
40 zammad run rails r "Setting.set('es_index', Socket.gethostname + '_zammad')"
41 zammad run rails r "Setting.set('es_attachment_ignore', [ '.png', '.jpg', '.jpeg', '.mpeg', '.mpg', '.mov', '.bin', '.exe', '.box', '.mbox' ] )"
42 zammad run rails r "Setting.set('es_attachment_max_size_in_mb', 50)"
43 cat /etc/os-release
44 ifconfig
45 vi /etc/nginx/sites-enabled/zammad.conf
46 systemctl restart nginx
47 tail -f /var/log/zammad/*.log
48 vi /var/log/zammad/scheduler_err.log
49 vi /var/log/zammad/searchindex-rebuild.log
50 reboot

I am running a test instance on Debian 8 jessie

Trenga · April 16, 2018, 1:36pm

HI MrGeneration
At first thanks for your time.

Yeah I was testing a another URL.
You can see it the different errors 400 (with the standard URL)
and 404 (with specific for my server http://localhost:9200/DV-TicketCenter_zammad_production)

But I have tried your (standard) URL again.
Please see my output:
root@DV-TicketCenter:/home/dv-ticketcenter# zammad run rails r “Setting.set(‘es_url’, ‘http://localhost:9200’)”
root@DV-TicketCenter:/home/dv-ticketcenter# zammad run rake searchindex:rebuild --trace
** Invoke searchindex:rebuild (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute searchindex:rebuild
** Execute searchindex:drop
drop indexes…done
** Execute searchindex:drop_pipeline
** Execute searchindex:create
create indexes…rake aborted!
Unable to process PUT request to elasticsearch URL ‘http://localhost:9200/DV-TicketCenter_zammad_production’. Check the response and payload for detailed information:

Response:
#<UserAgent::Result:0x000055f6b8926f30 @success=false, @body=nil, @data=nil, @code=“400”, @content_type=nil, @error=“Client Error: #<Net::HTTPBadRequest 400 Bad Request readbody=true>!”>

What could be the problem?

Thanks in advance.
Have a nice week.

system · June 15, 2018, 1:36pm

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.