Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Mark Mitchell 35 posts 60 karma points
    Feb 05, 2011 @ 18:03
    Mark Mitchell
    0

    Here are the changes I have made to utilize SQL server instead of SQL Lite:

    1. In the web.config section, change the following settings:

    <?xml version="1.0"?>
    <configuration>
        
        <elmah>
            
    <errorLog type="Elmah.SQLiteErrorLog, Elmah" connectionStringName="ELMAH.SQLite"/>
            <errorLog type="Elmah.SqlErrorLog, Elmah" connectionStringName="Elmah.Sql"/>

        </elmah>

        <connectionStrings>
            <add name="ELMAH.SQLite" connectionString="Data Source=~/App_Data/elmahDatabase.s3db.config" />
    <add name="Elmah.Sql" connectionString="data source=.\SQLExpress;User ID=sqluser;Password=yourpwd;persist security info=False;Database=dbname;" providerName="System.Data.SqlClient"/>

        </connectionStrings>

    </configuration>

     

    2. I had to remove the fileSystem.Data.SQLite.dll from the bin folder in order for my Umbraco installation to start without an exception since I did not have SQLite installed.

     

  • Mark Mitchell 35 posts 60 karma points
    Feb 05, 2011 @ 18:05
    Mark Mitchell
    0

    Looks like the strike-out markup did not post properly.  In the above config settings, replace the line directly above each bold line with the bold version.

  • Mark Mitchell 35 posts 60 karma points
    Feb 05, 2011 @ 18:11
    Mark Mitchell
    1

    I also had a question. I noticed the installation instrucitons removed the typical httphandler elmah.axd in the system.web section, probably because Umbraco is using an asp.net custom control for the backoffice to view the logs.

    However, the instructions still left the elmah.axd handler config in the system.webserver section. Should the installation settings be updated to remove this as well for the web servers that use the system.webserver settings instead of the system.web settings?

  • Murray Roke 477 posts 886 karma points c-trib
    Feb 06, 2011 @ 20:59
    Murray Roke
    0

    Thanks for spotting that, it's probably best to leave the elmah.axd handler in, I'll update the notes.

    In that way if there are any issues with umbraco back office you can use the raw elmah pages. To access them securely you'll need to do so 'locally' because in production the allowRemoteAccess should be set to 'no'. However, you can still use umbraco admin to remotely access the logs.

  • Murray Roke 477 posts 886 karma points c-trib
    Feb 06, 2011 @ 21:12
    Murray Roke
    0

    SQLite does not need any installation, it only needs permission to write to the file specified in the connection string.

  • Lachlann 344 posts 626 karma points
    Feb 25, 2011 @ 18:13
    Lachlann
    0

    Hi I tried to follow the above instructions but i get this [email protected]

     

     

    Could not find stored procedure 'ELMAH_GetErrorsXml'.

    any ideas?

     

    L

  • Murray Roke 477 posts 886 karma points c-trib
    Feb 26, 2011 @ 10:32
    Murray Roke
    1

    Looks like your DB has not been set up (hence the missing stored procedure)

    documentation for setting up SQL server can be found here: http://code.google.com/p/elmah/wiki/DotNetSlackersArticle#Storing_errors_in_SQL_Server

    In particular you'll need to execute the script mentioned in the second paragraph.

    Cheers.

    Murray

     

  • Lachlann 344 posts 626 karma points
    Feb 28, 2011 @ 10:11
    Lachlann
    0

    great thanks Murray will give it a go

     

    L

  • Murray Roke 477 posts 886 karma points c-trib
    Jul 07, 2011 @ 08:48
    Murray Roke
    0

    Did that work for ya? if so mark the correct answer :-)

  • Lachlann 344 posts 626 karma points
    Jul 07, 2011 @ 10:20
    Lachlann
    0

    Hey Murray, thanks! yeah your solution worked for me but i didnt start the post so cant mark the answer. (plus oned you though :)

     

    L

Please Sign in or register to post replies

Write your reply to:

Draft