I'm trying to run logstash using JDBC plugin. I have given a custom path for the file but still it is not reflecting and its getting created in the default path.
My config is as shown below
input {
jdbc {
jdbc_driver_library => "D:/ELK/mysql-connector-java-8.0.16/mysql-connector-java-8.0.16.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
jdbc_connection_string => "jdbc:mysql://10.115.115.109:3306/gpscbot"
jdbc_user => "root"
jdbc_password => "data.123"
#statement => "SELECT * from likefeedback"
clean_run => true
statement => "SELECT * FROM likefeedback WHERE id > :sql_last_value"
#schedule => "45 6 * 1-12 *"
use_column_value => true
tracking_column => "id"
tracking_column_type => "numeric"
last_run_metadata_path => "D:/ELK/logstash-7.0.1/logstash-7.0.1/bin/.logstash_jdbc_last_run"
record_last_run => true
}
Please help me on this.
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.