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

[Dominik Psenner (JIRA)]

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

Dominik Psenner commented on LOG4NET-538:
-

Has this issue been resolved? It looks like log4net works fine to others using 
both a newer and the same version of postgresql. This means that most probably 
there's nothing we can do to fix the issue. Therefore I am going to close this 
issue after, but not before 7 days from today with resolution "Not 
reproducable".

> 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

[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)
>>
>
>
>

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

[Dominik Psenner]

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-tabpanel=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] [Commented] (LOG4NET-538) AdoNetAppender to PostgreSQL

[Dominik Psenner (JIRA)]

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

Dominik Psenner commented on LOG4NET-538:
-

Would you kindly investigate if your configuration works with postgresql 9.4.5?

> 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] [Commented] (LOG4NET-538) AdoNetAppender to PostgreSQL

[Stefan Bodewig (JIRA)]

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

Stefan Bodewig commented on LOG4NET-538:


Thanks. I don't know whether it makes any difference, honestly. I'm just trying 
to collect data that may be relevant.

You seem to be the first one to report the problem and there are community 
members who don't see the same problem.

> 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] [Commented] (LOG4NET-538) AdoNetAppender to PostgreSQL

[Cristian Margescu (JIRA)]

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

Cristian Margescu commented on LOG4NET-538:
---

Hi, Stefan

Our logging lib is compiled on .Net 4 and we are using PostgreSQL 9.5 x64 if it 
makes a difference since about 6 months ago.  

> 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] [Commented] (LOG4NET-538) AdoNetAppender to PostgreSQL

[Stefan Bodewig (JIRA)]

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

Stefan Bodewig commented on LOG4NET-538:


The version of the .NET framework itself may also be of interest.

> 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]

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-
> tabpanel=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] [Commented] (LOG4NET-538) AdoNetAppender to PostgreSQL

[Cristian Margescu (JIRA)]

[ 
https://issues.apache.org/jira/browse/LOG4NET-538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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] [Commented] (LOG4NET-538) AdoNetAppender to PostgreSQL

[Dominik Psenner (JIRA)]

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

Dominik Psenner commented on LOG4NET-538:
-

> All you need to do is create a database on postgres using the create script 
> provided earlier. Define the configuration with the ado net adapter as 
> provided and trigger it under root config.

This is a little more work than one might think at first sight. For instance, 
we do not have virtual machines ready for every kind of database supported by 
Ado.Net. It would be great to have them, all along with specialized tests for 
all kinds of databases.

> I have my own adapter so far, so no worries but I am glad to provide all 
> needed information if someone wants to test and find the problem

Would you like to write a patch for the AdoNetAppender?

> 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] [Commented] (LOG4NET-538) AdoNetAppender to PostgreSQL

[Cristian Margescu (JIRA)]

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

Cristian Margescu commented on LOG4NET-538:
---

Hi Dominik,

All you need to do is create a database on postgres using the create script 
provided earlier. Define the configuration with the ado net adapter as provided 
and trigger it under root config. With version 2.13 it works but 2.15 it does 
not any more. The error output regarding the "field that is not fount" is from 
log4net debug log. Again is not the PostgreSql server, rights or anything. Same 
app wit the log4net dll of 2.13 works like a charm. Replacing the dll with 2.15 
it triggers the column not found error. I'm just saying that something changed 
on the AdoNetAdapter and if it used by others others will report maybe the same 
issue. I have my own adapter so far, so no worries but I am glad to provide all 
needed information if someone wants to test and find the problem. :) 

> 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] [Commented] (LOG4NET-538) AdoNetAppender to PostgreSQL

[Dominik Psenner (JIRA)]

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

Dominik Psenner commented on LOG4NET-538:
-

I've tried to work out the root cause of the issue. To me it looks like a 
configuration/permission/.. issue on the server side of postgres or maybe a 
postgres driver issue, shadowed behind adonet. At the moment I have no idea 
what we could change in log4net to fix your issue. With the provided 
information I am unable to reproduce the issue. You'll have to figure this out 
on your own. log4net's internal logging may be of help. Let us know about your 
findings.

> 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] [Commented] (LOG4NET-538) AdoNetAppender to PostgreSQL

[Dominik Psenner (JIRA)]

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

Dominik Psenner commented on LOG4NET-538:
-

Another thing that I just noticed is that the table name "public.audit" 
mentioned in the create script and the table "audit" in the insert statement do 
not match.

> 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] [Commented] (LOG4NET-538) AdoNetAppender to PostgreSQL

[Cristian Margescu (JIRA)]

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

Cristian Margescu commented on LOG4NET-538:
---

I know what you mean. It had a size value but for the sake of testing I have 
removed it. The result is the same. Probably I will implement a specific 
PostgreSQL Appender. 


> 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] [Commented] (LOG4NET-538) AdoNetAppender to PostgreSQL

[Dominik Psenner (JIRA)]

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

Dominik Psenner commented on LOG4NET-538:
-

-Does your implementation call AddParameter() for the message parameter in your 
ActivateOptions() overload?-

Forget it, this does not make sense. The configuration does not look like the 
documentation states:





should probably read as:



and it could be that you need to specify the size of the string column:



> 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] [Commented] (LOG4NET-538) AdoNetAppender to PostgreSQL

[Dominik Psenner (JIRA)]

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

Dominik Psenner commented on LOG4NET-538:
-

Does your implementation call AddParameter() for the message parameter in your 
ActivateOptions() overload?

> 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] [Commented] (LOG4NET-538) AdoNetAppender to PostgreSQL

[Cristian Margescu (JIRA)]

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

Cristian Margescu commented on LOG4NET-538:
---

Pretty much tried everything I could think of. :( 

I would gladly appreciate new ideas.

> 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] [Commented] (LOG4NET-538) AdoNetAppender to PostgreSQL

[Dominik Psenner (JIRA)]

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

Dominik Psenner commented on LOG4NET-538:
-

A quick google search gave me this too:

http://stackoverflow.com/questions/17104837/pgsql-error-code-42703-column-does-not-exist

> 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] [Commented] (LOG4NET-538) AdoNetAppender to PostgreSQL

[Dominik Psenner (JIRA)]

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

Dominik Psenner commented on LOG4NET-538:
-

What happens if you write it as follows?



> 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] [Commented] (LOG4NET-538) AdoNetAppender to PostgreSQL

[Cristian Margescu (JIRA)]

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

Cristian Margescu commented on LOG4NET-538:
---

Update: If I am inserting a text in the command configuration instead of the 
parameter the insert works and the appender does not throw any error.

with parameter  -->  {Error}
without parameter -->  {No Error}

> 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] [Commented] (LOG4NET-538) AdoNetAppender to PostgreSQL

[Cristian Margescu (JIRA)]

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

Cristian Margescu commented on LOG4NET-538:
---

Hi Dominik,

The table looks as follows 

CREATE SEQUENCE audit_id_seq;
CREATE TABLE public.audit
(
  "Id" integer NOT NULL DEFAULT nextval('audit_id_seq'::regclass),
  "message" text,
  "timestamp" timestamp without time zone,
  CONSTRAINT audit_id_pkey PRIMARY KEY ("Id")
)

WITH (
  OIDS=FALSE
);
ALTER TABLE public.audit ALTER COLUMN "timestamp" 
SET DEFAULT timezone('utc'::text, now());

ALTER TABLE public.audit
  OWNER TO {user};

The column is there and sample table data looks as follows  
"33" ; "{"employees":[{ "firstName":"John", "lastName":"Doe"},{ 
"firstName":"Anna", "lastName":"Smith"},{ "firstName":"Peter", 
"lastName":"Jones"}]}" ; "2016-12-09 09:32:03.128181"

Update: My mistake, the postgreSQL error is 42703  with the stacktrace as : 

Npgsql.PostgresException (0x80004005): 42703: column "message" does not exist
   at Npgsql.NpgsqlConnector.DoReadMessage(DataRowLoadingMode 
dataRowLoadingMode, Boolean isPrependedMessage)
   at Npgsql.NpgsqlConnector.ReadMessageWithPrepended(DataRowLoadingMode 
dataRowLoadingMode)
   at Npgsql.NpgsqlCommand.Prepare()
   at log4net.Appender.AdoNetAppender.SendBuffer(IDbTransaction dbTran, 
LoggingEvent[] events)
   at log4net.Appender.AdoNetAppender.SendBuffer(LoggingEvent[] events)
   at log4net.Appender.BufferingAppenderSkeleton.Append(LoggingEvent 
loggingEvent)
   at log4net.Appender.AppenderSkeleton.DoAppend(LoggingEvent loggingEvent)

Same configuration and the version 1.2.13 it does work without a problem. 

P.S. - glad to help. 

> 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] [Commented] (LOG4NET-538) AdoNetAppender to PostgreSQL

[Dominik Psenner (JIRA)]

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

Dominik Psenner commented on LOG4NET-538:
-

I cannot find PG error 47203 mentioned in 
https://www.postgresql.org/docs/9.4/static/errcodes-appendix.html , however you 
are saying the error message is "column 'message' not found" which indicates 
that the table audit has no column message. Would you please verify that?

> 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)