Eddie Foreman 215 posts 288 karma points

Jun 11, 2010 @ 20:38

Install dev site to live server - config error

Hi All

Have been testing a site locally for a while and all is fine. Today, I've made an attempt to transfer the files to the live server. The process has been to upload the site files to the server and then recreate the database from a backup.

The files have been uploaded, but I'm getting a configuration error, which looks like it caused from the local and live sites using different .NET framework versions ? If this is the case is there an easy method to update the web config file? Which I think needs to be chnaged from 3.5 to 2.0.

Thanks in advance

Eddie

The error message is:

Server Error in '/' Application.

Configuration Error

Description: 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.

Parser Error Message: Could not load file or assembly 'System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. Access is denied.

Source Error:

Line 97:         <!-- ASPNETAJAX -->
Line 98:         <add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
Line 99:         <add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
Line 100:        <add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
Line 101:        <add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />

Source File: C:\inetpub\vhosts\csr-ltd.co.uk\httpdocs\web.config Line: 99

Assembly Load Trace: The following information can be helpful to determine why the assembly 'System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' could not be loaded.

=== Pre-bind state information ===
LOG: User = BUSINESS7-ASP\IWAM_plesk(default)
LOG: DisplayName = System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
 (Fully-specified)
LOG: Appbase = file:///C:/inetpub/vhosts/csr-ltd.co.uk/httpdocs/
LOG: Initial PrivatePath = C:\inetpub\vhosts\csr-ltd.co.uk\httpdocs\bin
Calling assembly : (Unknown).
===
LOG: This bind starts in default load context.
LOG: Using application configuration file: C:\inetpub\vhosts\csr-ltd.co.uk\httpdocs\web.config
LOG: Using host configuration file: C:\Windows\Microsoft.NET\Framework\v2.0.50727\Aspnet.config
LOG: Using machine configuration file from C:\Windows\Microsoft.NET\Framework\v2.0.50727\config\machine.config.
LOG: Post-policy reference: System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

Version Information: Microsoft .NET Framework Version:2.0.50727.4927; ASP.NET Version:2.0.50727.4927

Copy Link

Eddie Foreman 215 posts 288 karma points

Jun 14, 2010 @ 15:07

Hi All

A bit of an update, I think that the AJAX version on the live server is different to my local version. Which has the assembly:

System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

I feel that I may need to recomplie the site on the live server. Would somone be able to point me in the direction of a script or tool for doing this.

Thanks in advance

Eddie

Copy Link

Eddie Foreman 215 posts 288 karma points

Jun 15, 2010 @ 18:11

HI All

I've moved on a bit, and the above issue has been resolved. The hosting company needed to set the permissons and set to network services.

However, I'm a conncetion time out message. As it looks like Umbraco cannot connect to the database. The hosting company has also reproted that Umbraco is also looking for "d:\TeamCity..." ?. I've no idea where this is coming from?

The site URL is: http://80.82.118.144/

The latest from the hosting company 34sp is below.

Please let me know, if you've any thoughts.

Thanks Eddie

Hi Eddie

I have tried changed the string to :

<add key="umbracoDbDSN" value="server=business7.34sp.com\sqlexpress;database=xxx_umbraco;user id=xxx;password=xxx" />

Still the same - no errors just seems to time out. I also tried:

<add key="umbracoDbDSN" value="Data Source=80.82.118.144\SQLEXPRESS;Initial Catalog=xxx_umbraco;User ID=xxx;Password=xxx" />

Again same issue.

The log files just are not providing any information they are just saying error code 500 or similar when errors happen, not actually giving any output of any use to aid debugging.

The problem with the webadmin is that its requiring your domain name to be pointing at the server which it is not, you should however still be able to use something like that EMS mssql manager to connect using business7.34sp.com as the connection hostname to be able to populate the data or such.

Did you get rid of them paths that were looking for d:\.... in that error message i posted?

I am seeing myself approx a 15 second timeout between opening the page and it coming back with an error, from what i can make out this could possibly be a ADODB.Connection error as this is a 15 second as default timeout i believe.

Copy Link

Sebastiaan Janssen 5060 posts 15522 karma points MVP admin hq

Jun 15, 2010 @ 18:49

