[WARN] OBD-4521: The config observer_sys_password in obproxy-ce did not take effect, please config it in oceanbase-ce

OceanBase
, ,
#5

ocp-express白屏化页面能访问到么

4 个赞
#6

老师，以这个为准
obd.log (117.3 KB)

4 个赞
#7

现在访问不到吧，因为启动的时候，就启动失败了，查看组件，也看不到ocp的那个显示

4 个赞
#8

手动使用mysql命令黑屏连接下
mysql -h192.168.146.27 -P2883 -umeta@ocp_meta -pc5B989Vesj -Ac
尝试单独拉起ocp组件
obd cluster start xxx -s #ocp的ip -c ocp-express

4 个赞
#9

mysql -h192.168.146.27 -P2883 -umeta@ocp_meta -pc5B989Vesj -Ac

登录不上，另外我又发现一个问题，就是我刚刚启动obd，但是我执行obd cluster display obtest 提示我没有启动。但是我可以用root登录到oceanbase租户中。 您看一下我的操作日志

4 个赞
#10

obclient -h192.168.146.27 -P2883 -uroot@proxysys -p’NubeWTJtZj’ -Doceanbase -A
image
这两个密码不一致呀，是不是改过。可以参考下这个帖子
三台电脑集群，然后三台电脑重启后打开集群报错：192.168.177.88: failed to connect meta db - #6，来自 至尊琳琳llavqm_gaMjAxODUwMDg2Ni4xNzIwNTA0NDU0_ga_T35KTM57DZ*MTcyMTcxMzY1Ny4zMi4xLjE3MjE3MTUzMjIuNDcuMC4w

3 个赞
#11

我没有改过，我只是做了一个版本升级的操作。

3 个赞
#12

mysql -h192.168.146.27 -uproxyro@sys -P2881 -pNubeWTJtZj -A
mysql -h192.168.146.27 -uproxyro@sys -P2881 -p HwqddBZqd -A
试下两个连接串哪个能用

2 个赞
#13

都不行

1 个赞
#14

obclient -h192.168.146.27 -P2883 -uroot@proxysys -p’NubeWTJtZj’ -Doceanbase -A

obclient -h192.168.146.27 -P2881 -uroot -p’Z:-}f!7z-c),RqjSv’ -Doceanbase -A

这样子连接是可以的

#15

config.yaml文件有问题呀，
obd cluster edit-config
把密码改成这个试试NubeWTJtZj

#16

[admin@obd-4231 ~]$ mysql -h192.168.146.27 -uproxyro@sys -P2881 -pNubeWTJtZj -A
ERROR 1045 (42000): Access denied for user ‘proxyro’@‘xxx.xxx.xxx.xxx’ (using password: YES)
[admin@obd-4231 ~]$ mysql -h192.168.146.27 -uproxyro@sys -P2881 -p’NubeWTJtZj’ -A
ERROR 1045 (42000): Access denied for user ‘proxyro’@‘xxx.xxx.xxx.xxx’ (using password: YES)
[admin@obd-4231 ~]$ mysql -h192.168.146.27 -uproxyro@sys -P2881 -pHwqddBZqd -A
ERROR 1045 (42000): Access denied for user ‘proxyro’@‘xxx.xxx.xxx.xxx’ (using password: YES)
[admin@obd-4231 ~]$ mysql -h192.168.146.27 -uproxyro@sys -P2881 -p’HwqddBZqd’ -A
ERROR 1045 (42000): Access denied for user ‘proxyro’@‘xxx.xxx.xxx.xxx’ (using password: YES)

[admin@obd-4231 ~]$ obd cluster edit-config obtest
Search param plugin and load ok

user:
username: admin
port: 22
oceanbase-ce:
version: 4.2.4.0
release: 100000082024070810.el7
package_hash: 7dc8b049b3283ef4660cdf6e3cfa24f81e9d2a78
192.168.146.27:
zone: zone1
servers:

  • 192.168.146.27
    global:
    appname: obtest
    root_password: Z:-}f!7z-c),RqjSv
    mysql_port: 2881
    rpc_port: 2882
    data_dir: /data
    redo_dir: /redo
    home_path: /home/admin/oceanbase/obtest/oceanbase
    cluster_id: 1721379461
    enable_syslog_recycle: true
    enable_syslog_wf: false
    max_syslog_file_count: 4
    memory_limit: 6144M
    datafile_size: 18432M
    system_memory: 2048M
    log_disk_size: 18432M
    cpu_count: 16
    production_mode: false
    datafile_maxsize: 185G
    datafile_next: 18957M
    ocp_agent_monitor_password: 689wiO6y64
    proxyro_password: NubeWTJtZj
    ocp_root_password: HmcJOkrRqM
    ocp_meta_password: c5B989Vesj
    obproxy-ce:
    version: 4.2.3.0
    package_hash: 0490ebc04220def8d25cb9cac9ac61a4efa6d639
    release: 3.el7
    servers:
  • 192.168.146.27
    global:
    prometheus_listen_port: 2884
    listen_port: 2883
    home_path: /home/admin/oceanbase/obtest/obproxy
    obproxy_sys_password: NubeWTJtZj
    skip_proxy_sys_private_check: true
    enable_strict_kernel_release: false
    enable_cluster_checkout: false
    rs_list: 192.168.146.27:2881
    observer_sys_password: Hwqdd2BZqd
    cluster_name: obtest
    observer_root_password: Z:-}f!7z-c),RqjSv
    192.168.146.27:
    proxy_id: 2580
    client_session_id_version: 2
    depends:
  • oceanbase-ce
    obagent:
    version: 4.2.2
    package_hash: 19739a07a12eab736aff86ecf357b1ae660b554e
    release: 100000042024011120.el7
    servers:
  • 192.168.146.27
    global:
    monagent_http_port: 8088
    mgragent_http_port: 8089
    home_path: /home/admin/oceanbase/obtest/obagent
    http_basic_auth_password: v7V4tzP9I
    ob_monitor_status: active
    depends:
  • oceanbase-ce
    ocp-express:
    version: 4.2.2
    package_hash: 09ffcf156d1df9318a78af52656f499d2315e3f7
    release: 100000022024011120.el7
    servers:
  • 192.168.146.27
    global:
    port: 8180
    home_path: /home/admin/oceanbase/obtest/ocpexpress
    admin_passwd: L@v6O.8t
    ocp_root_password: (t1.6uPD
    memory_size: 752M
    depends:
  • obagent
  • oceanbase-ce
  • obproxy-ce
#17

现在是两个密码都登陆不上去了？

#18

用 proxyro 用户登录，哪个密码都登录不上去，刚才没有改密码之前也是这样的。

#19

用root登录sys租户和proxysys租户是可以的。

obclient -h192.168.146.27 -P2881 -uroot -p’Z:-}f!7z-c),RqjSv’ -Doceanbase -A

