Probleme Logstash with MYSQL


(Mahdi Wafi) #1

Hello every body,
I'm traying yo use Logstash with mysql confiration but i have an error .

thanks o lot for your help

my file configuration:

input {
jdbc {
jdbc_driver_library => "C:/logstash/mysql-connector-java-5.1.39.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
jdbc_connection_string => "jdbc:mysql://localhost:3306/Project"
jdbc_user => "root"
jdbc_password => "root"
schedule => "* * * * *"
statement => "select * from person"
}

}
output {
elasticsearch {
index => "persons"
document_type => "person"
document_id => "%{table_id}"
hosts => "localhost:9500"

}

}

===============================
My error:

erties. Using default config which logs to console
Thu Jan 26 20:53:42 WAT 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL conne
ction must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need eit
her to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
20:53:42.794 [[main]-pipeline-manager] INFO logstash.outputs.elasticsearch - Elasticsearch pool URLs updated {:changes=>{:removed=>[], :added=>["http://localhost:9500"]}}
20:53:42.799 [[main]-pipeline-manager] INFO logstash.outputs.elasticsearch - Running health check to see if an Elasticsearch connection is working {:url=>#<URI::HTTP:0x5781acac URL:http://lo
calhost:9500>, :healthcheck_path=>"/"}
20:53:44.906 [[main]-pipeline-manager] WARN logstash.outputs.elasticsearch - Attempted to resurrect connection to dead ES instance, but got an error. {:url=>#<URI::HTTP:0x5781acac URL:http:/
/localhost:9500>, :error_type=>LogStash::Outputs::ElasticSearch::HttpClient::Pool::HostUnreachableError, :error=>"Elasticsearch Unreachable: [http://localhost:9500][Manticore::SocketException
] Connection refused: connect"}
20:53:44.907 [[main]-pipeline-manager] INFO logstash.outputs.elasticsearch - Using mapping template from {:path=>nil}
20:53:46.928 [[main]-pipeline-manager] WARN logstash.outputs.elasticsearch - Marking url as dead. {:reason=>"Elasticsearch Unreachable: [http://localhost:9500][Manticore::SocketException] Co
nnection refused: connect", :url=>#<URI::HTTP:0x2f212a6e URL:http://localhost:9500>, :error_message=>"Elasticsearch Unreachable: [http://localhost:9500][Manticore::SocketException] Connection
refused: connect", :error_class=>"LogStash::Outputs::ElasticSearch::HttpClient::Pool::HostUnreachableError"}


(Mark Walkom) #2

Are you sure that is the right ES address?


(Mahdi Wafi) #3

thank you for your replay,
in fact i am new with logstash i do not khnow if i have to use a specific
url,i thaught that i can use any E/S host in my file configuration

Thanks for help


(system) #4

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