InfluxDB: Add configuration option for enabling insecure gRPC connections

[jmickey]

What is this feature?

Adds an option in the SQL query language configuration for InfluxDB to skip TLS security on gRPC connections for Flight SQL.

Why do we need this feature?

InfluxData offers a Kubernetes deployment of V3 called "Clustered", when deployed alongside Grafana and using AWS LoadBalancers to terminate TLS attempting to connect to the cluster service endpoint for InfluxDB fails due to a lack of TLS connection when using the "SQL" Query Language type.

Who is this feature for?

InfluxDB v3 Clustered users.

Which issue(s) does this PR fix?:

Fixes #83732

Special notes for your reviewer:

Please check that:

• It works as expected from a user's perspective.
• If this is a pre-GA feature, it is behind a feature toggle.
• The docs are updated, and if this is a notable improvement, it's added to our What's New doc.

[CLAassistant]

All committers have signed the CLA.

[jdbaldry]

Docs look fine to me.

[Abhi94N]

Just to add to this. I'm using an Internal CA to sign my TLS/SSL certs and I am getting the following error.

ERROR: flightsql: rpc error: code = Unavailable desc = connection error: desc = "transport: authentication handshake failed: tls: failed to verify certificate: x509: certificate signed by unknown authority"

[itsmylife]

Thanks for the PR. It looks great.
Just a few nits.
After that it is good to go.

[jmickey]

@itsmylife thanks for the review! I've applied the suggestions you made. Much appreciated

[itsmylife]

Could you please run

• yarn run prettier:checkDocs
• yarn run prettier:write

and commit the changes you'll get?

[jmickey]

Done!

[itsmylife]

There was a problem in main. That was causing one test to fail always. We've fixed it. Could you please pull the latest main and merge into your branch? And then hopefully I will be able to merge this one. Thanks for that tin advance!

[jmickey]

No problem! Rebased now.

[itsmylife]

@jmickey Thank you for the PR and all the hustle you went through. 💪

[hiltontj]

It is not clear to me whether this was released with 11.0.0. I do not see it on the release page for the v11.0.0 tag, but I do see the changes on the version associated with the v11.0.0 tag.

[itsmylife]

@hiltontj This is released in v11.0.0 but somehow in the release page it wasn't mentioned. I am not sure what happened there bu this is in v11.0.0. Let me know if there is something else and I'd be happy to help.