-
Notifications
You must be signed in to change notification settings - Fork 3.7k
Description
hello, I am accessing the database on the cloud server from my local computer by python, but raise error (doris's 4.0)
code:
import adbc_driver_manager
import adbc_driver_flightsql.dbapi as flight_sql
conn = flight_sql.connect(uri=f"grpc://{doris_url}:8070",
db_kwargs={
adbc_driver_manager.DatabaseOptions.USERNAME.value: f"{doris_account}",
adbc_driver_manager.DatabaseOptions.PASSWORD.value: f"{doris_password}",
}
)
ProgrammingError: UNAUTHENTICATED: [FlightSQL] Unable to authenticate user read_user, exception: errCode = 2, detailMessage = Access denied for user 'read_user@0.0.0.0' (using password: YES) (Unauthenticated; AuthenticateBasicToken)
I can visit doris by mysql Protocol and I'm only a read_only role not root or admin.
thanks for your help