php artisan migrate not working in docker and laravel 5

sora sakamoto

I created an Apache container and a MYSQL container.

then, I created a Laravel project with composer.

to type php artisan make:auth, I typed php artisan migrate but, an error occurred.

SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Temporary failure in name resolution (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')

Exception trace:

1 PDOException::("PDO::__construct(): php_network_getaddresses: getaddrinfo failed: Temporary failure in name resolution") /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:70

2 PDO::__construct("mysql:host=otameshi_db;port=3306;dbname=laravel", "laravel", "ss119", []) /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:70

I checked .env file and /config/database.php. Below is .env file and /config/database.php.

DB_CONNECTION=mysql
DB_HOST=otameshi_db
DB_PORT=3306
DB_DATABASE=laravel
DB_USERNAME=laravel
DB_PASSWORD=ss119
        'mysql' => [
            'driver' => 'mysql',
            'url' => env('DATABASE_URL'),
            'host' => env('DB_HOST', 'otameshi_db'),
            'port' => env('DB_PORT', '3306'),
            'database' => env('DB_DATABASE', 'laravel'),
            'username' => env('DB_USERNAME', 'laravel'),
            'password' => env('DB_PASSWORD', 'ss119'),
            'unix_socket' => env('DB_SOCKET', ''),
version: '3'
services:
  backend:
    build:
      context: ./docker/php
      dockerfile: Dockerfile
    ports:
      - "80:80"
    volumes:
      - ./src/backend:/var/www/html
    depends_on:
      - db

  db:
    build:
      context: ./docker/mysql
      dockerfile: Dockerfile
    command: --default-authentication-plugin=mysql_native_password
    ports:
      - "3306:3306"
    volumes:
      - ./docker/mysql/data:/var/lib/mysql
    environment:
      - MYSQL_ROOT_PASSWORD=pass

and Below is the outcome of show databases.

enter image description here

.
├── docker
│   ├── mysql
│   │   ├── Dockerfile
│   │   ├── my.cnf
│   │   └── data
│   └── php
│       ├── 000-default.conf
│       └── Dockerfile
├── docker-compose.yml
└── src
    ├── backend
    └── frontend

Where is the mistake in my setting? Thank you for your help.

milica98

I had same error and I solved it with DB_HOST=localhost or 127.0.0.1, or you can try to name it DB_HOST=db as it is in Dockerfile.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

Laravel 5: php artisan migrate:refresh

laravel php artisan migrate

Docker - Nginx, PHP, MySQL - Laravel artisan migrate connection refused

Laravel 5: Running php artisan migrate, triggers functions in cron scheduler

error on php artisan migrate laravel

Php artisan migrate fails Laravel

laravel : php artisan not working

I'm using Laravel 5 and I'm not being able to migrate my database using php artisan migrate

php artisan migrate isn't working

Laravel 5 : test artisan migrate with path

Laravel Failing on php artisan migrate after php artisan make:auth

Laravel - php artisan migrate, table already exists

Running 'php artisan migrate:fresh' in Laravel code

Unable to run php artisan migrate in Laravel

php artisan migrate is not making tables in laravel 7

Got an error in PHP artisan migrate in laravel

php artisan migrate error in Laravel 5.3

Laravel php artisan migrate errors on empty database

How to fix " php artisan migrate" error in Laravel

Laravel Artisan Migrate [BadMethodCallException]

Artisan::call('migrate') not working after upgrading Laravel to 4.2

Laravel artisan migrate error: "zsh: illegal hardware instruction php artisan migrate"

PHP artisan migrate exception

Debugging a Laravel 5 artisan migrate unexpected T_VARIABLE FatalErrorException

Docker Microsoft SQL Server - PHP Artisan Migrate - Could not find driver

Laravel 5.8 php artisan migrate throwing error: Illuminate\Database\QueryException

laravel 5.4 - php artisan migrate command doesn't work

Laravel incompatible foreign key error when running php artisan migrate

Laravel php artisan migrate command - no errors and no console output?