Chapter 7: Configuration Error

zinedu5 · September 14th, 2016, 08:20 PM

Hi everyone,
i'm studying beginning ASP.NET 4.5.1 in C# and VB. In chapter 7 page 250 step 10. after adding a menu and populating it with the sitemap, on viewing it on all browsers i've on my computer it displayed a configuration error. i carefully followed all the steps from 1 to 10 but its still not displaying the menu. below is what the error message says. what's do you think is wrong?

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: Host 'xxxxx' is not allowed to connect to this MySQL server

Source Error:

HTML Code:

Line 283:    <siteMap>
Line 284:      <providers>
Line 285:        <add name="MySqlSiteMapProvider" type="MySql.Web.SiteMap.MySqlSiteMapProvider, MySql.Web, Version=6.9.8.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="LocalMySqlServer" applicationName="/" />
Line 286:      </providers>
Line 287:    </siteMap>

Source File: C:\Windows\Microsoft.NET\Framework\v4.0.30319\Conf ig\machine.config Line: 285

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.6.1586.0

zinedu5 · September 16th, 2016, 03:53 PM

I resolved the issue by putting this code in the web.config file.
I believe this may help others having the same problem

HTML Code:

<system.web>
 ...
  <siteMap>
    <providers>   
        <remove name="MySqlSiteMapProvider" />
    </providers>
  </siteMap>
</system.web>

Imar · September 17th, 2016, 05:38 PM

yeah, it looks like this (broken) provider gets registered when you install a .NET connector for MySQL. Not sure which one though.

Cheers,

Imar

hansheung · November 9th, 2016, 09:36 AM

Can further explain how this work?
<siteMap>
<providers>
<remove name="MySqlSiteMapProvider" />
</providers>
</siteMap>

Imar · November 13th, 2016, 08:51 PM

When you install the NET connector for MySQL it registers a sitemap in the global machine.config. For some reason, that one is broken. By using the remove element you effectively remove the sitemap from the current application. You could also remove it from machine.config so it's gone for all applications.

Hope this helps,

Imar

VermeerC · March 10th, 2017, 06:43 AM

Thanks zinedu5, this solution worked for me as well!