# Logstash Postgresql error

**URL:** https://discuss.elastic.co/t/logstash-postgresql-error/302864
**Category:** Logstash
**Created:** [April 21, 2022, 2:16am UTC](https://discuss.elastic.co/t/logstash-postgresql-error/302864 "2022-04-21T02:16:01Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![shrikantgulia](https://avatars.discourse-cdn.com/v4/letter/s/c68b51/32.png) [@shrikantgulia](https://discuss.elastic.co/u/shrikantgulia)
#### Post date: [April 21, 2022, 2:16am UTC](https://discuss.elastic.co/t/logstash-postgresql-error/302864/1 "2022-04-21T02:16:01Z")

</div>

Dear Team,

I faced the below error while fetching logs from postgresql DB

ERROR] 2022-04-20 10:26:51.485 [Converge PipelineAction::Create] jdbc - Missing a required setting for the jdbc input plugin:

input {  
jdbc {  
jdbc\_user =\> # SETTING MISSING  
...  
}  
}  
[ERROR] 2022-04-20 10:26:51.489 [Converge PipelineAction::Create] agent - Failed to execute action {:action=\>LogStash::PipelineAction::Create/pipeline\_id:main, :exception=\>"Java::JavaLang::IllegalStateException", :message=\>"Unable to configure plugins: (ConfigurationError) Something is wrong with your configuration.", :backtrace=\>["org.logstash.config.ir.CompiledPipeline.(CompiledPipeline.java:119)", "org.logstash.execution.JavaBasePipelineExt.initialize(JavaBasePipelineExt.java:86)", "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:1169)", "org.jruby.ir.runtime.IRRuntimeHelpers.instanceSuperSplatArgs(IRRuntimeHelpers.java:1156)", "org.jruby.ir.targets.InstanceSuperInvokeSite.invoke(InstanceSuperInvokeSite.java:39)", "usr.share.logstash.logstash\_minus\_core.lib.logstash.java\_pipeline.RUBY$method$initialize$0(/usr/share/logstash/logstash-core/lib/logstash/java\_pipeline.rb:47)", "org.jruby.internal.runtime.methods.CompiledIRMethod.call(CompiledIRMethod.java:80)", "org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:70)", "org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:333)", "org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:87)", "org.jruby.RubyClass.newInstance(RubyClass.java:939)", "org.jruby.RubyClass$INVOKER$i$newInstance.call(RubyClass$INVOKER$i$newInstance.gen)", "org.jruby.ir.targets.InvokeSite.invoke(InvokeSite.java:207)", "usr.share.logstash.logstash\_minus\_core.lib.logstash.pipeline\_action.create.RUBY$method$execute$0(/usr/share/logstash/logstash-core/lib/logstash/pipeline\_action/create.rb:52)", "usr.share.logstash.logstash\_minus\_core.lib.logstash.pipeline\_action.create.RUBY$method$execute$0$ **VARARGS** (/usr/share/logstash/logstash-core/lib/logstash/pipeline\_action/create.rb)", "org.jruby.internal.runtime.methods.CompiledIRMethod.call(CompiledIRMethod.java:80)", "org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:70)", "org.jruby.ir.targets.InvokeSite.invoke(InvokeSite.java:207)", "usr.share.logstash.logstash\_minus\_core.lib.logstash.agent.RUBY$block$converge\_state$2(/usr/share/logstash/logstash-core/lib/logstash/agent.rb:391)", "org.jruby.runtime.CompiledIRBlockBody.callDirect(CompiledIRBlockBody.java:138)", "org.jruby.runtime.IRBlockBody.call(IRBlockBody.java:58)", "org.jruby.runtime.IRBlockBody.call(IRBlockBody.java:52)", "org.jruby.runtime.Block.call(Block.java:139)", "org.jruby.RubyProc.call(RubyProc.java:318)", "org.jruby.internal.runtime.RubyRunnable.run(RubyRunnable.java:105)", "java.base/java.lang.Thread.run(Thread.java:829)"]}  
warning: thread "Converge PipelineAction::Create" terminated with exception (report\_on\_exception is true):  
LogStash::Error: Don't know how to handle `Java::JavaLang::IllegalStateException` for `PipelineAction::Create<main>`  
create at org/logstash/execution/ConvergeResultExt.java:135  
add at org/logstash/execution/ConvergeResultExt.java:60  
converge\_state at /usr/share/logstash/logstash-core/lib/logstash/agent.rb:404  
[ERROR] 2022-04-20 10:26:51.497 [Agent thread] agent - An exception happened when converging configuration {:exception=\>LogStash::Error, :message=\>"Don't know how to handle `Java::JavaLang::IllegalStateException` for `PipelineAction::Create<main>`"}  
[FATAL] 2022-04-20 10:26:51.503 [LogStash::Runner] runner - An unexpected error occurred! {:error=\>#\<LogStash::Error: Don't know how to handle `Java::JavaLang::IllegalStateException` for `PipelineAction::Create<main>`\>, :backtrace=\>["org/logstash/execution/ConvergeResultExt.java:135:in `create'", "org/logstash/execution/ConvergeResultExt.java:60:in `add'", "/usr/share/logstash/logstash-core/lib/logstash/agent.rb:404:in `block in converge\_state'"]}  
[FATAL] 2022-04-20 10:26:51.537 [LogStash::Runner] Logstash - Logstash stopped processing because of an error: (SystemExit) exit  
org.jruby.exceptions.SystemExit: (SystemExit) exit  
at org.jruby.RubyKernel.exit(org/jruby/RubyKernel.java:747) ~[jruby-complete-9.2.19.0.jar:?]  
at org.jruby.RubyKernel.exit(org/jruby/RubyKernel.java:710) ~[jruby-complete-9.2.19.0.jar:?]  
at usr.share.logstash.lib.bootstrap.environment.(/usr/share/logstash/lib/bootstrap/environment.rb:89) ~[?:?]

my logstash config is

\</\>  
input {  
jdbc {  
jdbc\_connection\_string =\> "jdbc:postgresql://lioteruser:liotaccesstodb@name-db-read-only--user-46789913-1.b.db.oldigitalocean.com:25060/data?sslmode=require"  
jdbc\_driver\_class =\> "org.postgresql.Driver"  
statement =\> "SELECT \* from project"  
}  
}  
output {  
Elasticsearch {  
hosts =\> "localhost:9200"  
index =\> "users"  
}  
}  
\</\>  
a help would be highly appreciated

Regards  
Shrikant

---

<div class="post-metadata">

### Author: ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)
#### Post date: [April 21, 2022, 2:36am UTC](https://discuss.elastic.co/t/logstash-postgresql-error/302864/2 "2022-04-21T02:36:22Z")

</div>

> [@shrikantgulia](#):
>
> jdbc\_user =\> # SETTING MISSING  
> ...
> 
> jdbc\_connection\_string =\> "jdbc:postgresql://foo:bar@name-db-read-only--user-46789913-1.b.db.oldigitalocean.com:25060/data?sslmode=require"

You cannot use [foo:bar@hostname.com](mailto:foo:bar@hostname.com) to provide the username and password as part of the connection string. Remove them there and add them to the input using

```
jdbc_user => "foo"
jdbc_password => "bar"

```

---

<div class="post-metadata">

### Author: ![shrikantgulia](https://avatars.discourse-cdn.com/v4/letter/s/c68b51/32.png) [@shrikantgulia](https://discuss.elastic.co/u/shrikantgulia)
#### Post date: [April 21, 2022, 4:44am UTC](https://discuss.elastic.co/t/logstash-postgresql-error/302864/3 "2022-04-21T04:44:29Z")

</div>

@Badger thankyou,  
i though username name and password within connection string will work

---

<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: [May 19, 2022, 4:45am UTC](https://discuss.elastic.co/t/logstash-postgresql-error/302864/4 "2022-05-19T04:45:10Z")

</div>

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