This is a migrated thread and some comments may be shown as answers.

Downgrades OpenAccess/MySQL Connector dlls

9 Answers 113 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

João asked on 20 Jun 2013, 07:13 AM

Is there any way to downgrade the mysql.data dependency? I'm running my website in a shared host (medium trust) and the current version of MySql.Data (6.6.5.0) seems to cause an exception. I see people fixing the problem by replacing the dll to version 6.2.5.0, but when I do that OpenAccess dlls complains about the version.

Is there any way to bypass this, or downgrade the OpenAccess version to get rid of this problem?

Btw, I've changed the rlinq configuration to medium trust already. The problem seems to be the MySql dll, not OpenAccess.

Also, here is the stack trace:

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: Cannot perform CAS Asserts in Security Transparent methods]

MySql.Data.MySqlClient.MySqlClientFactory..cctor() +23

[OpenAccessException: Cannot perform CAS Asserts in Security Transparent methods]

OpenAccessRuntime.ExceptionWrapper.Throw() +7

OpenAccessRuntime.Helper.getPersistenceManagerFactory(PropertySet props) +160

OpenAccessRuntime.DatabaseAdapter.AssertPersistenceManagerFactory(String usr, String password, Boolean open) +1078

OpenAccessRuntime.DatabaseAdapter.GetObjectScope(TransactionProvider provider) +36

Telerik.OpenAccess.Database.GetObjectScope(TransactionProvider provider) +13

Telerik.OpenAccess.OpenAccessContextBase.GetScope() +42

Telerik.OpenAccess.OpenAccessContext.GetAllCore() +33

Telerik.OpenAccess.OpenAccessContext.GetAll() +48

Cerberus.Models.Users.Authenticator.Validate(String email, String password) +128

Cerberus.Controllers.AccountController.Login(LoginForm form) +80

lambda_method(Closure , ControllerBase , Object[] ) +86

System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) +17

System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) +188

System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +27

System.Web.Mvc.Async.<>c__DisplayClass42.<BeginInvokeSynchronousActionMethod>b__41() +28

System.Web.Mvc.Async.<>c__DisplayClass8`1.<BeginSynchronous>b__7(IAsyncResult _) +12

System.Web.Mvc.Async.WrappedAsyncResult`1.End() +50

System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult) +29

System.Web.Mvc.Async.<>c__DisplayClass39.<BeginInvokeActionMethodWithFilters>b__33() +58

System.Web.Mvc.Async.<>c__DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b__49() +238

System.Web.Mvc.Async.<>c__DisplayClass37.<BeginInvokeActionMethodWithFilters>b__36(IAsyncResult asyncResult) +12

System.Web.Mvc.Async.WrappedAsyncResult`1.End() +50

System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) +31

System.Web.Mvc.Async.<>c__DisplayClass2a.<BeginInvokeAction>b__20() +23

System.Web.Mvc.Async.<>c__DisplayClass25.<BeginInvokeAction>b__22(IAsyncResult asyncResult) +128

System.Web.Mvc.Async.WrappedAsyncResult`1.End() +50

System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) +26

System.Web.Mvc.<>c__DisplayClass1d.<BeginExecuteCore>b__18(IAsyncResult asyncResult) +14

System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +25

System.Web.Mvc.Async.WrappedAsyncResult`1.End() +55

System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +41

System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +25

System.Web.Mvc.Async.WrappedAsyncResult`1.End() +55

System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) +28

System.Web.Mvc.Controller.System.Web.Mvc.Async.IAsyncController.EndExecute(IAsyncResult asyncResult) +10

System.Web.Mvc.<>c__DisplayClass8.<BeginProcessRequest>b__3(IAsyncResult asyncResult) +28

System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +25

System.Web.Mvc.Async.WrappedAsyncResult`1.End() +55

System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +30

System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) +9

System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +8966925

System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +184

Thank you!

9 Answers, 1 is accepted

answered on 25 Jun 2013, 07:41 AM

Hi João,

OpenAccess loads the ADO.NET driver (mysql.data assembly) using the standard ADO.NET ProviderFactory mechanism. If your machine.config points to the '6.2.5.0' version then OpenAccess will try to use this version of the driver. Is this version present in the GAC? What exception do you get when you try to use this version?

Regards,
Ady
Telerik

OpenAccess ORM Q2 2013 brings you a more powerful code generation and a unique Bulk Operations support with LINQ syntax. Check out the list of new functionality and improvements shipped with this release.

answered on 07 Jan 2014, 12:42 PM

Hi Ady ...

At first I used the version that you send along with your product (6.6.5.0).

Then tested with a recent version downloaded from MySql site (6.8.3.0).

In both I used the "ProviderFactory mechanism" suggested for you to have the system make use of this new version.

I have not tested with the older version suggested by you. This could be the problem? Ie I would have to download the older version for it to work?

Here is the stack trace

Telerik.OpenAccess.Runtime --> Cannot perform CAS Asserts in Security Transparent methodsem:

at OpenAccessRuntime.ExceptionWrapper.Throw()

at OpenAccessRuntime.Helper.getPersistenceManagerFactory(PropertySet props)

at OpenAccessRuntime.DatabaseAdapter.AssertPersistenceManagerFactory(String usr, String password, Boolean open)

at OpenAccessRuntime.DatabaseAdapter.GetObjectScope(TransactionProvider provider)

at Telerik.OpenAccess.Database.GetObjectScope(TransactionProvider provider)

at Telerik.OpenAccess.OpenAccessContextBase.GetScope()

at Telerik.OpenAccess.OpenAccessContext.GetAllCore[T]()

at Telerik.OpenAccess.OpenAccessContext.GetAll[T]()

at RepresDAO.Repres.get_Clientes() in d:\sistemas\fontes\Repres\RepresMobileSolution\RepresObjects\DatabaseObjects\Repres.cs:line 250

at RepresDataObjects.webservices.servicos_v2.RetornaClientes(Int32 Start, Int32 Lenght) in d:\sistemas\fontes\Repres\RepresMobileSolution\RepresDataObjects\webservices\servicos_v2.asmx.cs:line 687

MySql.Data --> Cannot perform CAS Asserts in Security Transparent methodsem:

at MySql.Data.MySqlClient.MySqlClientFactory..cctor()

Regards...

Nelson

answered on 31 Jan 2014, 04:45 PM

Hi Ady...

Sorry for long delay in answer, but I having to working out these days and dont have time to do the adjustments.

Really the change for a old version solve the problem. I have used the version 6.3.5 that is provided by my ISP.

For that someone have the same problem, the solution work perfectly!

On my opinion the unique problem is that he have do use a version that is old and can be have bugs on it.

Is there any plan to update de OpenAccess to use a new version of mysql connector without the problem of medium trust?

Thanks.

Nelson Santos