Eddie, the connection to your database is failing. You webhoster needs to check to see if they can access business7.34sp.com\sqlexpress from the machine that your website is on (and if they can't access it, they need to fix the problem).

The "d:\Teamcity" reference is normal, the code is trying to point you to the error in the original source file that was apparently somewhere on d:\Teamcity\etcetera. Not something you need to worry about!

Copy Link

Eddie Foreman 215 posts 288 karma points

Jun 15, 2010 @ 19:58

Hi Sebastiaan

Passed your advice to the hosting company, although I've noted had a reply. I can now view the default page, but any attemots on a subpages or umbraco login page results in:

Could not load file or assembly 'System.Web.Abstractions, 
Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or 
one of its dependencies. Access is denied.

Thanks

Eddie

Copy Link

Sebastiaan Janssen 5060 posts 15522 karma points MVP admin hq

Jun 15, 2010 @ 20:07

Hmmm, well either there is something wrong with the permissions (very well possible!) or your application pool is not configured to run .net 3.5 with integrated pipeline. So another mail to your hoster will probably be necessary. :-)

Copy Link

Eddie Foreman 215 posts 288 karma points

Jun 15, 2010 @ 21:45

Hi Sebastiaan

Thanks for your help, just getting an error now when I attempt to login to umbraco.

Validation of viewstate MAC failed. If this application is 
hosted by a Web Farm or cluster, ensure that <machineKey> 
configuration specifies the same validationKey and validation algorithm.
 AutoGenerate cannot be used in a cluster.

Would this be an issue with the hosting or can I disable viewstate for the login form?

Eddie

Copy Link

Eddie Foreman 215 posts 288 karma points

Jun 15, 2010 @ 21:59

Hi Sebastiaan

Not sure if this is progress, but I've added:

    <machineKey validationKey="93557AD76F04BB424879C78A99FA842B224AA1EE9CDE516305CD2C6EE1B9FBDB632D965F7553C0B76292252B38C8F59E3CD8534199585F8B4A2C9D268035F80D" decryptionKey="1B23AC6CCD8E827F430C0A82180333011814FCF8149706B7" validation="SHA1"/>

Using an online generator for the keys, and know get:

The connection name 'LocalSqlServer' was not found in the applications configuration or the connection string is empty.

Thanks

Eddie

Copy Link

Eddie Foreman 215 posts 288 karma points

Jun 15, 2010 @ 22:23

