Mailing-List: contact log4net-user-help@logging.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Log4NET User" <log4net-user@logging.apache.org>
Received-SPF: neutral (athena.apache.org: local policy)
Content-class: urn:content-classes:message
Subject: RE: How to pass password to AdoNetAppender?
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Date: Wed, 22 Oct 2008 11:17:08 -0400
Message-ID: <FFE6362EE00A4C4E83A98981EF88A3640511EE@zeus.roychastain.org>
In-Reply-To: <BLU130-W1761795131C41D697FFFAFF0290@phx.gbl>
Thread-Topic: How to pass password to AdoNetAppender?
thread-index: Ack0WJlMsSiAYrezR065usJ2VtbYLAAACeYg
References: <BLU130-W20A586CDD4D3C309F6B8BFF0290@phx.gbl>
 <002b01c93445$a1761cf0$e46256d0$@Jansen@Faktnet.com>
  <BLU130-W24C922B829ABA6DFCCCB69F0290@phx.gbl>
  <8464C36201C7C541A42F676EBFE94E9201333E9AEE67@APEXMAIL.corp.dom>
 <BLU130-W1761795131C41D697FFFAFF0290@phx.gbl>
From: "Roy Chastain" <Roy@roychastain.org>
To: "Log4NET User" <log4net-user@logging.apache.org>

Store the encrypted information in a config file.  Use a setup program
to solicit and encrypt the information.  Use the DPAPI wrapper code
(System.Security.Cryptography.ProtedData) in .Net 2.0 and up to encrypt,
decrypt and protect the keys.  Very simple to use.

------------------------------------------------------------------------
----------
Roy Chastain


-----Original Message-----
From: Bernhard Heinzel [mailto:bernhard.heinzel@live.com]=20
Sent: Wednesday, October 22, 2008 11:11
To: Log4NET User
Subject: RE: How to pass password to AdoNetAppender?

Thanks Michael.

But my Problem is that I have to configure the AdoNetAppender with a
config file so I don't have to recompile if I change the database.


________________________________

From: Michael.Richman@pgn.com
To: log4net-user@logging.apache.org
Date: Wed, 22 Oct 2008 07:55:41 -0700
Subject: RE: How to pass password to AdoNetAppender?


You can set the connection string in code, here is some sample code, you
only have to do this once and then you can use the AdoNetAppender
multiple times.
=20
log4net.Config.XmlConfigurator.Configure();
log4net.Repository.Hierarchy.Hierarchy h =3D
(log4net.Repository.Hierarchy.Hierarchy)
log4net.LogManager.GetRepository();
log4net.Appender.AdoNetAppender adoAppender =3D
(log4net.Appender.AdoNetAppender)
h.Root.GetAppender("AdoNetAppender_UserLog");
adoAppender.ConnectionString =3D <set your connection string here>;


________________________________

From: Bernhard Heinzel [mailto:bernhard.heinzel@live.com]
Sent: Wednesday, October 22, 2008 7:17 AM
To: Log4NET User
Subject: RE: How to pass password to AdoNetAppender?


Thanks Georg.

Unfortunatly integrated Security is not an option.
Seems it is not as trivial as it seems...
Any other suggestions?


Bernhard


________________________________

From: Georg.Jansen@Faktnet.com
To: log4net-user@logging.apache.org
Subject: RE: How to pass password to AdoNetAppender?
Date: Wed, 22 Oct 2008 14:56:36 +0200


Bernhard,

=20

This maybe of the point in your case, but have you considered using
integrated security?

=20

You could store the username and password encrypted, but then you have
the added problem of securing the encryption key.

=20

Maybe one of the links below is useful:

=20

http://msdn.microsoft.com/en-us/library/89211k9b.aspx

http://www.theserverside.net/tt/articles/showarticle.tss?id=3DNewSecurityF
eatures

=20

=20

Best regards

Georg

Log4Net Dashboard - Log Analysis and Monitoring made easy!

http://www.l4ndash.com

=20

=20

=20

From: Bernhard Heinzel [mailto:bernhard.heinzel@live.com]=20
Sent: 22. oktober 2008 14:08
To: lLog4NET Users
Subject: How to pass password to AdoNetAppender?

=20

Hi,

another Question from the new guy.
I want to pass the username and password for the database to the
AdoNetAppender.

The two ways I found were:
* Plaintext in the config file.
* 'Plaintext' in the sourcecode.

Both ways are not optimal, so were I missing something? Is there a
smarter way of passing a password?

Thanks in advance.

Regards
Bernhard

=20

________________________________

Connect to the next generation of MSN Messenger  Get it now!
<http://imagine-msn.com/messenger/launch80/default.aspx?locale=3Den-us&sou
rce=3Dwlmailtagline>=20


________________________________

Invite your mail contacts to join your friends list with Windows Live
Spaces. It's easy! Try it!
<http://spaces.live.com/spacesapi.aspx?wx_action=3Dcreate&wx_url=3D/friends=
.
aspx&mkt=3Den-us> =20

________________________________

Discover the new Windows Vista Learn more!
<http://search.msn.com/results.aspx?q=3Dwindows+vista&mkt=3Den-US&form=3DQB=
RE>