Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
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"/>
<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"/>
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.
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.
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?
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.
SQLite does not need any installation, it only needs permission to write to the file specified in the connection string.
Hi I tried to follow the above instructions but i get this [email protected]
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.
great thanks Murray will give it a go
Did that work for ya? if so mark the correct answer :-)
Hey Murray, thanks! yeah your solution worked for me but i didnt start the post so cant mark the answer. (plus oned you though :)
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted