Elasticsearch Host unreachable

[Huda_Aqilah]

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/][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..

[Huda_Aqilah]

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 }
}

[magnusbaeck (Magnus Bäck)]

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?

[Huda_Aqilah]

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"
}