SSL Authentication Error - A call to SSPI failed, see inner exception.

[kg6zgj]

This is a portion of the exception json log.

The strange thing is i am not using ssl.

"_index": "log-2018.01.24",
"_type": "logEvent",
"_id": "AWEp3wn8NcVp4M8On1s1",
"_version": 1,
"_score": null,
"_source": {
"timeStamp": "2018-01-24T20:32:18.2730385Z",
"message": "Application error",
"messageObject": {},
"exception": {
"Type": "MySql.Data.MySqlClient.MySqlException",
"Message": "SSL Authentication Error",
"HelpLink": null,
"Source": "MySqlConnector",
"HResult": -2147467259,
"StackTrace": " at MySql.Data.Serialization.MySqlSession.d__67.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
 at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
 at System.Runtime.CompilerServices.ConfiguredTaskAwaitable.ConfiguredTaskAwaiter.GetResult()
 at MySql.Data.Serialization.MySqlSession.d__52.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
 at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
 at MySql.Data.MySqlClient.MySqlConnection.d__79.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
 at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
 at MySql.Data.MySqlClient.MySqlConnection.d__19.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
 at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
 at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)
 at MySql.Data.MySqlClient.MySqlConnection.Open()
 at Microsoft.EntityFrameworkCore.Storage.Internal.MySqlConnectionSettings.<>c__DisplayClass2_0.b__0(String key)
 at System.Collections.Concurrent.ConcurrentDictionary2.GetOrAdd(TKey key, Func2 valueFactory)
 at System.Lazy1.CreateValue()
--- End of stack trace from previous location where exception was thrown ---
 at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
 at System.Lazy1.get_Value()
 at Microsoft.EntityFrameworkCore.Storage.Internal.MySqlSmartTypeMapper.MaybeConvertMapping(RelationalTypeMapping mapping)
 at Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapper.IsTypeMapped(Type clrType)
 at System.Linq.Enumerable.WhereArrayIterator1.MoveNext()
 at Microsoft.EntityFrameworkCore.Metadata.Conventions.Internal.PropertyDiscoveryConvention.Apply(InternalEntityTypeBuilder entityTypeBuilder)
 at Microsoft.EntityFrameworkCore.Metadata.Conventions.Internal.ConventionDispatcher.ImmediateConventionScope.OnEntityTypeAdded(InternalEntityTypeBuilder entityTypeBuilder)
 at Microsoft.EntityFrameworkCore.Metadata.Internal.Model.AddEntityType(EntityType entityType)
 at Microsoft.EntityFrameworkCore.Metadata.Internal.InternalModelBuilder.Entity(TypeIdentity type, ConfigurationSource configurationSource)
 at Microsoft.EntityFrameworkCore.Metadata.Internal.InternalModelBuilder.Entity(Type type, ConfigurationSource configurationSource)
 at Microsoft.EntityFrameworkCore.ModelBuilder.Entity(Type type)
 at Microsoft.EntityFrameworkCore.Infrastructure.ModelCustomizer.FindSets(ModelBuilder modelBuilder, DbContext context)
 at Microsoft.EntityFrameworkCore.Infrastructure.RelationalModelCustomizer.FindSets(ModelBuilder modelBuilder, DbContext context)
 at Microsoft.EntityFrameworkCore.Infrastructure.ModelCustomizer.Customize(ModelBuilder modelBuilder, DbContext context)
 at Microsoft.EntityFrameworkCore.Infrastructure.ModelSource.CreateModel(DbContext context, IConventionSetBuilder conventionSetBuilder, IModelValidator validator)
 at System.Collections.Concurrent.ConcurrentDictionary2.GetOrAdd(TKey key, Func2 valueFactory)
 at Microsoft.EntityFrameworkCore.Internal.DbContextServices.CreateModel()
 at Microsoft.EntityFrameworkCore.Internal.DbContextServices.get_Model()
 at lambda_method(Closure , ServiceProvider )
 at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService(IServiceProvider provider, Type serviceType)
 at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService[T](IServiceProvider provider)
 at Microsoft.EntityFrameworkCore.DbContext.get_DbContextDependencies()
 at Microsoft.EntityFrameworkCore.DbContext.get_InternalServiceProvider()
 at Microsoft.EntityFrameworkCore.DbContext.get_DbContextDependencies()
 at Microsoft.EntityFrameworkCore.DbContext.get_Model()
 at Microsoft.EntityFrameworkCore.Internal.InternalDbSet1.get_EntityType()
 at Microsoft.EntityFrameworkCore.Internal.InternalDbSet1.get_EntityQueryable()
 at Microsoft.EntityFrameworkCore.Internal.InternalDbSet1.System.Linq.IQueryable.get_Provider()
 at System.Linq.Queryable.Any[TSource](IQueryable1 source, Expression1 predicate)
 at Chatbooks.Core.Vocabluary.Using[T,TResult](Func1 init, Func2 func)
 at folkstory.Global.Application_PreRequestHandlerExecute(Object send, EventArgs e) in C:\TeamCity\buildAgent\work\53f103504e450429\trunk\folkstory\Website\Global.asax.cs:line 140
 at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
 at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)",
