1、升级到log4net的最新版

PM下执行

Install-Package log4net

还是无法解决的,使用下面的方法

2、使用Nlog替换之,详见https://github.com/NLog/NLog/wiki/Tutorial

安装

Install-Package NLog.Config 

NLog使用方法比log4net更为简单,配置文件如下,如果成windows程序需将NLog.config自动复制到bin下面

 <?xml version="1.0" encoding="utf-8" ?>
<nlog xmlns="http://www.nlog-project.org/schemas/NLog.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.nlog-project.org/schemas/NLog.xsd NLog.xsd"
autoReload="true"
throwExceptions="false"
internalLogLevel="Off" internalLogFile="F:\temp\20160907\NLog\log\nlog-internal.log"> <!-- optional, add some variables
https://github.com/nlog/NLog/wiki/Configuration-file#variables
-->
<variable name="myvar" value="myvalue"/> <!--
See https://github.com/nlog/nlog/wiki/Configuration-file
for information on customizing logging rules and outputs.
-->
<targets> <!--
add your targets here
See https://github.com/nlog/NLog/wiki/Targets for possible targets.
See https://github.com/nlog/NLog/wiki/Layout-Renderers for the possible layout renderers.
--> <!--
Write events to a file with the date in the filename.
<target xsi:type="File" name="f" fileName="${basedir}/logs/${shortdate}.log"
layout="${longdate} ${uppercase:${level}} ${message}" />
-->
<target name="logfile" xsi:type="File" fileName="${basedir}/logs/${shortdate}.log" />
<target name="console" xsi:type="ColoredConsole" />
</targets> <rules>
<!-- add your logging rules here --> <!--
Write all events with minimal level of Debug (So Debug, Info, Warn, Error and Fatal, but not Trace) to "f"
<logger name="*" minlevel="Debug" writeTo="f" />
-->
<logger name="*" minlevel="Debug" writeTo="logfile" />
<logger name="*" minlevel="Info" writeTo="console" />
</rules>
</nlog>

NLog.config

调用代码:

   Logger logger = LogManager.GetCurrentClassLogger();

             logger.Trace("Sample trace message");
logger.Debug("Sample debug message");
logger.Info("Sample informational message");
logger.Warn("Sample warning message");
logger.Error("Sample error message");
logger.Fatal("Sample fatal error message"); logger.Info("wilson测试 日志日期:{0}", DateTime.Now);

执行结果,非常漂亮的控制台输出:

web站点配置log写入到sql server数据库,需要安装NLog.Web

Install-Package NLog.Web

配置文件如下

 <?xml version="1.0" encoding="utf-8" ?>
