# Logstash.conf Not Working (Cannot Create Pipeline)

**URL:** <https://discuss.elastic.co/t/logstash-conf-not-working-cannot-create-pipeline/105078>\
**Category:** Logstash\
**Created:** [October 24, 2017, 2:17pm UTC](https://discuss.elastic.co/t/logstash-conf-not-working-cannot-create-pipeline/105078 "2017-10-24T14:17:50Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Anshuman\_Kirty](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@Anshuman\_Kirty](https://discuss.elastic.co/u/Anshuman_Kirty)\
**Post date:** [October 24, 2017, 2:17pm UTC](https://discuss.elastic.co/t/logstash-conf-not-working-cannot-create-pipeline/105078/1 "2017-10-24T14:17:50Z")

</div>

Logstash.conf

```
         input {
            	jdbc {
            	jdbc_connection_string => "jdbc:mysql://localhost:3306/testdb"
            	jdbc_user => "root"
            	jdbc_password ="explorer"
            	jdbc_driver_library => "C:/Users/ANSHUMAN/Desktop/mysql-connector-java-5.1.44/mysql-connector-java-5.1.44/mysql-connector-java-5.1.44-bin.jar"
            	jdbc_driver_class => "com.mysql.jdbc.Driver"
            	#our Query
            	statement => "Select * from testtable"

            	}
            }

            output{
            	stdout { codec => json_lines }
            	elasticsearch{
            	"hosts" => ["localhost:9200"]
            	protocol => "http"
            	"index" => "test-migrate"
            	"document_type" => "data"
            	}
            }

```

Error:  
Preformatted textSending Logstash's logs to E:/elasticsearch-5.6.3/logstash-5.6.3/logs which is now configured via log4j2.properties  
[2017-10-24T19:39:36,006][INFO][logstash.modules.scaffold] Initializing module {:module\_name=\>"fb\_apache", :directory=\>"E:/elasticsearch-5.6.3/logstash-5.6.3/modules/fb\_apache/configuration"}  
[2017-10-24T19:39:36,011][INFO][logstash.modules.scaffold] Initializing module {:module\_name=\>"netflow", :directory=\>"E:/elasticsearch-5.6.3/logstash-5.6.3/modules/netflow/configuration"}  
[2017-10-24T19:39:36,154][ERROR][logstash.agent] **Cannot create pipeline {:reason=\>"Expected one of #, =\> at line 5, column 16 (byte 117) after input {\n\tjdbc {\n\tjdbc\_connection\_string =\> "jdbc:mysql://localhost:3306/testdb"\n\tjdbc\_user =\> "root"\n\tjdbc\_password "}**

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [October 24, 2017, 2:34pm UTC](https://discuss.elastic.co/t/logstash-conf-not-working-cannot-create-pipeline/105078/2 "2017-10-24T14:34:51Z")

</div>

> ```
> jdbc_user => "root"
> jdbc_password ="explorer"
> 
> ```

There's a `>` missing from the second line. The error messages points to the exact location.

---

<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:** [November 21, 2017, 2:35pm UTC](https://discuss.elastic.co/t/logstash-conf-not-working-cannot-create-pipeline/105078/3 "2017-11-21T14:35:06Z")

</div>

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