Mysql connector python error violation of protocol (_ssl.c:2483)

Question

Im running an application running React, python and MySQL with a docker compose, When I run the application everything works fine, but when a pettition to the database (from the frontend with axios) is made multiple times, the connection breaks and the following error appears. Everything is running locally

"2055: Lost connection to MySQL server at 'database:3306', system error: 8 EOF occurred in violation of protocol (_ssl.c:2483)"

Here is the configuration of my connection and my dockerfile


    import mysql.connector


    return mysql.connector.connect(
    host=os.environ.get("database"),
    user="root",
    password="root",
    database="locatec",
    port=3306,
    auth_plugin='mysql_native_password'
    )

  database:
      image: mysql
      container_name: database
      restart: always
      ports:
        - '3306:3306'
      #command: --init-file /init.sql
      volumes:
        - ./init.sql:/docker-entrypoint-initdb.d/init.sql
        - ~/apps/mysql:/var/lib/locatec5
      environment:
        MYSQL_ROOT_PASSWORD: root
        MYSQL_USER: test
        MYSQL_PASSWORD: test
        MYSQL_ROOT_HOST: '%'
        TIMEZONE: UTC

      networks:
        - locatec

  server:
    build: 
      context: ../../../
      dockerfile: infra/deploy/backend/dev/Dockerfile
    restart: always
    ports:
      - "5000:5000"
    container_name: server
    networks:
      - locatec
    depends_on:
      - database

I tried using

mysql-connector-python==8.0.30

, also I configured the param of ssl to false

Could try 8.0.31, but its release notes don't list a fix. So this looks like a bug that would be beneficial to report. — danblack
– danblack, Commented Nov 12, 2022 at 22:34
Is the server container crashing that caused the this? The /var/lib/locatec5 looks odd and no /var/lib/mysql mount point. — danblack
– danblack, Commented Nov 12, 2022 at 23:45
Nothing looks crashed on docker, only the message appears and all connections are lost — Óscar Contreras
– Óscar Contreras, Commented Nov 15, 2022 at 4:05
Nothing is using SSL, the only thing that requires SSL is Auth0 that we are using on the frontend — Óscar Contreras
– Óscar Contreras, Commented Nov 15, 2022 at 4:20

Jib · Accepted Answer · 2022-11-16 10:29:00Z

2

+50

This looks like an error I faced some time ago. In my case, it was due to a client initiating a secured connection to a non-secured server.

The error message indicates that the client has initiated a SSL/TLS connection and is expecting to receive more data than the server has sent during the handshake procedure.

There are two ways to fix this, either by:

enabling SSL/TLS on server side so that the client can initiate a SSL/TLS handshake and get a consistent response. [Docker side]
disabling the SSL/TLS from the database connector. [Python side]

answered Nov 16, 2022 at 10:29

Jib

1,5831 gold badge5 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mysql connector python error violation of protocol (_ssl.c:2483)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related