{ERROR] 0BD-5000: alter user "root" IDENTIFIED BY %s execute failed

OceanBase 技术问题
#1

image
image1903×1131 247 KB

image
image2218×367 50 KB

obd_observer日志.zip (7.0 MB)
网卡
网卡1096×640 83.6 KB

ifconfig
ifconfig967×633 160 KB

在VMware中，CentOS Linux release 7.6.1810 (Core)，部署OceanBase出现错误：

[ERROR] OBD-5000: alter user “root” IDENTIFIED BY %s execute failed

部署指令：obd web集群安装

部署安装包：oceanbase-all-in-one-4.3.5_20250106.el7.x86_64.tar.gz

分配内存：16GB

硬盘空间:140GB

#3

登录失败可能是创建租户失败，麻烦提供一下yaml文件 ~/.obd/cluster/xxxx/

#4

[root@CentOS_7_Cluster cluster]# ls -lrt
total 0
drwxr-xr-x. 2 root root 50 Mar 3 09:46 myoceanbase
[root@CentOS_7_Cluster cluster]# cd myoceanbase/
[root@CentOS_7_Cluster myoceanbase]# ls -lrt
total 8
-rw-r–r–. 1 root root 216 Mar 3 09:46 inner_config.yaml
-rw-------. 1 root root 2146 Mar 3 09:46 config.yaml
[root@CentOS_7_Cluster myoceanbase]# vi inner_config.yaml
[root@CentOS_7_Cluster myoceanbase]# tail -100f inner_config.yaml
oceanbase-ce:
192.168.56.110: {}
192.168.56.111: {}
192.168.56.112: {}
obproxy-ce:
192.168.56.110: {}
obagent:
192.168.56.110: {}
192.168.56.111: {}
192.168.56.112: {}
ocp-express:
192.168.56.110: {}

^C
[root@CentOS_7_Cluster myoceanbase]#
[root@CentOS_7_Cluster myoceanbase]#
[root@CentOS_7_Cluster myoceanbase]#
[root@CentOS_7_Cluster myoceanbase]#
[root@CentOS_7_Cluster myoceanbase]#
[root@CentOS_7_Cluster myoceanbase]# pwd
/root/.obd/cluster/myoceanbase
[root@CentOS_7_Cluster myoceanbase]# ls -lrt
total 8
-rw-r–r–. 1 root root 216 Mar 3 09:46 inner_config.yaml
-rw-------. 1 root root 2146 Mar 3 09:46 config.yaml
[root@CentOS_7_Cluster myoceanbase]# cat inner_config.yaml
oceanbase-ce:
192.168.56.110: {}
192.168.56.111: {}
192.168.56.112: {}
obproxy-ce:
192.168.56.110: {}
obagent:
192.168.56.110: {}
192.168.56.111: {}
192.168.56.112: {}
ocp-express:
192.168.56.110: {}
[root@CentOS_7_Cluster myoceanbase]# cat config.yaml
user:
username: root
password: liuyunlin
port: 22
oceanbase-ce:
version: 4.3.5.0
release: 100000202024123117.el7
package_hash: 48b61655aaa13e9b01b722928d1979c76b41937e
192.168.56.110:
zone: zone1
192.168.56.111:
zone: zone2
192.168.56.112:
zone: zone3
servers:

  • 192.168.56.110
  • 192.168.56.111
  • 192.168.56.112
    global:
    appname: myoceanbase
    root_password: Rsync_0520
    mysql_port: 2881
    rpc_port: 2882
    home_path: /home/myoceanbase/oceanbase
    scenario: htap
    datafile_size: 2GB
    datafile_maxsize: 20GB
    datafile_next: 1GB
    log_disk_size: 10GB
    memory_limit: 10GB
    system_memory: 2GB
    cluster_id: 1740966412
    ocp_agent_monitor_password: CuLdtPeb1R
    proxyro_password: 7DFse52tiB
    enable_syslog_wf: false
    max_syslog_file_count: 4
    production_mode: false
    cpu_count: 16
    obproxy-ce:
    version: 4.3.2.0
    package_hash: b7ae0af3860478f3caecaaec05bd67d0565e4021
    release: 42.el7
    servers:
  • 192.168.56.110
    global:
    prometheus_listen_port: 2884
    listen_port: 2883
    rpc_listen_port: 2885
    home_path: /home/myoceanbase/obproxy
    obproxy_sys_password: y~PkSj;T9
    skip_proxy_sys_private_check: true
    enable_strict_kernel_release: false
    enable_cluster_checkout: false
    192.168.56.110:
    proxy_id: 6957
    client_session_id_version: 2
    depends:
  • oceanbase-ce
    obagent:
    version: 4.2.2
    package_hash: 19739a07a12eab736aff86ecf357b1ae660b554e
    release: 100000042024011120.el7
    servers:
  • 192.168.56.110
  • 192.168.56.111
  • 192.168.56.112
    global:
    monagent_http_port: 8088
    mgragent_http_port: 8089
    home_path: /home/myoceanbase/obagent
    http_basic_auth_password: V5DD87iwq
    ob_monitor_status: active
    depends:
  • oceanbase-ce
    ocp-express:
    version: 4.2.2
    package_hash: 09ffcf156d1df9318a78af52656f499d2315e3f7
    release: 100000022024011120.el7
    servers:
  • 192.168.56.110
    global:
    port: 8180
    admin_passwd: p7-5]R~fB[q+M-G7CKh]k1X09
    home_path: /home/myoceanbase/ocpexpress
    ocp_root_password: 5_hT9q_K
    memory_size: 872M
    depends:
  • obagent
  • oceanbase-ce
  • obproxy-ce
    [root@CentOS_7_Cluster myoceanbase]#
#5

看yaml缺失ocp_meta租户配置。ocp-express目前已经不推荐使用了，建议取消部署该组件选择部署ocp

#6

[quote=“辞霜, post:5, topic:35619532, full:true”]
看yaml缺失ocp_meta租户配置。ocp-express目前已经不推荐使用了，建议取消部署该组件选择部署ocp
[/quote]好的 感谢感谢

#7

你好，当前是否更改为部署ocp了，还有报错么