1.curl -O https://dbschema.com/jdbc-drivers/MongoDbJdbcDriver.zip
2.unzip MongoDbJdbcDriver.zip
I have downloaded and used this.
confile:
input{
jdbc{
jdbc_driver_class => "com.mongodb.jdbc.MongoDriver"
jdbc_driver_library => "/usr/share/logstash/logstash-core/lib/jars/mongodb-driver-core-4.8.1.jar"
jdbc_connection_string => "jdbc:mongodb://XXX:XXX@XXX.XXX.xXX.XXX:27017/mytestdb"
jdbc_user => "XXXXXXX"
jdbc_password => "XXXXXX"
statement => "db.getCollection('testcoll').find({})"
}
}
output{
stdout{ }
}
Currently I am writing like this
[ERROR][logstash.javapipeline ][main] Pipeline error {:pipeline_id=>"main", :exception=>#<LogStash::PluginLoadingError: #<Java::JavaLang::ClassNotFoundException: com.mongodb.jdbc.MongoDriver>. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?>, :backtrace=>["/home/admin/lg-862/vendor/bundle/jruby/2.6.0/gems/logstash-integration-jdbc-5.4.1/lib/logstash/plugin_mixins/jdbc/common.rb:45:in load_driver'", "/home/admin/lg-862/vendor/bundle/jruby/2.6.0/gems/logstash-integration-jdbc-5.4.1/lib/logstash/inputs/jdbc.rb:307:in register'", "/home/admin/lg-862/vendor/bundle/jruby/2.6.0/gems/logstash-mixin-ecs_compatibility_support-1.3.0-java/lib/logstash/plugin_mixins/ecs_compatibility_support/target_check.rb:48:in register'", "/home/admin/lg-862/logstash-core/lib/logstash/java_pipeline.rb:234:in block in register_plugins'", "org/jruby/RubyArray.java:1865:in each'", "/home/admin/lg-862/logstash-core/lib/logstash/java_pipeline.rb:233:in register_plugins'", "/home/admin/lg-862/logstash-core/lib/logstash/java_pipeline.rb:392:in start_inputs'", "/home/admin/lg-862/logstash-core/lib/logstash/java_pipeline.rb:317:in start_workers'", "/home/admin/lg-862/logstash-core/lib/logstash/java_pipeline.rb:191:in run'", "/home/admin/lg-862/logstash-core/lib/logstash/java_pipeline.rb:143:in block in start'"], "pipeline.sources"=>["/home/admin/lg-862/workshop.conf"], :thread=>"#<Thread:0x100c82d@/home/admin/lg-862/logstash-core/lib/logstash/java_pipeline.rb:131 run>"}
[2023-04-03T21:25:28,124][INFO ][logstash.javapipeline ][main] Pipeline terminated {"pipeline.id"=>"main"}
[2023-04-03T21:25:28,132][ERROR][logstash.agent ] Failed to execute action {:id=>:main, :action_type=>LogStash::ConvergeResult::FailedAction, :message=>"Could not execute action: PipelineAction::Create, action_result: false", :backtrace=>nil}
I am in this error state.