some work at getting db logging working on godaddyorigin/godaddylogging

5 files changed, 153 insertions, 5 deletions

diff --git a/samples/RelyingPartyPortal/RelyingPartyPortal.csproj b/samples/RelyingPartyPortal/RelyingPartyPortal.csproj
index 10e9a09..406c1e7 100644
--- a/samples/RelyingPartyPortal/RelyingPartyPortal.csproj
+++ b/samples/RelyingPartyPortal/RelyingPartyPortal.csproj
@@ -72,6 +72,13 @@
     <Compile Include="loginProgrammatic.aspx.designer.cs">

       <DependentUpon>loginProgrammatic.aspx</DependentUpon>

     </Compile>

+    <Compile Include="logs.aspx.cs">

+      <DependentUpon>logs.aspx</DependentUpon>

+      <SubType>ASPXCodeBehind</SubType>

+    </Compile>

+    <Compile Include="logs.aspx.designer.cs">

+      <DependentUpon>logs.aspx</DependentUpon>

+    </Compile>

     <Compile Include="m\Login.aspx.cs">

       <DependentUpon>Login.aspx</DependentUpon>

       <SubType>ASPXCodeBehind</SubType>

@@ -92,7 +99,10 @@
     <Content Include="xrds.aspx" />

   </ItemGroup>

   <ItemGroup>

+    <Content Include="App_Data\Logging.mdf">

+    </Content>

     <Content Include="loginProgrammatic.aspx" />

+    <Content Include="logs.aspx" />

     <Content Include="MembersOnly\Default.aspx" />

     <Content Include="MembersOnly\Web.config" />

     <Content Include="m\Login.aspx" />

diff --git a/samples/RelyingPartyPortal/Web.config b/samples/RelyingPartyPortal/Web.config
index f2453c7..a2fe2db 100644
--- a/samples/RelyingPartyPortal/Web.config
+++ b/samples/RelyingPartyPortal/Web.config
@@ -3,20 +3,25 @@
 	<configSections>

 		<section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler" requirePermission="false" />

 	</configSections>

+	<connectionStrings>

+		<add name="LoggingConnectionString1" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Logging.mdf;Integrated Security=True;User Instance=True"

+		 providerName="System.Data.SqlClient" />

+		<add name="godaddy" connectionString="data source=whsql-v22.prod.mesa1.secureserver.net;initial catalog=DNOIweb;User ID=DNOIweb;Password=DNOI2log" providerName="System.Data.SqlClient" />

+	</connectionStrings>

 	<system.web>

 		<!--<sessionState cookieless="true" />-->

 		<compilation debug="true"/>

-		<customErrors mode="RemoteOnly"/>

+		<customErrors mode="Off"/>

 		<authentication mode="Forms">

 			<forms name="RelyingPartySession"/> <!-- named cookie prevents conflicts with other samples -->

 		</authentication>

-		<trace enabled="false" writeToDiagnosticsTrace="true" />

+		<trace enabled="true" writeToDiagnosticsTrace="false" pageOutput="true" localOnly="false" />

 		<!-- Trust level discussion:

 		Full: everything works

 		High: TRACE compilation symbol must NOT be defined

 		Medium/Low: doesn't work on default machine.config, because WebPermission.Connect is denied.

 		-->

-		<trust level="High" originUrl=""/>

+		<!--<trust level="High" originUrl=""/>-->

 	</system.web>

 	<log4net>

 		<appender name="RollingFileAppender" type="log4net.Appender.RollingFileAppender">

@@ -30,10 +35,67 @@
 				<conversionPattern value="%date [%thread] %-5level %logger - %message%newline" />

 			</layout>

 		</appender>

+		<appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender">

+			<bufferSize value="1" />

+			<connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />

+			<connectionString value="data source=whsql-v22.prod.mesa1.secureserver.net;initial catalog=DNOIweb;User ID=DNOIweb;Password=DNOI2log" />

+			<!--<connectionString value="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Logging.mdf;Integrated Security=True;User Instance=True" />-->

+			<commandText value="INSERT INTO Log ([Date],[Thread],[Level],[Logger],[Message],[Exception]) VALUES (@log_date, @thread, @log_level, @logger, @message, @exception)" />

+			<parameter>

+				<parameterName value="@log_date" />

+				<dbType value="DateTime" />

+				<layout type="log4net.Layout.RawTimeStampLayout" />

+			</parameter>

+			<parameter>

+				<parameterName value="@thread" />

+				<dbType value="String" />

+				<size value="255" />

+				<layout type="log4net.Layout.PatternLayout">

+					<conversionPattern value="%thread" />

+				</layout>

+			</parameter>

+			<parameter>

+				<parameterName value="@log_level" />

+				<dbType value="String" />

+				<size value="50" />

+				<layout type="log4net.Layout.PatternLayout">

+					<conversionPattern value="%level" />

+				</layout>

+			</parameter>

+			<parameter>

+				<parameterName value="@logger" />

+				<dbType value="String" />

+				<size value="255" />

