运行 php artisan migrate:fresh 时出现此错误:
#15 0.576 Illuminate\Database\QueryException #15 0.576 SQLSTATE[HY000] [2002] No such file or directory (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
我的 docker-compose.yml:
version: "3.7" networks: app-network: driver: bridge services: app: build: context: ./ dockerfile: Dockerfile image: laravel8-php-fpm-80 container_name: app restart: unless-stopped tty: true working_dir: /var/www volumes: - ./:/var/www networks: - app-network db: image: mysql:5.7.33 container_name: db restart: unless-stopped tty: true environment: MYSQL_DATABASE: ${DB_DATABASE} MYSQL_ROOT_PASSWORD: ${DB_PASSWORD} MYSQL_PASSWORD: ${DB_PASSWORD} MYSQL_USER: ${DB_USERNAME} SERVICE_TAGS: dev SERVICE_NAME: db volumes: - ./mysql/data:/var/lib/mysql networks: - app-network nginx: image: nginx:1.19.8-alpine container_name: nginx restart: unless-stopped tty: true ports: - 8100:80 volumes: - ./src:/var/www - ./nginx/conf:/etc/nginx/conf.d networks: - app-network
我的 Dockerfile:
FROM php:8.0.3-fpm-buster RUN docker-php-ext-install bcmath pdo_mysql RUN apt-get update RUN apt-get install -y git zip unzip COPY --from=composer:latest /usr/bin/composer /usr/bin/composer COPY . /var/www WORKDIR /var/www RUN composer install RUN php artisan config:clear RUN php artisan migrate:fresh EXPOSE 9000
我的环境文件:
APP_NAME=App Name APP_ENV=local APP_KEY=base64:1XGhFF8+2qNi2IPyQVgdv783pZqTgsUl4Y77K9gUoYY= APP_DEBUG=true APP_URL=http://localhost LOG_CHANNEL=stack DB_CONNECTION=mysql DB_HOST=db DB_PORT=3306 DB_DATABASE=db_name DB_USERNAME=root DB_PASSWORD=123456 BROADCAST_DRIVER=log CACHE_DRIVER=file QUEUE_CONNECTION=sync SESSION_DRIVER=file SESSION_LIFETIME=120 REDIS_HOST=127.0.0.1 REDIS_PASSWORD=null REDIS_PORT=6379 MAIL_MAILER=smtp MAIL_HOST=smtp.mailtrap.io MAIL_PORT=2525 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= 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}"
在我的 config/database.php 我得到:
'mysql' => [ 'driver' => 'mysql', 'url' => env('DATABASE_URL'), 'host' => env('DB_HOST', '127.0.0.1'), 'port' => env('DB_PORT', '3306'), 'database' => env('DB_DATABASE', 'forge'), 'username' => env('DB_USERNAME', 'forge'), 'password' => env('DB_PASSWORD', 'forge'), 'unix_socket' => env('DB_SOCKET', ''), 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'prefix' => '', 'prefix_indexes' => true, 'strict' => true, 'engine' => null, 'options' => extension_loaded('pdo_mysql') ? array_filter([ PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'), ]) : [], ],
我是码头工人的新手,所以也许我错过了一些东西。有谁知道这里可能是什么问题:(我花了两天时间调查这个错误并没有找到任何好的答案
我通过运行这样的 bash 脚本找到了解决方案:
#!/bin/bash echo "Migration Started"; php artisan migrate echo "Seeding started" php artisan db:seed echo "Server starting" return
但现在我遇到了问题,因为我的迁移是循环运行的,迁移永远不会停止。我不知道为什么它会这样。有谁知道这种循环迁移问题的解决方案?我还尝试在 return 语句和迁移完成之前添加 php artisan serve 并且服务器确实启动了,但是我的问题是我无法在端口 8100 上打开应用程序,我认为这是因为 artisan serve 。