search

oceanbase / oceanbase

OceanBase is an enterprise distributed relational database with high availability, high performance, horizontal scalability, and compatibility with SQL standards.
https://open.oceanbase.com
Other
8.22k stars 1.65k forks source link

[Bug]: root@sys#obde 用户登录失败 || [Bug]: Login failed for root@sys#obde user #2000

Open michael-liumh opened 2 months ago

michael-liumh commented 2 months ago

Describe the bug

Environment

REVISION: 100000192024011915-fac02c6690de9ff9f9f96c0bdf86ffe39ae0d7e7 BUILD_BRANCH: HEAD BUILD_TIME: Jan 19 2024 15:14:05 BUILD_FLAGS: RelWithDebInfo BUILD_INFO:

Copyright (c) 2011-present OceanBase Inc.

Fast Reproduce Steps(Required)

Steps to reproduce the behavior: 用OBD部署的OceanBase 3副本集群，集群名称为obdemo，集群成功启动后，登录sys租户，用户名为root或者root@sys都能正常登录，但是用户名变成root@sys#obde就无法登录了，请问是什么原因呢？

Expected behavior

root@sys#obde能正常登录

Actual Behavior

root@sys#obde无法登录

Additional context

Describe the bug

Environment

REVISION: 100000192024011915-fac02c6690de9ff9f9f96c0bdf86ffe39ae0d7e7 BUILD_BRANCH: HEAD BUILD_TIME: Jan 19 2024 15:14:05 BUILD_FLAGS: RelWithDebInfo BUILD_INFO:

Copyright (c) 2011-present OceanBase Inc.

Fast Reproduce Steps(Required)

Steps to reproduce the behavior: OceanBase 3 replica cluster deployed with OBD, the cluster name is obdemo. After the cluster is successfully started, you can log in to the sys tenant with the user name root or root@sys, but you cannot log in when the user name becomes root@sys#obde. ,What is the reason?

Expected behavior

root@sys#obde can log in normally

Actual Behavior

root@sys#obde cannot log in

Additional context

michael-liumh commented 2 months ago

1 2 3

hnwyllmm commented 2 months ago

root@sys#obde ‘#’ 后面是集群名称，使用 obproxy 登录集群的时候，使用这种格式连接。

root@sys#obde ‘#’ is followed by the cluster name. When using obproxy to log in to the cluster, use this format to connect.

michael-liumh commented 2 months ago

没错呀，官网也有写，但现在问题是，带了集群名称就登录不了了，不带就能成功登录，导致在使用 obdumper 和 obloader 的时候备份不了数据，提示跟这个类似，说登录失败

正常来说，这种用户名格式应该是能正常登录的吧，毕竟文档很多地方都有写

---原始邮件--- 发件人: @.> 发送时间: 2024年6月11日(周二) 上午9:24 收件人: @.>; 抄送: @.**@.>; 主题: Re: [oceanbase/oceanbase] [Bug]: @.#obde 用户登录失败 || [Bug]: Login failed for @.#obde user (Issue #2000)

@.***#obde ‘#’ 后面是集群名称，使用 obproxy 登录集群的时候，使用这种格式连接。

@.***#obde ‘#’ is followed by the cluster name. When using obproxy to log in to the cluster, use this format to connect.

— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: @.***>

whhe commented 2 months ago

你需要指定 obproxy 的端口，2881 端口是直连单个 observer 用的，直连的用户名不带集群名。

You need to specify the port of obproxy. Port 2881 is used for direct connection to a single observer. The user name for direct connection does not include the cluster name.