# Unable to install output-jdbc plugin on logstash

**URL:** <https://discuss.elastic.co/t/unable-to-install-output-jdbc-plugin-on-logstash/273062>\
**Category:** Logstash\
**Created:** [May 14, 2021, 7:48pm UTC](https://discuss.elastic.co/t/unable-to-install-output-jdbc-plugin-on-logstash/273062 "2021-05-14T19:48:49Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Anoop\_kumar\_SRIVASTA](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/anoop_kumar_srivasta/32/88785_2.png) [@Anoop\_kumar\_SRIVASTA](https://discuss.elastic.co/u/Anoop_kumar_SRIVASTA)\
**Post date:** [May 14, 2021, 7:48pm UTC](https://discuss.elastic.co/t/unable-to-install-output-jdbc-plugin-on-logstash/273062/1 "2021-05-14T19:48:49Z")

</div>

Hi  
I am facing issue while connecting logstash output send to mysql database..below are my configuration setting  
output {  
jdbc{  
driver\_jar\_path =\> "/app/logstash-CBS/mysql-connector-java-8.0.25.jar"  
driver\_class =\> "com.mysql.jdbc.Driver"  
connection\_string =\> "jdbc:mysql://172.23.224.174:3306/OLTP?autoReconnect=true&user=appmonitordb&password=Welcome@2021$"  
statement =\> ["INSERT INTO CBS(timestamp,MessageId,Command,Id,dateTime,rspCode,DccID) values(?,?,?,?,?,?,?)","[timestamp]","[MessageId]","[Command]" ,"[Id]","[dateTime]","[rspCode]","[DccID"]  
}  
stdout { codec =\> rubydebug }  
}  
Post Configuration when we ran the logstash getting below mentioned error  
./logstash -f ../../Setup/CBC.conf  
Thread.exclusive is deprecated, use Thread::Mutex  
Sending Logstash logs to /app/logstash-CBS/logs which is now configured via log4j2.properties  
[2021-05-15T01:10:05,688][WARN][logstash.config.source.multilocal] Ignoring the 'pipelines.yml' file because modules or command line options are specified  
[2021-05-15T01:10:05,795][INFO][logstash.runner] Starting Logstash {"logstash.version"=\>"7.5.1"}  
[2021-05-15T01:10:07,893][INFO][org.reflections.Reflections] Reflections took 38 ms to scan 1 urls, producing 20 keys and 40 values  
[2021-05-15T01:10:08,356][ERROR][logstash.plugins.registry] Tried to load a plugin's code, but failed. {:exception=\>#\<LoadError: no such file to load -- logstash/outputs/jdbc\>, :path=\>"logstash/outputs/jdbc", :type=\>"output", :name=\>"jdbc"}  
[2021-05-15T01:10:08,374][ERROR][logstash.agent] Failed to execute action {:action=\>LogStash::PipelineAction::Create/pipeline\_id:main, :exception=\>"Java::JavaLang::IllegalStateException", :message=\>"Unable to configure plugins: (PluginLoadingError) Couldn't find any output plugin named 'jdbc'. Are you sure this is correct? Trying to load the jdbc output plugin resulted in this error: no such file to load -- logstash/outputs/jdbc", :backtrace=\>["org.logstash.config.ir.CompiledPipeline.(CompiledPipeline.java:100)", "org.logstash.execution.JavaBasePipelineExt.initialize(JavaBasePipelineExt.java:60)", "org.logstash.execution.JavaBasePipelineExt$INVOKER$i$1$0$initialize.call(JavaBasePipelineExt$INVOKER$i$1$0$initialize.gen)", "org.jruby.internal.runtime.methods.JavaMethod$JavaMethodN.call(JavaMethod.java:837)", "org.jruby.ir.runtime.IRRuntimeHelpers.instanceSuper(IRRuntimeHelpers.java:1156)", "org.jruby.ir.runtime.IRRuntimeHelpers.instanceSuperSplatArgs(IRRuntimeHelpers.java:1143)", "org.jruby.ir.targets.InstanceSuperInvokeSite.invoke(InstanceSuperInvokeSite.java:39)", "app.logstash\_minus\_CBS.logstash\_minus\_core.lib.logstash.java\_pipeline.RUBY$method$initialize$0(/app/logstash-CBS/logstash-core/lib/logstash/java\_pipeline.rb:27)", "org.jruby.internal.runtime.methods.CompiledIRMethod.call(CompiledIRMethod.java:91)", "org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:90)", "org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:332)", "org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:86)", "org.jruby.RubyClass.newInstance(RubyClass.java:915)", "org.jruby.RubyClass$INVOKER$i$newInstance.call(RubyClass$INVOKER$i$newInstance.gen)", "org.jruby.ir.targets.InvokeSite.invoke(InvokeSite.java:183)", "app.logstash\_minus\_CBS.logstash\_minus\_core.lib.logstash.pipeline\_action.create.RUBY$method$execute$0(/app/logstash-CBS/logstash-core/lib/logstash/pipeline\_action/create.rb:36)", "app.logstash\_minus\_CBS.logstash\_minus\_core.lib.logstash.pipeline\_action.create.RUBY$method$execute$0$ **VARARGS** (/app/logstash-CBS/logstash-core/lib/logstash/pipeline\_action/create.rb)", "org.jruby.internal.runtime.methods.CompiledIRMethod.call(CompiledIRMethod.java:91)", "org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:90)", "org.jruby.ir.targets.InvokeSite.invoke(InvokeSite.java:183)", "app.logstash\_minus\_CBS.logstash\_minus\_core.lib.logstash.agent.RUBY$block$converge\_state$2(/app/logstash-CBS/logstash-core/lib/logstash/agent.rb:326)", "org.jruby.runtime.CompiledIRBlockBody.callDirect(CompiledIRBlockBody.java:136)", "org.jruby.runtime.IRBlockBody.call(IRBlockBody.java:77)", "org.jruby.runtime.Block.call(Block.java:129)", "org.jruby.RubyProc.call(RubyProc.java:295)", "org.jruby.RubyProc.call(RubyProc.java:274)", "org.jruby.RubyProc.call(RubyProc.java:270)", "org.jruby.internal.runtime.RubyRunnable.run(RubyRunnable.java:105)", "java.lang.Thread.run(Thread.java:748)"]}

Error Descriptiopn : output-jdbc plugin unable to upload

I tried to multiple steps as per suggested offline upload the output-jdbc plugin but still not able achieve the result.

---

<div class="post-metadata">

**Author:** ![Wolfram\_Haussig](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wolfram_haussig/32/70528_2.png) [@Wolfram\_Haussig](https://discuss.elastic.co/u/Wolfram_Haussig)\
**Post date:** [May 16, 2021, 10:42am UTC](https://discuss.elastic.co/t/unable-to-install-output-jdbc-plugin-on-logstash/273062/2 "2021-05-16T10:42:40Z")

</div>

Hi,

Which LogStash version are you using and where did you get the jdbc output plugin from?

The only jdbc output plugin I am aware of is: [GitHub - theangryangel/logstash-output-jdbc: JDBC output for Logstash](https://github.com/theangryangel/logstash-output-jdbc) which is no longer maintained. This project only supported logStash 5.x and 6.x as far as I know.

It is possible that you are trying to install a plugin which does not support your LogStash version.

Best regards  
Wolfram

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [June 13, 2021, 10:42am UTC](https://discuss.elastic.co/t/unable-to-install-output-jdbc-plugin-on-logstash/273062/3 "2021-06-13T10:42:59Z")

</div>

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