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)