Membership Tables Invalid Using Local Service

Question

I have:

• MVC 3
• MySQL using .NET Connector 6.4.4

Everything is fine if I connect from a local PC with VS2010 to a remote database on Linux. I made a backup for the local database and installed the same version of MySQL (5.5, x64)

On the remote computer, I have the usual .net names of auto- my_aspnet_membership tables for membership, for example my_aspnet_membership , but when I start the application locally, it creates other table names, for example mysql_membership . I also got an exception: Unable to initialize provider. Missing or incorrect schema. Unable to initialize provider. Missing or incorrect schema.

With the same settings, but when connected to Remote DB everything works fine.

 <add name="MySqlSessionStateProvider" type="MySql.Web.SessionState.MySqlSessionStateStore, MySql.Web, Version=6.4.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" applicationName="/" autogenerateschema="true" connectionStringName="MySqlMembershipConnection" /> 

Does anyone know where the problem is?

Answer 1

I think the problem is in the configuration. See the following posts:

• Unable to initialize provider. Missing or incorrect schema.
• http://forums.asp.net/t/1557879.aspx/1
• Unable to initialize provider. Missing or incorrect circuit. to connect MySql.Web
• Unable to initialize provider. Missing or incorrect circuit
• Unable to initialize provider. Missing or incorrect schema in MYSQL
• Error hosting MySQL MVC2?