JDBC plugin doesn't work


#1

I'm trying to use the JDBC plugin has you recommended to connect to MySQL retrive query data and send to Elasticsearch for graph.
I get this error:
[2016-11-15T14:16:28,314][ERROR][logstash.agent ] fetched an invalid config

This is my config file:

input {
  jdbc {
    jdbc_driver_library => "/home/USERNAME/mysql-connector-java-5.1.40/mysql-connector-java-5.1.40-bin.jar"
    jdbc_driver_class => "com.mysql.jdbc.Driver"
    jdbc_connection_string => "USERNAME:PASSWORD://localhost:3306/mydb"
    jdbc_user => "USERNAME"
    schedule => "* * * * *"
    statement => "SELECT * from TABLE"
  }
}

output {
  elasticsearch {
       hosts => ["localhost:9200"]
       sniffing => false
       }
}

No success..
Any help?


(David Pilato) #2

Moved to #logstash


#3

Anyone ? :frowning:


(Magnus B├Ąck) #4

Is "fetched an invalid config" really the only error message you're getting?


(system) #5

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