Last post Dec 17, 2013 02:57 PM by bbcompent1
Dec 16, 2013 11:17 AM|beep1986|LINK
Hey guys, am trying to follow this tutorial http://dev.mysql.com/doc/refman/5.7/en/connector-net-tutorials-asp-roles.html/
Thing is im always running into the same problem. When i change the membership provider to MySQLMembershipProvider i get this error when i click on security.
There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected
to a page where you can choose a new data store.
The following message may help in diagnosing the problem: The source was not found, but some or all event logs could not be searched. To create
the source, you need permission to read all event logs to make sure that the new source name is unique. Inaccessible logs: Security.
code for web.config connection
<add name="MySqlMembershipProvider" connectionString="server=000.000.000.000;User Id=benoatsc_admin;database=*****;password=****;Persist Security Info=True"
code for machine.config
<add name="AspNetSqlProfileProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Profile.SqlProfileProvider, System.Web, Version=188.8.131.52, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add name="MySQLProfileProvider" type="MySql.Web.Profile.MySQLProfileProvider, MySql.Web, Version=184.108.40.206, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="Greenfilm" applicationName="/" />
I have been at this now for 4 days redoing the same tutorial from over and over, still comes back to the problem.
Dec 16, 2013 11:34 AM|bbcompent1|LINK
Take a look at this stack overflow thread. It could be one of those things they mention:
Dec 16, 2013 11:47 AM|beep1986|LINK
thank you i shall take a look,
hmm have tried all suggestion and still not workin with mysql, thanks for the help anyways
Dec 16, 2013 04:43 PM|bbcompent1|LINK
Can you check the MySQL Database to see if it actually has generated the ASPNET Membership Database?
Dec 16, 2013 05:49 PM|beep1986|LINK
Yes its auto generated the new tabels for the membership database
Dec 17, 2013 09:20 AM|bbcompent1|LINK
Hm, ok now this is getting interesting indeed. Let me give this some more thought and I'll get back to you.
Dec 17, 2013 11:51 AM|beep1986|LINK
Thank you, have found problem. the Mysql Connecter I put in Visual Studios has effected the config file, i have removed the line of code in config and now am trying to develop the system using SQL, having much better luck using Local db rather than trying
to remotly accsess a live hosted database.
Thanks for you help bbcompent1
Dec 17, 2013 02:57 PM|bbcompent1|LINK
Ah, so it was a remote DB you were trying to access. That can sometimes get a little crazy as I've been in that situation before. The way I resolved the problem was to host the MySQL DB locally on my own hosted server. A lot a crazy stuff can happen when
you go across the wire to another DB. Consider, what happens if the remote DB is down? Your app goes offline and gives all kinds of nasty errors.