解決したいこと
Laravel開発環境を構築しようと思い、php artisan migrate
コマンドを実行しようとしてもエラーが出てしまい、DB接続しマイグレーションできない。
###ファイル構成
root/
├ app(Laravelプロジェクト)
├ docker/
│ └ Dockerfile
└ docker-compose.yaml
エラー内容
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known (SQL: select * from information_schema.tables where table_schema = database and table_name = migrations and table_type = 'BASE TABLE') at vendor/laravel/framework/src/Illuminate/Database/Connection.php:712 708▕ // If an exception occurs when attempting to run a query, we'll format the error 709▕ // message to include the bindings with SQL, which will make this exception a 710▕ // lot more helpful to the developer instead of just the database's errors. 711▕ catch (Exception $e) { ➜ 712▕ throw new QueryException( 713▕ $query, $this->prepareBindings($bindings), $e 714▕ ); 715▕ } 716▕ } +36 vendor frames 37 artisan:37 Illuminate\Foundation\Console\Kernel::handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
内容
このエラー自体は.envファイルでの環境変数の記述ミスによるものらしいので、確かめてみても間違ってなく現在詰んでる状態です。
各種ソースコード
docker
1version: '3' 2services: 3 app: 4 build: ./docker 5 ports: 6 - 80:80 7 volumes: 8 - ./app:/var/www/app 9 working_dir: /var/www/app 10 db: 11 platform: linux/x86_64 12 image: mysql:8.0 13 ports: 14 - 3306:3306 15 environment: 16 MYSQL_DATABASE: database 17 MYSQL_USER: user 18 MYSQL_PASSWORD: pass
Dockerfilefile
1FROM php:8.0-apache 2COPY --from=composer:latest /usr/bin/composer /usr/bin/composer 3RUN apt-get update && apt-get install -y \ 4 git \ 5 && docker-php-ext-install pdo_mysql 6 7RUN sed -i 's!/var/www/html!/var/www/app/public!g' /etc/apache2/sites-available/000-default.conf
APP_NAME=Laravel APP_ENV=local APP_KEY=base64:2KXXtVvgGqOYcXbBP4nuRPKrDIEuLOtxcFbG/qbfGjc= APP_DEBUG=true APP_URL=http://localhost LOG_CHANNEL=stack LOG_DEPRECATIONS_CHANNEL=null LOG_LEVEL=debug DB_CONNECTION=mysql DB_HOST=db DB_PORT=3306 DB_DATABASE=database DB_USERNAME=user DB_PASSWORD=pass BROADCAST_DRIVER=log CACHE_DRIVER=file FILESYSTEM_DRIVER=local QUEUE_CONNECTION=sync SESSION_DRIVER=file SESSION_LIFETIME=120 MEMCACHED_HOST=127.0.0.1 REDIS_HOST=127.0.0.1 REDIS_PASSWORD=null REDIS_PORT=6379 MAIL_MAILER=smtp MAIL_HOST=mailhog MAIL_PORT=1025 MAIL_USERNAME=null MAIL_PASSWORD=null MAIL_ENCRYPTION=null MAIL_FROM_ADDRESS=null MAIL_FROM_NAME="${APP_NAME}" AWS_ACCESS_KEY_ID= AWS_SECRET_ACCESS_KEY= AWS_DEFAULT_REGION=us-east-1 AWS_BUCKET= AWS_USE_PATH_STYLE_ENDPOINT=false PUSHER_APP_ID= PUSHER_APP_KEY= PUSHER_APP_SECRET= PUSHER_APP_CLUSTER=mt1 MIX_PUSHER_APP_KEY="${PUSHER_APP_KEY}" MIX_PUSHER_APP_CLUSTER="${PUSHER_APP_CLUSTER}"