同步失败 8810 deny connection from该怎么办
同步失败 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之后就能够顺利登陆了
看完上述内容是否对您有帮助呢?如果还想对相关知识有进一步的了解或阅读更多相关文章,请关注亿速云行业资讯频道,感谢您对亿速云的支持。
声明:本站所有文章资源内容,如无特殊说明或标注,均为采集网络资源。如若本站内容侵犯了原著者的合法权益,可联系本站删除。