c# - 带有 .net 的 Web 服务未连接到内部信息服务中的 mysql db
问题描述
我编写了一个连接到 mysql 数据库并提供 api 的 web 服务。当我在 Visual Studio 中运行它时,它工作正常。现在我希望它在我把它放在互联网信息服务中时工作。但是 api 没有返回。我希望此 api 运行的单页应用程序给了我以下错误
GET http://localhost:8024/api/Interviewee 500 (Internal Server Error)
angular.js:15536 Possibly unhandled rejection: {"data":{"Message":"An error has occurred.","ExceptionMessage":"Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.","ExceptionType":"System.InvalidOperationException","StackTrace":" at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)\r\n at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n at System.Data.SqlClient.SqlConnection.Open()\r\n at IntervieweeService.Controllers.IntervieweeController.GetInterviewees() in C:\\Projects\\IntervieweeApp\\IntervieweeService\\IntervieweeService\\Controllers\\IntervieweeController.cs:line 30\r\n at lambda_method(Closure , Object , Object[] )\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_1.<GetExecutor>b__3(Object instance, Object[] methodParameters)\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__15.MoveNext()"},"status":500,"config":{"method":"GET","transformRequest":[null],"transformResponse":[null],"jsonpCallbackParam":"callback","url":"http://localhost:8024/api/Interviewee","headers":{"Accept":"application/json, text/plain, */*"}},"statusText":"Internal Server Error","xhrStatus":"complete"}
(anonymous) @ angular.js:15536
(anonymous) @ angular.js:11815
processChecks @ angular.js:17946
$digest @ angular.js:19075
$apply @ angular.js:19463
done @ angular.js:13312
completeRequest @ angular.js:13569
requestLoaded @ angular.js:13474
load (async)
(anonymous) @ angular.js:13457
sendReq @ angular.js:13257
serverRequest @ angular.js:12998
processQueue @ angular.js:17914
(anonymous) @ angular.js:17962
$digest @ angular.js:19075
$apply @ angular.js:19463
done @ angular.js:13312
completeRequest @ angular.js:13569
requestLoaded @ angular.js:13474
load (async)
(anonymous) @ angular.js:13457
sendReq @ angular.js:13257
serverRequest @ angular.js:12998
processQueue @ angular.js:17914
(anonymous) @ angular.js:17962
$digest @ angular.js:19075
$apply @ angular.js:19463
bootstrapApply @ angular.js:1945
invoke @ angular.js:5122
doBootstrap @ angular.js:1943
bootstrap @ angular.js:1963
angularInit @ angular.js:1848
(anonymous) @ angular.js:36216
fire @ jquery-2.2.4.js:3187
fireWith @ jquery-2.2.4.js:3317
ready @ jquery-2.2.4.js:3536
completed @ jquery-2.2.4.js:3552
连接字符串
Server=localhost;Port=8024;Database=intervieweedb;Uid=rrrr;Pwd=111;
我怎样才能使这项工作?谢谢
解决方案
如果您通过http://localhost:8024/api/Interviewee访问您的网站,那么您的 Web 服务器正在使用端口 8024。Server=localhost;Port=8024
在您的连接字符串中是错误的,因为 MySQL 需要在不同的端口上运行。
将 MySQL 连接字符串中的更改为Port
MySQL 服务器的端口号(通常为3306
)。
推荐阅读
- python - Gensim/word2vec 错误:嵌入层错误
- docker - 我可以使用任何命令在 tcp://localhost:2375 上公开“docker for windows”的守护进程吗?
- javascript - message.mentions.users.first().id 定义有问题
- dart - 来自 GestureDetector() 的 onTapDown 和其他回调被延迟
- sql - 比较 PostgreSQL 中的两个逗号分隔的列
- c - 错误:使用“designated_init”属性声明的“struct”中字段的位置初始化 [-Werror=designated-init]
- java - 根据 ADF 中的自定义 Pojo 列表在 af:table 上应用过滤器
- c# - 如何使用推送通知将来自 webapi 操作方法的返回消息显示到我的 Web 浏览器
- css - 使用断点创建新的引导类
- laravel-5.7 - DB::select() - 如何获取数组数组而不是集合数组