Unable to push data from local LOGSTASH to AWS elasticsearch service

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/", :error_type=>LogStash::Outputs::ElasticSearch::HttpClient::Pool::HostUnreachableError, :error=>"Elasticsearch Unreachable: [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 }
}

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