Web-side log4net output error log to MySQL

1. Configuring the Log4net.config File

<?xml version= "1.0" encoding= "Utf-8"?>
<configuration>
<!--author:gaobingbing-->
<configSections>
<section name= "log4net" type= "log4net. Config.log4netconfigurationsectionhandler, log4net "/>
</configSections>
<log4net>
<!--write to database--
<appender name= "Adonetappender_mysql" type= "log4net. Appender.adonetappender ">
<!--error queue data reached 5 to persist to database--
<buffersize value= "5"/>
<param name= "ConnectionType" value= "MySql.Data.MySqlClient.MySqlConnection, Mysql.data"/>
<param name= "ConnectionString" value= "server=localhost;database=test; Uid=sa; Pwd=sa;old Syntax=yes "/>
<commandtext value= "INSERT into log (log_datetime,log_thread,log_level,log_logger,log_message) VALUES (@log_date, @thread, @log_level, @logger, @message) "/>
<parameter>
<parametername value= "@log_date"/>
<dbtype value= "DateTime"/>
<layout type= "log4net. Layout.rawtimestamplayout "/>
<!--<layout type= "log4net. Layout.patternlayout "value="%date{yyyy '-' mm '-' dd HH ': ' mm ': ' ss} '/>-->
</parameter>
<parameter>
<parametername value= "@thread"/>
<dbtype value= "String"/>
<size value= "255"/>
<layout type= "log4net. Layout.patternlayout ">
<conversionpattern value= "%thread"/>
</layout>
</parameter>
<parameter>
<parametername value= "@log_level"/>
<dbtype value= "String"/>
<size value= "/>"
<layout type= "log4net. Layout.patternlayout ">
<conversionpattern value= "%level"/>
</layout>
</parameter>
<parameter>
<parametername value= "@logger"/>
<dbtype value= "String"/>
<size value= "255"/>
<layout type= "log4net. Layout.patternlayout ">
<conversionpattern value= "%logger"/>
</layout>
</parameter>
<parameter>
<parametername value= "@message"/>
<dbtype value= "String"/>
<size value= "4000"/>
<layout type= "log4net. Layout.patternlayout ">
<conversionpattern value= "%message"/>
</layout>
</parameter>
<!--<parameter>
<parametername value= "@exception"/>
<dbtype value= "String"/>
<size value= "/>"
<layout type= "log4net. Layout.exceptionlayout "/>
</parameter>-->
</appender>
<root>
<level value= "All"/>
<appender-ref ref= "Adonetappender_mysql"/>
</root>
<logger name= "*" >
<level value= "All"/>
<appender-ref ref= "Adonetappender_mysql"/>
</logger>
</log4net>
</configuration>

2. Project Start-Up office

Log4net. Config.XmlConfigurator.Configure ();

3.assemblyinfo.cs
[Assembly:log4net. Config.xmlconfigurator (configfile = "Log4net.config", Watch = True)]

4. Call Log4net

Log4net. ILog MyLogger = log4net. Logmanager.getlogger ("message");

Mylogger.info ("hello!");

Simple four-step configuration success The first time to write a blog park, have not mastered the layout of good-looking, and make unremitting efforts! Hee Hee

Web-side log4net output error log to MySQL