Skip to content

Authentication failed when use SETTINGS prefer_localhost_replica = 0 #107

@okarpov

Description

@okarpov

`Octonica.ClickHouseClient.Exceptions.ClickHouseServerException: DB::Exception: Received from 185.33.87.74:9000. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name. If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/ on the settings page for the corresponding service. 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. . Stack trace: 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x0000000013c42d9f 1. DB::Exception::Exception(String&&, int, String, bool) @ 0x000000000c89690e 2. DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000000c8963c0 3. DB::AccessControl::authenticate(DB::Credentials const&, Poco::Net::IPAddress const&, DB::ClientInfo const&) const @ 0x0000000017166ba3 4. DB::Session::authenticate(DB::Credentials const&, Poco::Net::SocketAddress const&, std::vector<String, std::allocator> const&) @ 0x00000000189ffc84 5. DB::Session::authenticate(String const&, String const&, Poco::Net::SocketAddress const&, std::vector<String, std::allocator> const&) @ 0x00000000189ff172 6. DB::TCPHandler::receiveHello() @ 0x000000001a48f859 7. DB::TCPHandler::runImpl() @ 0x000000001a47fc93 8. DB::TCPHandler::run() @ 0x000000001a4a5d59 9. Poco::Net::TCPServerConnection::start() @ 0x000000001f561c07 10. Poco::Net::TCPServerDispatcher::run() @ 0x000000001f562099 11. Poco::PooledThread::run() @ 0x000000001f528847 12. Poco::ThreadImpl::runnableEntry(void*) @ 0x000000001f526c41 13. ? @ 0x0000000000094ac3 14. ? @ 0x00000000001268c0 : While executing Remote at Octonica.ClickHouseClient.ClickHouseDataReader.Read(Boolean nextResult, Boolean async, CancellationToken cancellationToken) at Octonica.ClickHouseClient.ClickHouseDataReader.Read(Boolean async, CancellationToken cancellationToken) at _SSP.Pages.ChartsModel.OnGetHistoryMPartialAsync() in ._SSP\Pages\Charts.cshtml.cs:line 283

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions