It's in the FAQ: http://logging.apache.org/log4net/release/faq.html
-Original Message-
From: Steve Hueners [mailto:am.st...@gmail.com]
Sent: 18 September 2014 12:12
To: Log4NET User
Subject: Re: AdoNetAppender on Azure SQL: Works then quits working
On Wed, A
On Wed, Aug 20, 2014 at 11:01 AM, Joe wrote:
> and route this trace output to a file.
Thanks much for your reply. I'm not clear about how to route the
internal debug output to a trace file. An Azure website provides
access to the file system via the project's App_Data so if I knew the
precise st
com]
Sent: mardi 19 août 2014 16:34
To: log4net-user@logging.apache.org
Subject: Re: AdoNetAppender on Azure SQL: Works then quits working
It happened again last night - I had a line logged at 2014-08-19
00:59:59.537 (gmt) then nothing until I restarted the website.
On Mon, Aug 18, 2014 at 3:07
It happened again last night - I had a line logged at 2014-08-19
00:59:59.537 (gmt) then nothing until I restarted the website.
On Mon, Aug 18, 2014 at 3:07 PM, Steve Hueners wrote:
> Last week I stepped thru the hoops required to configure a connection
> string for my Azure SQL db and confirmed
Glad you were able to sort it out on your own and be sure that it would
have taken ages to find this. :-)
Cheers
2014-05-30 21:32 GMT+02:00 Rob Richardson :
> Sorry to bother you. The problem turns out to be what seems to me an
> unbelievable bug (feature?) in the PostgreSQL administration to
Sorry to bother you. The problem turns out to be what seems to me an
unbelievable bug (feature?) in the PostgreSQL administration tool PGAdmin
shipped with version 9.3: if you use that tool to create a table, the name of
the table includes double quotes.
I decided, just for grins, to try the
...@gmail.com]
Sent: Thursday, July 29, 2010 9:13 PM
To: Log4NET User
Subject: Re: ADONetAppender not logging
Hi Rob,
I notice that and I've included it in my configuration files.
I'm able to trap the mysql connection error with the internal logging file.
Exception: "an established
se
>
>
>
> *From:* shally chong [mailto:shally.ch...@gmail.com]
> *Sent:* Wednesday, July 28, 2010 11:44 PM
>
> *To:* Log4NET User
> *Subject:* Re: ADONetAppender not logging
>
>
>
> Hi Rob,
>
> Yes, this happened after server rebooted.
> There is no w
Rob Prouse
From: shally chong [mailto:shally.ch...@gmail.com]
Sent: Wednesday, July 28, 2010 9:29 PM
To: Log4NET User
Subject: Re: ADONetAppender not logging
Hi Rob,
Yes, I included the ReconnectOnError clause in my configuration and the log
is obtained.
Any idea why the connection issu
.NET runtime, or to the MySQL
> server.
>
>
>
> Rob Prouse
>
>
>
> *From:* shally chong [mailto:shally.ch...@gmail.com]
> *Sent:* Wednesday, July 28, 2010 9:29 PM
> *To:* Log4NET User
> *Subject:* Re: ADONetAppender not logging
>
>
>
> Hi Rob,
>
&
chong [mailto:shally.ch...@gmail.com]
Sent: Wednesday, July 28, 2010 9:29 PM
To: Log4NET User
Subject: Re: ADONetAppender not logging
Hi Rob,
Yes, I included the ReconnectOnError clause in my configuration and the log
is obtained.
Any idea why the connection issue happened after the server
Hi Rob,
Yes, I included the ReconnectOnError clause in my configuration and the log
is obtained.
Any idea why the connection issue happened after the server reboot?
All these while, I did not face such problem.
Thanks,
Shally
On Wed, Jul 28, 2010 at 9:29 PM, Rob Prouse wrote:
> Shally,
>
>
>
Shally,
In your configuration for the AdoNetAppender, do you have ReconnectOnError set
to true? It defaults to false and is not in the example configuration.
http://logging.apache.org/log4net/release/sdk/log4net.Appender.AdoNetAppender.ReconnectOnError.html
If not, add the following line to the
whole message. Silly
mistake, huh?
Many thanks for your help.
Gary
From: Ross Hinkley [mailto:rosshink...@gmail.com]
Sent: 11 May 2010 18:40
To: Log4NET User
Subject: Re: AdoNetAppender field sizes
I tried to recreate your problem on my local machine using your configuration.
I agree with Ron
Procedure", but it is still truncating.
>
> -Original Message-
> From: Ron Grabowski [mailto:rongrabow...@yahoo.com]
> Sent: 11 May 2010 01:57
> To: Log4NET User
> Subject: Re: AdoNetAppender field sizes
>
> The config looks correct to me. Are you sure you want to u
riginal Message-
From: Ron Grabowski [mailto:rongrabow...@yahoo.com]
Sent: 11 May 2010 01:57
To: Log4NET User
Subject: Re: AdoNetAppender field sizes
The config looks correct to me. Are you sure you want to use the .NET 1.0
version of System.Data? Does this make a difference?
- O
The config looks correct to me. Are you sure you want to use the .NET 1.0
version of System.Data? Does this make a difference?
- Original Message
From: "Watson, Gary"
To: "log4net-user@logging.apache.org"
Sent: Mon, May 10, 2010 8:19:48 AM
Subject: AdoNetAppender field sizes
Hello
Hadley
From:Hadley Willan
[mailto:[EMAIL PROTECTED]
Sent: Monday, 17 November 2008
14:16
To: Log4NET User
Subject: RE: AdoNetAppender
connection timeouts
Hi all,
I’ve done some testing by writing a
small test app that loops through, throws an ArgumentException, gets caught and
logs the exception to l
Willan [mailto:[EMAIL PROTECTED]
Sent: Monday, 17 November 2008 14:16
To: Log4NET User
Subject: RE: AdoNetAppender connection timeouts
Hi all,
I've done some testing by writing a small test app that loops through,
throws an ArgumentException, gets caught and logs the exception to
log4net.
[49] (6)ms
Timing[50] (41554)ms
Timing[51] (8)ms
Timing[52] (3)ms
Timing[53] (3)ms
Timing[54] (3)ms
Timing[55] (3)ms
From: Hadley Willan [mailto:[EMAIL PROTECTED]
Sent: Monday, 17 November 2008 09:48
To: Log4NET User
Subject: RE: AdoNetAppender connection ti
he timeout?
Thanks
Hadley
From: Ron Grabowski [mailto:[EMAIL PROTECTED]
Sent: Monday, 17 November 2008 00:55
To: Log4NET User
Subject: Re: AdoNetAppender connection timeouts
The AdoNetAppender keeps a reference to an open connection. At some
point it e
Regards
Hadley
From: Ron Grabowski [mailto:[EMAIL PROTECTED]
Sent: Monday, 17 November 2008 00:55
To: Log4NET User
Subject: Re: AdoNetAppender connection timeouts
The AdoNetAppender keeps a reference to an open connection. At some
point it ensures th
The AdoNetAppender keeps a reference to an open connection. At some point it
ensures the connection is open:
// shortened somewhat...the actual code is longer
if (m_reconnectOnError && m_dbConnection.State != ConnectionState.Open)
{
LogLog.Debug("Attempting to reconnect to database...");
Initia
:
... lots of stuff in here ...
-Original Message-
From: Dag Christensen [mailto:[EMAIL PROTECTED]
Sent: 16 October 2008 14:58
To: Log4NET User
Subject: RE: AdoNetAppender Connection String
Importance: Low
Shouldn't be a TextWriterAppender there. Can you post your configuration
Shouldn't be a TextWriterAppender there. Can you post your configuration file?
Not answering your question but as a workaround you could loop through the list
of appenders returned and find the first (or named) instance of AdoNetAppender
you're looking for.
Regards,
Dag
From: Gourlay, Colin
Ok, got it working.
More exactly, it was already working...but it wouldn't show anything in the
database because the bufferSize attribute was the default one...so it would
only log after 512 log entries...
I added to the configuration and it showed
immediately.
I hope this helps someone that is
Hmm, I'm using Npgsql as provider for data access.
NpgsqlConnection inherits DbConnection and so forth.
I've tried to put this working with the following configuration:
If there is an ADO.Net driver for PostgrSQL that implement IDbConnection,
IDbCommand, etc. then its supported.
- Original Message
From: Nuno Rocha <[EMAIL PROTECTED]>
To: log4net-user@logging.apache.org
Sent: Tuesday, September 18, 2007 1:03:17 PM
Subject: AdoNetAppender and PostgreSQL
I found out the error:
--- Move the commandText line after all the parameter nodes.
Thanks
Arun
nmarun wrote:
>
> Hi Log4Net developers/users,
>
> I'm currently developing a logging mechanism for our company and I'm
> having an issue with the below code - its not working!!
>
> [code]
>
>
et.cz/
Ron Grabowski napsal(a):
Is ReconnectOnError=true ?
http://logging.apache.org/log4net/release/sdk/log4net.Appender.AdoNetAppender.ReconnectOnError.html
- Original Message
From: Martin Hassman <[EMAIL PROTECTED]>
To: Log4NET User
Sent: Friday, February 2, 2007 4:27:35 A
Is ReconnectOnError=true ?
http://logging.apache.org/log4net/release/sdk/log4net.Appender.AdoNetAppender.ReconnectOnError.html
- Original Message
From: Martin Hassman <[EMAIL PROTECTED]>
To: Log4NET User
Sent: Friday, February 2, 2007 4:27:35 AM
Subject: Re: AdoNetAppend
Ron Grabowski napsal(a):
What version of log4net are you using? This may have been fixed in 1.2.10.
log4net-1.2.10, .NET 2.0
Martin Hassman
- Original Message
From: Martin Hassman <[EMAIL PROTECTED]>
To: log4net-user@logging.apache.org
Sent: Thursday, February 1, 2007 5:56:40 AM
What version of log4net are you using? This may have been fixed in 1.2.10.
- Original Message
From: Martin Hassman <[EMAIL PROTECTED]>
To: log4net-user@logging.apache.org
Sent: Thursday, February 1, 2007 5:56:40 AM
Subject: AdoNetAppender and reconnect
Hi,
I have problem with AdoNetAppe
: Log4NET User
Subject: Re: AdoNetAppender Connection String from App Config
This patch allows the connection string to come from the App.Config's
connectionStrings section:
http://issues.apache.org/jira/browse/LOG4NET-88
It will most likely make it into the next release. I need to contact Phi
This patch allows the connection string to come from the App.Config's
connectionStrings section:
http://issues.apache.org/jira/browse/LOG4NET-88
It will most likely make it into the next release. I need to contact Phil and
make him re-upload the files with the appropriate radio button for Apach
Did you ever watch debug output in Visual Studio? In my experience an
ADONetAppender is unable to correctly close on program shutdown and
these exceptions are written to debug output.
I have found a simple solution: to call LogManager.Shutdown on program exit.
-
Prostredi: VB.NET, VS2005 P
does any one experience of loss log entries when using AdoNetAppender?
I have both RollingFileAppender and AdoNetAppender in one of my application.
From time to time, there were some of log entries missing in the database
but they were in the log file. The bufferSize is set to 1.
On 1/8/07, bo
I found better way of doing this:
Here is my config file:
It works !
Stephen Murtagh wrote:
>
> I had a similar problem about a year back, ended up subclassing
> AdoNetAppenderParameter and overriding the FormatValue method as below
Thank you so much, but how can I set the type of the parameter ?
Here is my cofig file:
Where should I add MyAdoNetAppenderParameter ?
Stephen Murtagh wrote:
>
> I had a similar problem about a year back, ended up subclassing
> AdoNetAppenderParamet
I had a similar problem about a year back, ended up subclassing
AdoNetAppenderParameter and overriding the FormatValue method as below:
public class MyAdoNetAppenderParameter : AdoNetAppenderParameter
{
///
/// Custom version of FormatValue method which also converts NullText
value (null)
I believe you'll find the answer here.
http://mail-archives.apache.org/mod_mbox/logging-log4net-user/200609.mbox/%3
[EMAIL PROTECTED]
You'll want to use a Thread context property to store the user name.
-Original Message-
From: ebergemann [mailto:[EMAIL PROTECTED]
Sent: Tuesday, Sep
I was having the same problem.
I entered the data with milliseconds into sql server directly and it worked
fine.
(As it should - the datetime datatype is valid within 3.3 milliseconds)
That told me is was NOT a SQL issue.
I changed the ,fff to .fff and it worked fine.
Never mind, I got it...again I have a typo in the "parameterName"
Thanks,
Kumar
-Original Message-
From: Velugula, Kumar
Sent: Monday, May 22, 2006 9:36 AM
To: 'Log4NET User'
Subject: RE: AdoNetAppender: logging via stored proc:
Hi,
I am trying to log to databa
elements?
Thanks,
Kumar
-Original Message-
From: Velugula, Kumar
Sent: Monday, May 22, 2006 9:20 AM
To: 'Log4NET User'
Subject: RE: AdoNetAppender:
I greatly appreciate it. Thanks it works after changing the appender
name from "log4net.Appender.Ado
PM
To: Log4NET User
Subject: Re: AdoNetAppender:
What version of log4net are you using? Older versions of log4net used
log4net.Appender.ADONetAppender as the type name. The documentation on
the website is for log4net 1.2.10.
--- [EMAIL PROTECTED] wrote:
>
> > Hi
> >
> >
What version of log4net are you using? Older versions of log4net used
log4net.Appender.ADONetAppender as the type name. The documentation on
the website is for log4net 1.2.10.
--- [EMAIL PROTECTED] wrote:
>
> > Hi
> >
> > I am trying to log messages to Oracle 9i database table 'Log". I am
> > g
I still need help please. Hi, the following is the code that I use and I'm unable to write to SQL DB. What am I missing ??? :( Any help would be greatly appreciated. Thanks. Private logger As ILog Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
s [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 03, 2006 7:45 AM
To: Log4NET User
Subject: Re: ADONetAppender - can only use IP in connection string?
Thanks. Can anyone comment on log4net 1.2.8? 1.2.9 was a significant
upgrade.
Simon.
-Original message-
From: si [EMAIL PROTECTED]
Da
Thanks. Can anyone comment on log4net 1.2.8? 1.2.9 was a significant upgrade.
Simon.
-Original message-
From: si [EMAIL PROTECTED]
Date: Mon, 02 Jan 2006 23:34:20 -0800
To: Log4NET User log4net-user@logging.apache.org
Subject: Re: ADONetAppender - can only use IP in connection string
Hi Simon,
> Hi, it seems that we can only use the IP,port of our database in the
> ADONetAppender
> connection string (log4net 1.2.8). Is there a limitation that is preventing
> us from using the
> database name, or should the database name work as well as IP,port?
No problems here using databa
Joe,
The appender should be opening the connection before using it.
Can you enable log4net internal debug and get a trace of log4net
initialising the appender and attempting to log?
http://logging.apache.org/log4net/release/faq.html#internalDebug
Using is
preferable to the syntax because it en
age-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: 20 May 2005 11:34
> To: Log4NET User
> Subject: Re: AdoNetAppender losing first entry
>
> I've checked the code and think this is an error at line 400 in
> BufferingAppenderSkeleton.cs:
>
>
I've checked the code and think this is an error at line 400 in
BufferingAppenderSkeleton.cs:
if (discardedLoggingEvent != null && m_lossyEvaluator != null &&
m_lossyEvaluator.IsTriggeringEvent(discardedLoggingEvent))
If you don't give a lossy evaluator the event is discarded, regardless of
wheth
Sorry, everyone. Forget it.
The DOMConfigurator.Configure() line got removed in a branching merge in
ClearCase. Doh!
Kevin Williams wrote:
This issue hasn't gone away, apparently. It seems like our production
environment is not logging INFO-level messages. The production
environment is not acce
This issue hasn't gone away, apparently. It seems like our production
environment is not logging INFO-level messages. The production
environment is not accessible by developers, except the database logs.
Debugging will be next to impossible due to the security measures and
"red tape" around the
Nicko Cadell wrote:
Kevin,
Setting the BufferSize to any value less than or equal to 1 should have
the same effect; to log synchronously.
It didn't seem to be that way. It was 0 when it was logging sometimes at
best. Once we set it to 1, it seemed to log responsively as would be
expected. That ma
the appender to try to reconnect if the connection is lost.
Nicko
> -Original Message-
> From: Kevin Williams [mailto:[EMAIL PROTECTED]
> Sent: 01 April 2005 19:16
> To: Log4NET User
> Subject: Re: ADONetAppender losing logs
>
> No, we're using 1.2.0.30714 and no
No, we're using 1.2.0.30714 and no NDC.
I found the answer.
We had the bufferSize value set to 0. Once we changed it to 1, it
started working again.
The remarks for that are quite misleading, IMHO. Here's the doc:
The BufferSize option takes a positive integer representing the
maximum number o
Are you using 1.2.9 and NDC? If so you might want to check my thread
about Missing LoggingEvents in the RemotingAppender.
If not, then I'm not sure if I can help, but what I did (may or may
not be recommended) is add a Console.WriteLine (though you should
probably use a Trace.WriteLine with a Text
e respond to
"Log4NET User"
To
"Log4NET User"
cc
Subject
RE: ADONetAppender
Pass the name of the System.Data.DbType enum value
that you would pass
to the OracleParameter.DbType.OracleParameter.DbType for the prepared
statement parameter.
I don't use Oracle but
Message-
> From: Ping Xie [mailto:[EMAIL PROTECTED]
> Sent: 17 February 2005 16:47
> To: Log4NET User
> Cc: Log4NET User
> Subject: Re: ADONetAppender
>
>
> Sorry that I forgot to mention that I'm using ADONetAppender
> to log to Oracle 9i database. In log4net con
Sorry that I forgot to mention that
I'm using ADONetAppender to log to Oracle 9i database. In log4net configuration
file, there is a ... block for each database
column, something like listed below.
your BufferSize set to 1 in the
configuration of your ADONetReturnValueAppender.
Aaron
-Original Message-
From: Diego Barros [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 08, 2005 11:08 PM
To: Log4NET User
Subject: RE: ADONETAppender and stored procedures
Hi Aaron,
I tried your
ssage --
>Reply-To: "Log4NET User"
>Subject: RE: ADONETAppender and stored procedures
>Date: Tue, 8 Feb 2005 08:50:16 -0700
>From: "Hart, Aaron" <[EMAIL PROTECTED]>
>To: "Log4NET User"
>
>
>I should also note that I had to change the ADONET
Hi Aaron,
Thanks for taking the time to reply, appreciate it. And thanks for sending
the files, I will check them out as I try and get what I want working.
Cheers,
Diego
>-- Original Message --
>Reply-To: "Log4NET User"
>Subject: RE: ADONETAppender and stored procedures
>
I should also note that I had to change the ADONETAppender class to use
protected variables and functions instead of private in order to inherit
from it.
Aaron Hart
-Original Message-
From: Hart, Aaron
Sent: Tuesday, February 08, 2005 7:25 AM
To: 'Log4NET User'
S
Diego,
I have done this exact thing, although my intentions were different. I
wanted to create a logging table that has an auto-increment field and be
able to return the value for that field. Since each logging call could
go be written to multiple ADONETAppenders and therefore have several
sets o
Message-
> From: Burger, Erik [mailto:[EMAIL PROTECTED]
> Sent: 27 January 2005 14:15
> To: 'Log4NET User'
> Subject: RE: ADONetAppender through a firewall
>
> I am not referring to a faulty database server or network problems.
>
> Many companies (mine is one of the
Title: RE: ADONetAppender through a firewall
I am not referring to a faulty database server or network problems.
Many companies (mine is one of them) reboot their servers at least once a week. This is perfectly normal maintenance policy. If the database goes offline and online constantly
> Phone: +44 (0) 23 8076 2519
> Fax: +44 (0) 23 8076 2555
> Email: [EMAIL PROTECTED]
>
>
> -Original Message-
> From: Nicko Cadell [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 25, 2005 1:55 AM
> To: Log4NET User
> Subject: RE: ADONetAppender through a firewa
Title: RE: ADONetAppender through a firewall
Would it be an option to add a configurable parameter to the ADONetAppender that specifies a timespan between retries? Perhaps in this case the buffer size should become dynamic so that no messages are lost.
Just adding my two cents. I must admit
Dave,
Out of interest what would happen if the AdoNetAppender could not
connect to the database for some reason, lets say there is a network
connectivity error? Does this change mean that the appender tries to
connect each time a message is logged? Does this lead to a 30 second
blocking timeout fo
Aaron,
> I had that same thought. There are a couple of problems I saw
> with that, though. The LoggingEvent object is passed in by
> value, through several intermediary objects. Each of those
> would have to be changed, which would affect five or six
> objects just to change them to use refe
ge request.
Aaron Hart
-Original Message-
From: Nicko Cadell [mailto:[EMAIL PROTECTED]
Sent: Friday, December 17, 2004 10:01 AM
To: Log4NET User
Subject: RE: ADONetAppender - returning output parameters
Aaron,
The standard implementation of the ADONetAppender does not support
retrievi
Aaron,
The standard implementation of the ADONetAppender does not support
retrieving results from the database query. You will need to create your
own implementation that also retrieves a result from the database. The
LoggingEvent has a Properties map that can be used to store additional
data. You
Patrick,
What error are you getting?
Nicko
> -Original Message-
> From: Patrick [mailto:[EMAIL PROTECTED]
> Sent: 30 November 2004 08:35
> To: Nicko Cadell
> Subject: ADONetAppender
>
> Dear Mr. Cadell!
>
>
>
> Excellent, now it works. One problem occurred regarding my
> mobile a
The MSDN docs seem to have some useful examples about how to specify the
parameters to the prepared statement.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/h
tml/frlrfsystemdatasqlservercesqlcecommandclasspreparetopic.asp
Nicko
> -Original Message-
> From: Patr
Patrick,
To write to a SqlCE database you will need to use the SqlCeConnection
connection type.
The type to specify will be something like:
System.Data.SqlServerCe.SqlCeConnection, System.Data.Sqlserverce,
Version=X.X.X.X, Culture=neutral, PublicKeyToken=XX
I don't know what the Ver
l me what I have forgotten or made wrong??
>
> Best Regards
>
>
> --
> Patrick Achatschitz, Bakk.
> Fasangasse 8/3
> 1030 Vienna
> Austria
>
> Mobile: 01 650 270 8819
>
> -Ursprüngliche Nachricht-
> Von: Nicko Ca
Patrick,
Have you tried enabling log4net internal debug so that you can get a trace of
any errors that may be occurring when connecting to the database?
See: http://logging.apache.org/log4net/release/manual/faq.html#internalDebug
Cheers,
Nicko
> -Original Message-
> From: Patrick [mail
Thank you for your assistance, indeed with a buffersize = "1" évents are stored
directly in base. But i have always a problem with the Windows services:
Indeed on my server, i have a service which turns but no évent is registered in
base, even with a buffersize = "1". If you could also help me o
The ADONetAppender is able to buffer events before writing them to the
DB.
The buffer size is controlled the following configuration:
This means that the appender will not write anything to the DB until it
has buffered 100 events, it will then write all the events in the buffer
in one go. When l
Adam,
The PatternLayout("$X{UserID}") should be %X{FileID} and %X{UserID}
However I don't know why the sql client is not liking the SQL it is trying
to build.
What are the arguments, types and sizes for the InsertAuditEntry stored
procedure?
Nicko
> -Original Message-
> From: Adam Pata
Are you sure it's AnsiString?
Anyway, I did notice that any varchar > 4000 wasn't available. I had
columns with 8000 on them and it couldn't log to them. I also had a text
field and it didn't work. But the following does work for me but I use
String as opposed to AnsiString.
84 matches
Mail list logo
