Can't connect to SQL Server instance with "Require SSL/TLS" through the Cloud SQL connectors [184867147]

Infeasible

Bug

Status Update

No update yet.

Description

kv...@google.com

created issue #1

Apr 8, 2021 07:19PM

When connecting to a SQL Server instance that has "Require SSL/TLS" checked when using the Cloud SQL connectors (proxy binary, or Dialer, or Java JDBC Socket Factory), the connections fail with an error message like:

Client does not have encryption enabled but it is required by server, enable encryption and try connecting again

This is unintended behavior since the Cloud SQL connectors do provide encryption between the client and proxy server. This behavior only occurs with SQL Server - MySQL/Postgres instances are unaffected.

The workaround is to use self-managed SSL/TLS cert when connecting through the Cloud SQL Auth Proxy. There are no known workarounds for the other connectors.

Comments

wi...@google.com <wi...@google.com> #2Jun 29, 2021 07:47PM

Assigned to kv...@google.com.

This mentioned interface was removed only starting 7.2, so you shouldn't have problems with using firebase with AGP 7.1. Are you sure you don't have a dependency somewhere (maybe buildSrc?) on AGP or just gradle-api 7.2?

wi...@google.com <wi...@google.com> #3Jun 30, 2021 04:28AM

Reassigned to en...@google.com.

I checked the project and there is no reference to AGP 7.2
I looked in ~/.gradle/caches/modules-2/files-2.1/com.android.tools.build/gradle-api and ~/.gradle/caches/modules-2/files-2.1/com.android.tools.build/gradle

Only 7.1.0-beta04 and 7.1.0-beta05 is there.

I checked with a new project. This problem only occurs when I enable the com.google.gms.google-services
and com.google.firebase.firebase-perf plugin.
Without these plugins everything works fine.

wi...@google.com <wi...@google.com> #4Jul 1, 2021 06:39AM

This is a known issue, we are working with those teams so they release a compatible plugin.

en...@google.com <en...@google.com> #5Jul 1, 2021 01:41PM

Reassigned to sh...@google.com.

Thanks!

sh...@google.com <sh...@google.com> #6Jul 2, 2021 09:57PM

When can we expect an update on this?

Message last modified on Jul 7, 2021 04:47PM

kv...@google.com <kv...@google.com> Jul 7, 2021 04:20PM

Reassigned to wi...@google.com.

wi...@google.com <wi...@google.com> #7Oct 5, 2021 05:24PM

Reassigned to kv...@google.com.

Last communication from firebase-perf team stated a release is scheduled for this week.

sh...@google.com <sh...@google.com> #8Oct 5, 2021 06:17PM

But it looks like not only perf but androidx.navigation.safeargs.gradle.SafeArgsPlugin also has this issue.

kv...@google.com <kv...@google.com> #9Nov 5, 2021 03:44PM

Status: Won't Fix (Infeasible)

Yep, androidx.navigation.safeargs.gradle.SafeArgsPlugin seems to be an issue too.