For kerberos authentication username and password is not required.
But plugin make username as required parameter.
I have tried diiferent ways but not able to connect to MS Sql Server
OS Version :
RHEL 8.3 with x64
Logstash Version :
Using system java: /usr/bin/java
logstash 7.11.2
JDBC Plugins Version :
sqljdbc42
MSSQL Version :
2016
input {
jdbc {
jdbc_driver_library => "/usr/share/logstash/logstash-core/lib/jars/sqljdbc42.jar"
jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
jdbc_connection_string => "jdbc:sqlserver://<fqdn>;databaseName=<DB Name>;authenticationScheme=JavaKerberos"
jdbc_default_timezone => "UTC"
statement => "exec usp_elasticsearch_asc"
#tracking_column_type => "timestamp"
#tracking_column => "tagdatetime"
#use_column_value => true
#schedule => "*/1 * * * * *"
last_run_metadata_path => "/usr/share/logstash/.logstash_jdbc_last_run"
}
}
can anyone help me?
for this issue