Load data from mysql to elasticsearch with logstash

Hi,
I want to load data from mysql ( mysql wampserver ) into elasticsearch via logstash.
After downloading elasticsearch ,kibana and logstash ,i installed "com.mysql.jdbc_5.1.5" (JDBC).
test.conf
input {
jdbc {
jdbc_connection_string =>""jdbc:mysql://localhost:3306/giata_db""
jdbc_user => "root"
jdbc_password => ""
jdbc_driver_library => "C:\Users\hiba\OneDrive\ELK\logstash-7.0.0\logstash-7.0.0\bin\com.mysql.jdbc_5.1.5.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
statement => "SELECT * FROM countries"
}
}
output{
elasticsearch{
hosts => ["localhost:9200"]
index => "voyage2000"
}
stdout { codec => rubydebug }
}

any help please !

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