# Unable to push data from local LOGSTASH to AWS elasticsearch service

**URL:** <https://discuss.elastic.co/t/unable-to-push-data-from-local-logstash-to-aws-elasticsearch-service/220860>\
**Category:** Logstash\
**Created:** [February 25, 2020, 1:07pm UTC](https://discuss.elastic.co/t/unable-to-push-data-from-local-logstash-to-aws-elasticsearch-service/220860 "2020-02-25T13:07:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![vidhyadhara](https://avatars.discourse-cdn.com/v4/letter/v/c0e974/32.png) [@vidhyadhara](https://discuss.elastic.co/u/vidhyadhara)\
**Post date:** [February 25, 2020, 1:07pm UTC](https://discuss.elastic.co/t/unable-to-push-data-from-local-logstash-to-aws-elasticsearch-service/220860/1 "2020-02-25T13:07:15Z")

</div>

Hello Folks,

Below is my logstash configuration file i've in my local system, I'm trying to push data from my Server DB to AWS Elasticsearch endpoint but getting this error------

Attempted to resurrect connection to dead ES instance, but got an error. {:url=\>"[https://elastic:xxxxxx@search-dotsway2-paost77xd5wdbhd56ymrchhfai.us-east-2.es.amazonaws.com:9200/](https://elastic:xxxxxx@search-dotsway2-paost77xd5wdbhd56ymrchhfai.us-east-2.es.amazonaws.com:9200/)", :error\_type=\>LogStash::Outputs::ElasticSearch::HttpClient::Pool::HostUnreachableError, :error=\>"Elasticsearch Unreachable: [[https://elastic:xxxxxx@search-dotsway2-paost77xd5wdbhd56ymrchhfai.us-east-2.es.amazonaws.com:9200/](https://elastic:xxxxxx@search-dotsway2-paost77xd5wdbhd56ymrchhfai.us-east-2.es.amazonaws.com:9200/)][Manticore::ConnectTimeout] Connect timed out"}

I've installed ES in my local machine also and this configuration file works when i change hosts to ["localhost:9200"].

####LOGSTASH configuration file####

input {  
jdbc {  
jdbc\_driver\_library =\> "C:\Users\191439\Downloads\mysql-connector-java-8.0.18\mysql-connector-java-8.0.18\mysql-connector-java-8.0.18.jar"  
jdbc\_driver\_class =\> "com.mysql.jdbc.Driver"  
jdbc\_connection\_string =\> "jdbc:mysql://1x.xxx.xx.xx:xxxx/table\_name"  
jdbc\_user =\> "root"  
jdbc\_password =\> "password"  
statement =\> "SELECT \* FROM DB\_NAME.TABLE\_NAME;"  
}  
}

output {  
elasticsearch {  
hosts =\> ["AWS elasticsearch Endpoint link"]  
index =\> "index name"  
user =\> "username"  
password =\> "password"  
}  
stdout { codec =\>rubydebug }  
}

 ![Screenshot (37)](https://us1.discourse-cdn.com/elastic/original/3X/1/6/160665dd0cbd6330439cb59332cee0d0e557c269.png)

---

<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:** [March 24, 2020, 1:07pm UTC](https://discuss.elastic.co/t/unable-to-push-data-from-local-logstash-to-aws-elasticsearch-service/220860/2 "2020-03-24T13:07:19Z")

</div>

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