Visual Studio 8.9.6 can't authenticate DB on Mac OS 11.2.3

messier0109 1 Reputation point
2021-04-14T15:17:42.357+00:00

I have a fresh machine with a fresh installation of the latest Visual Studio. I am unable to connect to to the DB from my local api dev env because of DB connect error. I have confirmed that network and DB connection work from a different app, so it's something within VS. I have also followed tips on Known Issues: https://learn.microsoft.com/en-us/visualstudio/releasenotes/vs2019-mac-relnotes#--known-issues

Has anyone else encountered this? I noticed my MacOS version is different than the one listed in the VS Info

I also tried deleting all the "localhost" certificates in Keychain Access and re-adding them with sudo dotnet dev-certs https --clean and dotnet dev-certs https --trust. Did not work.

VS Info

=== Visual Studio Community 2019 for Mac ===  
  
Version 8.9.6 (build 6)  
Installation UUID: 54304ae5-2d92-4eb0-80f5-87bd4841e536  
 GTK+ 2.24.23 (Raleigh theme)  
 Xamarin.Mac 6.18.0.23 (d16-6 / 088c73638)  
  
 Package version: 612000125  
  
=== Mono Framework MDK ===  
  
Runtime:  
 Mono 6.12.0.125 (2020-02/8c552e98bd6) (64-bit)  
 Package version: 612000125  
  
=== Roslyn (Language Service) ===  
  
3.9.0-6.21152.10+c10f884b30737542ddd84ca889a4aad9281ce210  
  
=== NuGet ===  
  
Version: 5.8.0.6860  
  
=== .NET Core SDK ===  
  
SDK: /usr/local/share/dotnet/sdk/5.0.202/Sdks  
SDK Versions:  
 5.0.202  
 5.0.201  
 3.1.408  
 3.1.407  
MSBuild SDKs: /Applications/Visual Studio.app/Contents/Resources/lib/monodevelop/bin/MSBuild/Current/bin/Sdks  
  
=== .NET Core Runtime ===  
  
Runtime: /usr/local/share/dotnet/dotnet  
Runtime Versions:  
 5.0.5  
 5.0.4  
 3.1.14  
 3.1.13  
  
=== .NET Core 3.1 SDK ===  
  
SDK: 3.1.408  
  
=== Xamarin.Profiler ===  
  
'/Applications/Xamarin Profiler.app' not found  
  
=== Updater ===  
  
Version: 11  
  
=== Xamarin.Android ===  
  
Not Installed  
  
=== Microsoft OpenJDK for Mobile ===  
  
Java SDK: Not Found  
  
Android Designer EPL code available here:  
https://github.com/xamarin/AndroidDesigner.EPL  
  
=== Android SDK Manager ===  
  
Version: 16.9.0.22  
Hash: a391de2  
Branch: remotes/origin/d16-9~2  
Build date: 2021-03-24 08:30:26 UTC  
  
=== Android Device Manager ===  
  
Version: 16.9.0.17  
Hash: fc2b3db  
Branch: remotes/origin/dev/jmt/d16-9bump~1  
Build date: 2021-03-24 08:30:44 UTC  
  
=== Xamarin Designer ===  
  
Version: 16.9.0.323  
Hash: 1b4790c08  
Branch: remotes/origin/d16-9  
Build date: 2021-03-31 05:12:20 UTC  
  
=== Apple Developer Tools ===  
  
A valid Xcode installation was not found at the configured location: '/Library/Developer/CommandLineTools'  
  
=== Xamarin.Mac ===  
  
Xamarin.Mac not installed. Can't find /Library/Frameworks/Xamarin.Mac.framework/Versions/Current/Version.  
  
=== Xamarin.iOS ===  
  
Xamarin.iOS not installed.  
Can't find mtouch or the Version file at /Library/Frameworks/Xamarin.iOS.framework/Versions/Current.  
  
=== Build Information ===  
  
Release ID: 809060006  
Git revision: 47cf16e38721a785b8e2296ce6716502f34261ac  
Build date: 2021-04-07 07:23:18-04  
Build branch: release-8.9  
Xamarin extensions: 47cf16e38721a785b8e2296ce6716502f34261ac  
  
=== Operating System ===  
  
Mac OS X 10.16.0  
Darwin 20.3.0 Darwin Kernel Version 20.3.0  
    Thu Jan 21 00:07:06 PST 2021  
    root:xnu-7195.81.3~1/RELEASE_X86_64 x86_64  

Mac OS Info: macOS Big Sur, v11.2.3

Error:

System.Security.Authentication.AuthenticationException: Authentication failed, see inner exception.
---> Interop+AppleCrypto+SslException: Internal error
--- End of inner exception stack trace ---
at MySql.Data.Common.Ssl.StartSSL(Stream& baseStream, Encoding encoding, String connectionString)
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at System.Data.Common.DbConnection.OpenAsync(CancellationToken cancellationToken)
--- End of stack trace from previous location ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.GetResult()
at ActivTrak.Core.Dappers.Dapper.<QuerySingleOrDefaultAsync>d__101.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter1.GetResult()
at Microsoft.AspNetCore.Identity.UserManager1.<FindByNameAsync>d__78.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter1.GetResult()

VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,580 questions
{count} votes