同步失败 8810 deny connection from当怎么办
发布时间：2022-01-14 12:47:26 所属栏目：MySql教程 来源：互联网
导读：同步失败 8810 deny connection from该怎么办，很多新手对此不是很清楚，为了帮助大家解决这个难题，下面小编将为大家详细讲解，有这方面需求的人可以来学习下，希望你能有所收获。 发现法xxx.xxx.254.45，没有同步拉取到其他点的数据，查看同步的日志，一
 同步失败 8810 deny connection from该怎么办，很多新手对此不是很清楚，为了帮助大家解决这个难题，下面小编将为大家详细讲解，有这方面需求的人可以来学习下，希望你能有所收获。 发现法xxx.xxx.254.45，没有同步拉取到其他点的数据，查看同步的日志，一直显示被其他节点拒绝的状态，拒绝说明是权限没有通过 May 17 13:22:10 warning db_sync_short_video_oss_r2m0_d[]: [tid:137732] [SocketServer::OnAccept] deny connection from: xxx.xxx.125.2:53316 May 17 13:22:20 warning db_sync_short_video_oss_r2m0_d[]: [tid:137739] [SocketServer::OnAccept] deny connection from: xxx.xxx.125.2:53318 May 17 13:22:31 warning db_sync_short_video_oss_r2m0_d[]: [tid:137746] [SocketServer::OnAccept] deny connection from: xxx.xxx.125.2:53320 May 17 13:22:41 warning db_sync_short_video_oss_r2m0_d[]: [tid:137752] [SocketServer::OnAccept] deny connection from: xxx.xxx.125.2:53322 目标机器已经开通了防火墙和白名单了，在xxx.xxx.125.2机器上，使用netstat已经看到了建立了连接，说明防火墙已经开放了端口了 tcp 0 0 xxx.xxx.125.2:12505 xxx.xxx.254.45:41734 ESTABLISHED 48767/./db_sync_sho 重启xxx.xxx.254.45的4455，看到报错 May 17 13:36:43 info shardadmin_short_video_oss_20_d[138429]: HAVE_EPOLL May 17 13:36:43 debug shardadmin_short_video_oss_20_d[138429]: output queue ok May 17 13:36:43 debug shardadmin_short_video_oss_20_d[138429]: output queue ok May 17 13:36:43 err shardadmin_short_video_oss_20_d[138429]: Connect to db failed:[admin|SXobJfaXm4|xxx.xxx.254.45||8810] Lost connection to MySQL server at 'reading initial communication packet', system error: 0 May 17 13:36:43 info shardadmin_short_video_oss_20_d[138429]: create listen port 4455 success May 17 13:36:43 info shardadmin_short_video_oss_20_d[138429]: server start, epoll_prt=0x1335000 May 17 13:36:53 notice shardadmin_short_video_oss_20_d[138429]: request:0 proc:0 droped:0 active:0 May 17 13:37:03 notice shardadmin_short_video_oss_20_d[138429]: request:0 proc:0 droped:0 active:0 连接不上8810的DB是正常的，因为同步还没有开启，如果不启动shard8821到8827，启动myshardmin会报如下错误 May 17 14:27:31 info shardadmin_short_video_oss_20_d[141736]: HAVE_EPOLL May 17 14:27:31 debug shardadmin_short_video_oss_20_d[141736]: output queue ok May 17 14:27:31 debug shardadmin_short_video_oss_20_d[141736]: output queue ok May 17 14:27:31 err shardadmin_short_video_oss_20_d[141736]: Connect to db failed:[admin|SXobJfaXm4|45.124.254.45||8810] Lost connection to MySQL server at 'reading initial communication packet', system error: 111 May 17 14:27:31 err shardadmin_short_video_oss_20_d[141736]: Connect to db failed:[admin|SXobJfaXm4|127.0.0.1||8810] Lost connection to MySQL server at 'reading initial communication packet', system error: 111 May 17 14:27:31 err shardadmin_short_video_oss_20_d[141736]: Connect to db failed:[admin|SXobJfaXm4|127.0.0.1||8821] Lost connection to MySQL server at 'reading initial communication packet', system error: 111 May 17 14:27:31 err shardadmin_short_video_oss_20_d[141736]: Connect to db failed:[admin|SXobJfaXm4|127.0.0.1||8822] Lost connection to MySQL server at 'reading initial communication packet', system error: 111 May 17 14:27:31 err shardadmin_short_video_oss_20_d[141736]: Connect to db failed:[admin|SXobJfaXm4|127.0.0.1||8823] Lost connection to MySQL server at 'reading initial communication packet', system error: 111 May 17 14:27:31 err shardadmin_short_video_oss_20_d[141736]: Connect to db failed:[admin|SXobJfaXm4|127.0.0.1||8824] Lost connection to MySQL server at 'reading initial communication packet', system error: 111 May 17 14:27:31 err shardadmin_short_video_oss_20_d[141736]: Connect to db failed:[admin|SXobJfaXm4|127.0.0.1||8825] Lost connection to MySQL server at 'reading initial communication packet', system error: 111 May 17 14:27:31 err shardadmin_short_video_oss_20_d[141736]: Connect to db failed:[admin|SXobJfaXm4|127.0.0.1||8826] Lost connection to MySQL server at 'reading initial communication packet', system error: 111 May 17 14:27:31 err shardadmin_short_video_oss_20_d[141736]: Connect to db failed:[admin|SXobJfaXm4|127.0.0.1||8827] Lost connection to MySQL server at 'reading initial communication packet', system error: 111 May 17 14:27:31 warning shardadmin_short_video_oss_20_d[141736]: connect sync_server 45.124.254.45:12505 failed, [ShardAdminConfig2.cpp#81] May 17 14:27:31 info shardadmin_short_video_oss_20_d[141736]: create listen port 4455 success May 17 14:27:31 info shardadmin_short_video_oss_20_d[141736]: server start, epoll_prt=0x119b000 它把8821-8827的proxy当做是一个db来连接了，因为还真有可能不同端口对应不同的DB 后来4455的管理端口登录不上去了，报错没有权限 ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0 May 17 14:12:01 warning shardadmin_short_video_oss_20_d[139578]: deny connection from :127.0.0.1 怎样都连接不上 [root@localhost bin]# mysql -h0 -umyshard -pmyshard -P4455 ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0 [root@localhost bin]# mysql -h227.0.0.1 -umyshard -pmyshard -P4455 ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0 [root@localhost bin]# mysql -h227.0.0.1 -uadmin -padmin -P4455 ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0 [root@localhost bin]# mysql -h227.0.0.1 -uadmin -pSXobJfaXm4 -P4455 ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0 还有跟白名单有关系 mysql> select * from myshard_redip_list; +-----------------+-----------------+---------------+ | busi_name | machine_room_no | ip | +-----------------+-----------------+---------------+ | short_video_oss | 2 | xxx.xxx.252.45 | +-----------------+-----------------+---------------+ 发现白名单没有加上，于是改成自己的IP，再次重启shardadmin之后就能够顺利登陆了 看完上述内容是否对您有帮助呢？ （编辑：大连站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
站长推荐