# Why is my conf not running

**URL:** <https://discuss.elastic.co/t/why-is-my-conf-not-running/84309>\
**Category:** Logstash\
**Created:** [May 2, 2017, 6:07pm UTC](https://discuss.elastic.co/t/why-is-my-conf-not-running/84309 "2017-05-02T18:07:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Paul\_Spedding](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/paul_spedding/32/46958_2.png) [@Paul\_Spedding](https://discuss.elastic.co/u/Paul_Spedding)\
**Post date:** [May 2, 2017, 6:07pm UTC](https://discuss.elastic.co/t/why-is-my-conf-not-running/84309/1 "2017-05-02T18:07:46Z")

</div>

Hi,  
I'm using this line to input data  
/etc/logstash/conf.d# /usr/share/logstash/bin/logstash -f mySql.conf --deb --debug-config  
Now here is my config

# file: simple-out.conf

input {  
jdbc {  
# Postgres jdbc connection string to our database, mydb  
jdbc\_connection\_string =\> "jdbc:mysql://localhost:3306/tweets"  
# The user we wish to execute our statement as  
jdbc\_user =\> "root"  
# The path to our downloaded jdbc driver  
jdbc\_driver\_library =\> "/etc/elasticsearch/elasticsearch-jdbc-2.3.3.1/lib/mysql-connector-java-5.1.38.jar"  
# The name of the driver class for Postgresql  
jdbc\_driver\_class =\> "com.mysql.jdbc.Driver"  
jdbc\_user =\> "root"  
jdbc\_password =\> "Derp"  
# our query  
statement =\> "SELECT \* from tweets"  
}  
}

filter{  
mutate{  
convert =\> {  
"ID" =\> "integer"  
"AUTHOR" =\> "string"  
"RETWEET\_COUNT" =\> "integer"  
"FAVORITE\_COUNT" =\> "integer"  
"FOLLOWERS\_COUNT" =\> "integer"  
"FRIENDS\_COUNT" =\> "integer"  
"BODY" =\> "string"  
"STOCK\_PRICE" =\> "float"  
"STOCK\_CLOSE" =\> "float"  
"STOCK\_HIGH" =\> "float"  
"STOCK\_LOW" =\> "float"  
"STOCK\_OPEN" =\> "float"  
"STOCK\_VOLUME" =\> "integer"  
"SENTIMENT" =\> "float"  
}  
}  
}

output {  
elasticsearch { hosts =\> ["localhost:9200"] user =\> elastic password =\> changeme }  
stdout { codec =\> rubydebug }  
}

But everytime I go to run the conf file I get no output, i see it run via the TOP command and it uses 300%cpu for about 20 seconds and stops, where have I gone wrong?

Thanks

---

<div class="post-metadata">

**Author:** ![Xavy](https://avatars.discourse-cdn.com/v4/letter/x/e0b2c6/32.png) [@Xavy](https://discuss.elastic.co/u/Xavy)\
**Post date:** [May 2, 2017, 10:58pm UTC](https://discuss.elastic.co/t/why-is-my-conf-not-running/84309/2 "2017-05-02T22:58:51Z")

</div>

I think that for psql you will need a different jdbc driver , instead of the mysql one: [https://jdbc.postgresql.org/download.html](https://jdbc.postgresql.org/download.html)

Its class should be org.postgresql.Driver and the connection string jdbc:postgresql://host:port/database

Please check [https://jdbc.postgresql.org/documentation/94/](https://jdbc.postgresql.org/documentation/94/) for further details regarding psql jdbc driver

---

<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 30, 2017, 11:08pm UTC](https://discuss.elastic.co/t/why-is-my-conf-not-running/84309/3 "2017-05-30T23:08:23Z")

</div>

Closed on May 30, 2017, 11:08pm UTC

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