EF连接mysql，出现A call to SSPI failed错误，解决办法

最新推荐文章于 2023-04-29 18:03:21 发布
最新推荐文章于 2023-04-29 18:03:21 发布
阅读量1.1k 收藏
点赞数 1
文章标签： 数据库 c#
原文链接：http://www.cnblogs.com/xiaozhu39505/p/9299611.html
版权

我的使用场景是用EF连接AWS的mysql RDS，会偶发性的出现A call to SSPI failed错误，

System.AggregateException: One or more errors occurred. ---> System.Security.Authentication.AuthenticationException: A call to SSPI failed, see inner exception. ---> System.ComponentModel.Win32Exception: The message or signature supplied for verification has been altered
   --- End of inner exception stack trace ---
   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.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, 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.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, 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.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, 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.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, 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.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, 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.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.ForceAuthentication(Boolean receiveFirst, Byte[] buffer, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.ProcessAuthentication(LazyAsyncResult lazyResult)
   at System.Net.Security.SslStream.AuthenticateAsClient(String targetHost, X509CertificateCollection clientCertificates, SslProtocols enabledSslProtocols, Boolean checkCertificateRevocation)
   at MySql.Data.MySqlClient.NativeDriver.StartSSL()
   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 MySql.Data.MySqlClient.MySqlHelper.ExecuteNonQuery(String connectionString, String commandText, MySqlParameter[] parms)
   at Accushield.Program.WriteVisitInfoToDB(String filePath, String community_name, String eldermark_community_id) in E:\work\Veritage\GitSource\LIF-20180108-1-Staffed\DataLoader\Accushield\Program.cs:line 101
   at Accushield.Program.<ImportData>d__3.MoveNext() in E:\work\Veritage\GitSource\LIF-20180108-1-Staffed\DataLoader\Accushield\Program.cs:line 78
   --- End of inner exception stack trace ---
   at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
   at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
   at System.Threading.Tasks.Task.Wait()
   at Accushield.Program.Main(String[] args) in E:\work\Veritage\GitSource\LIF-20180108-1-Staffed\DataLoader\Accushield\Program.cs:line 20
---> (Inner Exception #0) System.Security.Authentication.AuthenticationException: A call to SSPI failed, see inner exception. ---> System.ComponentModel.Win32Exception: The message or signature supplied for verification has been altered
   --- End of inner exception stack trace ---
   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.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, 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.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, 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.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, 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.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, 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.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, 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.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.ForceAuthentication(Boolean receiveFirst, Byte[] buffer, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.ProcessAuthentication(LazyAsyncResult lazyResult)
   at System.Net.Security.SslStream.AuthenticateAsClient(String targetHost, X509CertificateCollection clientCertificates, SslProtocols enabledSslProtocols, Boolean checkCertificateRevocation)
   at MySql.Data.MySqlClient.NativeDriver.StartSSL()
   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 MySql.Data.MySqlClient.MySqlHelper.ExecuteNonQuery(String connectionString, String commandText, MySqlParameter[] parms)
   at Accushield.Program.WriteVisitInfoToDB(String filePath, String community_name, String eldermark_community_id) in E:\work\Veritage\GitSource\LIF-20180108-1-Staffed\DataLoader\Accushield\Program.cs:line 101
   at Accushield.Program.<ImportData>d__3.MoveNext() in E:\work\Veritage\GitSource\LIF-20180108-1-Staffed\DataLoader\Accushield\Program.cs:line 78<---

最后在StackOverflow里有人说在连接字符串里面加入SslMode=None，可以解决这个问题。

参考https://stackoverflow.com/questions/46518563/net-mysql-error-a-call-to-sspi-failed-message-received-was-unexpected

转载于:https://www.cnblogs.com/xiaozhu39505/p/9299611.html

weixin_30920513
关注
mysql 8.0 错误The server requested authentication method unknown to the client解决方法
01-19
mysql 安装了最新版本8.0.11后创建用户并授权后，授权的用户连接数据库提示 The server requested authentication method unknown to the client 查阅一些相关的资料后发现是由于新版本的mysql账号密码解锁机制不...
mysql spi_c# – .NET和MySQL错误 – 对SSPI的调用失败……“收到的消息是意外的或格式错误的”和“提供给函数的缓冲区太小”...
weixin_39699163的博客
01-19 1197
我希望这个问题不是太模糊,但我看得很远但却找不到任何有用的错误.我有一个.NET 4.5.2 Web服务层(使用ServiceStack和Dapper),自从我们部署服务以来,它几乎没有收到这两个错误.第一个错误：2017-09-29 18:13:26.637 +00:00 [Error] Class: "TokenRepository" | Method: "GetToken"System.Se...
C# SSL/TLS - 提示错误：“调用 SSPI 失败，请参见内部异常。”
猿长大人
01-20 7603
这里写自定义目录标题C#使用证书与服务端建立SSL/TLS通信，验证失败问题描述框架环境分析原因及解决方案 C#使用证书与服务端建立SSL/TLS通信，验证失败 遇到一个问题挺特殊的，记录一下。 问题描述 C#做客户端使用TcpClient+SslStream建立SSL/TLS通信时，在调用SslStream.AuthenticateAsClient方法验证证书时发生异常。 异常信息： 调用 SSPI 失败，请参见内部异常。 接收到的消息异常，或格式不正确。 A call to SSPI failed,
mysql spi_EF连接mysql，出现A call to SSPI failed错误，解决办法
weixin_39625872的博客
02-07 928
System.AggregateException: One or more errors occurred. ---> System.Security.Authentication.AuthenticationException: A call to SSPI failed, see inner exception. ---> System.ComponentModel.Win32E...
“User authentication failed: The SSL connection could not be established, see inner exception“ 解决方案
peixiaofei0721的专栏
09-13 1万+
闲来无事自己搞了一个Linux服务器进行学习，在部署完IdentityServer4的等各种服务啪啪啪啪搞完后，于是跑了第一个api service，蹦，直接提示The SSL connection could not be established, see inner exception，如下图： 解决方案如下： 第一步： 输入命令获取openssl相关信息，如图 openssl version -a 第二步： copy证书至/usr/local/openssl 下，如图 ...
The underlying connection was closed: An unexpected error occurred on a send
weixin_33726943的博客
05-11 1262
操作系统是Windows Server 2003 x64 SP2，使用Framework 4.0，在使用WebClient访问某些特定的HTTPS站点时，会引发异常：Unhandled Exception: System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a...
系统缓冲区耗尽
study4034的专栏
06-11 3779
系统缓冲区 简介 缓存是CPU的一部分，它存在于CPU中 CPU存取数据的速度非常的快，一秒钟能够存取、处理十亿条指令和数据（术语：CPU主频1G），而内存就慢很多，快的内存能够达到几十兆就不错了，可见两者的速度差异是多么的大，缓存是为了解决CPU速度和内存速度的速度差异问题。 解决问题过程 System.AggregateException: One or more errors occ...
无法校验计算机出示的证书,新计算机出现证书问题 - 提供给程序包的凭据无法识别...
weixin_31531599的博客
07-04 474
我正在新机器上安装Windows服务.该服务通过TCP对SslStream执行各种操作,该操作使用问题中的证书.该服务在其他2台Windows 2003计算机上使用相同的代码和相同的证书运行良好.但是,这台新机器也是带有64位处理器的Windows 2003.当我尝试使用"服务帐户"身份运行服务时,我遇到了这个问题.它使用我自己的凭据工作正常.(同样,它在使用此服务帐户的其他2台计算机上运行正常)...
C语言头文件 SSPI C语言头文件 SSPI
06-13
C语言头文件 SSPIC语言头文件 SSPIC语言头文件 SSPIC语言头文件 SSPIC语言头文件 SSPIC语言头文件 SSPIC语言头文件 SSPIC语言头文件 SSPIC语言头文件 SSPIC语言头文件 SSPIC语言头文件 SSPIC语言头文件 SSPIC语言...
易语言-SSPI 打造纯API+汇编 winhttp及socket支持SSL安全连接
06-29
SSPI 打造纯API+汇编 winhttp及socket支持SSL安全连接 抛弃累赘的OpenSSL，拥抱windows SSPI ! 背景:这也是在使用当中遇到的坑，winhttp组件在某些电脑上无法使用，要么open卡死，要么send卡死，后面用了hpsocket，...
SSPI 打造纯API+汇编 winhttp及socket支持SSL安全连接
05-27
SSPI 打造纯API+汇编 winhttp及socket支持SSL安全连接。抛弃累赘的OpenSSL，拥抱windows SSPI !。背景:这也是在使用当中遇到的坑，winhttp组件在某些电脑上无法使用，要么open卡死，要么send卡死，后面用了hpsocket...
MySQL配置文件my.ini的一般设置
热门推荐
学无止境
08-26 1万+
[mysqld] # 设置3306端口 port=3306 # 设置mysql的安装目录 basedir=D:\Software Package\mysql-8.0.12-winx64\mysql-8.0.12-winx64\ # 设置mysql数据库的数据的存放目录 datadir=D:\database\MySQL\Data # 允许最大连接数 max_connections=200 # 允...
【原创】HttpClient访问“不可靠”Https时错误处理
赵庆明老师
04-29 2256
但，使用HttpClient访问不合法的https站点，如直接使用IP地址访问，则出现异常。使用HttpClient访问带有合法证书的https站点，正常。使用HttpClient访问http站点，正常。这样，就不再报异常了。
Issue—C#—ssl相关错误
qq_37233070的博客
02-02 3453
Issue—C#—ssl相关错误
记一次线上SSL/TLS错误
yangguosheng的专栏
04-22 1969
业务需要调用第三方https，本地好好的，部署到服务器上报错。 服务器版本 window server 2012 r2 错误信息 .net core System.AggregateException：One or more errors occurred. (The SSL connection could not be established, see inner exception.) 内部错误System.Security.Authentication.AuthenticationExcepti
Fiddler无法抓取某些APP的HTTPS请求，无解！！！
weixin_30737433的博客
11-05 4287
遇到有些APP的HTTPS请求无法抓取！错误提示：!SecureClientPipeDirect failed: System.Security.Authentication.AuthenticationException A call to SSPI failed, see inner exception. < An unknown error occurred while proces...
Mysql连接失败解决方案
SteveForever的博客
11-28 3367
Mysql连接失败 在项目中，使用Mysql Client连接Mysql时出现了错误，打印错误信息 System.Security.Authentication.AuthenticationException: 调用 SSPI 失败，请参见内部异常。 ---> System.ComponentModel.Win32Exception: 接收到的消息异常，或格式不正确。 --- 内部异常堆栈跟踪的结尾 --- 在 System.Net.Security.SslState 可以观察到大致问题
wsus服务器无响应,WSUS的MMC无法连接服务器
weixin_42525353的博客
08-09 1495
我在WSUS服务器上打开WSUS控制台，报以下的错WSUS 管理控制台无法通过远程 API 连接到 WSUS 服务器。请确保 Update Services 服务、IIS 和 SQL 正在该服务器上运行。如果该问题仍然存在，请尝试重新启动 IIS、SQL 和 Update Services 服务。WSUS 管理控制台遇到意外错误。这可能是暂时错误；请尝试重新启动该管理控制台。如果此错误仍然存在，请...
vb.net连接mysql出现引发的异常:“System.Security.Authentication.AuthenticationException”(位于 MySql.Data.dll 中) Error: 调用 SSPI 失败，请参见内部异常。
最新发布
07-13
在使用 VB.NET 连接 MySQL 时，如果出现 "System.Security.Authentication.AuthenticationException" 异常并指示 "调用 SSPI 失败"，通常表示在与 MySQL 服务器建立 SSL 连接时遇到了问题。SSPI (Security Support ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值