"Data": {},
"InnerException": {
"Type": "System.Security.Authentication.AuthenticationException",
"Message": "A call to SSPI failed, see inner exception.",
"HelpLink": null,
"Source": "System",
"HResult": -2146233087,
"StackTrace": " at System.Net.Security.SslState.StartSendAuthResetSignal(ProtocolToken message, AsyncProtocolRequest asyncRequest, Exception exception)
 at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)
 at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)
 at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest)
 at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)
 at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)
 at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest)
 at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)
 at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)
 at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest)
 at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)
 at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)
 at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest)
 at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)
 at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)
 at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest)
 at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)
 at System.Net.Security.SslState.ForceAuthentication(Boolean receiveFirst, Byte[] buffer, AsyncProtocolRequest asyncRequest)
 at System.Net.Security.SslState.ProcessAuthentication(LazyAsyncResult lazyResult)
 at MySql.Data.Serialization.MySqlSession.d__67.MoveNext()",
"Data": {},
"InnerException": {
"Type": "System.ComponentModel.Win32Exception",
"Message": "The message received was unexpected or badly formatted",
"HelpLink": null,
"Source": null,
"HResult": -2147467259,
"StackTrace": null,
"Data": {},
"InnerException": null
}
}
},

[bgrainger]

What version of MySqlConnector are you using? (It does not appear to be a recent one.)

SSL is on by default (if the server supports it); use SslMode=None in your connection string to explicitly disable it.

Otherwise, it looks like this is an error from System.Net.Security.SslState.StartSendAuthResetSignal that's just being propagated through MySqlConnector. It's possible this might be caused by connecting to a MySQL Server that only supports TLS 1.2; on Windows we have to disable that TLS protocol due to the reasons given in #101. What MySQL Server and version are you connecting to?

[kg6zgj]

Thank you for the help! We are using 0.29.4 of MysqlConnector and Aurora MySQL 5.6.10a. We should probably update here soon! Thank you for making this library btw! You are awesome! I think for my situation I will make sure not to use ssl since we don't connect outside our network vpc right now. so that solution should work, I will try it and get back to this thread.

[infiniteloopltd]

Try setting the TLS version to 1.2 globally?

ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;

[bgrainger]

@infiniteloopltd That only affects HTTPS connections (so is not relevant to MySqlConnector); see https://docs.microsoft.com/en-us/dotnet/framework/network-programming/tls for more details.

[shuangyuxiaoyi]

@kg6zgj Is this solved? I got the same issue recently.

[bgrainger]

This appears to be an Aurora-related issue: #576 (comment)

The workaround is to retry opening the connection. If you're using Pomelo.EntityFrameworkCore.MySql, you might want to try setting MySqlDbContextOptionsBuilder.EnableRetryOnFailure.

[shuangyuxiaoyi]

I using MySql.Data and ADO.NET , it has error on mySqlConnection.Open();

…

------------------ 原始邮件 ------------------ 发件人: "notifications"<notifications@github.com>; 发送时间: 2019年5月18日(星期六) 凌晨0:15 收件人: "mysql-net/MySqlConnector"<MySqlConnector@noreply.github.com>; 抄送: "Mr.guo"<burst_city@foxmail.com>;"Comment"<comment@noreply.github.com>; 主题: Re: [mysql-net/MySqlConnector] SSL Authentication Error - A call toSSPI failed, see inner exception. (#428) This appears to be an Aurora-related issue: #576 (comment) The workaround is to retry opening the connection. If you're using Pomelo.EntityFrameworkCore.MySql, you might want to try setting MySqlDbContextOptionsBuilder.EnableRetryOnFailure. — You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.