ClickHouse / ClickHouse/ClickHouse

Document authentication process when using Dictionary.

Open
#56,033 6 comments 1 reaction 0 assignees View on GitHub
comp-dictionary external need-docs unexpected behaviour
Dominant language
C++
Stars
49.9k
Forks
9k
Avg merge
21h 32m
Merged PRs (30d)
515

Description

(you don't have to strictly follow this form)

**Describe the unexpected behaviour**
When trying to use ``getDict`` there is an authentication error thrown.

**How to reproduce**
ClickHouse server version 23.9.1 revision 54466.

Have a plaintext password setup for the default user.

Run the code:
```sql
create table test(a Int64, b String) Engine=MergeTree order by a;
insert into test values (1,'a'), (2,'b');

CREATE DICTIONARY test_dict( `a` Int64,`b` String)
PRIMARY KEY a
SOURCE(CLICKHOUSE(QUERY 'SELECT a,b FROM default.test'))
LIFETIME(MIN 0 MAX 0) LAYOUT(FLAT());

select dictGet('test_dict', 'b', 1);
```

**Expected behavior**
You get the result of ``dictGet``

**Error message and/or stacktrace**
```
Received exception from server (version 23.9.1):
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.

: While processing dictGet('test_dict', 'b', 1). (AUTHENTICATION_FAILED)
```

**Additional context**
None

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.