(Need Help) Import data from mysql to elasticsearch using logstash


(Angga Kurniawan) #1

help me please for Import data from mysql to elasticsearch using logstash

my logstash.conf:

input {

jdbc {
jdbc_connection_string => "jdbc:mysql://localhost:3306/angga1"
jdbc_user => "root"
jdbc_password => ""
jdbc_driver_library => "/home/angga/Downloads/mysql-connector-java-5.1.45/mysql-connector-java-5.1.45-bin.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"

statement => "SELECT * FROM table2"
}

}

output {
stdout { codec => json_lines }
elasticsearch {
hosts => "localhost"
index => "search1"
document_type => "table2"
}
}

can someone help me?


(Angga Kurniawan) #2

Error:

Help me Please :slight_smile:


(Christian Dahlqvist) #3

Please do not post images of text as they can be very hard to read and can also not be searched.


#4

What happens if you run telnet localhost 3306?


(system) #5

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