HangfireIO/Hangfire

Connection string is missing for the SQL error log.

Open

#915 opened on Jun 7, 2017

View on GitHub
 (1 comment) (0 reactions) (0 assignees)C# (10,068 stars) (1,748 forks)batch import
a: corehelp wantedt: question

Description

I am having an issue with Hangfire:

I am busy trying to add hangfire to my MVC project. I am following the Quick Start Guide

I have added this to my startup.cs file

   public void Configuration(IAppBuilder app)
    {
        ConfigureAuth(app);          

        //Hangfire
        GlobalConfiguration.Configuration.UseSqlServerStorage("data source=ip;initial catalog=Name;user id=Hangfire;password=Password;");
        app.UseHangfireDashboard();
        app.UseHangfireServer();
    }

However when I run my project I get the following error: (it highlights the GlobalConfiguration.Configuration.UseSqlServerStorage line in my startup.cs class)

Connection string is missing for the SQL error log.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: Elmah.ApplicationException: Connection string is missing for the SQL error log.

I have posted it on SO as well: https://stackoverflow.com/questions/44404484/hangfire-error-connection-string-is-missing-for-the-sql-error-log

Contributor guide

Tech stack
csharpsql
Domain
backenddatabase
Issue type
bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
under 1 hour
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
needs investigation
Prerequisites
basic .NET and ASP.NET MVCHangfire and Elmah basics
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
40
Research direction
The error originates from Elmah, not Hangfire. The user's Hangfire configuration appears correct, but the connection string for Elmah's SQL error log is missing. To resolve, the user should check their Web.config for an Elmah specific connection string (e.g., under <elmah><errorLog type="Elmah.SqlErrorLog, Elmah" connectionStringName="..." />). The issue may be resolved by adding the missing connection string. No linked PRs or further comments.
Connection string is missing for the SQL error log. · HangfireIO/Hangfire#915 | Good First Issue