Logstash ms sql connector


(Anuar Mukatov) #1

Hello!
I have some trouble with jdbc input plugin. How i can connect to ms sql database with windows domain authentication?
I know how connect with sql login name, but i can't understand how to connect with domain username?

My config file -

input {
jdbc {
jdbc_driver_library => "/etc/logstash/drivers/enu/jre8/sqljdbc42.jar"
jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
jdbc_connection_string => "jdbc:jtds:sqlserver://server:1433;databasename=2008"
jdbc_user => "login"
jdbc_password => "pass"
statement => "SELECT m.*
, mc.nameRu AS CategoryNameRu
, mt.nameRu AS TypeNameRu
, ms.nameRu AS SourceNameRu
, p.Fio_Ru
, s.RowName AS LoginName
, pos.FullNameRu AS PositionNameRu
FROM LOG_Messages m
JOIN DIC_LOG_MESSAGE_SOURCE_TO_TYPE mst ON mst.id = m.refMessageSourceType
JOIN DIC_LOG_MESSAGE_CATEGORY mc ON mc.id = mst.refMessageCategory
JOIN DIC_LOG_MESSAGE_TYPE mt ON mt.id = mst.refMessageType
JOIN DIC_LOG_MESSAGE_SOURCE ms ON ms.id = mst.refMessageSource
LEFT JOIN ULS_Persons p ON p.id = m.refRecordCard
LEFT JOIN LOG_SidIdentification s ON s.id = m.refSid
LEFT JOIN ULS_SubdivisionPositions pos ON pos.id = m.refPosition
where datetime > :sql_last_value"
use_column_value => "true"
tracking_column => "datetime"
}

(Anuar Mukatov) #2

Where are you guru of logstash? =)


(Anuar Mukatov) #3

Anyone?


(Anuar Mukatov) #4

I found my problem solution =)

 jdbc_driver_library => "/etc/logstash/drivers/jtds-1-2/jtds-1.3.1.jar"
 jdbc_driver_class => "Java::net.sourceforge.jtds.jdbc.Driver"
 jdbc_connection_string => "jdbc:jtds:sqlserver://server:1433;domain=NAME;integratedsecurity=true;databasename=2008"
 jdbc_user => "login"
 jdbc_password => "pass"

(system) #5

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