+				<layout type="log4net.Layout.PatternLayout">

+					<conversionPattern value="%logger" />

+				</layout>

+			</parameter>

+			<parameter>

+				<parameterName value="@message" />

+				<dbType value="String" />

+				<size value="4000" />

+				<layout type="log4net.Layout.PatternLayout">

+					<conversionPattern value="%message" />

+				</layout>

+			</parameter>

+			<parameter>

+				<parameterName value="@exception" />

+				<dbType value="String" />

+				<size value="2000" />

+				<layout type="log4net.Layout.ExceptionLayout" />

+			</parameter>

+		</appender>

+		<appender name="AspNetTraceAppender" type="log4net.Appender.AspNetTraceAppender" >

+			<layout type="log4net.Layout.PatternLayout">

+				<conversionPattern value="%date [%thread] %-5level %logger - %message%newline" />

+			</layout>

+		</appender>

 		<!-- Setup the root category, add the appenders and set the default level -->

 		<root>

-			<level value="INFO" />

-			<appender-ref ref="RollingFileAppender" />

+			<level value="ALL" />

+			<!--<appender-ref ref="RollingFileAppender" />-->

+			<appender-ref ref="AdoNetAppender" />

+			<appender-ref ref="AspNetTraceAppender" />

 		</root>

 		<!-- Specify the level for some specific categories -->

 		<logger name="DotNetOpenId">

diff --git a/samples/RelyingPartyPortal/logs.aspx b/samples/RelyingPartyPortal/logs.aspx
new file mode 100644
index 0000000..bb97ab4
--- /dev/null
+++ b/samples/RelyingPartyPortal/logs.aspx
@@ -0,0 +1,16 @@
+<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="logs.aspx.cs" Inherits="ConsumerPortal.logs" %>

+

+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

+

+<html xmlns="http://www.w3.org/1999/xhtml" >

+<head runat="server">

+    <title>Untitled Page</title>

+</head>

+<body>

+    <form id="form1" runat="server">

+    <div>

+    

+    </div>

+    </form>

+</body>

+</html>

diff --git a/samples/RelyingPartyPortal/logs.aspx.cs b/samples/RelyingPartyPortal/logs.aspx.cs
new file mode 100644
index 0000000..6369d79
--- /dev/null
+++ b/samples/RelyingPartyPortal/logs.aspx.cs
@@ -0,0 +1,35 @@
+using System;

+using System.Collections;

+using System.Configuration;

+using System.Data;

+using System.Web;

+using System.Web.Security;

+using System.Web.UI;

+using System.Web.UI.HtmlControls;

+using System.Web.UI.WebControls;

+using System.Web.UI.WebControls.WebParts;

+using System.Data.SqlClient;

+

+namespace ConsumerPortal {

+	public partial class logs : System.Web.UI.Page {

+		protected void Page_Load(object sender, EventArgs e) {

+			SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["godaddy"].ConnectionString);

+			conn.Open();

+			try {

+				var cmd = conn.CreateCommand();

+				cmd.Parameters.Add(new SqlParameter("@log_date", "1/1/2008"));

+				cmd.Parameters.Add(new SqlParameter("@thread", "3"));

+				cmd.Parameters.Add(new SqlParameter("@log_level", "INFO"));

+				cmd.Parameters.Add(new SqlParameter("@logger", "dnoi"));

+				cmd.Parameters.Add(new SqlParameter("@message", "some message"));

+				cmd.Parameters.Add(new SqlParameter("@exception", DBNull.Value));

+				cmd.CommandText = "INSERT INTO Log ([Date],[Thread],[Level],[Logger],[Message],[Exception]) VALUES (@log_date, @thread, @log_level, @logger, @message, @exception)";

+				cmd.CommandType = CommandType.Text;

+				int result = cmd.ExecuteNonQuery();

+				Response.Write("<P>result: " + result.ToString() + "</p>");

+			} finally {

+				conn.Close();

+			}

+		}

+	}

+}

diff --git a/samples/RelyingPartyPortal/logs.aspx.designer.cs b/samples/RelyingPartyPortal/logs.aspx.designer.cs
new file mode 100644
index 0000000..c825e12
--- /dev/null
+++ b/samples/RelyingPartyPortal/logs.aspx.designer.cs
@@ -0,0 +1,25 @@
+//------------------------------------------------------------------------------

+// <auto-generated>

+//     This code was generated by a tool.

+//     Runtime Version:2.0.50727.42

+//

+//     Changes to this file may cause incorrect behavior and will be lost if

+//     the code is regenerated.

+// </auto-generated>

+//------------------------------------------------------------------------------

+

+namespace ConsumerPortal {

+

+

+	public partial class logs {

+

+		/// <summary>

+		/// form1 control.

+		/// </summary>

+		/// <remarks>

+		/// Auto-generated field.

+		/// To modify move field declaration from designer file to code-behind file.

+		/// </remarks>

+		protected global::System.Web.UI.HtmlControls.HtmlForm form1;

+	}

+}