[Python] [ADBC_DRIVER] [FlightSQL] flight: no authorization header on the response (Unknown; AuthenticateBasicToken) when creating new connection.

[amir-bashir]

Describe the usage question you have. Please include as many useful details as possible.

Below is my python code to connect to my flight sql jdbc server.

with flight_sql.connect(uri="grpc+tls://192.168.140.77:32222",
                          db_kwargs={
                                    "username": "username",
                                    "password": "Password",
                                    "adbc.flight.sql.client_option.tls_skip_verify": "true"
                                    }
                          ) as conn:

My python client code throws an exception and it does get the data.

Traceback (most recent call last):
  File "/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap
    self.run()
  File "/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/multiprocessing/process.py", line 108, in run
    self._target(*self._args, **self._kwargs)
  File "/Users/a.bashir/Desktop/python_codes/newproj/venv/arrow_py_client.py", line 19, in execute_arrow_query
    with flight_sql.connect(uri="grpc+tls://192.168.140.77:32222",
  File "/Users/a.bashir/Desktop/python_codes/newproj/venv/lib/python3.10/site-packages/adbc_driver_flightsql/dbapi.py", line 120, in connect
    conn = adbc_driver_manager.AdbcConnection(db, **(conn_kwargs or {}))
  File "adbc_driver_manager/_lib.pyx", line 644, in adbc_driver_manager._lib.AdbcConnection.__init__
  File "adbc_driver_manager/_lib.pyx", line 385, in adbc_driver_manager._lib.check_error
adbc_driver_manager._lib.OperationalError: ADBC_STATUS_UNKNOWN (1): [FlightSQL] [FlightSQL] flight: no authorization header on the response (Unknown; AuthenticateBasicToken)

This issue is also part of below issue:
#117

Component(s)

Java, Python