machine.config

cdlciddit
cdlciddit used Ask the Experts™
on
Hello. I am getting an error saying Host 'CIDDWEB.ad.unc.edu' is not allowed to connect to this MySQL server.   Then I get this source error: <siteMap>
Line 176:      <providers>
Line 177:        <add name="MySqlSiteMapProvider" type="MySql.Web.SiteMap.MySqlSiteMapProvider, MySql.Web, Version=6.9.7.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="LocalMySqlServer" applicationName="/" />
Line 178:      </providers>
Line 179:    </siteMap>
 
 and it says it is coming from machine.config.  I have never done anything with this file.  I did recently install WordPress using the Web Platform installer.  I assume this made some entries in that file for MySQL.  Other than that I have not done anything with MySQL and that site doesn't access MySQL it should be accessing a Microsoft T SQL server.   I don't have much experience at all with this and I have never done anything with machine.config.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
I found the answer to my own question.  It is on stackoverflow.com
http://stackoverflow.com/questions/30865505/error-in-mysql-host-after-adding-master-page-in-asp-net-c-sharp


MySql installed a default siteMap provider in the machine config:

<siteMap>
  <providers>
    <add name="MySqlSiteMapProvider" type="MySql.Web.SiteMap.MySqlSiteMapProvider, MySql.Web, Version=6.9.5.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="LocalMySqlServer" applicationName="/" />
  </providers>
</siteMap>  


Added following to web.config under the system.web section to exclude it

<siteMap>
<providers> <remove name="MySqlSiteMapProvider" />  </providers>
</siteMap>

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial