Corporate Sample Site Error During Site Initialization
Hi All,
I am getting the below error when trying to set up the sample corporate site on my development machine. One of the things about it that really confuses me is that I am setting this up with MS Sql Server 2012, and NOT MySQL (of any sort). The status page shows two of these (different GUIDS) and stops. The wheel keeps spinning, but it goes no further into the setup. Any help would be really appreciated.
---------------------
HandlingInstanceID: 7230fd8b-0205-4b57-b20f-7554d3ea5d9b An exception of type 'System.Configuration.ConfigurationErrorsException' occurred and was caught. ------------------------------------------------------------------------------------------------- 11/06/2015 08:03:57 Type : System.Configuration.ConfigurationErrorsException, System.Configuration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a Message : Host 'DevMachine.DevDomain.net' is not allowed to connect to this MySQL server (C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config line 285) Source : System.Web Help link : BareMessage : Host 'DevMachine.DevDomain.net' is not allowed to connect to this MySQL server Filename : C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config Line : 285 Errors : System.Configuration.ConfigurationException[] Data : System.Collections.ListDictionaryInternal TargetSite : System.Configuration.Provider.ProviderBase InstantiateProvider(System.Configuration.ProviderSettings, System.Type) HResult : -2146232062 Stack Trace : at System.Web.Configuration.ProvidersHelper.InstantiateProvider(ProviderSettings providerSettings, Type providerType) at System.Web.Configuration.ProvidersHelper.InstantiateProviders(ProviderSettingsCollection configProviders, ProviderCollection providers, Type providerType) at System.Web.Configuration.SiteMapSection.get_ProvidersInternal() at System.Web.SiteMap.Initialize() at System.Web.SiteMap.get_Providers() at Telerik.Sitefinity.Web.SiteMapBase.GetSiteMapProvider[T](String rootName) at Telerik.Sitefinity.Web.BackendSiteMap.GetCurrentProvider() at Telerik.Sitefinity.Web.BackendSiteMap.FindSiteMapNode(Guid id, Boolean ifAccessible) at Telerik.Sitefinity.Web.RouteHelper.<ResolveUrl>b__0(String type, String value, String options) at Telerik.Sitefinity.Web.RouteHelper.<>c__DisplayClass9.<ReferenceMatchEvaluator>b__8(Match m) at System.Text.RegularExpressions.RegexReplacement.Replace(MatchEvaluator evaluator, Regex regex, String input, Int32 count, Int32 startat) at System.Text.RegularExpressions.Regex.Replace(String input, MatchEvaluator evaluator, Int32 count, Int32 startat) at System.Text.RegularExpressions.Regex.Replace(String input, MatchEvaluator evaluator) at Telerik.Sitefinity.Web.RouteHelper.ResolveUrl(String url, UrlResolveOptions urlOptions) at Telerik.Sitefinity.Modules.DefinitionsHelper.CreateRecycleBinLink(ConfigElementList`1 configElementList, String contentTypeName) at Telerik.Sitefinity.Modules.Libraries.Documents.DocumentsDefinitions.DefineBackendListView(ConfigElement parent, String controlDefinitionName, String viewName, ContentViewControlDefinitionFacade fluentContentView) at Telerik.Sitefinity.Modules.Libraries.Documents.DocumentsDefinitions.<>c__DisplayClass12.<DefineBackendContentView>b__b() at System.Lazy`1.CreateValue() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Lazy`1.get_Value() at Telerik.Sitefinity.Configuration.ConfigElementLazyItem`1.get_Element() at Telerik.Sitefinity.Configuration.ConfigElementDictionary`2.TryGetValueInternal(TKey key, TElement& element) at Telerik.Sitefinity.Configuration.ConfigElementDictionary`2.GetElementByKey(String key) at Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.LoadCollectionElement(ConfigElementCollection collection, XmlReader reader, ConfigPolicyHandler policyHandler, String policyName, UpgradingInfo upgradingInfo) at Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.LoadElement(ConfigElement element, XmlReader reader, ConfigPolicyHandler policyHandler, String policyName, UpgradingInfo upgradingInfo, Boolean isNew, Boolean validateTagName) at Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.LoadPropertyElement(ConfigElement element, XmlReader reader, ConfigPolicyHandler policyHandler, String policyName, UpgradingInfo upgradingInfo) at Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.LoadElement(ConfigElement element, XmlReader reader, ConfigPolicyHandler policyHandler, String policyName, UpgradingInfo upgradingInfo, Boolean isNew, Boolean validateTagName) at Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.LoadCollectionElement(ConfigElementCollection collection, XmlReader reader, ConfigPolicyHandler policyHandler, String policyName, UpgradingInfo upgradingInfo) at Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.LoadElement(ConfigElement element, XmlReader reader, ConfigPolicyHandler policyHandler, String policyName, UpgradingInfo upgradingInfo, Boolean isNew, Boolean validateTagName) at Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.LoadPropertyElement(ConfigElement element, XmlReader reader, ConfigPolicyHandler policyHandler, String policyName, UpgradingInfo upgradingInfo) at Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.LoadElement(ConfigElement element, XmlReader reader, ConfigPolicyHandler policyHandler, String policyName, UpgradingInfo upgradingInfo, Boolean isNew, Boolean validateTagName) at Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.LoadSectionFromReader(ConfigSection section, XmlReader reader, ConfigPolicyHandler policyHandler, String policyName, Boolean checkForUpgrade, UpgradingInfo& upgradingInfo) at Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.LoadSectionFromFile(ConfigSection section, ConfigPolicyHandler policyHandler, String policyName, Boolean withUpgrade) at Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.LoadSection(ConfigSection section, ConfigPolicyHandler policyHandler, String policyName) at Telerik.Sitefinity.Configuration.ConfigSection.Initialize(ConfigProvider provider, ConfigPolicyHandler policyHandler, String policyName, Boolean singlePolicy) at Telerik.Sitefinity.Configuration.ConfigSection.Initialize(ConfigProvider provider) at Telerik.Sitefinity.Configuration.Config.GetSectionInternal(Type sectionType, Boolean safeMode, String sectionName) at Telerik.Sitefinity.Configuration.Config.GetSectionPrivate(Type sectionType, Boolean safeMode, String sectionName) at Telerik.Sitefinity.Configuration.Config.GetSectionPrivate[TSection](Boolean safeMode) at Telerik.Sitefinity.Modules.Libraries.BlobStorage.BlobStorageManager.get_ProvidersSettings() at Telerik.Sitefinity.Data.ManagerBase`1.GetProvidersSettings() at Telerik.Sitefinity.Data.ManagerBase`1.Initialize() Additional Info: MachineName : DevMachine TimeStamp : 11/6/2015 2:03:57 PM FullName : Telerik.Sitefinity.Utilities, Version=8.2.5900.0, Culture=neutral, PublicKeyToken=b28c218413bdf563 AppDomainName : /LM/W3SVC/1/ROOT/SitefinityWebApp-1-130912922056787286 ThreadIdentity : WindowsIdentity : NT AUTHORITY\LOCAL SERVICE Requested URL : http://127.0.0.1/SitefinityWebApp/ Inner Exception --------------- Type : MySql.Data.MySqlClient.MySqlException, MySql.Data, Version=6.9.7.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d Message : Host 'DevMachine.DevDomain.net' is not allowed to connect to this MySQL server Source : MySql.Data Help link : Number : 1130 ErrorCode : -2147467259 Data : System.Collections.ListDictionaryInternal TargetSite : MySql.Data.MySqlClient.MySqlPacket ReadPacket() HResult : -2147467259 Stack Trace : at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() at MySql.Data.MySqlClient.MySqlPool.GetConnection() at MySql.Data.MySqlClient.MySqlConnection.Open() at MySql.Web.Common.SchemaManager.GetSchemaVersion(String connectionString) at MySql.Web.Common.SchemaManager.CheckSchema(String connectionString, NameValueCollection config) at MySql.Web.SiteMap.MySqlSiteMapProvider.Initialize(String name, NameValueCollection config) at System.Web.Configuration.ProvidersHelper.InstantiateProvider(ProviderSettings providerSettings, Type providerType)
Hi Brian,
For posterity's sake putting a note in this ticket about your fix:
While I do not have MySQL installed on my current dev box, I have used it before, so I installed the Visual Studio extensions for working with it. That apparently made some changes to my machine.config file and added some references to MySQL providers in addition to the SQL Server entries. I opened up the machine.config file and commented out those references. That did not fix the install we were working on, but it did get it much further in the pocess. So I set up a new installation (love the Project Manager tool btw). That succeeded. I am now looking at the backend dashboard.