Technik:NLog
Aus CoPlanner 11
In der NLog.Server.config bzw. NLog.Service.config lässt sich das Logging konfigurieren.
Prinzipiell kann hier mehr angepasst werden, aber die grundlegenden Eigenschaften beim Logging in eine Datei sind:
- logDirectory: Verzeichnis ohne den Dateinamen, wo hingeloggt werden soll
- fileName: Hier kann man den Dateinamen anpassen oder wenn man möchte auch den gesamten Pfad
- archiveAboveSize: gibt an, ab welcher Dateigröße eine neue Datei geschrieben wird. Der Standard von 10000000 entspricht 10 MB.
Logging in die Datenbank
Verfügbar ab CoPlanner 11 Release 1 2026.
Wenn man in eine Datenbank loggen will, so kann man das auch in dieser Konfiguration machen.
| Achtung! Es gibt kein Housekeeping für das Logging in eine Datenbank. Darum muss man sich derzeit selber kümmern. |
Beispiel NLog.Server.config für Logging in die Datenbank:
<?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"
autoReload="true"
internalLogLevel="Off"
internalLogFile="C:\NLogInternal\CopServer_NLogInternal.txt"
throwConfigExceptions="true">
<extensions>
<add assembly="NLog.Web.AspNetCore" />
<add assembly="CopServer" />
</extensions>
<variable name="logDirectory" value="Logs/" />
<targets>
<!-- console -->
<target xsi:type="AsyncWrapper"
name="consoleAsync"
overflowAction="Grow">
<target xsi:type="ColoredConsole"
name="console"
layout="${date:format=HH\:mm\:ss} ${message}">
<highlight-row condition="level == LogLevel.Warn"
foregroundColor="Yellow"
/>
<highlight-row condition="level == LogLevel.Error"
foregroundColor="Red"
/>
</target>
</target>
<!-- database -->
<target xsi:type="AsyncWrapper"
name="generalFileAsync">
<target xsi:type="Database"
name="generalFile"
commandType="Text"
commandText="Insert into Serverlog_GeneralErrorAndWarning (Message, Level) values (@Message, @Level)"
connectionString ="Server=localhost;Initial Catalog=CopNlogDb;User=cop;password=cop;pooling=false; TrustServerCertificate=true; timeout=300">
<parameter name="@level" layout="${level}" />
<parameter name="@message" layout="${message}" />
</target>
</target>
<target xsi:type="AsyncWrapper"
name="commandsFileAsync">
<target xsi:type="Database"
name="commandsFile"
commandType="Text"
commandText="Insert into Serverlog_Commands (Message, Level) values (@Message, @Level)"
connectionString ="Server=localhost;Initial Catalog=CopNlogDb;User=cop;password=cop;pooling=false; TrustServerCertificate=true; timeout=300">
<parameter name="@level" layout="${level}" />
<parameter name="@message" layout="${message}" />
</target>
</target>
<target xsi:type="AsyncWrapper"
name="formulaFileAsync">
<target xsi:type="Database"
name="formulaFile"
commandType="Text"
commandText="Insert into Serverlog_Formula (Message, Level) values (@Message, @Level)"
connectionString ="Server=localhost;Initial Catalog=CopNlogDb;User=cop;password=cop;pooling=false; TrustServerCertificate=true; timeout=300">
<parameter name="@level" layout="${level}" />
<parameter name="@message" layout="${message}" />
</target>
</target>
<target xsi:type="AsyncWrapper"
name="webApiFileAsync">
<target xsi:type="Database"
name="webApiFile"
commandType="Text"
commandText="Insert into Serverlog_Web (Message, Level, ip, TraceIdentifier, Userclaim_session, Userclaim_name, Userclaim_context, Longdate, Logger, Exception) values (@Message, @Level, @ip, @TraceIdentifier, @Userclaim_session, @Userclaim_name, @Userclaim_context, @Longdate, @Logger, @Exception)"
connectionString ="Server=localhost;Initial Catalog=CopNlogDb;User=cop;password=cop;pooling=false; TrustServerCertificate=true; timeout=300">
<parameter name="@level" layout="${level}" />
<parameter name="@message" layout="${message}" />
<parameter name="@ip" layout="${aspnet-request-ip}" />
<parameter name="@traceIdentifier" layout="${aspnet-TraceIdentifier}" />
<parameter name="@userclaim_session" layout="${aspnet-user-claim:cop_session_id}" />
<parameter name="@userclaim_name" layout="${aspnet-user-claim:name}" />
<parameter name="@userclaim_context" layout="${aspnet-user-claim:cop_session_context}" />
<parameter name="@longdate" layout="${longdate}" />
<parameter name="@logger" layout="${logger}" />
<parameter name="@exception" layout="${exception:format=tostring}" />
</target>
</target>
<target xsi:type="AsyncWrapper"
name="olapFileAsync">
<target xsi:type="Database"
commandType="Text"
commandText="Insert into Serverlog_Olap (Message, Level, ip, TraceIdentifier, Userclaim_session, Userclaim_name, Userclaim_context, Longdate, Logger, Exception) values (@Message, @Level, @ip, @TraceIdentifier, @Userclaim_session, @Userclaim_name, @Userclaim_context, @Longdate, @Logger, @Exception)"
connectionString ="Server=localhost;Initial Catalog=CopNlogDb;User=cop;password=cop;pooling=false; TrustServerCertificate=true; timeout=300">
<parameter name="@level" layout="${level}" />
<parameter name="@message" layout="${message}" />
<parameter name="@ip" layout="${aspnet-request-ip}" />
<parameter name="@traceIdentifier" layout="${aspnet-TraceIdentifier}" />
<parameter name="@userclaim_session" layout="${aspnet-user-claim:cop_session_id}" />
<parameter name="@userclaim_name" layout="${aspnet-user-claim:name}" />
<parameter name="@userclaim_context" layout="${aspnet-user-claim:cop_session_context}" />
<parameter name="@longdate" layout="${longdate}" />
<parameter name="@logger" layout="${logger}" />
<parameter name="@exception" layout="${exception:format=tostring}" />
</target>
</target>
<!-- memories -->
<target xsi:type="LimitedMemory"
name="generalMemory"
layout="${replace-newlines:${message}}"
maxLogsCount="1000"
/>
<target xsi:type="LimitedMemory"
name="commandsMemory"
layout="${replace-newlines:${message}}"
maxLogsCount="1000"
/>
<target xsi:type="LimitedMemory"
name="formulaMemory"
layout="${replace-newlines:${message}}"
maxLogsCount="1000"
/>
</targets>
<rules>
<logger name="consolelogger" writeTo="consoleAsync" final="true" />
<logger name="generalfilelogger" writeTo="generalMemory" />
<logger name="generalfilelogger" writeTo="generalFileAsync" final="true" />
<logger name="commandsfilelogger" writeTo="commandsMemory" />
<logger name="commandsfilelogger" writeTo="commandsFileAsync" final="true" />
<logger name="formulafilelogger" writeTo="formulaMemory" />
<logger name="formulafilelogger" writeTo="formulaFileAsync" final="true" />
<logger name="Microsoft.AspNetCore.Hosting.Internal.WebHost" minlevel="Warn" writeTo="consoleAsync">
<filters defaultAction="Log">
<when condition="contains('${message}', '/health ') or contains('${message}', '/session/isalive ') or contains('${message}', 'Request finished in ')"
action="Ignore"
/>
</filters>
</logger>
<logger name="Microsoft.AspNetCore*" minlevel="Warn" writeTo="webApiFileAsync" final="true">
<filters defaultAction="Log">
<when condition="starts-with('${message}', 'An error occurred while trying to create an XmlSerializer for the type')"
action="Ignore"
/>
</filters>
</logger>
<logger name="AspNet.*" minlevel="Warn" writeTo="consoleAsync" />
<logger name="AspNet.*" minlevel="Warn" writeTo="webApiFileAsync" final="true" />
<logger name="System.Net.Http.HttpClient*" minlevel="Warn" writeTo="consoleAsync" />
<logger name="System.Net.Http.HttpClient*" minlevel="Warn" writeTo="webApiFileAsync" final="true" />
<logger name="Cop.Server.WebApi*" minlevel="Warn" writeTo="consoleAsync" />
<logger name="Cop.Server.WebApi*" minlevel="Warn" writeTo="webApiFileAsync" final="true" />
<logger name="Cop.Analyze.ConnectorOlap" writeTo="olapFileAsync" final="true" />
<!--
<logger name="*" minlevel="Info" writeTo="consoleAsync" />
<logger name="*" minlevel="Info" writeTo="generalMemory" />
<logger name="*" minlevel="Info" writeTo="generalFileAsync" final="true" />
-->
</rules>
</nlog>