Hi,
I am a newbie to logstash/ELK and have a requirement of creating a working poc to monitor db trends, MQs and specific folders.
I created a basic config file below and tried running it with a vpn connection to client network:
input {
jdbc {
jdbc_validate_connection => true
jdbc_connection_string => "jdbc:oracle:thin:\\client_ip:1521\client_sid"
jdbc_user => "username"
jdbc_password => "password"
jdbc_driver_library => "D:\Darpan\Integration\Enhancements\ELK\ojdbc7.jar"
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
statement => "SELECT sysdate from dual"
}
}
output {
stdout {
#codec => rubydebug
debug => true
}
}
Output error(excerpt from long error):
Settings: Default pipeline workers: 8
←[31mPipeline aborted due to error {:exception=>"Sequel::DatabaseConnectionError
", :backtrace=>["oracle.jdbc.driver.T4CConnection.logon(oracle/jdbc/driver/T4CCo
nnection.java:743)", "oracle.jdbc.driver.PhysicalConnection.connect(oracle/jdbc/
driver/PhysicalConnection.java:666)", "oracle.jdbc.driver.T4CDriverExtension.get
Connection(oracle/jdbc/driver/T4CDriverExtension.java:32)", "oracle.jdbc.driver.
OracleDriver.connect(oracle/jdbc/driver/OracleDriver.java:566)", "java.lang.refl
ect.Method.invoke(java/lang/reflect/Method.java:483)", "RUBY.connect(D:/Darpan/I
ntegration/Enhancements/ELK/logstash-2.4.0/vendor/bundle/jruby/1.9/gems/sequel-4
Cannot find much information from the error apart from that its a connection error however db is getting connected via sqldeveloper side by side.
Any suggestions will be much helpful.
Thanks,