Serilog.Sinks.MySQL

Serilog sink that writes to MySQL database.

Getting started

Install Serilog.Sinks.MySQL from NuGet

Install-Package Serilog.Sinks.MySQL

Configure logger by calling WriteTo.MySQL

var logger = new LoggerConfiguration()
    .WriteTo.MySQL("server=127.0.0.1;uid=user;pwd=password;database=diagnostics;")
    .CreateLogger();

logger.Information("This informational message will be written to MySQL database");

XML <appSettings> configuration

To use the rolling file sink with the Serilog.Settings.AppSettings package, first install that package if you haven't already done so:

Install-Package Serilog.Settings.AppSettings

In your code, call ReadFrom.AppSettings()

var logger = new LoggerConfiguration()
    .ReadFrom.AppSettings()
    .CreateLogger();

In your application's App.config or Web.config file, specify the MySQL sink assembly and required connectionString under the <appSettings> node:

<appSettings>
    <add key="serilog:using:MySQL" value="Serilog.Sinks.MySQL"/>
    <add key="serilog:write-to:MySQL.connectionString" value="..."/>
    <add key="serilog:write-to:MySQL.tableName" value="Logs"/>
    <add key="serilog:write-to:MySQL.storeTimestampInUtc" value="true"/>
</appSettings>    

Note: This sink version 4.1 has breaking changes. It expects an additional column Template of type Template TEXT in log table. It is recommended to add this column manually or delete existing table so that it can be recreated correctly.