obd demo后，连接不上，报密码错误

OceanBase 技术问题
#1

【 使用环境 测试环境
【 OB or 其他组件 】
【 使用版本 】v4.2.0
【问题描述】odb demo安装后，连接数据库报密码错误
【复现路径】
[root@yingji-db03.produce.yz ~]# obd demo
Package grafana-7.5.17-1 is available.
Package obagent-4.2.0-3.el7 is available.
Package prometheus-2.37.1-10000102022110211.el7 is available.
Package obproxy-ce-4.2.0.0-7.el7 is available.
Package oceanbase-ce-4.2.0.0-101000032023091319.el7 is available.
install grafana-7.5.17 for local ok
install obagent-4.2.0 for local ok
install prometheus-2.37.1 for local ok
install obproxy-ce-4.2.0.0 for local ok
install oceanbase-ce-4.2.0.0 for local ok
Cluster param config check ok
Open ssh connection ok
Generate grafana configuration ok
Generate obagent configuration ok
Generate prometheus configuration ok
Generate obproxy configuration ok
Generate observer configuration ok
±-------------------------------------------------------------------------------------------+
| Packages |
±-------------±--------±-----------------------±-----------------------------------------+
| Repository | Version | Release | Md5 |
±-------------±--------±-----------------------±-----------------------------------------+
| grafana | 7.5.17 | 1 | 1bf1f338d3a3445d8599dc6902e7aeed4de4e0d6 |
| obagent | 4.2.0 | 3.el7 | 30793df12dc6b8ec5ccdc93262e5e9f1d51ed50a |
| prometheus | 2.37.1 | 10000102022110211.el7 | 58913c7606f05feb01bc1c6410346e5fc31cf263 |
| obproxy-ce | 4.2.0.0 | 7.el7 | b3ead2f667d69fe3195fd22002de83df6eb19382 |
| oceanbase-ce | 4.2.0.0 | 101000032023091319.el7 | 176ae96ab6ea606c860e0a9db09f8046eec0ceba |
±-------------±--------±-----------------------±-----------------------------------------+
Repository integrity check ok
Parameter check ok
Cluster status check ok
Initializes grafana work home ok
Initializes obagent work home ok
Initializes prometheus work home ok
Initializes obproxy work home ok
Initializes observer work home ok
Remote grafana-7.5.17-1-1bf1f338d3a3445d8599dc6902e7aeed4de4e0d6 repository install ok
Remote grafana-7.5.17-1-1bf1f338d3a3445d8599dc6902e7aeed4de4e0d6 repository lib check ok
Remote obagent-4.2.0-3.el7-30793df12dc6b8ec5ccdc93262e5e9f1d51ed50a repository install ok
Remote obagent-4.2.0-3.el7-30793df12dc6b8ec5ccdc93262e5e9f1d51ed50a repository lib check ok
Remote prometheus-2.37.1-10000102022110211.el7-58913c7606f05feb01bc1c6410346e5fc31cf263 repository install ok
Remote prometheus-2.37.1-10000102022110211.el7-58913c7606f05feb01bc1c6410346e5fc31cf263 repository lib check ok
Remote obproxy-ce-4.2.0.0-7.el7-b3ead2f667d69fe3195fd22002de83df6eb19382 repository install ok
Remote obproxy-ce-4.2.0.0-7.el7-b3ead2f667d69fe3195fd22002de83df6eb19382 repository lib check ok
Remote oceanbase-ce-4.2.0.0-101000032023091319.el7-176ae96ab6ea606c860e0a9db09f8046eec0ceba repository install ok
Remote oceanbase-ce-4.2.0.0-101000032023091319.el7-176ae96ab6ea606c860e0a9db09f8046eec0ceba repository lib check !!
Try to get lib-repository
Package oceanbase-ce-libs-4.2.0.0-101000032023091319.el7 is available.
install oceanbase-ce-libs-4.2.0.0 for local ok
Remote oceanbase-ce-libs-4.2.0.0-101000032023091319.el7-f784db915f66cfb4dcab77147a9d8b0aeefbfb8c repository install ok
Remote oceanbase-ce-4.2.0.0-101000032023091319.el7-176ae96ab6ea606c860e0a9db09f8046eec0ceba repository lib check ok
demo deployed
Get local repositories ok
Search plugins ok
Open ssh connection ok
Load cluster param plugin ok
Check before start observer ok
[WARN] OBD-1007: (127.0.0.1) The recommended number of open files is 655350 (Current value: 102400)
[WARN] OBD-2000: (127.0.0.1) not enough memory. (Free: 1.4G, Need: 6.0G)
[WARN] OBD-1012: (127.0.0.1) clog and data use the same disk (/)

