How to set password for distributed table in cluster discovery mode

[gogodjzhu]

I have a ck cluster with users.xml to specified password for users. But when I try to query a distributed table on it, I got exception:

10.132.174.22 :) select * from db1.table1_dist;                                                                                                                                                                      
                                                                                                                                                                                                                     
SELECT *                                                                                                                                                                                                             
FROM db1.table1_dist                                                                                                                                                                                                 
                                                                                                                                                                                                                     
Query id: 3a0269d4-6048-463c-b442-8e9861ab505d                                                                                                                                                                       
                                                                                                                                                                                                                     
Connecting to localhost:9000 as user default.                                                                                                                                                                        
Exception on client:                                                                                                                                                                                                 
Code: 516. DB::Exception: Received from localhost:9000. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name.                                                    
                                                                                                                                                                                                                     
If you have installed ClickHouse and forgot password you can reset it in the configuration file.                                                                                                                     
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml                                                                                                            
and deleting this file will reset the password.                                                                                                                                                                      
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.                                                                                                                               
                                                                                                                                                                                                                     
. (AUTHENTICATION_FAILED)     

What I know is to config user and password in remote_servers.replica, just like #5823 discuss. But I am deploy mode in cluster discovery mode like this which seems no properties about username/password.

Thx.

[vdimir]

Hi @gogodjzhu, thank you for the report!

Unfortunately, setting a password is not possible in the current implementation. (Link to the code if you are interested:

ClickHouse/src/Interpreters/ClusterDiscovery.cpp

Lines 250 to 252 in 20c0347

	ClusterConnectionParameters params{
	/* username= */ context->getUserName(),
	/* password= */ "",

)

So, it's something that has to be implemented. I assume it's not too challenging, and I'll check if it's feasible to implement it quickly.

[UnamedRus]

BTW, it would be nice to have support for secret instead of user/password (as it's newer alternative) .