How do you centralize ELMAH logs

Question

At my works we produce websites like they are going out of fashion (ie a lot of sites per year)

I want to install ELMAH on all of these as company practice and then log everything centrally for viewing by our developers. The process has to be really easy as otherwise its use won't take off.

I was thinking of setting up a central Google Reader account and hooking all the RSS feeds for the ELMAH installations into it.

my concern is that Google says that they only check about once an hour, and this means that if you are using the "in memory" storage for ELMAH there is a chance that the errors will be missed when an app pool restarts.

Email is pretty good, but if everyone starts recieving ELMAH error messages they'll start to ignore them - maybe i could setup an extra exchange mailbox JUST for this to keep things seperate?

your thoughts will be greatly appreciated

(ps this MAY be thought of as subjective - but i believe that someone probably has THE answer among a number of subjective answers, making it a valid question)

score 7 · Answer 1 · answered Mar 10 '11 at 14:28

With a few changes in the Elmah sourcecode, you can have all your sites writing to the same database. You can then configure one mastersite that displays all of the exceptions with the application that threw it.

Eric King shows how in this blog post http://blog.devadept.com/2010/02/using-elmah-with-multiple-applications.html

To summarize:

Create two additional stored procedures in the database called ELMAH_GetErrorsXML_Master and ELMAH_GetErrorXML_Master without the applicationname parameter.

Then create a SQLMasterErrorLog class based on the existing ‘SQLErrorLog.cs’ class. In this edit the GetErrorXml() and GetErrorsXML() methods to call the new stored procedures

public static SqlCommand GetErrorXml(string appName, Guid id)
{
    SqlCommand command = new SqlCommand("ELMAH_GetErrorXml_Master");
    command.CommandType = CommandType.StoredProcedure;

    SqlParameterCollection parameters = command.Parameters;
    parameters.Add("@ErrorId", SqlDbType.UniqueIdentifier).Value = id;

    return command;
}

public static SqlCommand GetErrorsXml(string appName, int pageIndex, int pageSize)
{
    SqlCommand command = new SqlCommand("ELMAH_GetErrorsXml_Master");
    command.CommandType = CommandType.StoredProcedure;

    SqlParameterCollection parameters = command.Parameters;

    parameters.Add("@PageIndex", SqlDbType.Int).Value = pageIndex;
    parameters.Add("@PageSize", SqlDbType.Int).Value = pageSize;
    parameters.Add("@TotalCount", SqlDbType.Int).Direction = ParameterDirection.Output;

    return command;
}

Change the RendorErrors() method in the ErrorLogPage class to display an extra column in the log viewer table for the Application Name.

Add the following to the table header

headRow.Cells.Add(FormatCell(new TableHeaderCell(), "Host", "host-col"));
headRow.Cells.Add(FormatCell(new TableHeaderCell(), "App", "app-col"));

And the following in the for loop creating the childrows

bodyRow.Cells.Add(FormatCell(new TableCell(), error.HostName, "host-col"));
bodyRow.Cells.Add(FormatCell(new TableCell(), error.ApplicationName, "app-col"));

Now all you need is a single empty website that has elmah configured. Instead of the normal SqlErrorLog use the following

<errorLog type="Elmah.SqlMasterErrorLog, Elmah" connectionStringName="elmah"/>

This is great, but being disconnected is what we want - we don't have all our sites in the same webhost and therefore can't write everything to a single database as it can't be central - hence my idea with google reader — Doug, Mar 11 '11 at 00:15
In that case I would create a class based on the XmlFileErrorLog that accepts ftp information. You can send all the xml files to a single server in your local network and use the same rendering changes I posted above. — Freek Buurman, Mar 11 '11 at 09:14

score 1 · Answer 2 · edited Aug 30 '17 at 10:06

1

I use ftp method transfer all error XML (site a,b,c ...) to the collect all site error XML (log site).

in Global.asax Application_Start add ElmahErrorLogCustomize task every 10 min to transfer all XML to the log site, after transfer all XML in site (a,b,c ...) and delete these log in site (a,b,c ...)

edited Aug 30 '17 at 10:06

Andreas

5,393
9
44
53

answered Aug 30 '17 at 09:29

ihsinhw

11
2

How do you centralize ELMAH logs

2 Answers2