<nlog xmlns="http://www.nlog-project.org/schemas/NLog.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.nlog-project.org/schemas/NLog.xsd NLog.xsd"
autoReload="true"
throwExceptions="false"
internalLogLevel="Off" internalLogFile="F:\temp\20160907\NLog\log\nlog-internal.log"> <!-- optional, add some variables
https://github.com/nlog/NLog/wiki/Configuration-file#variables
-->
<variable name="myvar" value="myvalue"/> <!--
See https://github.com/nlog/nlog/wiki/Configuration-file
for information on customizing logging rules and outputs.
-->
<targets> <!--
add your targets here
See https://github.com/nlog/NLog/wiki/Targets for possible targets.
See https://github.com/nlog/NLog/wiki/Layout-Renderers for the possible layout renderers.
--> <!--
Write events to a file with the date in the filename.
<target xsi:type="File" name="f" fileName="${basedir}/logs/${shortdate}.log"
layout="${longdate} ${uppercase:${level}} ${message}" />
-->
<target name="logfile" xsi:type="File" fileName="${basedir}/logs/${shortdate}.log" />
<target name="console" xsi:type="ColoredConsole" /> <target name="db"
xsi:type="Database"
connectionStringName="NLogConn"
commandType="StoredProcedure"
commandText="[dbo].[NLog_AddEntry_p]"
>
<parameter name="@machineName" layout="${machinename}" />
<parameter name="@siteName" layout="${iis-site-name}" />
<parameter name="@logged" layout="${date}" />
<parameter name="@level" layout="${level}" />
<parameter name="@username" layout="${aspnet-user-identity}" />
<parameter name="@message" layout="${message}" />
<parameter name="@logger" layout="${logger}" />
<parameter name="@properties" layout="${all-event-properties:separator=|}" />
<parameter name="@serverName" layout="${aspnet-request:serverVariable=SERVER_NAME}" />
<parameter name="@port" layout="${aspnet-request:serverVariable=SERVER_PORT}" />
<parameter name="@url" layout="${aspnet-request:serverVariable=HTTP_URL}" />
<parameter name="@https" layout="${when:inner=1:when='${aspnet-request:serverVariable=HTTPS}' == 'on'}${when:inner=0:when='${aspnet-request:serverVariable=HTTPS}' != 'on'}" />
<parameter name="@serverAddress" layout="${aspnet-request:serverVariable=LOCAL_ADDR}" />
<parameter name="@remoteAddress" layout="${aspnet-request:serverVariable=REMOTE_ADDR}:${aspnet-request:serverVariable=REMOTE_PORT}" />
<parameter name="@callSite" layout="${callsite}" />
<parameter name="@exception" layout="${exception:tostring}" />
</target> </targets> <rules>
<!-- add your logging rules here --> <!--
Write all events with minimal level of Debug (So Debug, Info, Warn, Error and Fatal, but not Trace) to "f"
<logger name="*" minlevel="Debug" writeTo="f" />
-->
<logger name="*" minlevel="Debug" writeTo="logfile" />
<logger name="*" minlevel="Info" writeTo="console" /> <logger name="*" minlevel="Debug" writeTo="db" />
</rules>
</nlog>

Web NLog配置

Web.Config要加上对应数据库连接

<?xml version="1.0" encoding="utf-8"?>

<!--
有关如何配置 ASP.NET 应用程序的详细信息,请访问
http://go.microsoft.com/fwlink/?LinkId=169433
--> <configuration>
<connectionStrings>
<add name="NLogConn" connectionString="Server=.;uid=sa;pwd=sa;Database=db;"/>
</connectionStrings>
<system.web>
<compilation debug="true" targetFramework="4.0" />
</system.web> </configuration>

保存数据库结果:

写入oracle的配置,使用System.Data.OracleClient,.net 4.0以上已经抛弃

 <targets>
<target name="oraclelog" type="Database"> <dbProvider>System.Data.OracleClient.OracleConnection,System.Data.OracleClient, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</dbProvider> <connectionString>Data Source=JMDB_215;User ID=TYUM_UM; Password=DEV_TYUM_UM;</connectionString> <commandText>insert into RS_LOGTABLE (log_user,log_level,log_date,log_message) values(:log_user,:log_level,:log_date,:log_message)</commandText> <parameter name=":log_user" layout="${aspnet-user-identity}"/>
<parameter name=":log_level" layout="${level}"/>
<parameter name=":log_date" layout="${date}"/>
<parameter name=":log_message" layout="${message}"/> </target>
</targets>
<rules>
<logger name="*" minlevel="Debug" writeTo="oraclelog" />
</rules>

写入oracle的配置,使用Oracle.DataAccess.Client,配置文件如下:

     <targets>
<target name="oraclelog" type="Database"> <!--<dbProvider>Oracle.ManagedDataAccess.Client,Oracle.ManagedDataAccess</dbProvider>-->
<dbProvider>Oracle.DataAccess.Client.OracleConnection,Oracle.DataAccess</dbProvider>
<connectionString>Data Source=orcl;User ID=oracle_user; Password=password;</connectionString> <commandText>insert into RS_LOGTABLE (log_user,log_level,log_date,log_message) values(:log_user,:log_level,:log_date,:log_message)</commandText> <parameter name=":log_user" layout="${machinename}"/>
<parameter name=":log_level" layout="${level}"/>
<parameter name=":log_date" layout="${date}"/>
<parameter name=":log_message" layout="${message}"/> </target>
</targets> <rules>
<logger name="oracleDbLog" minlevel="Debug" writeTo="oraclelog" />
</rules>

