Jdbc, for getting mssql to Logstash not working :-(

Hello
Unfortunately, I can not able to input mssql data base to logstash...
This is my configuration file:

input {
jdbc {
jdbc_driver_library => "/usr/share/logstash/jdbc_driver/sqljdbc_8.4/enu/mssql-jdbc-8.4.1.jre14.jar"
jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
# mssql jdbc connection string to our database, mydb
jdbc_connection_string => "jdbc:mssql://192.168.11.52:1433;databasename:Morakhasi"
# The user we wish to execute our statement as
jdbc_user => "faridTest"
jdbc_password => "---"
schedule => "* * * * *"
# our query to fetch blog details
#statement => "SELECT * from songs where artist = :favorite_artist"
}
}
output {
stdout { codec => rubydebug }
elasticsearch {
hosts => "localhost:9200"
index => "mssql"
document_type => "blogs"
}
}

PLEASE PLEASE, Somebody help me... (see the attachment photo)

#statement => "SELECT * from songs where artist = :favorite_artist"

The statement is commented out for one. Do you get data if you uncomment it? Try to execute something simple also to test.

statement => "SELECT TOP 1 * from songs"
1 Like

Thank you so much bro for replying...
It is work now, probably... but it seems have issue with the jdbc driver (see the attachment please

)

It could be dealing with this current issue. I would try that next.

Thank you so much...

1 Like