# Error on Logstash pipeline

**URL:** <https://discuss.elastic.co/t/error-on-logstash-pipeline/246831>\
**Category:** Logstash\
**Created:** [August 29, 2020, 6:49am UTC](https://discuss.elastic.co/t/error-on-logstash-pipeline/246831 "2020-08-29T06:49:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![zellu\_rakib](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/zellu_rakib/32/74687_2.png) [@zellu\_rakib](https://discuss.elastic.co/u/zellu_rakib)\
**Post date:** [August 29, 2020, 6:49am UTC](https://discuss.elastic.co/t/error-on-logstash-pipeline/246831/1 "2020-08-29T06:49:08Z")

</div>

what is the error on this pipeline:

input {  
jdbc {  
jdbc\_driver\_library =\> "/mysql-connector-java-8.0.21.jar"  
jdbc\_driver\_class =\> "com.mysql.jdbc.Driver"  
jdbc\_connection\_string =\> "jdbc:mysql://74.117.156.179:3306/egendashboard"  
jdbc\_user =\> root  
jdbc\_password =\>Kedhar@123  
jdbc\_paging\_enabled =\> true  
tracking\_column =\> "unix\_ts\_in\_secs"  
use\_column\_value =\> true  
tracking\_column\_type =\> "numeric"  
schedule =\> "\*/5 \* \* \* \* _"  
statement =\> "select c._ ,u.name as createrName,UNIX\_TIMESTAMP(last\_updated\_date) AS unix\_ts\_in\_secs,cj.job\_id as jobId,cj.job\_title as Jobtitle,u.avathar,u.avatar\_color,u.email as createrEmail from candidates as c left join candidate\_jobs as cj on cj.candidate\_id = c.id inner join users as u on c.created\_by = u.id where (UNIX\_TIMESTAMP(last\_updated\_date) \> :sql\_last\_value AND last\_updated\_date \< NOW()) and c.status = 'active' group by c.id ORDER BY last\_updated\_date DESC"  
}  
}

filter {  
mutate {  
copy =\> { "id" =\> "[@metadata][\_id]"}  
remove\_field =\> ["id", "@version", "unix\_ts\_in\_secs"]  
}  
}

output {  
stdout { codec =\> "rubydebug"}  
elasticsearch {  
hosts =\> ["74.117.153.170:9200"]  
index =\> "candidate\_sync\_idx"  
document\_id =\> "%{[@metadata][\_id]}"  
}  
}

[2020-08-29T12:46:25,052][ERROR][logstash.agent] Failed to execute action {:action=\>LogStash::PipelineAction::Create/pipeline\_id:main, :exception=\>"LogStash::ConfigurationError", :message=\>"Expected one of [A-Za-z0-9\_-], [\t\r\n], "#", "{", [A-Za-z0-9\_], "}" at line 7, column 27 (byte 256) after input {\n jdbc {\n jdbc\_driver\_library =\> "/mysql-connector-java-8.0.21.jar"\n jdbc\_driver\_class =\> "com.mysql.jdbc.Driver"\n jdbc\_connection\_string =\> "jdbc:mysql://74.117.156.179:3306/egendashboard"\n jdbc\_user =\> root\n jdbc\_password =\>Kedhar", :backtrace=\>["/home/zillur/Desktop/Local-elk/logstash-7.5.1/logstash-core/lib/logstash/compiler.rb:41:in `compile_imperative'", "/home/zillur/Desktop/Local-elk/logstash-7.5.1/logstash-core/lib/logstash/compiler.rb:49:in `compile\_graph'", "/home/zillur/Desktop/Local-elk/logstash-7.5.1/logstash-core/lib/logstash/compiler.rb:11:in `block in compile_sources'", "org/jruby/RubyArray.java:2584:in `map'", "/home/zillur/Desktop/Local-elk/logstash-7.5.1/logstash-core/lib/logstash/compiler.rb:10:in `compile_sources'", "org/logstash/execution/AbstractPipelineExt.java:156:in `initialize'", "org/logstash/execution/JavaBasePipelineExt.java:47:in `initialize'", "/home/zillur/Desktop/Local-elk/logstash-7.5.1/logstash-core/lib/logstash/java_pipeline.rb:27:in `initialize'", "/home/zillur/Desktop/Local-elk/logstash-7.5.1/logstash-core/lib/logstash/pipeline\_action/create.rb:36:in `execute'", "/home/zillur/Desktop/Local-elk/logstash-7.5.1/logstash-core/lib/logstash/agent.rb:326:in `block in converge\_state'"]}  
[2020-08-29T12:46:25,397][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=\>9600}  
[2020-08-29T12:46:30,346][INFO][logstash.runner] Logstash shut down.

---

<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:** [August 29, 2020, 2:44pm UTC](https://discuss.elastic.co/t/error-on-logstash-pipeline/246831/2 "2020-08-29T14:44:09Z")

</div>

> [@zellu\_rakib](#):
>
> jdbc\_password =\>Kedhar@123

You need double quotes around the value of the option.

---

<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:** [September 26, 2020, 2:44pm UTC](https://discuss.elastic.co/t/error-on-logstash-pipeline/246831/3 "2020-09-26T14:44:14Z")

</div>

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