Copy of web.config

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <section name="urlrewritingnet" restartOnExternalChanges="true" requirePermission="false" type="UrlRewritingNet.Configuration.UrlRewriteSection, UrlRewritingNet.UrlRewriter" />

    <!-- ASPNETAJAX -->
    <sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
      <sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
        <section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication" />
        <sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
          <section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="Everywhere" />
          <section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication" />
          <section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication" />
          <section name="roleService" type="System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication" />
        </sectionGroup>
      </sectionGroup>
    </sectionGroup>

    <sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
      <section name="umbraco.presentation.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
    </sectionGroup>
  </configSections>

  <urlrewritingnet configSource="config\UrlRewriting.config" />

  <appSettings>
    <add key="umbracoDbDSN" value="server=business7.34sp.com;database=csrltd_umbraco;user id=csr;password=primrose" />
    <add key="xxumbracoDbDSN" value="Data Source=80.82.118.144\SQLEXPRESS;Initial Catalog=csrltd_umbraco;User ID=csr;Password=primrose" />
    <add key="umbracoConfigurationStatus" value="4.0.3" />
    <add key="umbracoReservedUrls" value="/config/splashes/booting.aspx,/install/default.aspx,/config/splashes/noNodes.aspx" />
    <add key="umbracoReservedPaths" value="/umbraco,/install/" />
    <add key="umbracoContentXML" value="/data/umbraco.config" />
    <add key="umbracoStorageDirectory" value="/data" />
    <add key="umbracoPath" value="/umbraco" />
    <add key="umbracoEnableStat" value="false" />
    <add key="umbracoHideTopLevelNodeFromPath" value="true" />
    <add key="umbracoEditXhtmlMode" value="true" />
    <add key="umbracoUseDirectoryUrls" value="false" />
    <add key="umbracoDebugMode" value="true" />
    <add key="umbracoTimeOutInMinutes" value="20" />
    <add key="umbracoVersionCheckPeriod" value="7" />
    <add key="umbracoDisableXsltExtensions" value="true" />
    <add key="umbracoDefaultUILanguage" value="en" />
    <add key="umbracoProfileUrl" value="profiler" />
    <add key="umbracoUseSSL" value="false" />
    <add key="umbracoUseMediumTrust" value="false" />
  </appSettings>

  <system.net>
    <mailSettings>
      <smtp>
        <network host="127.0.0.1" userName="username" password="password" />
      </smtp>
    </mailSettings>
  </system.net>

  <system.web>
    <customErrors mode="Off" />
    <trace enabled="true" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true" />
    <sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data source=127.0.0.1;Trusted_Connection=yes" cookieless="false" timeout="20" />
    <globalization requestEncoding="UTF-8" responseEncoding="UTF-8" />
    <xhtmlConformance mode="Strict" />
    <machineKey validationKey="93557AD76F04BB424879C78A99FA842B224AA1EE9CDE516305CD2C6EE1B9FBDB632D965F7553C0B76292252B38C8F59E3CD8534199585F8B4A2C9D268035F80D" decryptionKey="1B23AC6CCD8E827F430C0A82180333011814FCF8149706B7" validation="SHA1"/>
    <pages enableEventValidation="false">
      <!-- ASPNETAJAX -->
      <controls>
        <add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
        <add tagPrefix="asp" namespace="System.Web.UI.WebControls" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
        <add tagPrefix="umbraco" namespace="umbraco.presentation.templateControls" assembly="umbraco" />
      </controls>
    </pages>

    <httpModules>
      <!-- URL REWRTIER -->
      <add name="UrlRewriteModule" type="UrlRewritingNet.Web.UrlRewriteModule, UrlRewritingNet.UrlRewriter" />
      <add name="umbracoRequestModule" type="umbraco.presentation.requestModule" />
      <!-- UMBRACO -->
      <add name="viewstateMoverModule" type="umbraco.presentation.viewstateMoverModule" />
      <add name="umbracoBaseRequestModule" type="umbraco.presentation.umbracobase.requestModule" />
      <!-- ASPNETAJAX -->
      <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
    </httpModules>

    <httpHandlers>
      <remove verb="*" path="*.asmx" />
      <add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
      <add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
      <add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false" />

      <!-- UMBRACO CHANNELS -->
      <add verb="*" path="umbraco/channels.aspx" type="umbraco.presentation.channels.api, umbraco" />
      <add verb="*" path="umbraco/channels/word.aspx" type="umbraco.presentation.channels.wordApi, umbraco" />
    </httpHandlers>

    <compilation batch="false" debug="true" defaultLanguage="c#">
      <assemblies>
        <!-- ASPNETAJAX -->
        <add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
        <add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
        <add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
        <add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
      </assemblies>
    </compilation>

    <authentication mode="Forms">
      <forms name="yourAuthCookie" loginUrl="login.aspx" protection="All" path="/" />
    </authentication>

    <authorization>
      <allow users="?" />
    </authorization>

    <!-- Membership Provider -->
    <membership defaultProvider="UmbracoMembershipProvider" userIsOnlineTimeWindow="15">
      <providers>
        <clear />
        <add name="UmbracoMembershipProvider" type="umbraco.providers.members.UmbracoMembershipProvider" enablePasswordRetrieval="false" enablePasswordReset="false" requiresQuestionAndAnswer="false" defaultMemberTypeAlias="TestType" />
        <add name="AspNetSqlMemberShipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="LocalSqlServer" />
        <add name="UsersMembershipProvider" type="umbraco.providers.UsersMembershipProvider" enablePasswordRetrieval="false" enablePasswordReset="false" requiresQuestionAndAnswer="false" />
      </providers>
    </membership>

    <!-- added to support membership providers in access layer -->
    <roleManager enabled="true" defaultProvider="UmbracoRoleProvider">
      <providers>
        <clear />
        <add name="UmbracoRoleProvider" type="umbraco.providers.members.UmbracoRoleProvider" applicationName="umbraco" />
      </providers>
    </roleManager>

    <!-- Sitemap provider-->
    <siteMap defaultProvider="UmbracoSiteMapProvider" enabled="true">
      <providers>
        <clear />
        <add name="UmbracoSiteMapProvider" type="umbraco.presentation.nodeFactory.UmbracoSiteMapProvider" defaultDescriptionAlias="description" securityTrimmingEnabled="true" />
      </providers>
    </siteMap>
  </system.web>

  <!-- ASPNET3.5 CODEDOM-->
  <system.codedom>
    <compilers>
      <compiler language="c#;cs;csharp" extension=".cs" warningLevel="4" type="Microsoft.CSharp.CSharpCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
        <providerOption name="CompilerVersion" value="v3.5" />
        <providerOption name="WarnAsError" value="false" />
      </compiler>
    </compilers>
  </system.codedom>


  <!-- ASPNETAJAX -->
  <system.web.extensions>
    <scripting>
      <scriptResourceHandler enableCompression="true" enableCaching="true" />
    </scripting>
  </system.web.extensions>


  <!-- IIS 7 Integrated Mode Configuration -->
  <system.webServer>
    <validation validateIntegratedModeConfiguration="false" />
    <modules>
      <!-- Asp.net 3.5 Modules-->
      <remove name="ScriptModule" />
      <add name="ScriptModule" preCondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />

      <!-- UMBRACO modules-->
      <add name="UrlRewriteModule" type="UrlRewritingNet.Web.UrlRewriteModule, UrlRewritingNet.UrlRewriter" />
      <add name="umbracoRequestModule" type="umbraco.presentation.requestModule" />
      <add name="viewstateMoverModule" type="umbraco.presentation.viewstateMoverModule" />
      <add name="umbracoBaseRequestModule" type="umbraco.presentation.umbracobase.requestModule" />

      <remove name="ScriptModule" />
      <add name="ScriptModule" preCondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
    </modules>
    <handlers accessPolicy="Read, Write, Script, Execute">
      <remove name="WebServiceHandlerFactory-Integrated" />
      <remove name="ScriptHandlerFactory" />
      <remove name="ScriptHandlerFactoryAppServices" />
      <remove name="ScriptResource" />
      <add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
      <add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
      <add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />

      <remove name="Channels" />
      <remove name="Channels_Word" />
      <add verb="*" name="Channels" preCondition="integratedMode" path="umbraco/channels.aspx" type="umbraco.presentation.channels.api, umbraco" />
      <add verb="*" name="Channels_Word" preCondition="integratedMode" path="umbraco/channels/word.aspx" type="umbraco.presentation.channels.wordApi, umbraco" />
    </handlers>
  </system.webServer>

  <!-- Ajax 1.0 Compatibility -->
  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35" />
        <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.Web.Extensions.Design" publicKeyToken="31bf3856ad364e35" />
        <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0" />
      </dependentAssembly>
    </assemblyBinding>
  </runtime>
