数据库集群工作正常。 通过2881 端口 可以正常访问。
但通过obproxy的2883端口访问时，提示ERROR 1045：access denied for user root@sys (using password: YES)
obproxy 与observer 在同一台主机中，obproxy与observer工作正常。netstat命令可以看到2881、2882、2883、2884 端口
怀疑是observer中proxyro帐号的口令 与proxyconfig中配置不一致，进行了如下设置：
observer中：
alter user proxyro identified by ‘abcd’;
proxysys中：
alter proxyconfig set observer_sys_password=‘abcd’;
alter proxyconfig set observer_sys_password1=‘abcd’;
但是，故障仍旧， 请教这是怎么回事？
看下配置文件和sql语句
配置文件。看下
或者obd cluster display name 执行下
[admin@ob1 etc]$ strings /home/admin/obproxy/etc/obproxy_config.bin
client_session_id_version=1
connection_diagnosis_option=3
read_stale_remove_interval=6h
ob_max_read_stale_time=-1
read_stale_retry_interval=5s
enable_session_info_verification=False
init_sql=
binlog_service_ip=
enable_transaction_split=False
enable_read_write_split=False
enable_global_ps_cache=True
obproxy_force_parallel_query_dop=1
obproxy_read_consistency=0
obproxy_read_only=1
digest_sql_length=1024
enable_stat=True
enable_trace=True
enable_performance_mode=False
observer_sys_password1=00a8a9aee4a93e2a5b3da56a51731941ad94a959
observer_sys_password=00a8a9aee4a93e2a5b3da56a51731941ad94a959
obproxy_sys_password=00a8a9aee4a93e2a5b3da56a51731941ad94a959
inspector_password=de6d44e0bb589f8044f6dde47d870569c31dbcec
citadel_agent_ip=
bt_mode=
bt_retry_times=3
bt_server_addr=
domain_name=
session_pool_stat_log_interval=1m
session_pool_stat_log_ratio=9000
session_pool_default_prefill=False
session_pool_default_blocking_timeout=500ms
session_pool_default_idle_timeout=1800s
session_pool_default_max_conn=20
session_pool_default_min_conn=0
use_local_session_prop=False
session_pool_cont_delay_interval=5ms
max_pending_num=100000
create_conn_cont_num=10
refresh_server_cont_num=5
session_pool_retry_interval=1ms
need_release_after_tx=False
enable_no_sharding_skip_real_conn=False
enable_session_pool_for_no_sharding=False
enable_conn_precreate=False
is_pool_mode=False
auto_scan_all=False
cloud_instance_id=
mng_url=
runtime_env=
instance_ip=
pod_namespace=
pod_name=
server_zone=
workspace_name=
env_tenant_name=
grpc_timeout=30m
enable_shard_authority=False
use_local_dbconfig=False
dataplane_host=
sidecar_node_id=
enable_sharding=False
enable_mysql_proxy_pool=True
sequence_prefetch_threshold=7000
enable_sequence_prefetch=True
sequence_fail_retry_count=2
sequence_entry_expire_time=1d
enable_async_pull_location_cache=True
check_tenant_locality_change=True
ldg_info_refresh_interval=20s
enable_ldg=False
enable_primary_zone=True
proxy_primary_zone_name=
enable_standby=True
qos_stat_item_limit=3000
qos_stat_item_max_idle_period=30m
qos_stat_clean_interval=1m
enable_qos=False
ssl_attributes=
enable_server_ssl=False
enable_client_ssl=False
skip_proxy_sys_private_check=True
skip_proxyro_check=False
enable_full_username=True
enable_cloud_full_username=False
sql_table_cache_mem_limited=128MB
sql_table_cache_expire_relative_time=0
enable_index_route=False
mysql_version=5.6.25
enable_cpu_isolate=False
proxy_route_policy=
qa_mode_mock_public_cloud_vid=1
qa_mode_mock_public_cloud_slb_addr=127.0.0.1:33045
location_expire_period_time=0d
location_expire_period=0
enable_qa_mode=False
partition_location_expire_relative_time=0
enable_causal_order_read=True
enable_extra_prometheus_metric=False
enable_prometheus=True
prometheus_sync_interval=1s
prometheus_cost_ms_unit=False
prometheus_listen_port=2884
enable_monitor_stat=True
monitor_stat_high_threshold=500ms
monitor_stat_middle_threshold=100ms
monitor_stat_low_threshold=30ms
monitor_stat_dump_interval=1m
monitor_cost_ms_unit=False
monitor_item_max_idle_period=30m
monitor_item_limit=3000
tenant_location_valid_time=1d
delay_update_entry_interval=5s
client_max_memory_size=8MB
max_connections=60000
current_local_config_version=0
proxy_idc_name=
mem_leak_check_class_name=
mem_leak_check_mod_name=
enable_async_log=True
xflush_log_level=ERROR
monitor_log_level=INFO
server_routing_mode=oceanbase
test_server_addr=
protocol_diagnosis_level=0
route_diagnosis_level=2
target_db_server=
internal_cmd_mem_limited=16M
sqlaudit_mem_limited=0
limited_pl_update_threshold=10
normal_pl_update_threshold=100
enable_cached_server=True
enable_pl_route=True
enable_weak_reroute=True
enable_reroute=False
compression_algorithm=
enable_transaction_internal_routing=True
enable_ob_protocol_v2_with_client=False
enable_ob_protocol_v2=True
enable_compression_protocol=True
enable_partition_table_route=True
enable_bad_route_reject=False
detect_server_timeout=5s
server_detect_refresh_interval=1s
server_detect_fail_threshold=3
server_detect_mode=1
enable_congestion=True
min_congested_connect_timeout=100ms
congestion_retry_interval=20s
congestion_fail_window=120s
min_keep_congestion_interval=20s
congestion_failure_threshold=5
proxy_tenant_name=
rootservice_list=192.168.10.41:2881;192.168.10.42:2881;192.168.10.43:2881
rootservice_cluster_name=obcluster1
enable_get_rslist_remote=False
enable_metadb_used=False
proxy_cluster=undefined
app_name=myobproxy
proxy_id=0
proxy_service_mode=client
obproxy_config_server_url=
local_bound_ipv6_ip=::
ip_listen_mode=1
listen_port=2883
local_bound_ip=0.0.0.0
ignore_local_config=True
scan_buffered_rows_warning_threshold=50000
slow_query_time_threshold=500ms
query_digest_time_threshold=100ms
slow_proxy_process_time_threshold=2ms
slow_transaction_time_threshold=1s
enable_trace_stats=False
enable_cpu_topology=False
enable_strict_stat_time=True
enable_report_session_stats=False
enable_mysqlsm_info=True
enable_sync_all_stats=True
enable_trans_detail_stats=True
enable_flow_control=True
flow_event_queue_threshold=5
flow_consumer_reenable_threshold=256
flow_low_water_mark=64K
flow_high_water_mark=64K
request_buffer_length=4KB
tunnel_request_size_threshold=8KB
default_buffer_water_mark=32KB
max_log_file_size=256MB
enable_strict_kernel_release=False
automatic_match_work_thread=True
shard_scan_thread_num=0
grpc_client_num=9
grpc_thread_num=8
block_thread_num=1
task_thread_num=2
work_thread_num=128
routing_cache_mem_limited=128MB
stack_size=1MB
proxy_mem_limited=2G
client_tcp_user_timeout=0
client_tcp_keepcnt=2
client_tcp_keepintvl=5
client_tcp_keepidle=5
client_sock_option_flag_out=3
server_tcp_user_timeout=0
server_tcp_keepcnt=2
server_tcp_keepintvl=5
server_tcp_keepidle=5
server_tcp_init_cwnd=0
sock_packet_tos_out=0
sock_packet_mark_out=0
sock_option_flag_out=3
sock_send_buffer_size_out=0
sock_recv_buffer_size_out=0
default_inactivity_timeout=180000s
net_config_poll_timeout=1ms
net_accept_threads=2
frequent_accept=True
connect_observer_max_retries=3
enable_client_ip_checkout=True
enable_proxy_scramble=True
enable_cluster_checkout=True
observer_query_timeout_delta=20s
client_max_connections=8192
enable_client_connection_lru_disconnect=False
username_separator=:;-;.
short_async_task_timeout=5s
long_async_task_timeout=60s
need_convert_vip_to_tname=False
syslog_io_bandwidth_limit=30MB
syslog_level=WDIAG
enable_syslog_wf=False
enable_syslog_file_compress=False
max_syslog_file_count=0
max_syslog_file_time=7d
log_dir_size_threshold=10G
log_cleanup_interval=1m
log_file_percentage=80
delay_exit_time=100ms
hot_upgrade_exit_timeout=30000000
hot_upgrade_rollback_timeout=24h
hot_upgrade_failure_retries=5
fetch_proxy_bin_timeout=120s
fetch_proxy_bin_random_time=300s
cluster_expire_time=1d
cluster_count_high_water_mark=256
stat_dump_interval=6000s
stat_table_sync_interval=60s
idc_list_refresh_interval=2h
config_server_refresh_interval=60s
metadb_batch_interval=10ms
metadb_batch_size=5
metadb_server_state_refresh_interval=60s
server_state_refresh_interval=20s
cache_cleaner_clean_interval=20s
proxy_hot_upgrade_check_interval=5s
proxy_info_check_interval=60s
enable_xa_route=True
[admin@ob1 etc]$
用ocp web界面部署的proxy集群。 1+1+1模式。 proxy和observer在同一台主机。
ocp什么版本的呢 ，看下右上角的帮助。“关于”
我看下
-
没有部署obd. 用的oat + ocp 部署的 ob集群 和 obproxy集群。
-
部署ob 和obproxy时，用的全是一个密码。 用这密码登录2881端口成功，但登录2883这就以上错误。
你好，你提的这个技术问题牵涉到OceanBase企业版范围内的功能细节。建议你通过以下方式寻求帮助：
1.如你所在的企业客户已签署OceanBase企业版销售合同，请你联系客户经理；
2.如你所在的企业客户尚未签署OceanBase企业版销售合同，你可通过OceanBase官网商务咨询页面留下你的联系方式，OceanBase企业版的业务顾问会在一个工作日内与你联系。
OceanBase官网商务咨询
加个#集群试试。
查询当前集群名称
show parameters like ‘%cluster%’;
使用ocp部署的obproxy时的密码也是一样的嘛
observer.log和obd密码提供下把
收到。可以先咨询下上面的链接。