You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@logging.apache.org by "Lasse Nilsson (Jira)" <ji...@apache.org> on 2019/11/14 16:10:00 UTC

[jira] [Commented] (LOG4NET-538) AdoNetAppender to PostgreSQL

    [ https://issues.apache.org/jira/browse/LOG4NET-538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16974391#comment-16974391 ] 

Lasse Nilsson commented on LOG4NET-538:
---------------------------------------

Hi, as I understand this is a known bug and is resolved in the "develop branch". The Bug has been known for almost 2 years but no new version released. Correct?

I really want to log directly from log4net to PostgreSQL (10.0.10.19218) but with latest ver 2.0.8 it is not possible.

How can I procced and get source code or binaries where this bug is fixed, not so nice breaking nuget updates in Studio, but rolling back all projects to last known working version (1.2.13) is not so nice either.

Any thoughts about this?

/Lasse Nilsson

 

 

> AdoNetAppender to PostgreSQL
> ----------------------------
>
>                 Key: LOG4NET-538
>                 URL: https://issues.apache.org/jira/browse/LOG4NET-538
>             Project: Log4net
>          Issue Type: Bug
>          Components: Appenders
>    Affects Versions: 1.2.15
>         Environment: C#
>            Reporter: Cristian Margescu
>            Assignee: Dominik Psenner
>            Priority: Major
>              Labels: patch
>             Fix For: 2.1.0
>
>
> I am using the AdoNetAppender to log audits to the database. I was using until some time the 1.2.13 version with a configuration for MSSQL or PostgreSQL which inserted practically data as json strings that will later be interpreted by another tool using the following appender configuration. 
> EX: <appender name="NpgsqlAppender" type="log4net.Appender.AdoNetAppender">
>     <filter type="log4net.Filter.LevelRangeFilter">
>       <levelMin value="AUDIT" />
>       <levelMax value="AUDIT" />
>     </filter>
>     <bufferSize value="1"/>
>     <connectionType
>       value="Npgsql.NpgsqlConnection, Npgsql" />
>     <connectionString
>       value="Server={myServer};Port=5432;Database={database};User Id={myuser};Password={mypassword}" />
>     <commandText value="INSERT INTO audit (message) VALUES (@message);" />
>     <reconnectOnError value="true" />
>     <useTransactions value="false"/>
>     <parameter>
>       <parameterName value="@message" />
>       <dbType value="String" />
>       <layout type="log4net.Layout.PatternLayout" >
>         <conversionPattern value="%message"/>
>       </layout>
>     </parameter>
>   </appender>
> It worked great until I have updated to 1.2.15 and then we have noticed that the PosgreSQL appender did not worked any more. After doing some research and testing I have narrowed it down to the AdoNetAppender
> that probably has a problem with the parameters because it shows a PG error 47203 as column "message" not found.
>   



--
This message was sent by Atlassian Jira
(v8.3.4#803005)