Newly created web.config -- unable to extract MySql DB info

Newly created web.config -- unable to extract MySql DB info

Postby Cody21 » Fri 02 Mar 2007 18:27

After a lot of reading, research, and testing, I now have my web.config file modified wituh ONLY the CoreLab MySql elements. However I am now having trouble accessing the data in my DB. It appears that there are standard Table definitions required for Login, PasswordRecovery, Role & Membership management. Is that TRUE? Are these default requirements documented someplace? Do I need to delete my DB and add it again from scratch? I *think* I'm making a little progress, but it still is not working. Thank you.

error: Table 'cityswingdb.aspnet_membership' doesn't exist

web.config ====





connectionString="User Id=*****;Password=*****;Host=localhost;Database=cityswingdb"
providerName="CoreLab.MySql" />














type="CoreLab.MySql.Web.Providers.MySqlSessionStateStore, CoreLab.MySql.Web, Version= 3.55.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701"
connectionStringName="MemberListConnectionString"
writeExceptionsToEventLog="false"/>





userIsOnlineTimeWindow="20">


type="CoreLab.MySql.Web.Providers.MySqlMembershipProvider, CoreLab.MySql.Web, Version= 3.55.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701"
connectionStringName="MemberListConnectionString"
enablePasswordRetrieval="true"
enablePasswordReset="true"
requiresQuestionAndAnswer="false"
requiresUniqueEmail="true"
passwordFormat="Clear"
maxInvalidPasswordAttempts="5"
passwordAttemptWindow="10"
minRequiredNonalphanumericCharacters="1"
ApplicationName="CitySwing"/>













type="CoreLab.MySql.Web.Providers.MySqlProfileProvider, CoreLab.MySql.Web, Version= 3.55.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701"
description="MySqlDirect profile provider"
connectionStringName="MemberListConnectionString"/>




cacheRolesInCookie="true"
defaultProvider="AspNetMySqlRoleProvider">


connectionStringName="MySqlSessionServices"
ApplicationName="CitySwing"
name="AspNetMySqlRoleProvider"
type="CoreLab.MySql.Web.Providers.MySqlRoleProvider, CoreLab.MySql.Web, Version= 3.55.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701"/>




























Cody21
 
Posts: 112
Joined: Thu 01 Mar 2007 00:58

Postby Alexey » Sat 03 Mar 2007 07:25

Yes, you have to create some tables in your database. Please take a look at the "ASP.NET Provider Model support" topic of our documentation.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Cody21 » Sat 03 Mar 2007 21:36

That worked, thank you ... However as previoulsly noted, I don't have that documentation to look at .. I found this HOW TO information by scouring your Forum.

PS - if you're attempting to send a .zip file to me, maybe either your provider or mine doens't allow .zip files??? Just a thought. Maybe change the extension to something like .junk or something...

Alexey wrote:Yes, you have to create some tables in your database. Please take a look at the "ASP.NET Provider Model support" topic of our documentation.
Cody21
 
Posts: 112
Joined: Thu 01 Mar 2007 00:58

Postby Alexey » Tue 06 Mar 2007 08:07

Re-sent (renamed to *.txt).
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL