# Elasticsearch Host unreachable

**URL:** <https://discuss.elastic.co/t/elasticsearch-host-unreachable/81261>\
**Category:** Logstash\
**Created:** [April 5, 2017, 7:42am UTC](https://discuss.elastic.co/t/elasticsearch-host-unreachable/81261 "2017-04-05T07:42:41Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Huda\_Aqilah](https://avatars.discourse-cdn.com/v4/letter/h/6de8d8/32.png) [@Huda\_Aqilah](https://discuss.elastic.co/u/Huda_Aqilah)\
**Post date:** [April 5, 2017, 7:42am UTC](https://discuss.elastic.co/t/elasticsearch-host-unreachable/81261/1 "2017-04-05T07:42:41Z")

</div>

I tried to migrate data from MySQL into Elasticsearch using logstash. unfortunately , i got an error that my elasticsearch is unreachable.

this is the error .

Marking url as de ad.Last error: [LogStash::Outputs::ElasticSearch::HttpClient::Pool::HostUnreachab leError] Elasticsearch Unreachable: [[http://101.44.28.29:9200/](http://101.44.28.29:9200/)][Manticore::SocketException] No route to host (Host unreachable)

[2017-04-05T07:15:46,624][INFO][logstash.pipeline] Pipeline main started The stdin plugin is now waiting for input:  
[2017-04-05T07:15:46,703][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=\>9601}  
[2017-04-05T07:15:48,320][INFO][logstash.inputs.jdbc] (1.692000s) SELECT \* FROM botnet  
[WARN][logstash.outputs.elasticsearch] UNEXPECTED POOL ERROR {:e=\>#\<LogStash::Outputs::ElasticSearch::HttpClient::Pool::NoConnectionAvailableError: No Available connections\>}

please anyone help me.. ☹

---

<div class="post-metadata">

**Author:** ![Huda\_Aqilah](https://avatars.discourse-cdn.com/v4/letter/h/6de8d8/32.png) [@Huda\_Aqilah](https://discuss.elastic.co/u/Huda_Aqilah)\
**Post date:** [April 5, 2017, 8:01am UTC](https://discuss.elastic.co/t/elasticsearch-host-unreachable/81261/2 "2017-04-05T08:01:32Z")

</div>

this is my logstash configuration file.

input{ stdin {}  
jdbc{  
jdbc\_connection\_string =\> "jdbc:mysql://101.44.43.43:3306/logger2"  
jdbc\_user =\> "root"  
jdbc\_password =\> "qwaszx1234"  
jdbc\_driver\_library =\> "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-4.1.3/lib/logstash/plugin\_mixins/mysql.jar"  
jdbc\_driver\_class =\> "com.mysql.jdbc.Driver"  
statement =\> "SELECT \* FROM botnet"  
}  
}  
output {  
elasticsearch {  
hosts =\> ["101.44.28.29"]  
index =\> logger2  
document\_type =\> botnet  
sniffing =\> false  
}  
stdout { codec =\> rubydebug }  
}

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [April 6, 2017, 5:05am UTC](https://discuss.elastic.co/t/elasticsearch-host-unreachable/81261/3 "2017-04-06T05:05:52Z")

</div>

Have you verified that the Logstash machine is able to connect? For example, does `curl http://101.44.28.29:9200` or `wget http://101.44.28.29:9200` work?

---

<div class="post-metadata">

**Author:** ![Huda\_Aqilah](https://avatars.discourse-cdn.com/v4/letter/h/6de8d8/32.png) [@Huda\_Aqilah](https://discuss.elastic.co/u/Huda_Aqilah)\
**Post date:** [April 6, 2017, 6:17am UTC](https://discuss.elastic.co/t/elasticsearch-host-unreachable/81261/4 "2017-04-06T06:17:15Z")

</div>

yes i have ...

and i got this..

{  
"name" : "kLMzSRs",  
"cluster\_name" : "docker-cluster",  
"cluster\_uuid" : "b-khSdHZSG-\_YW1q1Fo\_zg",  
"version" : {  
"number" : "5.3.0",  
"build\_hash" : "3adb13b",  
"build\_date" : "2017-03-23T03:31:50.652Z",  
"build\_snapshot" : false,  
"lucene\_version" : "6.4.1"  
},  
"tagline" : "You Know, for Search"  
}

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [May 4, 2017, 6:17am UTC](https://discuss.elastic.co/t/elasticsearch-host-unreachable/81261/5 "2017-05-04T06:17:20Z")

</div>

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