Devart Forums

Discussion forums for open issues and questions concerning database tools, data access components and developer tools from Devart
https://forums.devart.com/

Can't Install or Deploy MVC4.5 Application to server with dotConnect for SQLite

https://forums.devart.com/viewtopic.php?f=29&t=26960

Page 1 of 1

Can't Install or Deploy MVC4.5 Application to server with dotConnect for SQLite

Posted: Wed 24 Apr 2013 15:30
by acooper
We are building an application that will be installed on a local server. We are using the wix installer to build the install package. The local server does not have access to the internet.
I have built the application and deployed it to the local server (not installed through wix, it was a webdeploy). I was able to get it to run only after I used the Devart install executable which loaded the entire Devart assemblies into the GAC . If I uninstall Devart from the server the application crashes.
I reference the following Devart Assemblies in my MVC4.5 web project
Devart.Data V5.0.661.0
Devart.Data.SQLite V4.5.202.0
Devart.Data.SQLite.Web V4.5.202.4
These assemblies get deployed and end up in the BIN along with the App_ License.dll. If I use your install executable and install Devart on the server everything runs fine. If I Uninstall Devart and just do an install or deploy then I get this error:
<!DOCTYPE html>
<html>
<head>
<title>Configuration Error</title>
<meta name="viewport" content="width=device-width" />
<style>
body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}
p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
pre {font-family:"Consolas","Lucida Console",Monospace;font-size:11pt;margin:0;padding:0.5em;line-height:14pt}
.marker {font-weight: bold; color: black;text-decoration: none;}
.version {color: gray;}
.error {margin-bottom: 10px;}
.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }
@media screen and (max-width: 639px) {
pre { width: 440px; overflow: auto; white-space: pre-wrap; word-wrap: break-word; }
}
@media screen and (max-width: 479px) {
pre { width: 280px; }
}
</style>
</head>
<body bgcolor="white">
<span><H1>Server Error in '/DevartTest' Application.<hr width=100% size=1 color=silver></H1>
<h2> <i>Configuration Error</i> </h2></span>
<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">
<b> Description: </b>An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
<br><br>
<b> Parser Error Message: </b>Default Role Provider could not be found.<br><br>
<b>Source Error:</b> <br><br>
<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>
Line 29: <system.web>
Line 30: <membership defaultProvider="SQLiteExtendedMembershipProvider" />
<font color=red>Line 31: <roleManager enabled="true" defaultProvider="SQLiteExtendedRoleProvider" />
</font>Line 32: <compilation targetFramework="4.5">
Line 33: <assemblies></pre></code>
</td>
</tr>
</table>
<br>
<b> Source File: </b> C:\inetpub\wwwroot\cra_site\DevartTest\web.config<b> &nbsp;&nbsp; Line: </b> 31
<br><br>
<hr width=100% size=1 color=silver>
<b>Version Information:</b>&nbsp;Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.17929
</font>
</body>
</html>
<!--
[ConfigurationErrorsException]: Default Role Provider could not be found. (C:\inetpub\wwwroot\cra_site\DevartTest\web.config line 31)
at System.Web.Security.Roles.Initialize()
at System.Web.Security.RoleManagerModule.OnEnter(Object source, EventArgs eventArgs)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
-->

I cannot install Devart on all the Servers that I will deploying /installing our application on I need to know what DLL go in the local Bin and if there are any other configurations I need to make on the server?
I tried looking at the output window in Visual studios to see what was being loaded when I run in debug mode on my local machine. Apparently every Devart DLL is being loaded from the GAC… not much help!


