# Logstash mysql

**URL:** <https://discuss.elastic.co/t/logstash-mysql/335400>\
**Category:** Logstash\
**Tags:** docker\
**Created:** [June 7, 2023, 7:43am UTC](https://discuss.elastic.co/t/logstash-mysql/335400 "2023-06-07T07:43:25Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![adimi\_worou](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/adimi_worou/32/121931_2.png) [@adimi\_worou](https://discuss.elastic.co/u/adimi_worou)\
**Post date:** [June 7, 2023, 7:43am UTC](https://discuss.elastic.co/t/logstash-mysql/335400/1 "2023-06-07T07:43:25Z")

</div>

Hi, i’ve the same problem. Logstash can’t load data from mysql db to elasticsearch.

I use docker.

Thanks for your help

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [June 7, 2023, 8:55am UTC](https://discuss.elastic.co/t/logstash-mysql/335400/2 "2023-06-07T08:55:50Z")

</div>

Welcome!

The same problem of what?

What is the problem?

---

<div class="post-metadata">

**Author:** ![adimi\_worou](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/adimi_worou/32/121931_2.png) [@adimi\_worou](https://discuss.elastic.co/u/adimi_worou)\
**Post date:** [June 7, 2023, 9:54am UTC](https://discuss.elastic.co/t/logstash-mysql/335400/3 "2023-06-07T09:54:41Z")

</div>

Thank you very much.  
I have configured elasticsearch, written my docker-compose.yml and installed Dockerfile. When I launch the app with docker-compose up -d. The mysql database is not imported into elasticsearch.  
I send you my docker-compose and Dockerfile.

---

<div class="post-metadata">

**Author:** ![adimi\_worou](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/adimi_worou/32/121931_2.png) [@adimi\_worou](https://discuss.elastic.co/u/adimi_worou)\
**Post date:** [June 7, 2023, 9:55am UTC](https://discuss.elastic.co/t/logstash-mysql/335400/4 "2023-06-07T09:55:40Z")

</div>

```auto
  logging:
        driver: "json-file"
        options:
            max-size: "10k"
            max-file: "10"
  elasticsearch:
    image: docker.elastic.co/elasticsearch/elasticsearch:7.9.3
    container_name: elasticsearch
    # restart: on-failure
    environment:
      - discovery.type=single-node
      - bootstrap.memory_lock=true
      - "ES_JAVA_OPTS=-Xms256m -Xmx256m"
    ports:
      - '9201:9200'
      - '9301:9300'
    ulimits:
      memlock:
        soft: -1
        hard: -1
    volumes:
      - ./volumes/elasticsearch:/usr/share/elasticsearch/data
    logging:
        driver: "json-file"
        options:
            max-size: "10k"
            max-file: "10"

  phpmyadmin:
    image: phpmyadmin/phpmyadmin:latest
    restart: always
    environment:
      PMA_HOST: w_mysql
      PMA_PORT: 3306
    ports:
      - 8080:80
  logstash:
    build:
      context: .
      dockerfile: Dockerfile
    container_name: logstash
    # restart: on-failure
    depends_on:
      - w_mysql
      - elasticsearch
    ports:
      - '9600:9600'
    volumes:
      - ./volumes/logstash/pipeline/:/usr/share/logstash/pipeline/
      - ./volumes/logstash/config/logstash.yml:/usr/share/logstash/config/logstash.yml
      - ./volumes/logstash/config/pipelines.yml:/usr/share/logstash/config/pipelines.yml
      - ./volumes/logstash/config/queries/:/usr/share/logstash/config/queries/
    logging:
      driver: "json-file"
      options:
        max-size: "10k"
        max-file: "10"
  kibana:
    image: docker.elastic.co/kibana/kibana:7.9.3
    container_name: kibana
    environment:
      - "ELASTICSEARCH_URL=http://elasticsearch:9200"
      - "SERVER_NAME=127.0.0.1"
    ports:
      - 5601:5601
    depends_on:
      - elasticsearch

#Dockerfile#
  GNU nano 6.2 Dockerfile
FROM docker.elastic.co/logstash/logstash:7.9.3

```

type or paste code here

```auto

```

---

<div class="post-metadata">

**Author:** ![adimi\_worou](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/adimi_worou/32/121931_2.png) [@adimi\_worou](https://discuss.elastic.co/u/adimi_worou)\
**Post date:** [June 7, 2023, 9:56am UTC](https://discuss.elastic.co/t/logstash-mysql/335400/5 "2023-06-07T09:56:29Z")

</div>

```auto
  GNU nano 6.2 Dockerfile
FROM docker.elastic.co/logstash/logstash:7.9.3

# Download JDBC connector for Logstash
RUN curl -L --output "mysql-connector-java-8.0.22.tar.gz" "https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-8.0.22.tar.gz" \
    && tar -xf "mysql-connector-java-8.0.22.tar.gz" "mysql-connector-java-8.0.22/mysql-connector-java-8.0.22.jar" \
    && mv "mysql-connector-java-8.0.22/mysql-connector-java-8.0.22.jar" "mysql-connector-java-8.0.22.jar" \
    && rm -r "mysql-connector-java-8.0.22" "mysql-connector-java-8.0.22.tar.gz"

ENTRYPOINT ["/usr/local/bin/docker-entrypoint"]

```

---

<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:** [July 5, 2023, 9:56am UTC](https://discuss.elastic.co/t/logstash-mysql/335400/6 "2023-07-05T09:56:59Z")

</div>

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