Big problem with migrate function (The subject has been closed also i repost here)

[lmarmier]

Hi,

In your framework, you've a very big problem with the migrate command.

When i make a migrate command, i've this exception :
MacBook-Pro-de-Lionel:~ lionel$ /Users/lionel/Site/yii2-advanced/yii migrate
Yii Migration Tool (based on Yii v2.0.0-dev)

exception 'PDOException' with message 'SQLSTATE[HY000] [2002] No such file or directory' in /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/db/Connection.php:355
Stack trace:
#0 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/db/Connection.php(355): PDO->__construct('mysql:host=loca...', 'root', 'root', NULL)
#1 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/db/Connection.php(311): yii\db\Connection->createPdoInstance()
#2 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/db/Connection.php(385): yii\db\Connection->open()
#3 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/db/mysql/Schema.php(188): yii\db\Connection->createCommand('SHOW FULL COLUM...')
#4 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/db/mysql/Schema.php(93): yii\db\mysql\Schema->findColumns(Object(yii\db\TableSchema))
#5 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/db/Schema.php(114): yii\db\mysql\Schema->loadTableSchema('tbl_migration')
#6 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/console/controllers/MigrateController.php(577): yii\db\Schema->getTableSchema('{{%migration}}', true)
#7 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/console/controllers/MigrateController.php(617): yii\console\controllers\MigrateController->getMigrationHistory(-1)
#8 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/console/controllers/MigrateController.php(153): yii\console\controllers\MigrateController->getNewMigrations()
#9 [internal function]: yii\console\controllers\MigrateController->actionUp(0)
#10 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/base/InlineAction.php(53): call_user_func_array(Array, Array)
#11 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/base/Controller.php(128): yii\base\InlineAction->runWithParams(Array)
#12 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/console/Controller.php(82): yii\base\Controller->runAction('', Array)
#13 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/base/Module.php(586): yii\console\Controller->runAction('', Array)
#14 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/console/Application.php(131): yii\base\Module->runAction('migrate', Array)
#15 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/console/Application.php(99): yii\console\Application->runAction('migrate', Array)
#16 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/base/Application.php(289): yii\console\Application->handleRequest(Object(yii\console\Request))
#17 /Users/lionel/Site/yii2-advanced/yii(30): yii\base\Application->run()
#18 {main}

Next exception 'yii\db\Exception' with message 'SQLSTATE[HY000] [2002] No such file or directory' in /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/db/Connection.php:316
Stack trace:
#0 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/db/Connection.php(385): yii\db\Connection->open()
#1 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/db/mysql/Schema.php(188): yii\db\Connection->createCommand('SHOW FULL COLUM...')
#2 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/db/mysql/Schema.php(93): yii\db\mysql\Schema->findColumns(Object(yii\db\TableSchema))
#3 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/db/Schema.php(114): yii\db\mysql\Schema->loadTableSchema('tbl_migration')
#4 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/console/controllers/MigrateController.php(577): yii\db\Schema->getTableSchema('{{%migration}}', true)
#5 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/console/controllers/MigrateController.php(617): yii\console\controllers\MigrateController->getMigrationHistory(-1)
#6 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/console/controllers/MigrateController.php(153): yii\console\controllers\MigrateController->getNewMigrations()
#7 [internal function]: yii\console\controllers\MigrateController->actionUp(0)
#8 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/base/InlineAction.php(53): call_user_func_array(Array, Array)
#9 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/base/Controller.php(128): yii\base\InlineAction->runWithParams(Array)
#10 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/console/Controller.php(82): yii\base\Controller->runAction('', Array)
#11 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/base/Module.php(586): yii\console\Controller->runAction('', Array)
#12 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/console/Application.php(131): yii\base\Module->runAction('migrate', Array)
#13 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/console/Application.php(99): yii\console\Application->runAction('migrate', Array)
#14 /Users/lionel/Site/yii2-advanced/vendor/yiisoft/yii2/base/Application.php(289): yii\console\Application->handleRequest(Object(yii\console\Request))
#15 /Users/lionel/Site/yii2-advanced/yii(30): yii\base\Application->run()
#16 {main}

Additional Information:

Please correct this problem to i can test your dev application

Thank you for your quickly answer
Lionel
Alexander Makarov
samdark commented 23 minutes ago
It's not Yii issue but MySQL configuration. Try "127.0.0.1" instead of "localhost" in DB connection string. In some cases it helps.
Alexander Makarovsamdark closed the issue 23 minutes ago
Lionel Marmier

lmarmier commented a minute ago
Thank for your answer, but the problem is always present with 127.0.0.1.

Why can i do to fix this bug ?