obproxy无法登录

【产品名称】oceanbase

【产品版本】社区版最新

【问题描述】obproxy无法登录,登录单节点正常,如下:

[admin@duizhang sstable]$ mysql -h 192.168.211.54 -uroot@sys#obce-3zone-obproxy -P2883 -poracle_4U -c -A oceanbase mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1045 (42000): Access denied for user ‘root@sys#obce-3zone-obproxy’@‘192.168.211.54’ (using password: YES)

yaml配置文件如下:


[admin@duizhang ~]$ more obce-3zones-obproxy.yaml
oceanbase-ce:
  servers:
    - name: server1
      ip: 192.168.211.54
    - name: server2
      ip: 192.168.211.54
    - name: server3
      ip: 192.168.211.54
  global:
    devname: eth0
    cluster_id: 1
    memory_limit: 8G
    system_memory: 4G
    stack_size: 512K
    cpu_count: 16
    disk_size: 20G
    datafile_size: 20G
    cache_wash_threshold: 1G
    __min_full_resource_pool_memory: 268435456
    workers_per_cpu_quota: 10
    schema_history_expire_time: 1d
    net_thread_count: 4
    major_freeze_duty_time: Disable
    minor_freeze_times: 10
    enable_separate_sys_clog: 0
    enable_merge_by_turn: FALSE
    datafile_disk_percentage: 20
    syslog_level: INFO
    enable_syslog_wf: false
    enable_syslog_recycle: true
    max_syslog_file_count: 4
    appname: obcluster
    root_password: oracle_4U
    proxyro_password: oracle_4U
  server1:
    mysql_port: 2881
    rpc_port: 2882
    home_path: /home/admin/observer1
    zone: zone1
  server2:
    mysql_port: 3881
    rpc_port: 3882
    home_path: /home/admin/observer2
    zone: zone2
  server3:
    mysql_port: 4881
    rpc_port: 4882
    home_path: /home/admin/observer3
    zone: zone3
obproxy:
  depends:
    - oceanbase-ce
  servers:
    - 192.168.211.54
  global:
    listen_port: 2883
    prometheus_listen_port: 2884
    home_path: /home/admin/obproxy
    enable_cluster_checkout: false
    skip_proxy_sys_private_check: true
    obproxy_sys_password: oracle_4U
    observer_sys_password: oracle_4U



[admin@duizhang sstable]$ mysql -h 192.168.211.54 -uproxyro@sys#obce-3zones-obproxy -P2883 -poracle_4U -c -A oceanbase
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error: 0


可以了。


[admin@duizhang sstable]$ mysql -h 192.168.211.54 -uroot@proxysys -P 2883 -poracle_4U
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.6.25


Copyright (c) 2000, 2021, Oracle and/or its affiliates.


Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.


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


这个用户默认不允许登陆,不用这么测试。用业务其他用户测试。

1 个赞


root@sys#obcluster


登陆

1 个赞