This topic is locked

Error thrown when displaying list page on MySQL hosted in AWS

4/27/2021 2:49:47 AM
ASPRunner.NET General questions
G
GBH author

Probably a simple question, but I'm not sure where to even start looking as my issue seems to be ASPRunner.Net specific.

I have a a functional application, and I am in the process of moving the MySQL database from a legacy hosting provided to one which is hosted by AWS

When I go to the tables tab and change the connection properties to point to the new environment, everything seems to be working fine.
I can still

  1. Synch the database
  2. Go into the Query tab, and the "results" are still displayed as normal
  3. Generate the application, seemingly with no issue

When I Build the project it compiles fine, then I click "View in browser" so that it will run under localhost and straight away it crashes, before any pages are displayed

I don't think that it's an AWS issue as such, because I can successflly do a number of things with this new environment outsaide of ASPRunner.net

What I CAN do with the data within AWS is:

  1. Connect to the AWS via MySQl Workbench. I can create a database, insert data everything as expected
  2. I can connect other query tools to the AWS database and build queries that return data

Thanks in advance, but I don't know where to start looking.

This is the error

Server Error in '/' Application.
The function requested is not supported
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ComponentModel.Win32Exception: The function requested is not supported

Source Error:

Line 156: if( !silentMode )
Line 157: {
Line 158: throw e;
Line 159: }
Line 160: return null;

Source File: c:\Development\TSSDb\connections\Connection.cs Line: 158

Stack Trace:

[Win32Exception (0x80004005): The function requested is not supported]

[AuthenticationException: A call to SSPI failed, see inner exception.]
runnerDotNet.Connection.connect() in c:\Development\TSSDb\connections\Connection.cs:158
runnerDotNet.Connection..ctor(XVar parameters) in c:\Development\TSSDb\connections\Connection.cs:50
runnerDotNet.MySQLConnection..ctor(XVar parameters) in c:\Development\TSSDb\connections\MySQLConnection.cs:16
runnerDotNet.ConnectionManager.getConnection(Object connId) in c:\Development\TSSDb\connections\ConnectionManager.cs:24
runnerDotNet.ConnectionManager_Base.byId(Object _param_connId) in c:\Development\TSSDb\connections\ConnectionManager_base.cs:76
runnerDotNet.ConnectionManager_Base.getDefault() in c:\Development\TSSDb\connections\ConnectionManager_base.cs:91
runnerDotNet.appsettings.Apply() in c:\Development\TSSDb\include\appsettings.cs:232
runnerDotNet.BaseController.OnActionExecuting(ActionExecutingContext filterContext) in c:\Development\TSSDb\Controllers\BaseController.cs:69
System.Web.Mvc.Controller.System.Web.Mvc.IActionFilter.OnActionExecuting(ActionExecutingContext filterContext) +10
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func1 continuation) +41 System.Web.Mvc.<>c__DisplayClass17.<InvokeActionMethodWithFilters>b__14() +22 System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +190
System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName) +311
System.Web.Mvc.Controller.ExecuteCore() +105
runnerDotNet.BaseController.ExecuteThread(Object arg) in c:\Development\TSSDb\Controllers\BaseController.cs:48

[AggregateException: One or more errors occurred.]
runnerDotNet.BaseController.ExecuteCore() in c:\Development\TSSDb\Controllers\BaseController.cs:35
System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext) +88
System.Web.Mvc.ControllerBase.System.Web.Mvc.IController.Execute(RequestContext requestContext) +10
System.Web.Mvc.<>cDisplayClassb.<BeginProcessRequest>b5() +34
System.Web.Mvc.Async.<>cDisplayClass1.<MakeVoidDelegate>b0() +16
System.Web.Mvc.Async.<>cDisplayClass8`1.<BeginSynchronous>b7(IAsyncResult _) +10
System.Web.Mvc.Async.WrappedAsyncResult`1.End() +50
System.Web.Mvc.<>cDisplayClasse.<EndProcessRequest>bd() +28
System.Web.Mvc.SecurityUtil.<GetCallInAppTrustThunk>b__0(Action f) +7
System.Web.Mvc.SecurityUtil.ProcessInApplicationTrust(Action action) +23
System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +59
System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) +9
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +9850009
System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +50
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +163

Admin 4/27/2021

This looks like SSL issue. Check the suggested solution at Stackoverflow

If the suggested registry change doesn't help try to run this application on another web server i.e. on Demo Account and see what happens.