如何用ASP.NET MVC中的ELMAH解决SQL服务器问题？ [英] How to solve SQL server problem with ELMAH in ASP.NET MVC ?

问题描述

<结构> 
 
< configSections> 
< sectionGroup name =elmah> 
< section name =securityrequirePermission =falsetype =Elmah.SecuritySectionHandler，Elmah/> 
< section name =errorLogrequirePermission =falsetype =Elmah.ErrorLogSectionHandler，Elmah/> 
< section name =errorMailrequirePermission =falsetype =Elmah.ErrorMailSectionHandler，Elmah/> 
< section name =errorFilterrequirePermission =falsetype =Elmah.ErrorFilterSectionHandler，Elmah/> 
< / sectionGroup> 
< section name =entityFrameworktype =System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection，EntityFrameworkrequirePermission =false/> 
< / configSections> 
 
< connectionStrings> 
< add name =SCEconnectionString =metadata = res：//*/SCE.csdl | res：//*/SCE.ssdl | res：//*/SCE.msl; provider = System .Data.SqlClient; provider connection string =data source = 11.234.135.5; initial catalog = SCE2; persist security info = True; user id = ddd; password = sss; MultipleActiveResultSets = True; App = EntityFrameworkproviderName =System .Data.EntityClient/> 
< / connectionStrings> 
 
< appSettings> 
< add key =webpages：Versionvalue =2.0.0.0/> 
< add key =webpages：Enabledvalue =false/> 
< add key =PreserveLoginUrlvalue =true/> 
< add key =ClientValidationEnabledvalue =true/> 
< add key =UnobtrusiveJavaScriptEnabledvalue =true/> 
< add key =ClientValidationEnabledvalue =true/> 
 
< add key =UnobtrusiveJavaScriptEnabledvalue =true/> 
 
< / appSettings> 
 
< system.web> 
< customErrors mode =OffdefaultRedirect =/ Error / Error> 
< error statusCode =403redirect =/ Error / NoPermissions/> 
< / customErrors> 
< globalization uiCulture =en-GBculture =en-GB/> 
< compilation targetFramework =4.5debug =true/> 
< httpRuntime targetFramework =4.5maxRequestLength =10240requestLengthDiskThreshold =10024000enableVersionHeader =false/> 
 
< authentication mode =Forms> 
< forms loginUrl =〜/ Account / Indextimeout =2880/> 
< / authentication> 
< pages> 
< namespaces> 
< add namespace =System.Web.Helpers/> 
< add namespace =System.Web.Mvc/> 
< add namespace =System.Web.Mvc.Ajax/> 
< add namespace =System.Web.Mvc.Html/> 
< add namespace =System.Web.Optimization/> 
< add namespace =System.Web.Routing/> 
< add namespace =System.Web.WebPages/> 
< / namespaces> 
< / pages> 
< sessionState timeout =2800mode =StateServer> 
< / sessionState> 
 
< httpHandlers> 
< add verb =POST，GET，HEADpath =elmah.axdtype =Elmah.ErrorLogPageFactory，Elmah/> 
< / httpHandlers> 
 
< httpModules> 
< add name =ErrorLogtype =Elmah.ErrorLogModule，Elmah/> 
< add name =ErrorMailtype =Elmah.ErrorMailModule，Elmah/> 
< add name =ErrorFiltertype =Elmah.ErrorFilterModule，Elmah/> 
< / httpModules> 
 
< /system.web> 
 
< system.webServer> 
 
< handlers> 
< remove name =ExtensionlessUrlHandler-ISAPI-4.0_32bit/> 
< remove name =ExtensionlessUrlHandler-ISAPI-4.0_64bit/> 
< remove name =ExtensionlessUrlHandler-Integrated-4.0/> 
< add name =ExtensionlessUrlHandler-ISAPI-4.0_32bitpath =*。 verb =GET，HEAD，POST，DEBUG，PUT，DELETE，PATCH，OPTIONSmodules =IsapiModulescriptProcessor =％windir％\ Mesrosoft.NET \ Framework\v4.0.30319\aspnet_isapi.dllprecondition =classicMode，runtimeVersionv4.0，bitness32responseBufferLimit =0/> 
< add name =ExtensionlessUrlHandler-ISAPI-4.0_64bitpath =*。 verb =GET，HEAD，POST，DEBUG，PUT，DELETE，PATCH，OPTIONSmodules =IsapiModulescriptProcessor =％windir％\ Mesrosoft.NET \ Framework64 \v4.0.30319 \ aspnet_isapi.dllprecondition =classicMode，runtimeVersionv4.0，bitness64responseBufferLimit =0/> 
< add name =ExtensionlessUrlHandler-Integrated-4.0path =*。 verb =GET，HEAD，POST，DEBUG，PUT，DELETE，PATCH，OPTIONStype =System.Web.Handlers.TransferRequestHandlerpreCondition =integratedMode，runtimeVersionv4.0/> 
 