obclient -h192.168.146.27 -P2883 -uroot@proxysys -p’NubeWTJtZj’ -Doceanbase -A

#20

稍等哈，这边联系下其他同学帮忙看一下

#21

麻烦obd重新启动集群复现后，提供下最新的obproxy.log日志

#22

按照以下步骤操作试试：

  1. obclient -h192.168.146.27 -P2881 -uroot -p’Z:-}f!7z-c),RqjSv’ -Doceanbase -A
    登录后执行alter user proxyro identified by “NubeWTJtZj”;

  2. obclient -h192.168.146.27 -P2883 -uroot@proxysys -p’NubeWTJtZj’ -Doceanbase -A
    执行两条sql：
    alter proxyconfig set observer_sys_password=“NubeWTJtZj”;
    alter proxyconfig set observer_sys_password1=“NubeWTJtZj”;

  3. obd cluster start obtest

#23

执行了您给的命令。现在提示[ERROR] 192.168.146.27: failed to connect meta db

[admin@obd-4231 log]$ obd cluster start obtest
Get local repositories ok
Search plugins ok
Load cluster param plugin ok
Open ssh connection ok
Check before start observer ok
Check before start obproxy ok
[WARN] OBD-4521: The config observer_sys_password in obproxy-ce did not take effect, please config it in oceanbase-ce

Check before start obagent ok
Check before start ocp-express ok
Start observer ok
observer program health check ok
obshell program health check ok
Connect to observer 192.168.146.27:2881 ok
Start obproxy ok
obproxy program health check ok
Connect to obproxy ok
Initialize obproxy-ce ok
Start obagent ok
obagent program health check ok
Connect to Obagent ok
Start ocp-express x
[ERROR] 192.168.146.27: failed to connect meta db

[ERROR] ocp-express start failed
Wait for observer init ok
±-------------------------------------------------+
| observer |
±---------------±--------±-----±------±-------+
| ip | version | port | zone | status |
±---------------±--------±-----±------±-------+
| 192.168.146.27 | 4.2.4.0 | 2881 | zone1 | ACTIVE |
±---------------±--------±-----±------±-------+
obclient -h192.168.146.27 -P2881 -uroot -p’Z:-}f!7z-c),RqjSv’ -Doceanbase -A

cluster unique id: 9241407d-07ae-5648-91be-1ccd318afb5d-190cbd4ee56-00040204

±-------------------------------------------------+
| obproxy |
±---------------±-----±----------------±-------+
| ip | port | prometheus_port | status |
±---------------±-----±----------------±-------+
| 192.168.146.27 | 2883 | 2884 | active |
±---------------±-----±----------------±-------+
obclient -h192.168.146.27 -P2883 -uroot@proxysys -p’NubeWTJtZj’ -Doceanbase -A

±------------------------------------------------------------------+
| obagent |
±---------------±-------------------±-------------------±-------+
| ip | mgragent_http_port | monagent_http_port | status |
±---------------±-------------------±-------------------±-------+
| 192.168.146.27 | 8089 | 8088 | active |
±---------------±-------------------±-------------------±-------+
See OceanBase分布式数据库-海量数据 笔笔算数 .
Trace ID: d50ad004-48d0-11ef-a4d1-000c291dacdb
If you want to view detailed obd logs, please run: obd display-trace d50ad004-48d0-11ef-a4d1-000c291dacdb
[admin@obd-4231 log]$ obd cluster list
±-----------------------------------------------------------+
| Cluster List |
±-------±--------------------------------±----------------+
| Name | Configuration Path | Status (Cached) |
±-------±--------------------------------±----------------+
| obtest | /home/admin/.obd/cluster/obtest | stopped |
±-------±--------------------------------±----------------+
Trace ID: c99c5980-48d1-11ef-9803-000c291dacdb
If you want to view detailed obd logs, please run: obd display-trace c99c5980-48d1-11ef-9803-000c291dacdb
[admin@obd-4231 log]$

#24

obproxy.zip (1.8 MB)
obproxy_error.log (445.1 KB)