|
|
I get an error in line 155 "foreach (SettingsProperty prop in ppc)" about an unsupported property? Any ideas?
.
.
.
public override SettingsPropertyValueCollection GetPropertyValues (SettingsContext context, SettingsPropertyCollection ppc)
{
string username = (string)context["UserName"];
bool isAuthenticated = (bool)context["IsAuthenticated"];
// The serializeAs attribute is ignored in this provider implementation.
SettingsPropertyValueCollection svc = new SettingsPropertyValueCollection();
foreach (SettingsProperty prop in ppc)
.
.
.
|
|
|
|
|
This functionality is provided in the MySQL Connector/NET's MySql.Web.dll. No need to build your own!
MySql.Web.Security.MySqlRoleProvider and MySql.Web.Security.MySqlMembershipProvider
Mikko
|
|
|
|
|
That's true as for Membership and Roles, but Profile has yet to be implemented?
|
|
|
|
|
The SiteMap provider is complaining that I don't have a ParentID for a particular record. For the Home reference, there wouldn't be any ParentID. What do I do in this situation?
Thanks,
King Wilder
|
|
|
|
|
I'm not 100% sure. Try using 0 as the ParentID for the Home reference.
"I'm about as expert as a palsy victim performing brain surgery with a pipe wrench."
Check out my site at JacquesSnyman.co.za
** Remember: An article is only as good as the votes it gets **
|
|
|
|
|
Nice job on this. I have it working for the most part, but I'm getting the "Hashed or Encrypted passwords are not supported with auto-generated keys" error. I'll try to figure that out.
I built an Admin User Manager UI built on top of the .Net 2.0 classes. I'm using my UI with your provider and it works (except for the password error).
I thought you might want to look at it and see if it needs any additional features. You can find it to download at my web site: http://www.kingwilder.com.
I have instructions on it in my Blog and I call it the Membership API. It just has a few user controls and ASPX pages to drop into your application and a web.config sample and you're all set.
Now with your MySql provider, I'm able to quickly add Membership capabilities to my SQL Server apps or MySql apps.
Thanks,
King Wilder
|
|
|
|
|
Had a look at your site and I must say... Excellent work on the UI. I'm thoroughly impressed.
Will go through it tonight and tell you if there's anything I would add.
To solve the "Hashed or Encrypted passwords are not supported with auto-generated keys" error read this message on the article's forum: http://www.codeproject.com/aspnet/MySQLsuite.asp?msg=2013240#xx2013240xx
Don't you want to post a link on your blog to this article?
"I'm about as expert as a palsy victim performing brain surgery with a pipe wrench."
Check out my site at JacquesSnyman.co.za
** Remember: An article is only as good as the votes it gets **
|
|
|
|
|
Jacques,
I posted a comment on my Blog that has a link to this CodeProject article.
I saw your solution for the passwords error I was getting and implemented it and it worked. I'm not sure why it doesn't work out of the box, since it works with SQL Server, but at least I got it to work.
The only thing that doesn't work yet is my BreadCrumb using any SiteMap datasource. I've gotten SiteMap's to work with other applications, but for some reason with this application I can't get it to work with either the XML file, or your SiteMap provider. I'll figure something out.
There are probably some features that can be added to my Membership UI app, but as-is it has enough to get developers started. I leave the Change Password functionality up to the standard ASP.NET control since users would probably be doing this themselves, the Admin doesn't have to.
Anyway, thanks for buildling this provider. It's helped a lot.
There was only one problem I had at first, when I made a reference to your DLL in the /bin folder I kept getting an error that it couldn't find the resource. And when I looked closer at the error message and path, it was pointing to the location of your /jacques folder in the path you used to create the DLL. That's strange!
So I just re-compiled the app, made a new reference and it worked fine.
|
|
|
|
|
Hey there!
The suite is really great and works on my normal MyISAM development server, but when I try to create the tables on a cluster (NDBCluster), I get the following error when trying to create the users and profiles tables:
Can't create table {tablename} (errno: 904)
Any ideas?
Thanks.
|
|
|
|
|
Unfortunately I've never used NDBCluster with MySQL. It looks to me like the syntax differs from the normal MyISAM engine.
Have you tried googling the error?
"I'm about as expert as a palsy victim performing brain surgery with a pipe wrench."
Check out my site at JacquesSnyman.co.za
** Remember: An article is only as good as the votes it gets **
|
|
|
|
|
Jacques,
Thanks for your response.
I Goggled the error and came up with a problem relating to: 'MaxNoOfOrderedIndexes'.
There's no information on what I can do, or how I can fix the problem really. There seem to be others who have had similar errors pop up like this, but solutions are beyond my technical grasp.
I'm more .NET than MySQL to be perfectly honest!
|
|
|
|
|
Looks like there's an issue with indexing then. Try this SQL for the profiles and users tables:
<br />
CREATE TABLE `profiles` (<br />
`UniqueID` int(8) NOT NULL auto_increment,<br />
`Username` varchar(255) NOT NULL default '',<br />
`ApplicationName` varchar(255) NOT NULL default '',<br />
`IsAnonymous` tinyint(1) default '0',<br />
`LastActivityDate` datetime default NULL,<br />
`LastUpdatedDate` datetime default NULL,<br />
PRIMARY KEY (`UniqueID`)<br />
);<br />
<br />
CREATE TABLE `users` (<br />
`PKID` varchar(255) NOT NULL default '',<br />
`Username` varchar(255) NOT NULL default '',<br />
`ApplicationName` varchar(255) NOT NULL default '',<br />
`Email` varchar(128) default NULL,<br />
`Comment` varchar(255) default NULL,<br />
`Password` varchar(128) NOT NULL default '',<br />
`FailedPasswordAttemptWindowStart` datetime default NULL,<br />
`PasswordQuestion` varchar(255) default NULL,<br />
`IsLockedOut` tinyint(1) default '0',<br />
`PasswordAnswer` varchar(255) default NULL,<br />
`FailedPasswordAnswerAttemptCount` int(8) default '0',<br />
`FailedPasswordAttemptCount` int(8) default '0',<br />
`IsApproved` tinyint(1) NOT NULL default '0',<br />
`FailedPasswordAnswerAttemptWindowStart` datetime default NULL,<br />
`LastActivityDate` datetime default NULL,<br />
`IsOnLine` tinyint(1) default '0',<br />
`CreationDate` datetime default NULL,<br />
`LastPasswordChangedDate` datetime default NULL,<br />
`LastLockedOutDate` datetime default NULL,<br />
`LastLoginDate` datetime default NULL,<br />
PRIMARY KEY (`PKID`),<br />
);<br />
Let me know if it works, please.
"I'm about as expert as a palsy victim performing brain surgery with a pipe wrench."
Check out my site at JacquesSnyman.co.za
** Remember: An article is only as good as the votes it gets **
|
|
|
|
|
I'll have to wait until tomorrow when I get back to my computer, but thankyou for your help.
|
|
|
|
|
I'm afraid that I get failures on both when I try to create these tables as an NDBCluster.
Error:
Can't create table (errno: 904) - 1005
|
|
|
|
|
Oh no... Sorry I have no clue. Will investigate as soon as I get some time and get back to you.
"I'm about as expert as a palsy victim performing brain surgery with a pipe wrench."
Check out my site at JacquesSnyman.co.za
** Remember: An article is only as good as the votes it gets **
|
|
|
|
|
Can anyone please help me? I setup the suite as specified. I opened Visual Studio Express. The wizard attempted to convert the project but could not parse the Simple.Providers.MySQL.csproj file. I am new to .net in general. Until recently, I programmed in ASP VBScript. Here is the conversion log contents:
ERROR: Unable to parse project file Simple.Providers.MySQL.csproj.
=========================COMMENTS=================
Project Simple.Providers.MySQL.csproj has been converted successfully at August 06 2007, 05:45:58.
Any tips or help greatly appreciated.
|
|
|
|
|
Hi Rob...
I've never worked with Visual Studio Express but have read quite a lot about it.
The project is a Visual Studio 2005 project and you shouldn't have to convert it. Maybe you should try opening it with Visual C# Express as it is a library and not a WinForm or Web project. You can then make changes and compile it. You then need to reference the compiled library from your Visual Studio Express environment. I hope this solves your problem. As I said, I've never used VS Express, so this is probably a shot in the dark.
Please let me know it this worked.
"I'm about as expert as a palsy victim performing brain surgery with a pipe wrench."
Check out my site at JacquesSnyman.co.za
** Remember: An article is only as good as the votes it gets **
|
|
|
|
|
Is it possible to use more than one child node in an treeview control?
I have managed to show the root and parent nodes but I cannot get the child nodes to show. Is I doing it wrong or is it simply not possible?
Thanx for a fabulous suite!
|
|
|
|
|
Please specify where you are having the problem. Is it with the sitemap provider?
"I'm about as expert as a palsy victim performing brain surgery with a pipe wrench."
Check out my site at JacquesSnyman.co.za
** Remember: An article is only as good as the votes it gets **
|
|
|
|
|
I have added to the database in the SiteMap table a few rows that I am using to fill a treeview with and that works. I get the root node and the 1st depth of nodes to show. I have used the id of the root node as the value for the parent column for the parent nodes. I would then like to have child nodes under the parent nodes and tried to set the parent column values the same as the ID for the parent but it doesnt work. Should that work?
I want to have a menu like this
root node
- Parent node 1
--Child 1
--Child 2
-Parent node 2
--Child 1
and so on but all i have managed to produce is the root and parent nodes. Does the provider support this usage? I hope this clearifies my question
|
|
|
|
|
Set the maxdatabinddepth of the treeview to -1
"I'm about as expert as a palsy victim performing brain surgery with a pipe wrench."
Check out my site at JacquesSnyman.co.za
** Remember: An article is only as good as the votes it gets **
|
|
|
|
|
|
Hello!
Thats the error that ocurrs when i deploy the solution to the product server.
Whats it about? where should i register it and how?
on Local machine everythin works good, but not on the hosting server.
any advices?
|
|
|
|
|
It might be that your host only supports signed assemblies. Or it might be any of a number of other factors. I think your hosting provider will be your best bet to try and find the problem.
"I'm about as expert as a palsy victim performing brain surgery with a pipe wrench."
Check out my site at JacquesSnyman.co.za
** Remember: An article is only as good as the votes it gets **
|
|
|
|