Skip to content
GHSA H9x9 P972 28q9

GHSA H9x9 P972 28q9

github.com • November 17, 2026

If a database server accepts an empty password, AdminNeo verifies the entered password against defaultPasswordHash , the common password for the accounts without their own one. The check is done by openPasswordless() . The ClickHouse driver opened the connection directly, so the check was not applied. A ClickHouse account identified by no_password accepts any password, so any non-empty password logged in to it although a common password was configured.

All releases before 5.9.1, ClickHouse driver (labelled as alpha), with defaultPasswordHash set to a hash. The check was added to MySQL and PostgreSQL in 5.2.0 ( 7905a358 , issue #162 ) and ClickHouse was not included.

admin/drivers/clickhouse.inc.php#L375 — connect() calls $connection->open() with the entered password.

admin/core/Connection.php#L84-L99 — openPasswordless() tries an empty password first and verifies the entered one against the hash. It is used by MySQL, PostgreSQL, Elasticsearch and SimpleDB.

The Oracle driver calls open() the same way. No way to an account without a password was found there, so it is not changed.

Preconditions: defaultPasswordHash is set to a hash; a ClickHouse account without a password exists, created e.g. by CREATE USER nopass NOT IDENTIFIED ; the attacker knows its name.

Set defaultPasswordHash to the hash of secret .

Log in by the ClickHouse driver as nopass with the password wrong .

Result (verified on ClickHouse 26.8):

The default account of a stock installation, which the report names as an example, is not affected. It is identified by plaintext_password with an empty password and the server rejects any non-empty one. For the same reason it was not possible to log in to it at all if the hash was set.

Anyone who can reach the login form and knows the name of an account without a password gets a session with its rights, although the operator protected such accounts by a common password. The account has to be created without a password explicitly, the stock default account is not affected.

connect() of the ClickHouse driver opens the connection by openPasswordless() as MySQL and PostgreSQL do. An account that accepts an empty password is accessible only by the password matching defaultPasswordHash , which also makes the stock default account usable with the common password.

Found by AlpetGexha, reported through VulnCheck (CNA).

Extracted Entities