Trying to use membership

Trying to use membership

Postby iradio » Tue 04 Sep 2007 19:33

I am a new CoreLab customer, trying to use membership services with MyDirect 4.20 / VS2005 / C#.

So far no good... I am probably doing something wrong or missing astep. Tried to follow documentation...

I can do nothing in ASP.net Web Site Administration Tool.
Cannot test provider - get an error:

Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.

Can not add user - get an error:

An error was encountered. Please return to the previous page and try again.

My web.config is:
















userIsOnlineTimeWindow="15">


name="AspNetMySqlMembershipProvider"
type="CoreLab.MySql.Web.Providers.MySqlMembershipProvider"
connectionStringName="MySqlConnectionString"
enablePasswordRetrieval="false"
enablePasswordReset="true"
requiresQuestionAndAnswer="true"
requiresUniqueEmail="false"
passwordFormat="Hashed"
maxInvalidPasswordAttempts="5"
passwordAttemptWindow="10" />










iradio
 
Posts: 4
Joined: Tue 04 Sep 2007 17:15
Location: NYC

Database script

Postby iradio » Tue 04 Sep 2007 20:04

I forgot to mention that I did run the InstallWebTables.sql script
iradio
 
Posts: 4
Joined: Tue 04 Sep 2007 17:15
Location: NYC

Postby iradio » Wed 05 Sep 2007 00:56

OK. Had some progress.
I dragged the "CreateUserWizard" onto a page and managed to create users. I still cannot create a user through the Web Site Administration Tool, but at least I can create users. I can live with that.

Is thera a similar control to manage groups? I could create groups with Web Site Administration Tool, but cannot assign users to a group. The Web Site Administration Tool does not see any of the users I created.

The login page works fins and allows only existing users to get into my test site... How do I connect between the Web Site Administration Tool and MySql/CoreLab based membership provider?

Thanks
iradio
 
Posts: 4
Joined: Tue 04 Sep 2007 17:15
Location: NYC

Postby Alexey » Wed 05 Sep 2007 10:10

I've sent you my WebSite application. Please try it. I was able to add users successfully.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby iradio » Thu 06 Sep 2007 13:16

No. Same problem. Can only add users programatically.
It looks like the Web Site Administration Tool does not see the MySql based membership provider.
How can I add and manage groups programatically?
iradio
 
Posts: 4
Joined: Tue 04 Sep 2007 17:15
Location: NYC

Postby Alexey » Fri 07 Sep 2007 07:55

Please take a look at our WebProviders demo (try to use its web.config).
If the problem persists, try to debug local server which starts ASP.NET Web Site Administration Tool and observe the exception being raised.
To manage roles use appropriate functions of Roles class: AddUsersToRole, etc.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL