php - 执行 yii migrate 时如何修复错误“异常”?
问题描述
我尝试在 macOS BigSur 中使用 docker 运行 yii2 基本项目。这是我的 docker-compose.yml:
version: '2'
services:
php:
image: yiisoftware/yii2-php:7.4-apache
volumes:
- ~/.composer-docker/cache:/root/.composer/cache:delegated
- ./:/app:delegated
ports:
- '8000:80'
mysqldb:
image: mysql
ports:
- 3306:3306
environment:
- MYSQL_ROOT_PASSWORD=p@ssw0rd1
- MYSQL_DATABASE=yii2basic
这是配置/db.php:
<?php
return [
'class' => 'yii\db\Connection',
'dsn' => 'mysql:host=mysqldb;port=3306;dbname=yii2basic',
'username' => 'root',
'password' => 'p@ssw0rd1',
'charset' => 'utf8',
// Schema cache options (for production environment)
//'enableSchemaCache' => true,
//'schemaCacheDuration' => 60,
//'schemaCache' => 'cache',
];
我使用与 yii2 高级版中相同的文件夹迁移。当我运行命令 ./yii migrate 时,出现错误“Exception 'yii\db\Exception' with message 'SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known'”。我做错了什么?我在互联网上尝试了很多东西,但不明白这一点。而不是解决我的问题。-->执行yii migrate时如何修复错误异常?
我可以访问我的数据库。我不能做任何迁移。给我这个错误:
php yii migrate
Yii Migration Tool (based on Yii v2.0.42-dev)
Exception 'yii\db\Exception' with message 'SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known'
in /Users/danielz3/PhpstormProjects/Portfoleo/vendor/yiisoft/yii2/db/Connection.php:651
Error Info:
Array
(
[0] => HY000
[1] => 2002
[2] => php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known
)
Caused by: Exception 'PDOException' with message 'SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known'
in /Users/danielz3/PhpstormProjects/Portfoleo/vendor/yiisoft/yii2/db/Connection.php:721
Caused by: Exception 'PDOException' with message 'PDO::__construct(): php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known'
in /Users/danielz3/PhpstormProjects/Portfoleo/vendor/yiisoft/yii2/db/Connection.php:721
Stack trace:
#0 /Users/danielz3/PhpstormProjects/Portfoleo/vendor/yiisoft/yii2/db/Connection.php(721): PDO->__construct('mysql:host=mysq...', 'root', 'p@ssw0rd1', NULL)
#1 /Users/danielz3/PhpstormProjects/Portfoleo/vendor/yiisoft/yii2/db/Connection.php(640): yii\db\Connection->createPdoInstance()
#2 /Users/danielz3/PhpstormProjects/Portfoleo/vendor/yiisoft/yii2/db/Connection.php(1063): yii\db\Connection->open()
#3 /Users/danielz3/PhpstormProjects/Portfoleo/vendor/yiisoft/yii2/db/Connection.php(1050): yii\db\Connection->getMasterPdo()
#4 /Users/danielz3/PhpstormProjects/Portfoleo/vendor/yiisoft/yii2/db/Command.php(261): yii\db\Connection->getSlavePdo()
#5 /Users/danielz3/PhpstormProjects/Portfoleo/vendor/yiisoft/yii2/db/Command.php(1163): yii\db\Command->prepare(true)
#6 /Users/danielz3/PhpstormProjects/Portfoleo/vendor/yiisoft/yii2/db/Command.php(410): yii\db\Command->queryInternal('fetchAll', NULL)
#7 /Users/danielz3/PhpstormProjects/Portfoleo/vendor/yiisoft/yii2/db/mysql/Schema.php(319): yii\db\Command->queryAll()
#8 /Users/danielz3/PhpstormProjects/Portfoleo/vendor/yiisoft/yii2/db/mysql/Schema.php(125): yii\db\mysql\Schema->findColumns(Object(yii\db\TableSchema))
#9 /Users/danielz3/PhpstormProjects/Portfoleo/vendor/yiisoft/yii2/db/Schema.php(758): yii\db\mysql\Schema->loadTableSchema('migration')
#10 /Users/danielz3/PhpstormProjects/Portfoleo/vendor/yiisoft/yii2/db/Schema.php(194): yii\db\Schema->getTableMetadata('{{%migration}}', 'schema', true)
#11 /Users/danielz3/PhpstormProjects/Portfoleo/vendor/yiisoft/yii2/console/controllers/MigrateController.php(211): yii\db\Schema->getTableSchema('{{%migration}}', true)
#12 /Users/danielz3/PhpstormProjects/Portfoleo/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(894): yii\console\controllers\MigrateController->getMigrationHistory(NULL)
#13 /Users/danielz3/PhpstormProjects/Portfoleo/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(169): yii\console\controllers\BaseMigrateController->getNewMigrations()
#14 [internal function]: yii\console\controllers\BaseMigrateController->actionUp(0)
#15 /Users/danielz3/PhpstormProjects/Portfoleo/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
#16 /Users/danielz3/PhpstormProjects/Portfoleo/vendor/yiisoft/yii2/base/Controller.php(181): yii\base\InlineAction->runWithParams(Array)
#17 /Users/danielz3/PhpstormProjects/Portfoleo/vendor/yiisoft/yii2/console/Controller.php(184): yii\base\Controller->runAction('', Array)
#18 /Users/danielz3/PhpstormProjects/Portfoleo/vendor/yiisoft/yii2/base/Module.php(534): yii\console\Controller->runAction('', Array)
#19 /Users/danielz3/PhpstormProjects/Portfoleo/vendor/yiisoft/yii2/console/Application.php(181): yii\base\Module->runAction('migrate', Array)
#20 /Users/danielz3/PhpstormProjects/Portfoleo/vendor/yiisoft/yii2/console/Application.php(148): yii\console\Application->runAction('migrate', Array)
#21 /Users/danielz3/PhpstormProjects/Portfoleo/vendor/yiisoft/yii2/base/Application.php(392): yii\console\Application->handleRequest(Object(yii\console\Request))
#22 /Users/danielz3/PhpstormProjects/Portfoleo/yii(20): yii\base\Application->run()
#23 {main}
解决方案
我使用这个命令解决了我的问题。我不知道为什么,但解决了。(我猜我正在使用 docker 端)。
docker-compose run --rm php yii migrate
推荐阅读
- javascript - 如何将对象添加和更新到对象数组中?
- javascript - 如何在基本文本编辑器中为 textarea 中的选定文本设置样式?
- azure-ad-b2c - 在验证技术配置文件中发送声明
- sqlite - flask.(jsonify) 中只输出 null
- delphi - System.Classes.MaxListSize 的正确替代方案
- c++ - 客户端挂起等待来自服务器的响应(读/写套接字 C++)
- angular - 如何使用 Angular 9 向下滚动到元素内容的底部?
- django - 渲染后如何获取模板(Django)
- flask-sqlalchemy - Flask appbuilder如何使用现有模型创建新模型并保存到数据库中
- javascript - 数据表css的更改不适用