prmoore77 commented on PR #14082:
URL: https://github.com/apache/arrow/pull/14082#issuecomment-1344334877
>
After the latest changes to flight_sql.py - I attempted to test with:
```import os
import pyarrow.flight_sql
from dotenv import load_dotenv
import base64
# Load our environment for the password...
load_dotenv(dotenv_path=".env")
flight_password = os.environ["FLIGHT_PASSWORD"]
authorization_header = f"Basic
{str(base64.b64encode(bytes(f'flight_username:{flight_password}',
encoding='utf-8')), encoding='utf-8')}"
conn = pyarrow.flight_sql.connect(uri="grpc+tls://localhost:31337",
db_kwargs={"adbc.flight.sql.authorization_header": authorization_header,
"adbc.flight.sql.client_option.disable_server_verification": "true"
},
conn_kwargs=dict()
)
```
Getting:
```
Ssl handshake failed: SSL_ERROR_SSL: error:1416F086:SSL
routines:tls_process_server_certificate:certificate verify failed.
```
Can you advise? I'm not sure what to put in conn_kwargs - it is a required
arg. I attempted moving the server verification key/value into that arg, but
to no avail. Should we default it to any empty dict?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
