I created a logstash config file with the following code
input {
jdbc {
jdbc_connection_string => "jdbc:sqlserver://localhost/serverName;database=dbName;integratedSecurity=true"
jdbc_driver_library => "C:/Users/palti/JDBD/sqljdbc_4.2/enu/jre8/sqljdbc42.jar"
jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
statement => "SELECT * FROM catalog"
}
}
output {
elasticsearch {
hosts => ["localhost:9200","localhost:9201"]
index => "catalog"
}
}
And when I run my logstash with the following command:
`bin/logstash -f C:/Users/palti/Desktop/logstash-7.9.1/bin/test2.conf`
It seems that logstash is not picking up my config file. This is what I get from the console:
Java HotSpot(TM) 64-Bit Server VM warning: Ignoring option UseConcMarkSweepGC; support was removed in 14.0
Java HotSpot(TM) 64-Bit Server VM warning: Ignoring option CMSInitiatingOccupancyFraction; support was removed in 14.0
Java HotSpot(TM) 64-Bit Server VM warning: Ignoring option UseCMSInitiatingOccupancyOnly; support was removed in 14.0
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by org.jruby.ext.openssl.SecurityHelper (file:/C:/Users/steph/AppData/Local/Temp/jruby-25472/jruby1742364261552339428jopenssl.jar) to field java.security.MessageDigest.provider
WARNING: Please consider reporting this to the maintainers of org.jruby.ext.openssl.SecurityHelper
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
Sending Logstash logs to C:/Users/palti/Desktop/logstash-7.9.1/logs which is now configured via log4j2.properties
[2020-09-10T16:23:02,242][INFO ][logstash.runner ] Starting Logstash {"logstash.version"=>"7.9.1", "jruby.version"=>"jruby 9.2.13.0 (2.5.7) 2020-08-03 9a89c94bcc Java HotSpot(TM) 64-Bit Server VM 14.0.2+12-46 on 14.0.2+12-46 +indy +jit [mswin32-x86_64]"}
[2020-09-10T16:23:02,446][WARN ][logstash.config.source.multilocal] Ignoring the 'pipelines.yml' file because modules or command line options are specified
[2020-09-10T16:23:02,882][ERROR][logstash.config.sourceloader] No configuration found in the configured sources.
[2020-09-10T16:23:03,291][INFO ][logstash.agent ] Successfully started Logstash API endpoint {:port=>9600}
[2020-09-10T16:23:08,215][INFO ][logstash.runner ] Logstash shut down.
[2020-09-10T16:23:08,249][ERROR][org.logstash.Logstash ] java.lang.IllegalStateException: Logstash stopped processing because of an error: (SystemExit) exit
No idea what I'm missing, any help is appreciated.
I'm on windows 10 and everything is running local, got 2 nodes for elasticsearch and kibana running