Trying to use membership

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
iradio
Posts: 4
Joined: Tue 04 Sep 2007 17:15
Location: NYC

Trying to use membership

Post by 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:












section enables configuration
of the security authentication mode used by
ASP.NET to identify an incoming user.
-->

section enables configuration
of what to do if/when an unhandled error occurs
during the execution of a request. Specifically,
it enables developers to configure html error pages
to be displayed in place of a error stack trace.

-->
















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

Database script

Post by 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

Post by 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

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Wed 05 Sep 2007 10:10

I've sent you my WebSite application. Please try it. I was able to add users successfully.

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

Post by 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?

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by 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.

Post Reply