***** Output window from Visual studios when I run locally *****
C:\Users\Andy\AppData\Local\Temp\Temporary ASP.NET Files\root\b615151e\9e069a05\assembly\dl3\603eb9c8\dfc772b3_7426ce01\App_Licenses.dll'
C:\Users\Andy\AppData\Local\Temp\Temporary ASP.NET Files\root\b615151e\9e069a05\assembly\dl3\2fd4994e\8e532b40_ec2ace01\System.Web.Http.WebHost.dll'
C:\Users\Andy\AppData\Local\Temp\Temporary ASP.NET Files\root\b615151e\9e069a05\assembly\dl3\129d7a15\825cbd40_ec2ace01\System.Web.Optimization.dll'
C:\Users\Andy\AppData\Local\Temp\Temporary ASP.NET Files\root\b615151e\9e069a05\assembly\dl3\8e266e63\a51f4b41_ec2ace01\Microsoft.Web.WebPages.OAuth.dll'
C:\windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.VisualStudio.Web.PageInspector.Loader\v4.0_1.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.Web.PageInspector.Loader.dll'
C:\windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.VisualStudio.Web.PageInspector.Runtime\v4.0_1.2.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.Web.PageInspector.Runtime.dll'
C:\Users\Andy\AppData\Local\Temp\Temporary ASP.NET Files\root\b615151e\9e069a05\assembly\dl3\e0821486\a0713442_ec2ace01\DotNetOpenAuth.Core.dll'
iisexpress.exe Information: 0 : DotNetOpenAuth.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=2780ccd10d57b246 (official)
iisexpress.exe Information: 0 : Reporting will use isolated storage with scope: User, Domain, Assembly
C:\windows\assembly\GAC_MSIL\Devart.Data.SQLite.Web\4.5.202.0__09af7300eec23701\Devart.Data.SQLite.Web.dll'
C:\windows\assembly\GAC_MSIL\Devart.Data.SQLite\4.5.202.0__09af7300eec23701\Devart.Data.SQLite.dll'
C:\windows\Microsoft.Net\assembly\GAC_MSIL\Devart.Data.SQLite.Web\v4.0_4.5.202.4__09af7300eec23701\Devart.Data.SQLite.Web.dll'
C:\Users\Andy\AppData\Local\Temp\Temporary ASP.NET Files\root\b615151e\9e069a05\App_global.asax.pgfht3ex.dll', Symbols loaded.
C:\Users\Andy\AppData\Local\Temp\Temporary ASP.NET Files\root\b615151e\9e069a05\assembly\dl3\58bd6a78\f3e3e422_4840ce01\DevartTest.dll', Symbols loaded.
C:\windows\Microsoft.Net\assembly\GAC_MSIL\System.Web.Extensions\v4.0_4.0.0.0__31bf3856ad364e35\System.Web.Extensions.dll'
C:\Users\Andy\AppData\Local\Temp\Temporary ASP.NET Files\root\b615151e\9e069a05\assembly\dl3\2f876e75\68191176_6a3bce01\Elmah.dll'
C:\Users\Andy\AppData\Local\Temp\Temporary ASP.NET Files\root\b615151e\9e069a05\assembly\dl3\0166cbb9\e5c3c63f_ec2ace01\System.Web.Http.dll'
C:\Users\Andy\AppData\Local\Temp\Temporary ASP.NET Files\root\b615151e\9e069a05\assembly\dl3\1b176664\e7c4423f_ec2ace01\System.Net.Http.Formatting.dll'
C:\Users\Andy\AppData\Local\Temp\Temporary ASP.NET Files\root\b615151e\9e069a05\assembly\dl3\9952f5d2\03cce33d_ec2ace01\Newtonsoft.Json.dll'
C:\windows\Microsoft.Net\assembly\GAC_MSIL\System.Web.DynamicData\v4.0_4.0.0.0__31bf3856ad364e35\System.Web.DynamicData.dll'
C:\Users\Andy\AppData\Local\Temp\Temporary ASP.NET Files\root\b615151e\9e069a05\assembly\dl3\6888aed3\c53ca943_ec2ace01\Antlr3.Runtime.dll'
C:\windows\assembly\GAC_MSIL\Devart.Data\5.0.661.0__09af7300eec23701\Devart.Data.dll'
C:\Users\Andy\AppData\Local\Temp\Temporary ASP.NET Files\root\b615151e\9e069a05\assembly\dl3\ba97fbe6\d344f541_ec2ace01\DotNetOpenAuth.AspNet.dll'
C:\Users\Andy\AppData\Local\Temp\Temporary ASP.NET Files\root\b615151e\9e069a05\assembly\dl3\23b22795\cc488042_ec2ace01\DotNetOpenAuth.OAuth.Consumer.dll'
C:\Users\Andy\AppData\Local\Temp\Temporary ASP.NET Files\root\b615151e\9e069a05\assembly\dl3\6f9d8b0a\bff4cd42_ec2ace01\DotNetOpenAuth.OAuth.dll'
C:\Users\Andy\AppData\Local\Temp\Temporary ASP.NET Files\root\b615151e\9e069a05\assembly\dl3\361e8408\6d8e1143_ec2ace01\DotNetOpenAuth.OpenId.dll'
C:\Users\Andy\AppData\Local\Temp\Temporary ASP.NET Files\root\b615151e\9e069a05\assembly\dl3\0e8f1be7\25545c43_ec2ace01\DotNetOpenAuth.OpenId.RelyingParty.dll'
C:\Users\Andy\AppData\Local\Temp\Temporary ASP.NET Files\root\b615151e\9e069a05\assembly\dl3\04050234\6a592d36_ec2ace01\EntityFramework.dll'
C:\Users\Andy\AppData\Local\Temp\Temporary ASP.NET Files\root\b615151e\9e069a05\assembly\dl3\ef7dd614\1576a14a_6d3bce01\System.Data.SQLite.dll'
C:\Users\Andy\AppData\Local\Temp\Temporary ASP.NET Files\root\b615151e\9e069a05\assembly\dl3\48430825\36c4a14a_6d3bce01\System.Data.SQLite.Linq.dll'
C:\windows\Microsoft.Net\assembly\GAC_MSIL\System.Dynamic\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Dynamic.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
C:\windows\Microsoft.Net\assembly\GAC_MSIL\System.Data.Services.Design\v4.0_4.0.0.0__b77a5c561934e089\System.Data.Services.Design.dll'
C:\Users\Andy\AppData\Local\Temp\Temporary ASP.NET Files\root\b615151e\9e069a05\App_Web_p5urz3kd.dll', Symbols loaded.
C:\Users\Andy\AppData\Local\Temp\Temporary ASP.NET Files\root\b615151e\9e069a05\App_Web_ts5qbqvo.dll', Symbols loaded.
C:\Users\Andy\AppData\Local\Temp\Temporary ASP.NET Files\root\b615151e\9e069a05\App_Web_domeinb3.dll', Symbols loaded.
C:\windows\Microsoft.Net\assembly\GAC_MSIL\Devart.Data.SQLite.Entity\v4.0_4.5.202.0__09af7300eec23701\Devart.Data.SQLite.Entity.dll'
C:\Users\Andy\AppData\Local\Temp\Temporary ASP.NET Files\root\b615151e\9e069a05\App_Web_0zdeddlg.dll

