Error documentation while setup

Documenting some common error while setting up Uli locally

1) Database Connection Refused

The solution to this is change the mysql version in the docker-compose.yml file to 8.0.33. so the container db should now look like this

NOTE - make sure you have first deleted the ~/data/ogbv_plugin/

  db:
    image: "mysql:8.0.33"
    command: --default-authentication-plugin=mysql_native_password
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: root_pw
      MYSQL_USER: tattle
      MYSQL_PASSWORD: tattle_pw
      MYSQL_DATABASE: uli_dev
    ports:
      - 3306:3306
    volumes:
      - "~/data/ogbv_plugin/db:/var/lib/mysql"

2) mysql connection refused - ERROR: connect ECONNREFUSED 172.18.0.3:3306

Docker here is trying to connect to this IP - 172.18.0.3 (this IP address will vary from machine to machine)

the solution here is to add this IP has an extra host for the docker container - modify the db docker container in docker-compose.yml to look like this

  db:
    image: "mysql:8.0.33"
    command: --default-authentication-plugin=mysql_native_password
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: root_pw
      MYSQL_USER: tattle
      MYSQL_PASSWORD: tattle_pw
      MYSQL_DATABASE: uli_dev
    ports:
      - 3306:3306
    volumes:
      - "~/data/ogbv_plugin/db:/var/lib/mysql"
    extra_hosts:
      - "host.docker.internal:172.18.0.3"