Oracle.DataAccess.Client Log配置

C#调用代码:

   Logger oracleLogger = LogManager.GetLogger("oracleDbLog");

            oracleLogger.Error(new Exception("自定义异常oracle"), "错误信息 oracledb", string.Empty);

执行结果:

写入Mysql,需应用MySql.Data程序集,安装Install-Package MySql.Data -Version 6.9.9,配置文件如下:

 <targets>
<target name="MySQLLog" type="Database">
<dbProvider>MySql.Data.MySqlClient.MySqlConnection,MySql.Data</dbProvider>
<connectionString>Server=192.168.0.2;Uid=root;Pwd=root;Database=mydb;</connectionString> <commandText>insert into t_nlog (log_user,log_level,log_date,log_message) values(@log_user,@log_level,@log_date,@log_message)</commandText> <parameter name="@log_user" layout="${machinename}"/>
<parameter name="@log_level" layout="${level}"/>
<parameter name="@log_date" layout="${date}"/>
<parameter name="@log_message" layout="${message}"/>
</target>
</targets> <rules>
<logger name="*" minlevel="Debug" writeTo="MySQLLog" />
</rules>

NLog Mysql

执行结果:

文件日志异常模板:

      <target name="logfile" xsi:type="File" fileName="${basedir}/nlogs/${shortdate}.log"  layout="${longdate}|${level}||${logger} ${message}| ${exception:format=tostring}" />

NLog日志写入到MongoDB,安装NLog.Mongo

PM> Install-Package NLog.Mongo
配置文件:
  <extensions>
<add assembly="NLog.Mongo"/>
</extensions> <target xsi:type="Mongo"
name="mongoDefault"
connectionString="mongodb://192.168.0.226:6111/NLogging"
collectionName="DefaultLog"
cappedCollectionSize="26214400">
<property name="ThreadID" layout="${threadid}" bsonType="Int32" />
<property name="ThreadName" layout="${threadname}" />
<property name="ProcessID" layout="${processid}" bsonType="Int32" />
<property name="ProcessName" layout="${processname:fullName=true}" />
<property name="UserName" layout="${windows-identity}" />
</target> <rules> <logger name="*" level="Debug" writeTo="mongoDefault" />
</rules>

NLog.config

执行结果如下:

参考:https://github.com/loresoft/NLog.Mongo

												

最新文章

  1. ADO.net 更新和插入数据 遇到null 执行不成功
  2. 深入理解KMP算法之续篇
  3. java中内部类使用小结
  4. 工作中遇到的问题--JPA 一对多查询
  5. java request判断微信客户端访问
  6. openSourceEvent
  7. Elasticsearch相关配置(二)
  8. HDU-1166-敌兵布阵(线段树)
  9. HDU1065 I Think I Need a Houseboat 【数学递推】
  10. 简单模拟struts2及struts2的处理流程介绍
  11. Spark从入门到精通(一)
  12. Python 爬虫实例(爬百度百科词条)
  13. wpf、winform仿QQ靠边隐藏
  14. spring集成ActiveMQ居然要依赖这么多包
  15. Oracle 数据库中查看表空间的2种方法
  16. vue 路由meta作用及在路由中添加props作用
  17. ubuntu18.04配置nvidia docker和远程连接ssh+远程桌面连接(二)
  18. snmp安装
  19. MSXML4 SP2 sp3安装时出错
  20. Android开机广播和关机广播

热门文章

  1. find_in_set()
  2. 动态获取Android权限
  3. UVA 247 电话圈 (floyd传递闭包 + dfs输出连通分量的点)
  4. Smart210学习记录-----SD/MMC/SDIO驱动
  5. substring,substr,和slice的区别详解。
  6. 68. 蓄水池抽样(Reservoir Sampling)
  7. HC蓝牙模块测试AT指令搭建外部电路遇到的问题
  8. Nginx 502 Bad Gateway 错误的原因及解决方法
  9. s查找父节点
  10. java中,去除空白的方法