在 Yii 2.0 的数据库迁移时报错：Exception: Redis error: ERR Client sent AUTH, but no password is set
1、在 Yii 2.0 的数据库迁移时报错：Exception: Redis error: ERR Client sent AUTH, but no password is set。如图1
图1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | *** applying m191113_084655_sync_redis_wx_auth_data_to_mysqlException: Redis error: ERR Client sent AUTH, but no password is setRedis command was: AUTH Redis (E:\wwwroot\channel-pub-api\vendor\yiisoft\yii2-redis\src\Connection.php:821)#0 E:\wwwroot\channel-pub-api\vendor\yiisoft\yii2-redis\src\Connection.php(789): yii\redis\Connection->parseResponse(Array, '*2\r\n$4\r\nAUTH\r\n$...')#1 E:\wwwroot\channel-pub-api\vendor\yiisoft\yii2-redis\src\Connection.php(772): yii\redis\Connection->sendCommandInternal('*2\r\n$4\r\nAUTH\r\n$...', Array)#2 E:\wwwroot\channel-pub-api\vendor\yiisoft\yii2-redis\src\Connection.php(634): yii\redis\Connection->executeCommand('AUTH', Array)#3 E:\wwwroot\channel-pub-api\console\migrations\m191113_084655_sync_redis_wx_auth_data_to_mysql.php(27): yii\redis\Connection->open()#4 E:\wwwroot\channel-pub-api\vendor\yiisoft\yii2\db\Migration.php(114): m191113_084655_sync_redis_wx_auth_data_to_mysql->safeUp()#5 E:\wwwroot\channel-pub-api\vendor\yiisoft\yii2\console\controllers\BaseMigrateController.php(725): yii\db\Migration->up()#6 E:\wwwroot\channel-pub-api\vendor\yiisoft\yii2\console\controllers\BaseMigrateController.php(200): yii\console\controllers\BaseMigrateController->migrateUp('m191113_084655_...')#7 [internal function]: yii\console\controllers\BaseMigrateController->actionUp(0)#8 E:\wwwroot\channel-pub-api\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array)#9 E:\wwwroot\channel-pub-api\vendor\yiisoft\yii2\base\Controller.php(157): yii\base\InlineAction->runWithParams(Array)#10 E:\wwwroot\channel-pub-api\vendor\yiisoft\yii2\console\Controller.php(164): yii\base\Controller->runAction('', Array)#11 E:\wwwroot\channel-pub-api\vendor\yiisoft\yii2\base\Module.php(528): yii\console\Controller->runAction('', Array)#12 E:\wwwroot\channel-pub-api\vendor\yiisoft\yii2\console\Application.php(180): yii\base\Module->runAction('migrate', Array)#13 E:\wwwroot\channel-pub-api\vendor\yiisoft\yii2\console\Application.php(147): yii\console\Application->runAction('migrate', Array)#14 E:\wwwroot\channel-pub-api\vendor\yiisoft\yii2\base\Application.php(386): yii\console\Application->handleRequest(Object(yii\console\Request))#15 E:\wwwroot\channel-pub-api\yii(23): yii\base\Application->run()#16 {main}*** failed to apply m191113_084655_sync_redis_wx_auth_data_to_mysql (time: 0.011s) |
2、打开终端并连接 redis-cli，测试 AUTH Redis。报错：(error) ERR Client sent AUTH, but no password is set
1 2 3 4 | PS E:\wwwroot\channel-pub-api> redis-cli127.0.0.1:6379> AUTH Redis(error) ERR Client sent AUTH, but no password is set127.0.0.1:6379> |
3、编辑 redis.windows.conf 与 redis.windows-service.conf ，添加 requirepass Redis。
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | ################################## SECURITY #################################### Require clients to issue AUTH <PASSWORD> before processing any other# commands. This might be useful in environments in which you do not trust# others with access to the host running redis-server.## This should stay commented out for backward compatibility and because most# people do not need auth (e.g. they run their own servers).# # Warning: since Redis is pretty fast an outside user can try up to# 150k passwords per second against a good box. This means that you should# use a very strong password otherwise it will be very easy to break.#requirepass Redis |
4、在 Windows 10 中，停止与启动 Redis
1 2 3 4 | PS E:\wwwroot\channel-pub-api> redis-server --service-stop[29528] 30 Mar 14:04:24.076 # Redis service successfully stopped.PS E:\wwwroot\channel-pub-api> redis-server --service-start[28132] 30 Mar 14:04:34.748 # Redis service successfully started. |
5、打开终端并连接 redis-cli，测试 AUTH Redis。响应 OK。如图2
图2
1 2 3 4 | PS E:\wwwroot\channel-pub-api> redis-cli127.0.0.1:6379> AUTH RedisOK127.0.0.1:6379> |
6、在 Yii 2.0 的数据库迁移时迁移成功。如图3
图3
1 2 | *** applying m191113_084655_sync_redis_wx_auth_data_to_mysql*** applied m191113_084655_sync_redis_wx_auth_data_to_mysql (time: 0.266s) |
近期评论