# Configuration error

**URL:** <https://discuss.elastic.co/t/configuration-error/119904>\
**Category:** Logstash\
**Created:** [February 15, 2018, 4:14am UTC](https://discuss.elastic.co/t/configuration-error/119904 "2018-02-15T04:14:14Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sudhakar\_N](https://avatars.discourse-cdn.com/v4/letter/s/b2d939/32.png) [@Sudhakar\_N](https://discuss.elastic.co/u/Sudhakar_N)\
**Post date:** [February 15, 2018, 4:14am UTC](https://discuss.elastic.co/t/configuration-error/119904/1 "2018-02-15T04:14:14Z")

</div>

when i run logstash i am getting below error.

[ERROR] 2018-02-15 09:32:09.497 [Ruby-0-Thread-1: /home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/stud-0.0.23/lib/stud/task.rb:22] agent - Failed to execute action {:action=\>LogStash::PipelineAction::Create/pipeline\_id:main, :exception=\>"LogStash::ConfigurationError", :message=\>"Expected one of #, {, } at line 5, column 18 (byte 149) after input {\r\n jdbc {\r\n\tjdbc\_connection\_string=\>"jdbc:postgresql://192.168.1.66:5432/mems\_mixed\_db\_2016\_11\_03"\r\n\tjdbc\_user=\>"postgres\r\n\tjdbc\_password=\>"", :backtrace=\>["/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/compiler.rb:42:in `compile_imperative'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/compiler.rb:50:in`compile\_graph'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/compiler.rb:12:in `block in compile_sources'", "org/jruby/RubyArray.java:2486:in`map'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/compiler.rb:11:in `compile_sources'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:51:in`initialize'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:169:in `initialize'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/pipeline_action/create.rb:40:in`execute'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/agent.rb:315:in `block in converge_state'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/agent.rb:141:in`with\_pipelines'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/agent.rb:312:in `block in converge_state'", "org/jruby/RubyArray.java:1734:in`each'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/agent.rb:299:in `converge_state'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/agent.rb:166:in`block in converge\_state\_and\_update'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/agent.rb:141:in `with_pipelines'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/agent.rb:164:in`converge\_state\_and\_update'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/agent.rb:90:in `execute'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/runner.rb:348:in`block in execute'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/stud-0.0.23/lib/stud/task.rb:24:in `block in initialize'"]}  
[INFO] 2018-02-15 09:32:09.808 [Api Webserver] agent - Successfully started Logstash API endpoint {:port=\>9600}

And My db.conf file is

input {  
jdbc {  
jdbc\_connection\_string=\>"jdbc:postgresql://localhpost/mems\_mixed\_db\_2016\_11\_03"  
jdbc\_user=\>"postgres  
jdbc\_password=\>"postgres  
jdbc\_validate\_connection =\> true  
jdbc\_driver\_library=\>"/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/drivers/postgresql-42.2.1.jar"  
#the name of the driver class for postgres  
jdbc\_driver\_class=\>"org.postgresql.Driver"  
#our query  
statement=\>"select ct\_ctid,ct\_lname from giscities\_ref;"  
}  
}

output {  
elasticsearch {  
#protocol =\> http  
index=\>"cities"  
document\_type=\>"giscities\_ref"  
document\_id =\>%{ct\_ctid}  
host =\> "localhost:9200"  
}  
}

please provide the solution

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [February 15, 2018, 4:54am UTC](https://discuss.elastic.co/t/configuration-error/119904/2 "2018-02-15T04:54:09Z")

</div>

You seem to be missing quite a few closing quotes, eg lines 5 and 6.

---

<div class="post-metadata">

**Author:** ![Sudhakar\_N](https://avatars.discourse-cdn.com/v4/letter/s/b2d939/32.png) [@Sudhakar\_N](https://discuss.elastic.co/u/Sudhakar_N)\
**Post date:** [February 15, 2018, 5:03am UTC](https://discuss.elastic.co/t/configuration-error/119904/3 "2018-02-15T05:03:28Z")

</div>

i modified the config file and run the logstash. and i got the below error

WARN ] 2018-02-15 10:31:24.653 [LogStash::Runner] multilocal - Ignoring the 'pipelines.yml' file because modules or command line options are specified  
[INFO] 2018-02-15 10:31:24.832 [LogStash::Runner] runner - Starting Logstash {"logstash.version"=\>"6.2.1"}  
[INFO] 2018-02-15 10:31:25.000 [Api Webserver] agent - Successfully started Logstash API endpoint {:port=\>9600}  
[ERROR] 2018-02-15 10:31:25.217 [Ruby-0-Thread-1: /home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/stud-0.0.23/lib/stud/task.rb:22] agent - Failed to execute action {:action=\>LogStash::PipelineAction::Create/pipeline\_id:main, :exception=\>"LogStash::ConfigurationError", :message=\>"Expected one of #, ", ', -, [, { at line 22, column 19 (byte 674) after output {\r\n elasticsearch {\n #protocol =\> http\r\n index=\>"cities"\r\n document\_type=\>"giscities\_ref"\r\n document\_id =\>", :backtrace=\>["/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/compiler.rb:42:in `compile_imperative'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/compiler.rb:50:in`compile\_graph'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/compiler.rb:12:in `block in compile_sources'", "org/jruby/RubyArray.java:2486:in`map'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/compiler.rb:11:in `compile_sources'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:51:in`initialize'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:169:in `initialize'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/pipeline_action/create.rb:40:in`execute'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/agent.rb:315:in `block in converge_state'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/agent.rb:141:in`with\_pipelines'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/agent.rb:312:in `block in converge_state'", "org/jruby/RubyArray.java:1734:in`each'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/agent.rb:299:in `converge_state'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/agent.rb:166:in`block in converge\_state\_and\_update'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/agent.rb:141:in `with_pipelines'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/agent.rb:164:in`converge\_state\_and\_update'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/agent.rb:90:in `execute'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/logstash-core/lib/logstash/runner.rb:348:in`block in execute'", "/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/vendor/bundle/jruby/2.3.0/gems/stud-0.0.23/lib/stud/task.rb:24:in `block in initialize'"]}

My config file is

input {  
jdbc {  
jdbc\_connection\_string=\>"jdbc:postgresql://192.168.1.66/mems\_mixed\_db\_2016\_11\_03"  
jdbc\_user=\>"postgres"  
jdbc\_password=\>"postgres"  
jdbc\_validate\_connection =\> "true"  
jdbc\_driver\_library=\>"/home/suryakiran/sudhakar/elk/logstash-6.2.1/usr/share/logstash/drivers/postgresql-42.2.1.jar"  
#the name of the driver class for postgres  
jdbc\_driver\_class=\>"org.postgresql.Driver"  
#our query  
statement=\>"select ct\_ctid,ct\_lname from giscities\_ref;"  
type =\> "Database"  
tags =\> ["cities", "import"]  
}  
}

output {  
elasticsearch {  
#protocol =\> http  
index=\>"cities"  
document\_type=\>"giscities\_ref"  
document\_id =\>%{ct\_ctid}  
host =\> "localhost:9200"  
}  
}

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [February 15, 2018, 5:04am UTC](https://discuss.elastic.co/t/configuration-error/119904/4 "2018-02-15T05:04:10Z")

</div>

> [@Sudhakar\_N](#):
>
> Expected one of #, ", ', -, [, { at line 22, column 19 (byte 674)

That's why.

---

<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:** [March 15, 2018, 5:04am UTC](https://discuss.elastic.co/t/configuration-error/119904/5 "2018-03-15T05:04:14Z")

</div>

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