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