暂无图片
在虚拟机上安装ocenbase数据库时,报错ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.58.128' (111)
我来答
分享
striver
2021-03-01
在虚拟机上安装ocenbase数据库时,报错ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.58.128' (111)

1、第一步
[admin@observer1 oceanbase]$ bin/observer -i eth0 -P 2882 -p 2881 -z zone1 -d /home/admin/oceanbase/store/obdemo -r ‘192.168.58.128:2882:2881;192.168.58.129:2882:2881;192.168.58.130:2882:2881’ -c 20210227 -n obdemo -o “cpu_count=2,memory_limit=8G,datafile_size=40G,config_additional_dir=/data/1/obdemo/etc3;/data/log1/obdemo/etc2”
bin/observer -i eth0 -P 2882 -p 2881 -z zone1 -d /home/admin/oceanbase/store/obdemo -r 192.168.58.128:2882:2881;192.168.58.129:2882:2881;192.168.58.130:2882:2881 -c 20210227 -n obdemo -o cpu_count=2,memory_limit=8G,datafile_size=40G,config_additional_dir=/data/1/obdemo/etc3;/data/log1/obdemo/etc2
devname: eth0
rpc port: 2882
mysql port: 2881
zone: zone1
data_dir: /home/admin/oceanbase/store/obdemo
rs list: 192.168.58.128:2882:2881;192.168.58.129:2882:2881;192.168.58.130:2882:2881
cluster id: 20210227
appname: obdemo
optstr: cpu_count=2,memory_limit=8G,datafile_size=40G,config_additional_dir=/data/1/obdemo/etc3;/data/log1/obdemo/etc2
[2021-03-01 11:30:07.797187] ERROR [LIB] pidfile_test (utility.cpp:1168) [11112][0][Y0-0000000000000000] [lt=0] fid file doesn’t exist(pidfile=“run/observer.pid”) BACKTRACE:0x7a794ba 0x7a24476 0x461333 0x434cf82 0x7a7d09c 0x4499979 0x2b517ef213d5 0x44f8385

2、第二步
[admin@observer1 ~]$ mysql -h192.168.58.128 -uroot -P2881 -p

ERROR 2003 (HY000): Can’t connect to MySQL server on ‘192.168.58.128’ (111)

3、登录本地的mariadb可以登录
[admin@observer1 ~]$ mysql -h192.168.58.128 -uroot -P3306
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 5.5.60-MariaDB MariaDB Server

Copyright © 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

MariaDB [(none)]>

–请问如何解决

我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
刘贵宾

看一下配置文件my.cnf中bind-address的配置

暂无图片 评论
暂无图片 有用 1
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