< add name =ELMAHverb =POST，GET，HEADpath =elmah.axdtype =Elmah.ErrorLogPageFactory，ElmahpreCondition =integratedMode/> 
 
< / handlers> 
 
 
< modules runAllManagedModulesForAllRequests =true> 
< add name =Elmah.ErrorLogtype =Elmah.ErrorLogModule，ElmahpreCondition =managedHandler/> 
< add name =Elmah.ErrorMailtype =Elmah.ErrorMailModulepreCondition =managedHandler/> 
< add name =ErrorFiltertype =Elmah.ErrorFilterModule，ElmahpreCondition =managedHandler/> 
< / modules> 
< validation validateIntegratedModeConfiguration =false/> 
 
 
 
< /system.webServer> 
 
< entityFramework> 
< defaultConnectionFactory type =System.Data.Entity.Infrastructure.LocalDbConnectionFactory，EntityFramework> 
< parameters> 
< parameter value =v11.0/> 
< / parameters> 
< / defaultConnectionFactory> 
< / entityFramework> 
 
< elmah> 
< security allowRemoteAccess =0/> 
< errorLog type =Elmah.SqlErrorLog，ElmahconnectionStringName =SCE/> 
< errorMail from =[e-mail] =[e-mail] =ELMAH错误登录SCasync =true>< / errorMail> 
< / elmah> 
 
< / configuration> 

我的尝试：



以上是我的web.configuration文件。

问题1：在坏URL上，电子邮件被发送到emailid但未保存在Sql数据库中< br $> b $ b

问题2：我无法看到elmah.axd文件。注意：我有身份验证模式表单。



请帮忙。

解决方案

这是一个明显的问题：

< pre lang =XML> < errorLog type = Elmah.SqlErrorLog，Elmah connectionStringName = SolutionCentreEntities / >

查看< connectionStrings> 部分 - 您定义的唯一连接字符串是名为<$ c $的实体框架连接c> SCE 。



ELMAH不使用实体框架。您需要定义一个名为 SolutionCentreEntities 的标准SQL连接字符串，指向您创建的ELMAH数据库。



如果您还没有这样做，则需要下载 [ ^ ]并运行MS SQL Server DDL脚本。



终极ELMAH教程：登录到SQL Server [ ^ ]

