同步失败 8810 deny connection from该怎么办，很多新手对此不是很清楚，为了帮助大家解决这个难题，下面小编将为大家详细讲解，有这方面需求的人可以来学习下，希望你能有所收获。

发现法xxx.xxx.254.45，没有同步拉取到其他点的数据，查看同步的日志，一直显示被其他节点拒绝的状态，拒绝说明是权限没有通过

May1713:22:10warningdb_sync_short_video_oss_r2m0_d[]:[tid:137732][SocketServer::OnAccept]denyconnectionfrom:xxx.xxx.125.2:53316May1713:22:20warningdb_sync_short_video_oss_r2m0_d[]:[tid:137739][SocketServer::OnAccept]denyconnectionfrom:xxx.xxx.125.2:53318May1713:22:31warningdb_sync_short_video_oss_r2m0_d[]:[tid:137746][SocketServer::OnAccept]denyconnectionfrom:xxx.xxx.125.2:53320May1713:22:41warningdb_sync_short_video_oss_r2m0_d[]:[tid:137752][SocketServer::OnAccept]denyconnectionfrom:xxx.xxx.125.2:53322

目标机器已经开通了防火墙和白名单了，在xxx.xxx.125.2机器上，使用netstat已经看到了建立了连接，说明防火墙已经开放了端口了

tcp00xxx.xxx.125.2:12505xxx.xxx.254.45:41734ESTABLISHED48767/./db_sync_sho

重启xxx.xxx.254.45的4455，看到报错

May1713:36:43infoshardadmin_short_video_oss_20_d[138429]:HAVE_EPOLLMay1713:36:43debugshardadmin_short_video_oss_20_d[138429]:outputqueueokMay1713:36:43debugshardadmin_short_video_oss_20_d[138429]:outputqueueokMay1713:36:43errshardadmin_short_video_oss_20_d[138429]:Connecttodbfailed:[admin|SXobJfaXm4|xxx.xxx.254.45||8810]LostconnectiontoMySQLserverat'readinginitialcommunicationpacket',systemerror:0May1713:36:43infoshardadmin_short_video_oss_20_d[138429]:createlistenport4455successMay1713:36:43infoshardadmin_short_video_oss_20_d[138429]:serverstart,epoll_prt=0x1335000May1713:36:53noticeshardadmin_short_video_oss_20_d[138429]:request:0proc:0droped:0active:0May1713:37:03noticeshardadmin_short_video_oss_20_d[138429]:request:0proc:0droped:0active:0

连接不上8810的DB是正常的，因为同步还没有开启，如果不启动shard8821到8827，启动myshardmin会报如下错误

May1714:27:31infoshardadmin_short_video_oss_20_d[141736]:HAVE_EPOLLMay1714:27:31debugshardadmin_short_video_oss_20_d[141736]:outputqueueokMay1714:27:31debugshardadmin_short_video_oss_20_d[141736]:outputqueueokMay1714:27:31errshardadmin_short_video_oss_20_d[141736]:Connecttodbfailed:[admin|SXobJfaXm4|45.124.254.45||8810]LostconnectiontoMySQLserverat'readinginitialcommunicationpacket',systemerror:111May1714:27:31errshardadmin_short_video_oss_20_d[141736]:Connecttodbfailed:[admin|SXobJfaXm4|127.0.0.1||8810]LostconnectiontoMySQLserverat'readinginitialcommunicationpacket',systemerror:111May1714:27:31errshardadmin_short_video_oss_20_d[141736]:Connecttodbfailed:[admin|SXobJfaXm4|127.0.0.1||8821]LostconnectiontoMySQLserverat'readinginitialcommunicationpacket',systemerror:111May1714:27:31errshardadmin_short_video_oss_20_d[141736]:Connecttodbfailed:[admin|SXobJfaXm4|127.0.0.1||8822]LostconnectiontoMySQLserverat'readinginitialcommunicationpacket',systemerror:111May1714:27:31errshardadmin_short_video_oss_20_d[141736]:Connecttodbfailed:[admin|SXobJfaXm4|127.0.0.1||8823]LostconnectiontoMySQLserverat'readinginitialcommunicationpacket',systemerror:111May1714:27:31errshardadmin_short_video_oss_20_d[141736]:Connecttodbfailed:[admin|SXobJfaXm4|127.0.0.1||8824]LostconnectiontoMySQLserverat'readinginitialcommunicationpacket',systemerror:111May1714:27:31errshardadmin_short_video_oss_20_d[141736]:Connecttodbfailed:[admin|SXobJfaXm4|127.0.0.1||8825]LostconnectiontoMySQLserverat'readinginitialcommunicationpacket',systemerror:111May1714:27:31errshardadmin_short_video_oss_20_d[141736]:Connecttodbfailed:[admin|SXobJfaXm4|127.0.0.1||8826]LostconnectiontoMySQLserverat'readinginitialcommunicationpacket',systemerror:111May1714:27:31errshardadmin_short_video_oss_20_d[141736]:Connecttodbfailed:[admin|SXobJfaXm4|127.0.0.1||8827]LostconnectiontoMySQLserverat'readinginitialcommunicationpacket',systemerror:111May1714:27:31warningshardadmin_short_video_oss_20_d[141736]:connectsync_server45.124.254.45:12505failed,[ShardAdminConfig2.cpp#81]May1714:27:31infoshardadmin_short_video_oss_20_d[141736]:createlistenport4455successMay1714:27:31infoshardadmin_short_video_oss_20_d[141736]:serverstart,epoll_prt=0x119b000

它把8821-8827的proxy当做是一个db来连接了，因为还真有可能不同端口对应不同的DB

后来4455的管理端口登录不上去了，报错没有权限

ERROR2013(HY000):LostconnectiontoMySQLserverat'readinginitialcommunicationpacket',systemerror:0

May1714:12:01warningshardadmin_short_video_oss_20_d[139578]:denyconnectionfrom:127.0.0.1

怎样都连接不上

[root@localhostbin]#mysql-h0-umyshard-pmyshard-P4455ERROR2013(HY000):LostconnectiontoMySQLserverat'readinginitialcommunicationpacket',systemerror:0[root@localhostbin]#mysql-h227.0.0.1-umyshard-pmyshard-P4455ERROR2013(HY000):LostconnectiontoMySQLserverat'readinginitialcommunicationpacket',systemerror:0[root@localhostbin]#mysql-h227.0.0.1-uadmin-padmin-P4455ERROR2013(HY000):LostconnectiontoMySQLserverat'readinginitialcommunicationpacket',systemerror:0[root@localhostbin]#mysql-h227.0.0.1-uadmin-pSXobJfaXm4-P4455ERROR2013(HY000):LostconnectiontoMySQLserverat'readinginitialcommunicationpacket',systemerror:0

还有跟白名单有关系

mysql>select*frommyshard_redip_list;+-----------------+-----------------+---------------+|busi_name|machine_room_no|ip|+-----------------+-----------------+---------------+|short_video_oss|2|xxx.xxx.252.45|+-----------------+-----------------+---------------+

发现白名单没有加上，于是改成自己的IP，再次重启shardadmin之后就能够顺利登陆了

看完上述内容是否对您有帮助呢？如果还想对相关知识有进一步的了解或阅读更多相关文章，请关注亿速云行业资讯频道，感谢您对亿速云的支持。