2022/12/05

From Docker Virtual Network Connect To Solid MySQL Server

ๅ‡่จญๆˆ‘ๅ€‘็š„ server ๅชๆœ‰ไธ€ๅฐ,PHP ็’ฐๅขƒ็‚บ docker container,่€Œ่ณ‡ๆ–™ๅบซ็‚บๅฏฆ้ซ”ๆฉŸๅฎ‰่ฃ,่ณ‡ๆ–™ๅบซ 3306 ้˜ฒ็ซ็‰†้˜ฒๅ ตไธๅฐๅค–,ไฝ†่ฆๅ…่จฑๅพž Docker ็’ฐๅขƒๅ…ง็š„ๆœๅ‹™ๅญ˜ๅ–,ๆœ€็ฐกๅ–ฎ็š„ๆ–นๅผๅฐฑๆ˜ฏ้˜ฒ็ซ็‰†่ฎ“ Docker ็”ข็”Ÿ็š„ network interface ้€š้Ž,ไธ‹้ขๆˆ‘ๅ€‘ไพ†ๅฏฆๅš้€™ไปถไบ‹。

ไปŠๅคฉ็คบ็ฏ„็’ฐๅขƒ็‚บไฝฟ็”จ Vagrant ่ตทไธ€ๅฐ Ubuntu jammy64,็„ถๅพŒๅœจ่ฃก้ข้€ฒ่กŒ้˜ฒ็ซ็‰†็š„ๆธฌ่ฉฆ。

sudo service ufw start
sudo ufw enable
sudo ufw allow ssh

่จ˜ๅพ—้–‹ๅ•Ÿ้˜ฒ็ซ็‰†่ฆๅ…ˆๆŠŠ ssh ๆ‰“้–‹,ไธ็„ถๅฐฑๆ‚ฒๅЇไบ†,ๆŽฅ่‘—ๅฎ‰่ฃ MySQL,docker ไปฅๅŠ docker compose ้ƒจๅˆ†ๅฐฑ้บป็…ฉ่‡ช่กŒๅฎ‰่ฃ。

sudo apt install -y mariadb-server mariadb-client

ๅฎ‰่ฃๅฎŒ็•ขๅพŒ,ๆˆ‘ๅ€‘ไพ†ๅปบ็ซ‹ๆธฌ่ฉฆ็”จ่ณ‡ๆ–™ๅบซไปฅๅŠๅธณ่™Ÿ。

sudo mysql
create database laravel;
GRANT ALL PRIVILEGES ON `laravel`.* TO 'homestead'@'%' IDENTIFIED BY 'secret' WITH GRANT OPTION;

้€™้‚ŠๆฌŠ้™้–‹ % ๆฒ’้—œไฟ‚,ๅ› ็‚บๆˆ‘ๅ€‘ๅชๆœƒๅ…่จฑ docker network ๆŒ‡ๅฎš็š„ network interface ้€ฒๅ…ฅ่€Œๅทฒ。

docker-compose.yml
version: "3.9"

services:
  fpm:
    container_name: fpm
    build: .
    restart: always
    working_dir: /www
    extra_hosts:
      - "host.docker.internal:host-gateway"
    networks:
      - front_end
    volumes:
      - ./www/:/www

networks:
  front_end:
    driver_opts:
      com.docker.network.bridge.name: br-fpm
Dockerfile
FROM php:8.1-fpm

RUN apt-get update && apt-get install -y \
    git \
    curl \
    libpng-dev \
    libonig-dev \
    libxml2-dev \
    zip \
    unzip

ADD https://github.com/mlocati/docker-php-extension-installer/releases/latest/download/install-php-extensions /usr/local/bin/

RUN chmod +x /usr/local/bin/install-php-extensions && \
    install-php-extensions @composer pdo_mysql mbstring exif pcntl bcmath gd

WORKDIR /www

้€™ๆ˜ฏ่ฆๅฎ‰่ฃ Laravel ็š„ๆœ€ๅฐ็’ฐๅขƒ,ๆˆ‘ๅ€‘ไปŠๅคฉๅชๆ˜ฏ่ฆๆธฌ่ฉฆ้€ฃ็ทšๆ‰€ไปฅๅ…ถไป–็š„่จญๅฎšๅฐฑๅ…ˆไธ็†ๆœƒไบ†。

sudo docker compose up -d

็ญ‰ image build ๅฎŒไปฅๅŠ service ่ตทไพ†ไปฅๅพŒ,ๆˆ‘ๅ€‘ไพ†ๅˆฉ็”จๆŒ‡ไปคๅฎ‰่ฃไธ€ๅ€‹ Laravel ็š„็’ฐๅขƒ。

sudo docker compose exec fpm composer create-project laravel/laravel .

ๆŽฅ่‘—ๆˆ‘ๅ€‘ๆ‰“้–‹ .env ๆช”ๆกˆ่จญๅฎš่ณ‡ๆ–™ๅบซ้€ฃ็ทšๅ…งๅฎน。

DB_CONNECTION=mysql
DB_HOST=host.docker.internal
DB_PORT=3306
DB_DATABASE=laravel
DB_USERNAME=homestead
DB_PASSWORD=secret

้€™ๆ™‚ไพ†ๆธฌ่ฉฆไธ€ไธ‹้€ฃ็ทš。

sudo docker compose exec fpm php artisan migrate

ๅ› ็‚บ้˜ฒ็ซ็‰†ๆ“‹ไฝไบ†,ๆ‰€ไปฅ connection ๆœƒ hang ไฝ,ๆœ€็ต‚ๅคฑๆ•—,ๆŽฅ่‘—ไพ†้–‹ๅง‹้˜ฒ็ซ็‰†่จญๅฎš。

sudo ufw allow in on br-fpm to any port 3306

ๆŽฅ่‘—ๅ†ๅŸท่กŒไธ€ๆฌก migrate ็š„ๆŒ‡ไปค。

sudo docker compose exec fpm php artisan migrate

   INFO  Preparing database.

  Creating migration table ............................................................................................................... 10ms DONE

   INFO  Running migrations.

  2014_10_12_000000_create_users_table .................................................................................................... 9ms DONE
  2014_10_12_100000_create_password_resets_table .......................................................................................... 2ms DONE
  2019_08_19_000000_create_failed_jobs_table .............................................................................................. 3ms DONE
  2019_12_14_000001_create_personal_access_tokens_table ................................................................................... 4ms DONE

ๅฏไปฅ็œ‹ๅˆฐ migration ้ †ๅˆฉๆˆๅŠŸไบ†,ๅฆ‚ๆžœ็™ผ็”Ÿ connection refuse ็š„้Œฏ่ชค็š„่ฉฑ,่จ˜ๅพ—ๆŠŠ MySQL ็š„ bind-address ่จญๅฎš็‚บ 0.0.0.0。

iptable ็š„่ฉฑ็”จไธ‹ๆ–น็š„ๆŒ‡ไปคๆ‡‰ๅฏ้”ๅˆฐไธ€ๆจฃ็š„ๆ•ˆๆžœ。

iptables -A INPUT -i br-fpm -p tcp --dport 3306 -j ACCEPT
iptables -A INPUT -p tcp --dport 3306 -j DROP