配置ELMAH以使用SQL Server~andyfrench.info [< a href =http://www.andyfrench.info/2014/07/configuring-elmah-to-use-sql-server.htmltarget =_ blanktitle =New Window> ^ ]

<configuration>
  
  <configSections>
    <sectionGroup name="elmah">
      <section name="security" requirePermission="false" type="Elmah.SecuritySectionHandler, Elmah" />
      <section name="errorLog" requirePermission="false" type="Elmah.ErrorLogSectionHandler, Elmah" />
      <section name="errorMail" requirePermission="false" type="Elmah.ErrorMailSectionHandler, Elmah" />
      <section name="errorFilter" requirePermission="false" type="Elmah.ErrorFilterSectionHandler, Elmah" />
    </sectionGroup>
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework" requirePermission="false" />
  </configSections>
  
  <connectionStrings>
    <add name="SCE" connectionString="metadata=res://*/SCE.csdl|res://*/SCE.ssdl|res://*/SCE.msl;provider=System.Data.SqlClient;provider connection string="data source=11.234.135.5;initial catalog=SCE2;persist security info=True;user id=ddd;password=sss;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />
  </connectionStrings>
  
  <appSettings>
    <add key="webpages:Version" value="2.0.0.0" />
    <add key="webpages:Enabled" value="false" />
    <add key="PreserveLoginUrl" value="true" />
    <add key="ClientValidationEnabled" value="true" />
    <add key="UnobtrusiveJavaScriptEnabled" value="true" />
    <add key="ClientValidationEnabled" value="true" />
   
    <add key="UnobtrusiveJavaScriptEnabled" value="true" />

  </appSettings>
  
  <system.web>
    <customErrors mode="Off" defaultRedirect="/Error/Error">
      <error statusCode="403" redirect="/Error/NoPermissions" />
    </customErrors>
    <globalization uiCulture="en-GB" culture="en-GB" />
    <compilation targetFramework="4.5" debug="true" />
    <httpRuntime targetFramework="4.5" maxRequestLength="10240" requestLengthDiskThreshold="10024000" enableVersionHeader="false" />
    
    <authentication mode="Forms">
      <forms loginUrl="~/Account/Index" timeout="2880" />
    </authentication>
    <pages>
      <namespaces>
        <add namespace="System.Web.Helpers" />
        <add namespace="System.Web.Mvc" />
        <add namespace="System.Web.Mvc.Ajax" />
        <add namespace="System.Web.Mvc.Html" />
        <add namespace="System.Web.Optimization" />
        <add namespace="System.Web.Routing" />
        <add namespace="System.Web.WebPages" />
      </namespaces>
    </pages>
    <sessionState timeout="2800" mode="StateServer">
    </sessionState>

    <httpHandlers>
      <add verb="POST,GET,HEAD" path="elmah.axd" type="Elmah.ErrorLogPageFactory, Elmah" />
    </httpHandlers>

    <httpModules>
      <add name="ErrorLog" type="Elmah.ErrorLogModule, Elmah"/>
      <add name="ErrorMail" type="Elmah.ErrorMailModule, Elmah"/>
      <add name="ErrorFilter" type="Elmah.ErrorFilterModule, Elmah" />
    </httpModules>

  </system.web>
  
  <system.webServer>

    <handlers>
      <remove name="ExtensionlessUrlHandler-ISAPI-4.0_32bit" />
      <remove name="ExtensionlessUrlHandler-ISAPI-4.0_64bit" />
      <remove name="ExtensionlessUrlHandler-Integrated-4.0" />
      <add name="ExtensionlessUrlHandler-ISAPI-4.0_32bit" path="*." verb="GET,HEAD,POST,DEBUG,PUT,DELETE,PATCH,OPTIONS" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness32" responseBufferLimit="0" />
      <add name="ExtensionlessUrlHandler-ISAPI-4.0_64bit" path="*." verb="GET,HEAD,POST,DEBUG,PUT,DELETE,PATCH,OPTIONS" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness64" responseBufferLimit="0" />
      <add name="ExtensionlessUrlHandler-Integrated-4.0" path="*." verb="GET,HEAD,POST,DEBUG,PUT,DELETE,PATCH,OPTIONS" type="System.Web.Handlers.TransferRequestHandler" preCondition="integratedMode,runtimeVersionv4.0" />

      <add name="ELMAH" verb="POST,GET,HEAD" path="elmah.axd" type="Elmah.ErrorLogPageFactory, Elmah" preCondition="integratedMode" />

    </handlers>


    <modules runAllManagedModulesForAllRequests="true">
      <add name="Elmah.ErrorLog" type="Elmah.ErrorLogModule, Elmah" preCondition="managedHandler" />
      <add name="Elmah.ErrorMail" type="Elmah.ErrorMailModule" preCondition="managedHandler" />
      <add name="ErrorFilter" type="Elmah.ErrorFilterModule, Elmah" preCondition="managedHandler" />
    </modules>
    <validation validateIntegratedModeConfiguration="false" />


   
  </system.webServer>
  
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="v11.0" />
      </parameters>
    </defaultConnectionFactory>
  </entityFramework>

  <elmah>
    <security allowRemoteAccess="0" />
    <errorLog type="Elmah.SqlErrorLog, Elmah" connectionStringName="SCE"/>
    <errorMail from="[e-mail]" to="[e-mail]" subject="ELMAH Error Logged on SC" async="true"></errorMail>
  </elmah>

</configuration>

What I have tried:

The above is my web.configuration file.
Problem 1 : On bad url the email is sent to emailid but not saved in Sql database

problem 2 : i am not able to see elmah.axd file . Note : i have Authentication mode Forms.

Please help.

解决方案

Here's the obvious problem:

<errorLog type="Elmah.SqlErrorLog, Elmah" connectionStringName="SolutionCentreEntities"/>

Look at your <connectionStrings> section - the only connection string you've defined is an Entity Framework connection called SCE.

ELMAH doesn't use Entity Framework. You'll need to define a standard SQL connection string called SolutionCentreEntities, pointing to the ELMAH database you created.

If you haven't done so already, you'll need to download[^] and run the "MS SQL Server DDL Script".

The Ultimate ELMAH Tutorial: Logging to SQL Server[^]
Configuring ELMAH to use SQL Server ~ andyfrench.info[^]

这篇关于如何用ASP.NET MVC中的ELMAH解决SQL服务器问题？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！