首页 文章

MVC3 EF4 MySQL System.Security.SecurityException:请求失败

提问于
浏览
1

我正在开发一个ASP.NET MVC3 Web应用程序,它使用Entity Framework 4.1和MySQL .

本地一切都运行良好,但当我将解决方案部署到Web主机时,它给我以下错误消息:

System.Security.SecurityException:请求失败 . 在System.Security.CodeAccessSecurityEngine.ThrowSecurityException(RuntimeAssembly asm,PermissionSet grant,PermissionSet denied,RuntimeMethodHandleInternal rmh,SecurityAction action,Object demand,IPermission permThatFailed)at System.Security.CodeAccessSecurityEngine.ThrowSecurityException(Object assemblyOrString,PermissionSet grant,PermissionSet denied,RuntimeMethodHandleInternal rmh ,System.Security.PermissionSetTriple.CheckSetDemand(PermissionSet)上的System.Security.CodeAccessSecurityEngine.CheckSetHelper(PermissionSet grants,PermissionSet denied,PermissionSet requirements,RuntimeMethodHandleInternal rmh,Object assemblyOrString,SecurityAction action,Boolean throwException)中的,SecurityAction操作,对象需求,IPermission permThatFailed)在System.Security.PermissionListSet.DemandFlags的System.Security.PermissionListSet.CheckSetDemand(PermissionSet pset,RuntimeMethodHandleInternal rmh)中的demandSet,PermissionSet和changedDemandset,RuntimeMethodHandleInternal rmh) System.Security.CodeAccessSecurityEngine.ReflectionTargetDemandHelper(Int32权限,PermissionSet targetGrant,CompressedStack securityContext)中的OrGrantSet(Int32标志,PermissionSet grantSet),System.Security.CodeAccessSecurityEngine.ReflectionTargetDemandHelper(Int32权限,PermissionSet targetGrant)失败的操作是:Demand类型失败的第一个权限是:System.Security.PermissionSet

我的Web.Config:

<connectionStrings>
    <add name="MySqlMembershipConnection" connectionString="Data Source=localhost;userid=userName;password=passw0rd;database=tv;" providerName="MySql.Data.MySqlClient,Version=6.3.6.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d"/>
    <add name="TvEntities" connectionString="metadata=res://*/Entities.Model.csdl|res://*/Entities.Model.ssdl|res://*/Entities.Model.msl;provider=MySql.Data.MySqlClient;provider connection string=&quot;server=127.0.0.1;port=3351;User Id=userName;password=passw0rd;Persist Security Info=True;database=tv&quot;" providerName="System.Data.EntityClient" />
</connectionStrings>

<system.data>
    <DbProviderFactories>
        <clear />
        <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL"
        type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data,Version=6.3.6.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
    </DbProviderFactories>
</system.data>

Trustlevel在Medium上 .

有任何想法吗?

3 回答

  • 2

    您可以随时切换到另一个托管服务提供商完全信任?

  • 2

    尝试使用较新版本的连接器 . 它是reported as a bug,应该在6.3.7和6.4.1中修复 .

  • 0

    添加对System.Web.Providers的引用 . 如果程序集在本地不可用,请使用NuGet Package Manager按如下方式安装它:

    PM> Install-Package System.Web.Providers
    

    还要在web.config文件中验证以下条目是否已添加到配置文件部分

    <roleManager defaultProvider="DefaultRoleProvider">
        <providers>
            <add name="DefaultRoleProvider" type="System.Web.Providers.DefaultRoleProvider,            
                       System.Web.Providers, Version=1.0.0.0, Culture=neutral,  
                       PublicKeyToken=31bf3856ad364e35"   
                       connectionStringName="DefaultConnection" applicationName="/" />
        </providers>
    </roleManager>
    

    然后,您可以重建应用程序并执行它 .

相关问题