</configuration>

Copy Link

Eddie Foreman 215 posts 288 karma points

Jun 16, 2010 @ 10:23

Hi Sebastiaan

Can now login, by adding:

<connectionStrings>
  <remove name="LocalSqlServer" />
  <add name="LocalSqlServer" connectionString="Data Source=business7.34sp.com;Integrated
 Security=false;Initial Catalog=xxx_xxx;User 
ID=xxx;Password=xxx" providerName="System.Data.SqlClient" />
</connectionStrings>

When I view the live site all appears to be correct, but when I login all i see is the content folder ,any thoughts?

Thanks

Eddie

Copy Link

Sebastiaan Janssen 5060 posts 15522 karma points MVP admin hq

Jun 16, 2010 @ 10:29

Sounds like a javascript issue, could you check in a different browser? Do you see javascript errors? Can you access the other section (settings, developer, media...) and are they filled?

Copy Link

Eddie Foreman 215 posts 288 karma points

Jun 16, 2010 @ 10:56

Hi Sebastiaan

Happens across all sections, and in different broswers. No javascript erros are shown in the error console?

Using the search feature I can edit and publish the different pages, so the content appears have been copied over correclty. If I attempt to update an image using the media picker, the message undefined error is displayed under the media node. Could this be a permission issue?

Thanks

Eddie

Copy Link

Eddie Foreman 215 posts 288 karma points

Jun 16, 2010 @ 11:00

Hi Sebastiaan

Just noticed that when using the media picker and I click on the media node I get the message, parent.openDashboard is not a function.

Thanks

Eddie

Copy Link

Eddie Foreman 215 posts 288 karma points

Jun 16, 2010 @ 11:03

Under IE, the error details are:

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0)

Timestamp: Wed, 16 Jun 2010 09:02:36 UTC

Message: Object doesn't support this property or method

Line: 1

Char: 1

Code: 0

URI: http://80.82.118.144/umbraco/treeinit.aspx?rnd=ead528e2-ccf5-4b0e-8e46-26aef578c41f&id=-1&treeType=media&contextMenu=false&isDialog=true&dialogMode=id&app=media

Copy Link

is working on a reply...

Flag this post as spam?

Install dev site to live server - config error

Server Error in '/' Application.

Configuration Error