phpunitでテスト用DBへ接続できない - d-sazanami/laravel-jissenkaihatsu-v1 GitHub Wiki
現象
テスト用データベースにアクセスするテストケースをphpunitで実行すると、エラーになる。
# vendor/bin/phpunit
PHPUnit 9.5.16 by Sebastian Bergmann and contributors.
.E 2 / 2 (100%)
Time: 00:02.809, Memory: 22.00 MB
There was 1 error:
1) Tests\Feature\ExampleTest::test_example
Illuminate\Database\QueryException: SQLSTATE[HY000] [2002] Connection refused (SQL: select count(*) as aggregate from `people` where (`id` = 1 and `name` = Reimu Hakurei and `mail` = [email protected] and `age` = 16))
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:712
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:784
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:764
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:675
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:376
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2414
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2402
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2936
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2403
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2863
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2791
/var/www/html/vendor/laravel/framework/src/Illuminate/Testing/Constraints/HasInDatabase.php:54
/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Testing/Concerns/InteractsWithDatabase.php:29
/var/www/html/tests/Feature/ExampleTest.php:23
Caused by
PDOException: SQLSTATE[HY000] [2002] Connection refused
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:70
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:100
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:50
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php:24
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php:184
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:1062
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:1098
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:442
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:368
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:705
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:784
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:764
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:675
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:376
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2414
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2402
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2936
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2403
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2863
/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2791
/var/www/html/vendor/laravel/framework/src/Illuminate/Testing/Constraints/HasInDatabase.php:54
/var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Testing/Concerns/InteractsWithDatabase.php:29
/var/www/html/tests/Feature/ExampleTest.php:23
ERRORS!
Tests: 2, Assertions: 2, Errors: 1.
対策
config/database.php のホストを env 関数の初期値とし、デフォルト環境の .env のホストと同じにするところが、差異が出てしまっていた
testing環境のホスト設定を以下に設定し直すことで解決。
'host' => 'mysql',