Re: Can't Install or Deploy MVC4.5 Application to server with dotConnect for SQLite

Posted: Wed 24 Apr 2013 15:32
by acooper
Just downloaded the newest ver 4.6.226.4... still NOT WORKING

Re: Can't Install or Deploy MVC4.5 Application to server with dotConnect for SQLite

Posted: Fri 26 Apr 2013 15:08
by Pinturiccio
It is likely that the issue is caused by the fact that you don't add provider descriptions to the web.config file of your application. When you install dotConnect for SQLite, ASP.NET provider descriptions are written to the machine.config file.

For example, after installing dotConnect for SQLite, you can find records about SQLiteExtendedMembershipProvider and SQLiteExtendedRoleProvider in the machine.config file located in the folder %windir%\Microsoft.NET\Framework\v4.0.30319\Config\
If an application finds these records, it works. When a provider is deleted, these records are deleted from the machine.config file too.

To avoid the exception, you can add these records manually to the global machine.config file or to the web.config file of your application. Below is an example of how to replace records in your web.config file:

Instead of this:

Code: Select all

<membership defaultProvider="SQLiteExtendedMembershipProvider" />
Use the following:

Code: Select all

<membership defaultProvider="SQLiteExtendedMembershipProvider">
      <providers>
        <remove name="SQLiteExtendedMembershipProvider" />
        <add name="SQLiteExtendedMembershipProvider" type="Devart.Data.SQLite.Web.Providers.SQLiteExtendedMembershipProvider, Devart.Data.SQLite.Web, Version=4.5.202.4, Culture=neutral, PublicKeyToken=09af7300eec23701"
          description="dotConnect for SQLite extended membership provider"
          connectionStringName="SQLiteServices" useridcolumn="UserId"
          usernamecolumn="UserName" usertablename="UserProfile" />
      </providers>
</membership>
Instead of this:

Code: Select all

<roleManager enabled="true" defaultProvider="SQLiteExtendedRoleProvider" />
Use the following:

Code: Select all

<roleManager enabled="true" defaultProvider="SQLiteExtendedRoleProvider" >
  <providers>
    <remove name="SQLiteExtendedRoleProvider" />
    <add name="SQLiteExtendedRoleProvider" type="Devart.Data.SQLite.Web.Providers.SQLiteExtendedRoleProvider, Devart.Data.SQLite.Web, Version=4.5.202.4, Culture=neutral, PublicKeyToken=09af7300eec23701"
     description="dotConnect for SQLite extended role provider"
     connectionStringName="SQLiteServices"
     useridcolumn="UserId" usernamecolumn="UserName" usertablename="UserProfile" />
  </providers>
</roleManager>

Re: Can't Install or Deploy MVC4.5 Application to server with dotConnect for SQLite

Posted: Fri 26 Apr 2013 15:51
by acooper
I tried what you posted It did not work! Same results as before.

Re: Can't Install or Deploy MVC4.5 Application to server with dotConnect for SQLite

Posted: Sat 27 Apr 2013 08:38
by Shalex
If you added the posted entries to the web.config file of your application but the "Default Role Provider could not be found" error persists, please send us a small test project so that we can reproduce the issue in our environment.
All times are UTC
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/