【产品名称】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.
这个用户默认不允许登陆，不用这么测试。用业务其他用户测试。
换
root@sys#obcluster
登陆