SQL-ERROR SQLSTATE[HY000] [2002] Connection refused

[daantrommel]

I try to setup Lychee-Laravel but keep getting the following error in the docker log when starting:

Migrate the database

In Connection.php line 664:

SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_s
chema.tables where table_schema = lychee and table_name = migrations)

In PDOConnection.php line 31:

SQLSTATE[HY000] [2002] Connection refused

In PDOConnection.php line 27:

SQLSTATE[HY000] [2002] Connection refused

Create user and use PUID/PGID -e User UID : 1000 -e User GID : 1000 Set Permissions Setup complete, starting the server.

Docker-compose is as follows: lychee_db: container_name: lychee_db image: mysql:8.0 command: --default-authentication-plugin=mysql_native_password environment:

• MYSQL_ROOT_PASSWORD=randomPassword
• MYSQL_DATABASE=lychee
• MYSQL_USER=lychee
• MYSQL_PASSWORD=randomPassword ports:
• 3309:3306 volumes:
• /mnt/storage/photos_db:/var/lib/mysql restart: unless-stopped

lychee: image: bigrob8181/lychee-laravel container_name: lychee_laravel ports:

• 90:80 volumes:
• /myFileLocation:/conf
• /mnt/storage/photos:/uploads environment:

  - PUID=1000

  - PGID=1000

• PHP_TZ=Europe/Amsterdam

  - APP_NAME=Laravel

  - APP_ENV=local

  - APP_DEBUG=true

  - APP_URL=http://localhost

  - LOG_CHANNEL=stack

• DB_CONNECTION=mysql
• DB_HOST=lychee_db
• DB_PORT=3309
• DB_DATABASE=lychee
• DB_USERNAME=lychee
• DB_PASSWORD=YvtHW5FZg5U9Qnz7

  - DB_DROP_CLEAR_TABLES_ON_ROLLBACK=false

  - DB_OLD_LYCHEE_PREFIX=''

  - BROADCAST_DRIVER=log

  - CACHE_DRIVER=file

  - SESSION_DRIVER=file

  - SESSION_LIFETIME=120

  - QUEUE_DRIVER=sync

  - SECURITY_HEADER_HSTS_ENABLE=false

  - REDIS_HOST=127.0.0.1

  - REDIS_PASSWORD=null

  - REDIS_PORT=6379

  - MAIL_DRIVER=smtp

  - MAIL_HOST=smtp.mailtrap.io

  - MAIL_PORT=2525

  - MAIL_USERNAME=null

  - MAIL_PASSWORD=null

  - MAIL_ENCRYPTION=null

  - PUSHER_APP_ID=''

  - PUSHER_APP_KEY=''

  - PUSHER_APP_SECRET=''

  - PUSHER_APP_CLUSTER=mt1

  restart: unless-stopped depends_on:

• lychee_db

[daantrommel]

I figured it out, even though I used port 3309 on my host I still had to set DB_PORT to 3306.