Check before start obagent ok
Check before start prometheus ok
Check before start obproxy ok
Check before start grafana ok
Start observer ok
observer program health check ok
Connect to observer 127.0.0.1:2881 ok
Initialize oceanbase-ce ok
Start obagent ok
obagent program health check ok
Connect to Obagent x
[ERROR] OBD-1006: Failed to connect to obagent

Wait for observer init ok
±--------------------------------------------+
| observer |
±----------±--------±-----±------±-------+
| ip | version | port | zone | status |
±----------±--------±-----±------±-------+
| 127.0.0.1 | 4.2.0.0 | 2881 | zone1 | ACTIVE |
±----------±--------±-----±------±-------+
obclient -h127.0.0.1 -P2881 -uroot -Doceanbase -A

See https://www.oceanbase.com/product/ob-deployer/error-codes .
Trace ID: bd697aa0-64af-11ee-aa8a-34737920d831
If you want to view detailed obd logs, please run: obd display-trace bd697aa0-64af-11ee-aa8a-34737920d831

obclient -h127.0.0.1 -P2881 -uroot@sys -Doceanbase -A
ERROR 1045 (42000): Access denied for user ‘root’@‘xxx.xxx.xxx.xxx’ (using password: YES)
【问题现象及影响】
obclient -h127.0.0.1 -P2881 -uroot@sys -Doceanbase -A
ERROR 1045 (42000): Access denied for user ‘root’@‘xxx.xxx.xxx.xxx’ (using password: YES)
【附件】

#3

看下进程起来了吗，进程起来的话，用下面方式尝试连接下
obclient -h127.0.0.1 -P2881 -uroot -Doceanbase -A

#4

怎么看进程起来了吗
还是报错：
obclient -h127.0.0.1 -P2881 -uroot -Doceanbase -A
ERROR 1045 (42000): Access denied for user ‘root’@‘xxx.xxx.xxx.xxx’ (using password: YES)

#5

ps -ef | grep observer
看下有没有这个进程在运行

#6

存在

ps -ef | grep observer
root 36680 1 20 09:22 ? 00:45:21 /root/oceanbase-ce/bin/observer -r 127.0.0.1:2882:2881 -p 2881 -P 2882 -z zone1 -c 1696641720 -d /root/oceanbase-ce/store -i lo -o __min_full_resource_pool_memory=1073741824,enable_syslog_recycle=True,enable_syslog_wf=False,max_syslog_file_count=4,memory_limit=6G,system_memory=1G,cpu_count=62,datafile_size=2G,datafile_maxsize=8G,datafile_next=2G,log_disk_size=13G

#7

obd demo安装完后，是不是应该有个密码，就是不知道密码是什么

#8

明白了，密码是空，加个-p直接回车再回车就好了，文档写的不严谨

obclient -h127.0.0.1 -P2881 -uroot -Doceanbase -A -p
Enter password:
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221500835
Server version: OceanBase_CE 4.2.0.0 (r101000032023091319-600ea4557d9847784acfa3e6b7a7d24c595891c6) (Built Sep 13 2023 20:02:19)

Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.

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

obclient [oceanbase]> show databases;
±-------------------+
| Database |
±-------------------+
| information_schema |
| LBACSYS |
| mysql |
| oceanbase |
| ORAAUDITOR |
| SYS |
| test |
±-------------------+
7 rows in set (0.007 sec)

1 个赞
#9

有你说的这个建议的链接嘛？