I have to Fetch the Today's status from my MYSQL table. Result From Table is empty. when i creating an index with null result of data the index does not created. What i am missing?
this is my config file:
input {
jdbc {
jdbc_driver_library => "C:/New_ELK/logstash-5.5.2/mysql-connector-java-5.1.42/mysql-connector-java-5.1.42-bin.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
jdbc_connection_string => "jdbc:mysql://localhost:3306/emob_report"
jdbc_user => "root"
jdbc_password => ""
statement => "select * from attendance
where punchin_date=curdate()"
}
}
output {
elasticsearch {
index => "users_punched_in"
hosts => ["localhost:9200"]
}
stdout { codec => json_lines }
}