Umbraco MySqlSiteMapProvider Error When Trying To Save And Publish

I recently ran into a very strange issue upgrading an Umbraco 6 website. The server in question ran several websites, one of them being a WordPress blog and another one of them being an Umbraco site. In order to get WordPress to work in IIS, the MySql provider needs to be installed on the server.

After making some changes to the build to get Umbraco working with transforms, when any of the content editors tried doing a ‘Save and Publish’ within Umbraco they received a MySqlSiteMapProvide exceptions, as shown below:

umbraco_MySqlSiteMapProvider

Parser Error Message: Authentication to host '' for user '' using method 'mysql_native_password' failed with message: Access denied for user ''@'localhost' (using password: NO)
Source Error: 
Line 273:    <siteMap>
Line 274:      <providers>
Line 275:        <add name="MySqlSiteMapProvider" type="MySql.Web.SiteMap.MySqlSiteMapProvider, MySql.Web, Version=6.9.7.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="LocalMySqlServer" applicationName="/"/>
Line 276:      </providers>
Line 277:    </siteMap>
Source File:  C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config

The Umbraco website didn’t use the Umbraco WordPress connector but just having it installed on the server broke the site. Nothing on the server had supposedly been updated or changed since the site was known to be working, so the issue is still a mystery.

A quick fix to the issue is to tell Umbraco not to ignore the connector completely. This can be done by adding in a section under in your web.config.

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

Jon D Jones

Software Architect, Programmer and Technologist Jon Jones is founder and CEO of London-based tech firm Digital Prompt. He has been working in the field for nearly a decade, specializing in new technologies and technical solution research in the web business. A passionate blogger by heart , speaker & consultant from England.. always on the hunt for the next challenge

More Posts

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *