Discussion on: Elasticsearch in Laradock

[Boy Thanakorn]

Dockerfile
ARG ELK_VERSION=7.5.1
FROM docker.elastic.co/logstash/logstash:${ELK_VERSION}

USER root
RUN rm -f /usr/share/logstash/pipeline/logstash.conf
RUN curl -L -o /usr/share/logstash/lib/mysql-connector-java-5.1.47.jar repo1.maven.org/maven2/mysql/mysql...
RUN curl -L -o /usr/share/logstash/lib/mssql-jdbc-9.2.1.jre11.jar github.com/microsoft/mssql-jdbc/re...
ADD ./pipeline/ /usr/share/logstash/pipeline/
ADD ./config/ /usr/share/logstash/config/

RUN logstash-plugin install logstash-input-jdbc
RUN logstash-plugin install logstash-input-beats

---

pipeline.conf
input {
jdbc {
jdbc_driver_library => "/usr/share/logstash/lib/mssql-jdbc-9.2.1.jre11.jar"
jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
jdbc_connection_string => "jdbc:sqlserver://servername:1433;databaseName=DatabaseName;"
jdbc_user => "user"
jdbc_password => "password"
statement => "SELECT * FROM DatabaseName..users"
schedule => "1 * * * *"
}
}
filter {

}
output {
elasticsearch {
hosts => "elasticsearch:9200"
index => "users"
document_type => "user"
}
stdout { codec => rubydebug }
}