DB::Exception: default: Authentication failed [ClickHouse]

Question

I Create CH with 1 shard and create some db and tables then i change my cluster to have 2 shard. shard 2 started and have all of tables but when i use this query i get error:

SELECT hostname() FROM tutorial.visits_all

Received exception from server (version 21.3.20): Code: 516. DB::Exception: Received from localhost:9000. DB::Exception: Received from chi-repl-05-replicated-0-0:9000. DB::Exception: default: Authentication failed: password is incorrect or there is no user with such name.

I'm sure my password is correct and i use this command clickhouse-client -h clickhouse-repl-05.rezvani-prom.svc --password qwerty --query "select hostname() from tutorial.visits_all"

Can anyone help me please

Thank you

this message is from the Distributed table. It cannot connect to another server. Shards use default user by default to connect to each other. You can configure secret in remote_servers or another user/password pair. — Denny Crane
– Denny Crane, Commented Apr 5, 2022 at 12:11
@DennyCrane I think this is from set password for default user. I say that because when i remove password my query works. — Ali Rezvani
– Ali Rezvani, Commented Apr 6, 2022 at 10:19
yes. It's expected. Use host_regex and remove password github.com/Altinity/clickhouse-operator/… — Denny Crane
– Denny Crane, Commented Apr 6, 2022 at 12:26

Ali Rezvani · Accepted Answer · 2022-04-09 05:44:57Z

5

Distributed queries use default user to connect to other shards. There are options

remove password from default user and setup < network > restriction for default user.
setup password for default user and use the same password in remote_servers
setup < secret > for remote_servers
setup another user and use this user in remote_servers
host_regexp in case of operator

https://github.com/Altinity/clickhouse-operator/issues?q=is%3Aissue+is%3Aopen+host_regexp

edited Apr 9, 2022 at 5:44

answered Apr 8, 2022 at 20:36

Ali Rezvani

4051 gold badge5 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

DB::Exception: default: Authentication failed [ClickHouse]

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related