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

[Dominik Psenner]

The author of the issue is most probably not subscribed to the mailing
list, therefore i quote you in the issue tracker.

On 13 Dec 2016 5:16 p.m., "Raymond Sanchez"  wrote:

Hi Dominik,

I upgrade my database to 9.5.4 and it works fine. Cristian, are you able to
push your project to Github?

If you are not able to do so, check the raw sql query being sent to
Postgres. I have seen .net providers sending incorrect column names to the
database.

Hope this helps.




On Mon, Dec 12, 2016 at 10:05 AM, Dominik Psenner 
wrote:

> Hi Raymond,
>
> have you already tried to migrate to postgresql 9.5 or newer?
>
> Best regards,
> Dominik
> On 2016-12-12 16:06, Raymond Sanchez wrote:
>
> What version of Postgresql are you using?
>
> Our company is using 9.4.5 and log4net 1.2.15 with no issues.
>
>
> On Mon, Dec 12, 2016 at 7:30 AM, Cristian Margescu (JIRA)  > wrote:
>
>>
>> [ https://issues.apache.org/jira/browse/LOG4NET-538?page=com.a
>> tlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&
>> focusedCommentId=15741894#comment-15741894 ]
>>
>> Cristian Margescu commented on LOG4NET-538:
>> ---
>>
>> Hi,
>> I would be glad to but I have time as of 20th this month. So if there is
>> no real hurry would be my pleasure. you can contact me per email with
>> details.
>> Thank You
>>
>> > 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
>> >  Labels: patch
>> >
>> > 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: 
>> > 
>> >   
>> >   
>> > 
>> > 
>> > > >   value="Npgsql.NpgsqlConnection, Npgsql" />
>> > > >   value="Server={myServer};Port=5432;Database={database};User
>> Id={myuser};Password={mypassword}" />
>> > > />
>> > 
>> > 
>> > 
>> >   
>> >   
>> >   
>> > 
>> >   
>> > 
>> >   
>> > 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
>> (v6.3.4#6332)
>>
>
>
>

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

[Raymond Sanchez]

Hi Dominik,

I upgrade my database to 9.5.4 and it works fine. Cristian, are you able to
push your project to Github?

If you are not able to do so, check the raw sql query being sent to
Postgres. I have seen .net providers sending incorrect column names to the
database.

Hope this helps.




On Mon, Dec 12, 2016 at 10:05 AM, Dominik Psenner 
wrote:

> Hi Raymond,
>
> have you already tried to migrate to postgresql 9.5 or newer?
>
> Best regards,
> Dominik
> On 2016-12-12 16:06, Raymond Sanchez wrote:
>
> What version of Postgresql are you using?
>
> Our company is using 9.4.5 and log4net 1.2.15 with no issues.
>
>
> On Mon, Dec 12, 2016 at 7:30 AM, Cristian Margescu (JIRA)  > wrote:
>
>>
>> [ https://issues.apache.org/jira/browse/LOG4NET-538?page=com.
>> atlassian.jira.plugin.system.issuetabpanels:comment-tabpane
>> l=15741894#comment-15741894 ]
>>
>> Cristian Margescu commented on LOG4NET-538:
>> ---
>>
>> Hi,
>> I would be glad to but I have time as of 20th this month. So if there is
>> no real hurry would be my pleasure. you can contact me per email with
>> details.
>> Thank You
>>
>> > 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
>> >  Labels: patch
>> >
>> > 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: 
>> > 
>> >   
>> >   
>> > 
>> > 
>> > > >   value="Npgsql.NpgsqlConnection, Npgsql" />
>> > > >   value="Server={myServer};Port=5432;Database={database};User
>> Id={myuser};Password={mypassword}" />
>> > > />
>> > 
>> > 
>> > 
>> >   
>> >   
>> >   
>> > 
>> >   
>> > 
>> >   
>> > 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
>> (v6.3.4#6332)
>>
>
>
>

[jira] [Created] (LOG4NET-539) NuGet error: Could not install package 'log4net 2.0.5'

[Emanuele Sabetta (JIRA)]

Emanuele Sabetta created LOG4NET-539:


 Summary: NuGet error: Could not install package 'log4net 2.0.5'
 Key: LOG4NET-539
 URL: https://issues.apache.org/jira/browse/LOG4NET-539
 Project: Log4net
  Issue Type: Bug
Affects Versions: 1.2.15
Reporter: Emanuele Sabetta


This is a great library, I'd like to use it in my Xamarin.Forms projects. 
Unfortunately it seems that there is some incompatibility in the NuGet package 
profile. Those are the error I get when I try to add it to my Xamarin.Forms 
project: 

> Could not install package 'log4net 2.0.5'. You are trying to install this 
> package into a project that targets 'Xamarin.iOS,Version=v1.0', but the 
> package does not contain any assembly references or content files that are 
> compatible with that framework. For more information, contact the package 
> author.

> Could not install package 'log4net 2.0.5'. You are trying to install this 
> package into a project that targets 
> '.NETPortable,Version=v4.5,Profile=Profile78', but the package does not 
> contain any assembly references or content files that are compatible with 
> that framework. For more information, contact the package author.

>Could not install package 'log4net 2.0.5'. You are trying to install this 
>package into a project that targets 'MonoAndroid,Version=v7.0', but the 
>package does not contain any assembly references or content files that are 
>compatible with that framework. For more information, contact the package 
>author.

Can you help me with that?



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)