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 => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
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.