Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- FROM elastic/logstash:6.3.0
- ENV https_proxy=
- ENV http_proxy=
- COPY ./mysql-connector-java-5.1.46/mysql-connector-java-5.1.46.jar /tmp/mysql-connector-java-5.1.46.jar
- COPY ./logstash.conf /tmp/logstash.conf
- COPY ./logstash.yml /usr/share/logstash/config/logstash.yml
- RUN logstash-plugin install logstash-input-jdbc
- docker run -d --rm --name=logstach -v /data/logstash:/home/logstash logstash bin/logstash -f /tmp/logstash.conf
- input {
- jdbc {
- jdbc_driver_library => "/tmp/mysql-connector-java-5.1.46.jar"
- jdbc_driver_class => "com.mysql.jdbc.Driver"
- jdbc_connection_string => "jdbc:mysql://10.0.2.22:3306/itop_db"
- jdbc_user => "admin_itop"
- jdbc_password => "XiOS7ohkUx3IQiLaNVroyAu1T"
- statement => "SELECT * FROM contact”
- }
- }
- output {
- elasticsearch {
- index => "contact"
- document_type => "data"
- document_id => "%{id}"
- hosts => "127.0.0.1:9200"
- }
- stdout { codec => json_lines }
- }
Add Comment
Please, Sign In to add comment