Hi All,
I don't understand what's wrong in below conf file.
input {
jdbc {
jdbc_driver_library => "/usr/share/logstash/myjars/mysql-connector-java-8.0.11.jar"
jdbc_driver_class => "com.mysql.cj.jdbc.Driver"
jdbc_connection_string => "jdbc:mysql://10.0.1.133:5500/alumini_factor"
jdbc_user => "root"
jdbc_password => "********"
statement => "select * FROM profile"
use_column_value => true
tracking_column => id
}
}
output {
elasticsearch {
document_id => "%{id}"
hosts => ["http://localhost:9200"]
index => "profiles"
document_type => "data"
}
}
P.S:
Elasticsearch version 7.0.1
Logstash version 7.3
Mysql verion 5.7.26-0ubuntu0.16.04.1
Thanks,
Manideep