問題描述

我的 laradock 項目遇到了麻煩:我已經下載并安裝了 docker，并且我已經使用 laradock 成功完成了我的 laravel 項目的設置.我使用 php 7、laravel(5.5.14) 和最新版本的 laradock.我開始在 shell 中編寫我的項目:

I'm in trouble with my laradock project: i have downloaded and installed docker and i have successfully completed the setup of my laravel project with laradock. I use php 7, laravel(5.5.14) and the latest version of laradock. I start my project writing in shell:

docker-compose up -d nginx mysql

然后所有服務都啟動了.我的 env 文件是:

and all services starts. My env file is:

DB_CONNECTION=mysql
DB_HOST=mysql
DB_PORT=3306
DB_DATABASE=homestead
DB_USERNAME=root
DB_PASSWORD=root

但是當我嘗試將遷移與

But when i try to use the migration with

php artisan migrate

我收到此錯誤:

SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known (SQL: select * from information_schema.tables where table_schema = homestead and table_name = migrations) 
SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known 
PDO::__construct(): php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known 

我的名為 homestead 的數據庫已創建并且可以正常工作.在我的 Laravel 項目中，在遷移文件夾下我有 3 個文件 php:create_user_table、create_password_reset_table 和 create_customer_table(我寫了這個文件).我需要在我的數據庫中創建一個名為 customer 的表，其中包含一些列:

My db called homestead is created and it works. In my laravel project, under the migration folder i have 3 files php: create_user_table, create_password_reset_table and create_customer_table( i have wrote this file). I need to create a table in my db called customer with some colums:

Schema::create('customers', function (Blueprint $table) {
        $table->increments('id');
        $table->string('first_name');
        $table->string('last_name');
        $table->boolean('azienda');
        $table->string('iva');
        $table->string('ds');
        $table->boolean('fatres');
        $table->string('cf');
        $table->string('mail');
        $table->string('telefono');
        $table->integer('sponsor');
        $table->string('indinst');
        $table->string('civinst');
        $table->string('cityInst');
        $table->string('capinst');
        $table->string('provinst');
        $table->string('indf');
        $table->string('civf');
        $table->string('capf');
        $table->string('provf');
        $table->string('cityFatt');
        $table->timestamps();
    });

如何完成遷移并創建表?謝謝解答！

How can i complete the migration and create the table? Thank you for answer!

推薦答案

@Stefano Zaniboni 在評論中回答了這個問題，但要擴展:

@Stefano Zaniboni answered this in a comment but to expand:

我遇到這個問題是因為我習慣于在本地目錄而不是在 virtualbox/vagrant box/docker 容器中運行 php artisan 命令.

I ran across this issue because I'm used to running php artisan commands in my local directory rather than in a virtualbox / vagrant box / docker container.

Laravel Docs 提到您需要運行 phpartisan migrate 命令從你的虛擬機中.

The Laravel Docs mention that you need to run the php artisan migrate command from within your virtual machine.

如果您使用 docker，則可以使用 docker ps 獲取容器 ID.然后使用 docker exec -it ssh 進入容器./bin/bash.然后只需 cd 進入您的項目目錄并運行 php artisan migrate.

If you're using docker, you can get your container id using docker ps. Then to ssh into the container use docker exec -it <containerId> /bin/bash. Then just cd into your project directory and run php artisan migrate.

這篇關于php artisan migrate錯誤:提供或不知道節點名或服務名的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！