No data load by logstash on sqlserver database

Hi, I installed logstash as a service on a redhat 7 server, everything seems to be correctly configured, but logstash does not load anything. I asked him to ask every minute, but nothing happens !

My logstash.conf :

input {
jdbc {
jdbc_driver_library => "sqljdbc42.jar"
jdbc_driver_class => ""
jdbc_connection_string => "jdbc:sqlserver://SQL/PRD:1433;databaseName=MaBase;integratedSecurity=true;"
jdbc_user => "user"
jdbc_password => "pass"
schedule => "1 * * * *"
statement => "SELECT datetime, probename, customer, host, servicename, target, availability, setuptime, responsetime, transfertput, metric_1, metric_2, metric_3, metric_4, metric_5, metric_6, metric_7, metric_8, interval, slo_violations FROM MaBase dat where (datetime) in (SELECT max(datetime) FROM MaBase dat2 where datetime > (select cast(getDate() As Date)) and dat.servicename=dat2.servicename group by servicename) order by servicename;"

input {
beats {
port => 5044

output {
elasticsearch {
hosts => ["http://susis:9200"]
index => "%{[@metadata][beat]}-%{[@metadata][version]}-%{+YYYY.MM.dd}"

the query works very well and brings back a 100 of records. It is scheduled every minute.

My logstash.yml :
config.debug: true
log.level: debug

My Logstash-plain.log en mode DEBUG does not signal any problem !

How can i see what logstash does ?

Where do we have to look to follow logstash activity?

Thanks for your Help, Michel.

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