Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

小白求指教 ERROR conn.go:[231] #568

Open
luochaovg opened this issue Apr 25, 2020 · 1 comment
Open

小白求指教 ERROR conn.go:[231] #568

luochaovg opened this issue Apr 25, 2020 · 1 comment

Comments

@luochaovg
Copy link

luochaovg commented Apr 25, 2020

连接不上kingshard, 报错如下图!请问是什么问题
最新从github拉下的代码
2020/04/25 21:38:17 - ERROR - conn.go:[231] - [ClientConn] "readHandshakeResponse" "error" "auth=[42 186 130 42 215 157 183 209 186 5 9 239 107 215 155 215 248 187 254 239]|client_user=kingshard|config_set_user=kingshard|passworld=" conn_id=0
2020/04/25 21:38:17 - ERROR - conn.go:[108] - [server] "readHandshakeResponse" "ERROR 1045 (28000): Access denied for user 'kingshard'@'127.0.0.1:19456' (using password: Yes)" "msg=read Handshake Response error" conn_id=10006
2020/04/25 21:38:17 - ERROR - server.go:[386] - [server] "onConn" "ERROR 1045 (28000): Access denied for user 'kingshard'@'127.0.0.1:19456' (using password: Yes)" "" conn_id=0
2020/04/25 21:38:33 - ERROR - conn.go:[231] - [ClientConn] "readHandshakeResponse" "error" "auth=[71 250 119 52 0 216 240 16 78 148 5 25 183 44 252 92 130 157 101 124]|client_user=kingshard|config_set_user=kingshard|passworld=" conn_id=0
2020/04/25 21:38:33 - ERROR - conn.go:[108] - [server] "readHandshakeResponse" "ERROR 1045 (28000): Access denied for user 'kingshard'@'127.0.0.1:19458' (using password: Yes)" "msg=read Handshake Response error" conn_id=10007

场景

mysql -h 127.0.0.1 -P 9696 -ukingshard -pkingshard -e "select * from test_shard_hash where id in (2, 3, 4, 5)"

配置:

addr : 0.0.0.0:9696
prometheus_addr : 0.0.0.0:7080
user : kingshard
password : kingshard

web_addr : 0.0.0.0:9797
web_user : admin
web_password : admin
log_path : /data/go/src/github.com/flike/kingshard/log
log_level : debug
log_sql: on

nodes :

name : node1 
max_conns_limit : 32
user :  root 
password : ******
master : 127.0.0.1:3306
down_after_noalive : 32

schema :
nodes: [node1]
default: node1
shard:
-
db : vpdn
table : flows
key : id
nodes : [node1]
type: range
table_row_limit: 1000

@luochaovg luochaovg changed the title 小白求指教 小白求指教 conn.go:[231] Apr 25, 2020
@luochaovg luochaovg changed the title 小白求指教 conn.go:[231] 小白求指教 ERROR conn.go:[231] Apr 25, 2020
@deyigifts
Copy link

参考#591, 使用最新mysqlsh登录不会复现问题

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants