[logstash.outputs.Elasticsearch][main] Attempted to resurrect connection to dead ES instance, but got an error {:url=>"http://elastic:xxxxxx@elasticsearch:9200/", :exception=>LogStash::Outputs::Elasticsearch::HttpClient::Pool::HostUnreachableError, :message=>"Elasticsearch Unreachable: [http://elasticsearch:9200/][Manticore::ResolutionFailure] Elasticsearch"}
My Logstash.conf file :
input {
jdbc {
jdbc_driver_library => "/usr/share/logstash/logstash-core-plugin-api/mysql-connector-java-8.0.28/mysql-connector-java-8.0.28.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
jdbc_connection_string => "jdbc:mysql://Ip-address:port/Database_name"
jdbc_user => "user"
jdbc_password => "password"
statement => "SELECT * FROM users"
schedule => "* * * * *" jdbc_paging_enabled => "true"
jdbc_page_size => "50000"
}
}
output {
Elasticsearch {
hosts => "Elasticsearch:9200"
user => "elastic"
password => "password"
document_type => "data"
document_id => "%{id}"
index => "logstashmysql"
}
}
Iam trying to connect my Database to kibana for metrics using logstash, its not happening, iam trying this from 2 weeks changing the conf file but no solution. need help on this.
The below is my output file
curl -XGET http://elastic:Y2SBU9TXk99ZPjSWgrLJ@ip-address:9200
{
"name" : "b5b66de9f9f3",
"cluster_name" : "my-Elasticsearch-cluster",
"cluster_uuid" : "nkRoFq5zSxq-TQSpmnuiGQ",
"version" : {
"number" : "8.1.0",
"build_flavor" : "default",
"build_type" : "docker",
"build_hash" : "3700f7679f7d95e36da0b43762189bab189bc53a",
"build_date" : "2022-03-03T14:20:00.690422633Z",
"build_snapshot" : false,
"lucene_version" : "9.0.0",
"minimum_wire_compatibility_version" : "7.17.0",
"minimum_index_compatibility_version" : "7.0.0"
},
"tagline" : "You Know, for Search"
}