Trying to connect to my Sql Server Instance thru Windows Authentication using the following configuration:
input {
udp {
port => 517
}
}
filter {
mutate { gsub => [ "message", "\u0000", "[0x00]" ] }
mutate { gsub => [ "message", "\r\n", "[0x01]" ] }
mutate { gsub => [ "message", "\r", "[0x02]" ] }
mutate { gsub => [ "message", "\n", "[0x03]" ] }
xml {
force_array => false
source => "message"
target => "myxml"
}
ruby {
code => '
event.get("myxml").each { |k, v|
event.set(k,v)
}
'
}
mutate {
remove_field => "host"
remove_field => "event"
remove_field => "message"
remove_field => "@version"
remove_field => "myxml"
remove_field => "LINENO"
copy => { "@timestamp" => "event.ingested" }
rename =>{ "GENID" => "[@metadata][altuuid]" }
rename =>{ "HOST" => "apphost" }
rename =>{ "APPLICATION" => "exename" }
rename =>{ "APPVERSION" => "exeversion" }
rename =>{ "EVENTSEQNO" => "eventseqno" }
rename =>{ "EVENTNAME" => "eventname" }
rename =>{ "EVENTINFO" => "eventinfo" }
rename =>{ "SEVERITY" => "severity" }
rename =>{ "EVENTDATETIME" => "logeventdate" }
rename =>{ "THREADID" => "threadid" }
rename =>{ "INSTANCEID" => "instanceid" }
gsub => [ "logeventdate", "(\d{2}):(\d{3})$", "\1.\2" ]
}
jdbc_static {
id => "udplogstash"
jdbc_driver_library => "D:\\sqljdbc_12.10\\enu\\jars\\mssql-jdbc-12.10.0.jre11.jar"
jdbc_connection_string => "jdbc:sqlserver://;serverName=mysqlserverhost;databaseName=mydatabasename;integratedSecurity=true;authenticationScheme=NativeAuthentication;encrypt=false;"
jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
loader_schedule => "*/30 * * * *"
local_db_objects => [
{
name => "localstore"
index_columns => ["RNID"]
columns => [
["RNID", "int"],
["ChainCode", "int"],
["ServiceName", "varchar(100)"],
["ProcessorPartner", "varchar(100)"]
]
}
]
loaders => [
{
id => "dbquery"
query => "usp_GetLoggerRNIDInfo_1_10_100"
local_table => "localvars"
}
]
local_lookups => [
{
id => "loadingdata"
query => "select ChainCode from localstore where RNID = :RNID"
parameters => { RNID => "1"}
target => "[metadata][ChainCode]"
default_hash => {
ChainCode => ""
}
}
]
}
}
output {
file {
path => "/log_streaming/my_app/records/log-%{+yyyy-MM-dd_HH.mm.ss.SSS}.log"
}
elasticsearch {
hosts => "https://myelasticistance:9200"
user => "username"
password => "password"
ssl_certificate_verification => "false"
index => "delphi-processlog_write"
document_id => "%{[@metadata][altuuid]}"
doc_as_upsert => "true"
}
}
I receive this error:
Pipeline error {:pipeline_id=>"test", :exception=>#<LogStash::Filters::Jdbc::ConnectionJdbcException: Java::ComMicrosoftSqlserverJdbc::SQLServerException: This driver is not configured for integrated authentication.
I have read that I am missing the mssql-jdbc_auth-xx.xx.x.x64/86.dll somewhere I cannot figure out where having them in the downloaded folder D:\sqljdbc_12.10\enu\auth\x64/86.
I have downloaded the drivers from
Could you help me?