Block in start-input (file not readable) sqlserver logstash

Elastic Stack Logstash
1

Hi all,

I plan to load data from SQL Server database to Elastic. While trying to load this data using the Logstash JDBC plugin I am facing a problem. I found in the community errors like this but no solution,

Test: Copy the driver to the path "C:\Users\Lenovo\Desktop\ELK\logstash-8.1.0\logstash-core\lib\jars\mssql-jdbc-7.2.2.jre8.jar"
Error: unable to load sqljdbc4-2.0.jar from :jdbc_driver_library, file not readable (please check user and group permissions for the path) <

myfile.conf

input {
  jdbc {
	jdbc_default_timezone => "America/New_York"
    jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
    jdbc_connection_string => "jdbc:sqlserver://localhost;databaseName=sales;user=admin;password=1234;"
    jdbc_user => ""
    jdbc_password => ""
    use_column_value => true
	tracking_column_type => "timestamp"
	tracking_column => "rml_lastupdate"
	statement => "SELECT * FROM Fevrier WHERE rml_lastupdate >= :sql_last_value order by rml_lastupdate"
	schedule => "*/5 * * * * *"
 }
}
output {
 elasticsearch {
	hosts => ["localhost:9200"]
	index => "cs_users"
	document_id => "%{Order ID}"
 }
}
2

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