Windows SharePoint Services Hosting

Re: Custom Membership Provider User Rights Issue

subhashdike — Wed, 06 Aug 2008 08:32:26 GMT

Please take a look at this. Anonymous Access and Forms Authentication with WSS 3.0 See if that helprs you

Thanks,

Subhash Dike

Re: Custom Membership Provider User Rights Issue

senthilkumar_me2006 — Fri, 27 Jun 2008 17:07:22 GMT

What do u mean by not working (finding users from database). Do you mean that it throws an error or do you mean that it does not find any user and always return user not find.

In your code, i saw that following query is used

[Code]

UserTable = TreoData.GetData("SELECT name, user_id, email FROM [user] WHERE user_id LIKE '" + username + "'");

[/Code]

In which you used "like" but no "%" sign.

[Code]

UserTable = TreoData.GetData("SELECT name, user_id, email FROM [user] WHERE user_id LIKE '%" + username + "%'");
[/Code]

Also, what is "treoapp" which you used while instantiating membershipuser class. You have to put your membershipprovider class name in there instead of some random name. for your case it should be "TreoMembershipProvider".

[Code]

MembershipUser user = new MembershipUser("TreoMembershipProvider", dr[0].ToString(), dr[1].ToString(), dr[2].ToString(), "", "", true, false, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now);

[/Code]

Re: Custom Membership Provider User Rights Issue

rideon88 — Thu, 26 Jun 2008 19:02:02 GMT

It seems to be loading fine now... after making that edit. The problem is that it isn't actually working (finding users from my database). That means my class is broken. Are there any sample MembershipProviders out there in C# that only pull a username, email, and a password out of a MSSQL database with the required methods already written?

Re: Custom Membership Provider User Rights Issue

senthilkumar_me2006 — Thu, 26 Jun 2008 18:26:57 GMT

I am sorry, i missed to tell you, that u have to copy and paste that class library *.dll file into c:\inetpub\wwwroot\wss\virtualdirectories\80\bin

and c:\inetpub\wwwroot\wss\virtualdirectories\[your administrative portnumber]\bin

Also, since you changed the code into a class library there is a namespace introduction plus assembly name change happends. you have to update your configuration as below

[Code]

<add name="TreoMembershipProvider"

type="TreoMP.TreoMembershipProvider, TreoMP, Version=1.0.0.0, Culture=neutral, PublicKeyToken=e29287ee7e26bca9"

requiresQuestionAndAnswer="false"

passwordFormat="Clear"

connectionStringName="MyConnectionString"/>

</providers>

</membership>

[/Code]

Thanks,

Senthilkumar

Re: Custom Membership Provider User Rights Issue

rideon88 — Thu, 26 Jun 2008 16:26:58 GMT

Hi,

First off, thanks for your help senthilkumar. It's greatly appreciated.

I've rewritten my class file, built the DLL, created the strong key file, and implemented the library into my local GAC and my dev servers GAC. Before actually tackeling sharepoint, I wanted to run it locally just under the ASPNET configuration.It loads up fine, but I'm getting the following message when I click on the security link to add and manage users already in the database. Any advice would be greatly appreciated. Hopefully its something simple like the i'm just calling the wrong name from my web.config.

The following message may help in diagnosing the problem: Could not load file or assembly 'TreoMembershipProvider, Version=1.0.0.0, Culture=neutral, PublicKeyToken=e29287ee7e26bca9' or one of its dependencies. The system cannot find the file specified. (C:\Inetpub\wwwroot\wss\VirtualDirectories\WebSite1\web.config line 58)

Here is my sample web.config file just to make sure that my class will work through the ASPNET Configuration. I figured that if I immediately load it up in sharepoint, and it doesn't work, I'll never be able to debug it. So before I try and get sharepoint to work I want to make sure this works. I also uploaded some screen shots of the error message i'm getting, my dll file in the assembly folder, and the database structure im writing this for just for fun.

1    
2    <!-- 
3        Note: As an alternative to hand editing this file you can use the 
4        web admin tool to configure settings for your application. Use
5        the Website->Asp.Net Configuration option in Visual Studio.
6        A full list of settings and comments can be found in 
7        machine.config.comments usually located in 
8        \Windows\Microsoft.Net\Framework\v2.x\Config 
9    -->
10   <configuration>
11   	<appSettings/>
12   	<connectionStrings>
13   		<add name="MyConnectionString" connectionString="Server=x-db2;Database=Aarons_Playground;uid=treoapp;pwd=xxx;"/>
14   
15   	</connectionStrings>
16   	<system.web>
17   		<!-- 
18               Set compilation debug="true" to insert debugging 
19               symbols into the compiled page. Because this 
20               affects performance, set this value to true only 
21               during development.
22   
23               Visual Basic options:
24               Set strict="true" to disallow all data type conversions 
25               where data loss can occur. 
26               Set explicit="true" to force declaration of all variables.
27           -->
28   		<compilation debug="true" strict="false" explicit="true"/>
29   		<pages>
30   			<namespaces>
31   				<clear/>
32   				<add namespace="System"/>
33   				<add namespace="System.Collections"/>
34   				<add namespace="System.Collections.Specialized"/>
35   				<add namespace="System.Configuration"/>
36   				<add namespace="System.Text"/>
37   				<add namespace="System.Text.RegularExpressions"/>
38   				<add namespace="System.Web"/>
39   				<add namespace="System.Web.Caching"/>
40   				<add namespace="System.Web.SessionState"/>
41   				<add namespace="System.Web.Security"/>
42   				<add namespace="System.Web.Profile"/>
43   				<add namespace="System.Web.UI"/>
44   				<add namespace="System.Web.UI.WebControls"/>
45   				<add namespace="System.Web.UI.WebControls.WebParts"/>
46   				<add namespace="System.Web.UI.HtmlControls"/>
47   			</namespaces>
48   		</pages>
49   		<!--
50               The <authentication> section enables configuration 
51               of the security authentication mode used by 
52               ASP.NET to identify an incoming user. 
53           -->
54   		<authentication mode="Forms"/>
55   		<membership defaultProvider="TreoMembershipProvider">
56   			<providers>
57   				<add name="TreoMembershipProvider"
58   					 type="TreoMembershipProvider, TreoMembershipProvider, Version=1.0.0.0, Culture=neutral, PublicKeyToken=e29287ee7e26bca9"
59   					 requiresQuestionAndAnswer="false"
60   					 passwordFormat="Clear"
61   					 connectionStringName="MyConnectionString"
62   					 
63   					 />
64   			</providers>
65   		</membership>
66   	</system.web>
67   </configuration>
68

Here is my updated TreoMP.dll/.cs class file

1    using System;
2    using System.Collections.Generic;
3    using System.Text;
4    using System.Data;
5    using System.Data.SqlClient;
6    using System.Data.OleDb;
7    using System.Data.Odbc;
8    using System.Configuration;
9    using System.Collections.Specialized;
10   using System.Configuration.Provider;
11   using System.Security.Cryptography;
12   using System.Web;
13   using System.Web.Security;
14   using System.Web.UI;
15   using System.Web.UI.WebControls;
16   using System.Web.UI.WebControls.WebParts;
17   using System.Web.UI.HtmlControls;
18   using TreoSolutions.Data;
19   namespace TreoMP
20   {
21       public class TreoMembershipProvider:MembershipProvider
22       {
23           public TreoMembershipProvider()
24   	{
25   		//
26   		// TODO: Add constructor logic here
27             
28   		//
29   	}
30   
31       public override string ApplicationName
32       {
33           get
34           {
35               throw new Exception("The method or operation is not implemented.");
36           }
37           set
38           {
39               throw new Exception("The method or operation is not implemented.");
40           }
41       }
42   
43       public override bool ChangePassword(string username, string oldPassword, string newPassword)
44       {
45           throw new Exception("The method or operation is not implemented.");
46       }
47   
48       public override bool ChangePasswordQuestionAndAnswer(string username, string password, string newPasswordQuestion, string newPasswordAnswer)
49       {
50           throw new Exception("The method or operation is not implemented.");
51       }
52   
53       public override MembershipUser CreateUser(string username, string password, string email, string passwordQuestion, string passwordAnswer, bool isApproved, object providerUserKey, out MembershipCreateStatus status)
54       {
55           throw new Exception("The method or operation is not implemented.");
56       }
57   
58       public override bool DeleteUser(string username, bool deleteAllRelatedData)
59       {
60           throw new Exception("The method or operation is not implemented.");
61       }
62   
63       public override bool EnablePasswordReset
64       {
65           get { throw new Exception("The method or operation is not implemented."); }
66       }
67   
68       public override bool EnablePasswordRetrieval
69       {
70           get { throw new Exception("The method or operation is not implemented."); }
71       }
72   
73       public override MembershipUserCollection FindUsersByEmail(string emailToMatch, int pageIndex, int pageSize, out int totalRecords)
74       {
75           try
76           {
77               totalRecords = 0;
78               SQLData TreoData = null;
79               DataTable UserTable = null;
80               MembershipUserCollection users = new MembershipUserCollection();
81   
82               TreoData = new SQLData();
83               UserTable = TreoData.GetData("SELECT name, user_id, email FROM [user] WHERE email LIKE '" + emailToMatch + "'");
84   
85               foreach (DataRow dr in UserTable.Rows)
86               {
87                   totalRecords++;
88                   MembershipUser user = new MembershipUser("treoapp", dr[0].ToString(), dr[1].ToString(), dr[2].ToString(), "", "", true, false, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now);
89                   users.Add(user);
90               }
91               return users;
92           }
93           catch (Exception e)
94           {
95               throw e;
96           }
97   
98           
99       }
100  
101      public override MembershipUserCollection FindUsersByName(string usernameToMatch, int pageIndex, int pageSize, out int totalRecords)
102      {
103          try
104          {
105              totalRecords = 0;
106              SQLData TreoData = null;
107              DataTable UserTable = null;
108              MembershipUserCollection users = new MembershipUserCollection();
109  
110              TreoData = new SQLData();
111              UserTable = TreoData.GetData("SELECT name, user_id, email FROM [user]");
112  
113              foreach (DataRow dr in UserTable.Rows)
114              {
115                  totalRecords++;
116                  MembershipUser user = new MembershipUser("treoapp", dr[0].ToString(), dr[1].ToString(), dr[2].ToString(), "", "", true, false, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now);
117                  users.Add(user);
118              }
119  
120              return users;
121          }
122          catch (Exception e)
123          {
124              throw e;
125          }
126  
127          //throw new Exception("The method or operation is not implemented.");
128      }
129  
130      public override MembershipUserCollection GetAllUsers(int pageIndex, int pageSize, out int totalRecords)
131      {
132          try
133          {
134              totalRecords = 0;
135              SQLData TreoData = null;
136              DataTable UserTable = null;
137              MembershipUserCollection users = new MembershipUserCollection();
138  
139              TreoData = new SQLData();
140              UserTable = TreoData.GetData("SELECT name, user_id, email FROM [user]");
141  
142              foreach (DataRow dr in UserTable.Rows)
143              {
144                  totalRecords++;
145                  MembershipUser user = new MembershipUser("treoapp", dr[0].ToString(), dr[1].ToString(), dr[2].ToString(), "", "", true, false, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now);
146                  users.Add(user);
147  
148              }
149  
150              return users;
151          }
152          catch (Exception e)
153          {
154              throw e;
155          }
156  
157          //throw new Exception("The method or operation is not implemented.");
158      }
159  
160      public override int GetNumberOfUsersOnline()
161      {
162          throw new Exception("The method or operation is not implemented.");
163      }
164  
165      public override string GetPassword(string username, string answer)
166      {
167          throw new Exception("The method or operation is not implemented.");
168      }
169  
170      public override MembershipUser GetUser(string username, bool userIsOnline)
171      {
172          
173          SQLData TreoData = null;
174          DataTable UserTable = null;
175          
176  
177          TreoData = new SQLData();
178          UserTable = TreoData.GetData("SELECT name, user_id, email FROM [user] WHERE user_id LIKE '" + username + "'");
179  
180          foreach (DataRow dr in UserTable.Rows)
181          {
182              MembershipUser user = new MembershipUser("treoapp", dr[0].ToString(), dr[1].ToString(), dr[2].ToString(), "", "", true, false, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now);
183              return user;
184          }
185          return null;
186         
187           
188      }
189  
190      public override MembershipUser GetUser(object providerUserKey, bool userIsOnline)
191      {
192          
193           
194          throw new Exception("The method or operation is not implemented.");
195      }
196  
197      public override string GetUserNameByEmail(string email)
198      {
199          SQLData TreoData = null;
200          DataTable UserTable = null;
201          MembershipUserCollection users = new MembershipUserCollection();
202  
203          TreoData = new SQLData();
204          UserTable = TreoData.GetData("SELECT name, user_id, email FROM [user] WHERE email LIKE '" + email + "'");
205  
206          foreach (DataRow dr in UserTable.Rows)
207          {
208              MembershipUser user = new MembershipUser("treoapp", dr[0].ToString(), dr[1].ToString(), dr[2].ToString(), "", "", true, false, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now);
209              return user.UserName;
210          }
211  
212          return null;
213      }
214  
215      public override int MaxInvalidPasswordAttempts
216      {
217          get { throw new Exception("The method or operation is not implemented."); }
218      }
219  
220      public override int MinRequiredNonAlphanumericCharacters
221      {
222          get { throw new Exception("The method or operation is not implemented."); }
223      }
224  
225      public override int MinRequiredPasswordLength
226      {
227          get { throw new Exception("The method or operation is not implemented."); }
228      }
229  
230      public override int PasswordAttemptWindow
231      {
232          get { throw new Exception("The method or operation is not implemented."); }
233      }
234  
235      public override MembershipPasswordFormat PasswordFormat
236      {
237          get { throw new Exception("The method or operation is not implemented."); }
238      }
239  
240      public override string PasswordStrengthRegularExpression
241      {
242          get { throw new Exception("The method or operation is not implemented."); }
243      }
244  
245      public override bool RequiresQuestionAndAnswer
246      {
247          get { throw new Exception("The method or operation is not implemented."); }
248      }
249  
250      public override bool RequiresUniqueEmail
251      {
252          get { throw new Exception("The method or operation is not implemented."); }
253      }
254  
255      public override string ResetPassword(string username, string answer)
256      {
257          throw new Exception("The method or operation is not implemented.");
258      }
259  
260      public override bool UnlockUser(string userName)
261      {
262          throw new Exception("The method or operation is not implemented.");
263      }
264  
265      public override void UpdateUser(MembershipUser user)
266      {
267          throw new Exception("The method or operation is not implemented.");
268      }
269  
270      public override bool ValidateUser(string username, string password)
271      {
272          try
273          {
274              SQLData TreoData = null;
275              DataTable UserData = null;
276  
277              TreoData = new SQLData();
278              UserData = TreoData.GetData("Select * FROM [user] WHERE email = '" + username + "' AND password = '" + password + "'");
279              if (UserData == null)
280                  return false;
281              else
282                  return true;
283  
284          }
285          catch (Exception e)
286          {
287              throw e;
288          }
289  
290  
291      }
292  
293      }
294  }
295

Re: Custom Membership Provider User Rights Issue

senthilkumar_me2006 — Wed, 25 Jun 2008 21:44:29 GMT

To get the Sharepoint authentication working for your existing database, u have to modify the configuration to point to the proper database as well as your custom provider.

TreoMembershipProvider is your custom provider so, change your configuration as below.

[Code]

</providers>

</membership>

[/Code]

Your membership provider name should be ur custom membership provider class name. Type is the namespace.classname, assembly name, version is your version refer assembly.cs for version information.

You cannot put ur *.cs or *.vb file as part of deployment, u need to compile and deploy the *.dll into GAC. From ur query it seems, u have an website project. Create a new class library project, Compile your library project drop the dll in GAC, find the public key token and replace the public key token in configuration.

"MyConnectionString" is the connection string key refered in this config. Add/modify your connection string info as below

[Code]

</connectionStrings>

[/Code]

Add more code in your TreoMembershipProvider class, because u need to implement some other functions which is used to retrieve user info while searching, adding them as admin etc.,

Minimum Required methods to implements are

[Code]

public override bool ValidateUser(string username, string password)

public override MembershipUserCollection FindUsersByEmail(string emailToMatch, int pageIndex, int pageSize, out int totalRecords)

public override MembershipUserCollection FindUsersByName(string usernameToMatch, int pageIndex, int pageSize, out int totalRecords)

public override MembershipUser GetUser(string username, bool userIsOnline)

public override string GetUserNameByEmail(string email)

[/Code]

i hope u know how to implement those methods. A small tip for you to instantiate membership user and return membership user collection

[Code]

MembershipUser myUser = new MembershipUser("TreoMembershipProvider", "username", null, "email", "dummy question?", "no comments",

true, false, DateTime.MinValue, DateTime.MinValue, DateTime.MinValue, DateTime.MinValue, DateTime.MinValue);

[/Code]

some arguments are not really meant for you but required to send some dummy data inorder to instantiate the object. Hope you can enjoy ur custom authentication. Reply back if u need more info.

Thanks,

Esen

Re: Custom Membership Provider User Rights Issue

rideon88 — Wed, 25 Jun 2008 18:03:52 GMT

I have been working on this project for almost a week now. I have forms auth working on the aspsqlnet database that the regsql wizard created, but I really need to get it to authenticate against an existing database with 1000's of users that my company runs off of. I've written my custom membership provider, written a class to connect to the sql database and even configured the web.config file but things just don't seem to work. I'm going to paste my code, but I'd also ask that someone posts up the entire web.config and the membership provider class.

Also, can you tell me where to put the CustomMembershipProvider.cs file in the sharepoint directory, and how to make sharepoint to read from it?In my failed VB tests it was in App_code but there is no such folder in sharepoint.

Third, should I be able to interact using the Website-> ASPNET configuration tool? I'm so lost there is no useful documentation anywhere out there.

<b>MembershipProvider.cs file</b>

1    using System;
2    using System.Data;
3    using System.Data.SqlClient;
4    using System.Data.OleDb;
5    using System.Data.Odbc;
6    using System.Configuration;
7    using System.Web;
8    using System.Web.Security;
9    using System.Web.UI;
10   using System.Web.UI.WebControls;
11   using System.Web.UI.WebControls.WebParts;
12   using System.Web.UI.HtmlControls;
13   using TreoSolutions.Data;
14   
15   /// <summary>
16   /// Summary description for TreoMembershipProvider
17   /// </summary>
18   public class TreoMembershipProvider:MembershipProvider
19   {
20   	public TreoMembershipProvider()
21   	{
22   		//
23   		// TODO: Add constructor logic here
24   		//
25   	}
26   
27       public override string ApplicationName
28       {
29           get
30           {
31               throw new Exception("The method or operation is not implemented.");
32           }
33           set
34           {
35               throw new Exception("The method or operation is not implemented.");
36           }
37       }
38   
39       public override bool ChangePassword(string username, string oldPassword, string newPassword)
40       {
41           throw new Exception("The method or operation is not implemented.");
42       }
43   
44       public override bool ChangePasswordQuestionAndAnswer(string username, string password, string newPasswordQuestion, string newPasswordAnswer)
45       {
46           throw new Exception("The method or operation is not implemented.");
47       }
48   
49       public override MembershipUser CreateUser(string username, string password, string email, string passwordQuestion, string passwordAnswer, bool isApproved, object providerUserKey, out MembershipCreateStatus status)
50       {
51           throw new Exception("The method or operation is not implemented.");
52       }
53   
54       public override bool DeleteUser(string username, bool deleteAllRelatedData)
55       {
56           throw new Exception("The method or operation is not implemented.");
57       }
58   
59       public override bool EnablePasswordReset
60       {
61           get { throw new Exception("The method or operation is not implemented."); }
62       }
63   
64       public override bool EnablePasswordRetrieval
65       {
66           get { throw new Exception("The method or operation is not implemented."); }
67       }
68   
69       public override MembershipUserCollection FindUsersByEmail(string emailToMatch, int pageIndex, int pageSize, out int totalRecords)
70       {
71           throw new Exception("The method or operation is not implemented.");
72       }
73   
74       public override MembershipUserCollection FindUsersByName(string usernameToMatch, int pageIndex, int pageSize, out int totalRecords)
75       {
76           throw new Exception("The method or operation is not implemented.");
77       }
78   
79       public override MembershipUserCollection GetAllUsers(int pageIndex, int pageSize, out int totalRecords)
80       {
81           throw new Exception("The method or operation is not implemented.");
82       }
83   
84       public override int GetNumberOfUsersOnline()
85       {
86           throw new Exception("The method or operation is not implemented.");
87       }
88   
89       public override string GetPassword(string username, string answer)
90       {
91           throw new Exception("The method or operation is not implemented.");
92       }
93   
94       public override MembershipUser GetUser(string username, bool userIsOnline)
95       {
96           throw new Exception("The method or operation is not implemented.");
97       }
98   
99       public override MembershipUser GetUser(object providerUserKey, bool userIsOnline)
100      {
101          throw new Exception("The method or operation is not implemented.");
102      }
103  
104      public override string GetUserNameByEmail(string email)
105      {
106          throw new Exception("The method or operation is not implemented.");
107      }
108  
109      public override int MaxInvalidPasswordAttempts
110      {
111          get { throw new Exception("The method or operation is not implemented."); }
112      }
113  
114      public override int MinRequiredNonAlphanumericCharacters
115      {
116          get { throw new Exception("The method or operation is not implemented."); }
117      }
118  
119      public override int MinRequiredPasswordLength
120      {
121          get { throw new Exception("The method or operation is not implemented."); }
122      }
123  
124      public override int PasswordAttemptWindow
125      {
126          get { throw new Exception("The method or operation is not implemented."); }
127      }
128  
129      public override MembershipPasswordFormat PasswordFormat
130      {
131          get { throw new Exception("The method or operation is not implemented."); }
132      }
133  
134      public override string PasswordStrengthRegularExpression
135      {
136          get { throw new Exception("The method or operation is not implemented."); }
137      }
138  
139      public override bool RequiresQuestionAndAnswer
140      {
141          get { throw new Exception("The method or operation is not implemented."); }
142      }
143  
144      public override bool RequiresUniqueEmail
145      {
146          get { throw new Exception("The method or operation is not implemented."); }
147      }
148  
149      public override string ResetPassword(string username, string answer)
150      {
151          throw new Exception("The method or operation is not implemented.");
152      }
153  
154      public override bool UnlockUser(string userName)
155      {
156          throw new Exception("The method or operation is not implemented.");
157      }
158  
159      public override void UpdateUser(MembershipUser user)
160      {
161          throw new Exception("The method or operation is not implemented.");
162      }
163  
164      public override bool ValidateUser(string username, string password)
165      {
166          SQLData TreoData = null;
167          DataTable UserActivity = null;
168  
169          TreoData = new SQLData();
170          UserActivity = TreoData.GetData("Select * FROM [user] WHERE email = '"+username+"' AND password = '"+password+"'");
171          if( UserActivity == null )
172                 return false;
173          else
174              return true;
175            
176  
177      }
178  }
179

 <b>Sharepoint Web.config file</b>

 1    
2    <configuration>
3      <configSections>
4        <sectionGroup name="SharePoint">
5          <section name="SafeControls" type="Microsoft.SharePoint.ApplicationRuntime.SafeControlsConfigurationHandler, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
6          <section name="RuntimeFilter" type="System.Configuration.SingleTagSectionHandler, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
7          <section name="WebPartLimits" type="System.Configuration.SingleTagSectionHandler, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
8          <section name="WebPartCache" type="System.Configuration.SingleTagSectionHandler, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
9          <section name="WebPartWorkItem" type="System.Configuration.SingleTagSectionHandler, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
10         <section name="WebPartControls" type="System.Configuration.SingleTagSectionHandler, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
11         <section name="SafeMode" type="Microsoft.SharePoint.ApplicationRuntime.SafeModeConfigurationHandler, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
12         <section name="MergedActions" type="System.Configuration.SingleTagSectionHandler, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
13         <section name="PeoplePickerWildcards" type="System.Configuration.NameValueSectionHandler, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
14       </sectionGroup>
15       <sectionGroup name="System.Workflow.ComponentModel.WorkflowCompiler" type="System.Workflow.ComponentModel.Compiler.WorkflowCompilerConfigurationSectionGroup, System.Workflow.ComponentModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
16         <section name="authorizedTypes" type="System.Workflow.ComponentModel.Compiler.AuthorizedTypesSectionHandler, System.Workflow.ComponentModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
17       </sectionGroup>
18     </configSections>
19     <SharePoint>
20       <SafeMode MaxControls="200" CallStack="true" DirectFileDependencies="10" TotalFileDependencies="50" AllowPageLevelTrace="false">
21         <PageParserPaths>
22         </PageParserPaths>
23       </SafeMode>
24       <WebPartLimits MaxZoneParts="50" PropertySize="1048576" />
25       <WebPartCache Storage="CacheObject" />
26       <WebPartControls DatasheetControlGuid="65BCBEE4-7728-41a0-97BE-14E1CAE36AAE" />
27       <SafeControls>
28         <SafeControl Assembly="System.Web, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" Namespace="System.Web.UI.WebControls" TypeName="*" Safe="True" AllowRemoteDesigner="True" />
29         <SafeControl Assembly="System.Web, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" Namespace="System.Web.UI.HtmlControls" TypeName="*" Safe="True" AllowRemoteDesigner="True" />
30         <SafeControl Assembly="System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" Namespace="System.Web.UI" TypeName="*" Safe="True" AllowRemoteDesigner="True" />
31         <SafeControl Assembly="System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" Namespace="System.Web.UI.WebControls" TypeName="SqlDataSource" Safe="False" AllowRemoteDesigner="False" />
32         <SafeControl Assembly="System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" Namespace="System.Web.UI.WebControls" TypeName="AccessDataSource" Safe="False" AllowRemoteDesigner="False" />
33         <SafeControl Assembly="System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" Namespace="System.Web.UI.WebControls" TypeName="XmlDataSource" Safe="False" AllowRemoteDesigner="False" />
34         <SafeControl Assembly="System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" Namespace="System.Web.UI.WebControls" TypeName="ObjectDataSource" Safe="False" AllowRemoteDesigner="False" />
35         <SafeControl Assembly="Microsoft.SharePoint, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.SharePoint" TypeName="*" Safe="True" AllowRemoteDesigner="True" />
36         <SafeControl Assembly="Microsoft.SharePoint, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.SharePoint.WebPartPages" TypeName="*" Safe="True" AllowRemoteDesigner="True" />
37         <SafeControl Assembly="Microsoft.SharePoint, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.SharePoint.WebControls" TypeName="*" Safe="True" AllowRemoteDesigner="True" />
38         <SafeControl Assembly="Microsoft.SharePoint, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.SharePoint.ApplicationPages" TypeName="*" Safe="True" AllowRemoteDesigner="True" />
39         <SafeControl Assembly="Microsoft.SharePoint, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.SharePoint.SoapServer" TypeName="*" Safe="True" AllowRemoteDesigner="True" />
40         <SafeControl Assembly="Microsoft.SharePoint, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.SharePoint.Meetings" TypeName="*" Safe="True" AllowRemoteDesigner="True" />
41         <SafeControl Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.SharePoint" TypeName="*" Safe="True" AllowRemoteDesigner="True" />
42         <SafeControl Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.SharePoint.WebPartPages" TypeName="*" Safe="True" AllowRemoteDesigner="True" />
43         <SafeControl Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.SharePoint.WebControls" TypeName="*" Safe="True" AllowRemoteDesigner="True" />
44         <SafeControl Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.SharePoint.ApplicationPages" TypeName="*" Safe="True" AllowRemoteDesigner="True" />
45         <SafeControl Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.SharePoint.SoapServer" TypeName="*" Safe="True" AllowRemoteDesigner="True" />
46         <SafeControl Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.SharePoint.Meetings" TypeName="*" Safe="True" AllowRemoteDesigner="True" />
47         <SafeControl Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.SharePoint.Workflow" TypeName="*" Safe="True" AllowRemoteDesigner="True" />
48         <SafeControl Assembly="Microsoft.SharePoint.Search, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.SharePoint.Search.WebControls" TypeName="*" Safe="True" AllowRemoteDesigner="True" />
49         <SafeControl Assembly="Microsoft.SharePoint.Search, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.SharePoint.Search.Internal.WebControls" TypeName="*" Safe="True" AllowRemoteDesigner="True" />
50         <SafeControl src="~/_controltemplates/*" IncludeSubFolders="True" Safe="True" AllowRemoteDesigner="True" />
51         <SafeControl Assembly="CKS.FormsBasedAuthentication, Version=1.0.0.0, Culture=neutral, PublicKeyToken=d0c9b215512a2c5d" Namespace="CKS.FormsBasedAuthentication" TypeName="*" Safe="True" />
52       </SafeControls>
53       <PeoplePickerWildcards>
54         <clear />
55         <add key="AspNetSqlMembershipProvider" value="%" />
56       </PeoplePickerWildcards>
57     </SharePoint>
58     <connectionStrings>
59       <remove name="LocalSqlServer" />
60       <add name="LocalSqlServer" connectionString="Server=x-db2;Database=Aarons_Playground;uid=treoapp;pwd=xxxx;" providerName="System.Data.SqlClient" />
61     </connectionStrings>
62     <system.web>
63       <!-- membership provider -->
64       <membership defaultProvider="AspNetSqlMembershipProvider">
65         <providers>
66           <add connectionStringName="LocalSqlServer" 
67   			 enablePasswordRetrieval="false" 
68   			 enablePasswordReset="true" 
69   			 requiresQuestionAndAnswer="false" 
70   			 applicationName="/" 
71   			 requiresUniqueEmail="false" 
72   			 passwordFormat="Hashed" 
73   			 maxInvalidPasswordAttempts="5" 
74   			 minRequiredPasswordLength="5" 
75   			 minRequiredNonalphanumericCharacters="0" 
76   			 passwordAttemptWindow="10" 
77   			 passwordStrengthRegularExpression="" 
78   			 name="AspNetSqlMembershipProvider " 
79   			 type="System.Web.Security.SqlMembershipProvider, System.Web,Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"  />
80         </providers>
81       </membership>
82       <!-- role provider -->
83       <roleManager enabled="true">
84         <providers>
85           <add connectionStringName="LocalSqlServer" 
86   			 applicationName="/" 
87   			 name="SharepointDev" 
88   			 type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
89         </providers>
90       </roleManager>
91       <securityPolicy>
92         <trustLevel name="WSS_Medium" policyFile="C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\config\wss_mediumtrust.config" />
93         <trustLevel name="WSS_Minimal" policyFile="C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\config\wss_minimaltrust.config" />
94       </securityPolicy>
95       <httpHandlers>
96         <remove verb="GET,HEAD,POST" path="*" />
97         <add verb="GET,HEAD,POST" path="*" type="Microsoft.SharePoint.ApplicationRuntime.SPHttpHandler, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
98         <add verb="OPTIONS,PROPFIND,PUT,LOCK,UNLOCK,MOVE,COPY,GETLIB,PROPPATCH,MKCOL,DELETE,(GETSOURCE),(HEADSOURCE),(POSTSOURCE)" path="*" type="Microsoft.SharePoint.ApplicationRuntime.SPHttpHandler, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
99       </httpHandlers>
100      <customErrors mode="Off" />
101      <httpRuntime maxRequestLength="51200" />
102  	  <authentication mode="Forms">
103  		  <forms name="cookie" loginUrl="/_layouts/login.aspx"  timeout="30" />  
104  	  </authentication>
105      <identity impersonate="true" />
106      <authorization>
107        <allow users="*" />
108      </authorization>
109      <httpModules>
110        <clear />
111        <add name="SPRequest" type="Microsoft.SharePoint.ApplicationRuntime.SPRequestModule, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
112        <add name="OutputCache" type="System.Web.Caching.OutputCacheModule" />
113        <add name="FormsAuthentication" type="System.Web.Security.FormsAuthenticationModule" />
114        <add name="UrlAuthorization" type="System.Web.Security.UrlAuthorizationModule" />
115        <add name="WindowsAuthentication" type="System.Web.Security.WindowsAuthenticationModule" />
116        <add name="RoleManager" type="System.Web.Security.RoleManagerModule" />
117        <!-- <add name="Session" type="System.Web.SessionState.SessionStateModule"/> -->
118      </httpModules>
119      <globalization fileEncoding="utf-8" />
120      <compilation batch="true" debug="true">
121        <assemblies>
122          <add assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
123        </assemblies>
124        <expressionBuilders>
125          <remove expressionPrefix="Resources" />
126          <add expressionPrefix="Resources" type="Microsoft.SharePoint.SPResourceExpressionBuilder, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
127          <add expressionPrefix="SPHtmlEncodedResources" type="Microsoft.SharePoint.SPHtmlEncodedResourceExpressionBuilder, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
128          <add expressionPrefix="SPSimpleFormattingEncodedResources" type="Microsoft.SharePoint.SPSimpleFormattingEncodedResourceExpressionBuilder, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
129        </expressionBuilders>
130      </compilation>
131      <pages enableSessionState="false" enableViewState="true" enableViewStateMac="true" validateRequest="false" pageParserFilterType="Microsoft.SharePoint.ApplicationRuntime.SPPageParserFilter, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" asyncTimeout="7">
132        <namespaces>
133          <remove namespace="System.Web.UI.WebControls.WebParts" />
134        </namespaces>
135        <tagMapping>
136          <add tagType="System.Web.UI.WebControls.SqlDataSource, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" mappedTagType="Microsoft.SharePoint.WebControls.SPSqlDataSource, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
137        </tagMapping>
138      </pages>
139      <siteMap defaultProvider="SPSiteMapProvider" enabled="true">
140        <providers>
141          <add name="SPNavigationProvider" type="Microsoft.SharePoint.Navigation.SPNavigationProvider, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
142          <add name="SPSiteMapProvider" type="Microsoft.SharePoint.Navigation.SPSiteMapProvider, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
143          <add name="SPContentMapProvider" type="Microsoft.SharePoint.Navigation.SPContentMapProvider, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
144          <add name="SPXmlContentMapProvider" siteMapFile="_app_bin/layouts.sitemap" type="Microsoft.SharePoint.Navigation.SPXmlContentMapProvider, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
145        </providers>
146      </siteMap>
147      <trust level="WSS_Minimal" originUrl="" />
148      <webParts>
149        <transformers>
150          <add name="TransformableFilterValuesToFilterValuesTransformer" type="Microsoft.SharePoint.WebPartPages.TransformableFilterValuesToFilterValuesTransformer, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
151          <add name="TransformableFilterValuesToParametersTransformer" type="Microsoft.SharePoint.WebPartPages.TransformableFilterValuesToParametersTransformer, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
152          <add name="TransformableFilterValuesToFieldTransformer" type="Microsoft.SharePoint.WebPartPages.TransformableFilterValuesToFieldTransformer, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
153        </transformers>
154      </webParts>
155      <machineKey validationKey="2E98DE67D80F7AE7DFD3B637439125DF0DD601585C7BB0C8" decryptionKey="147D6EB9B20E7BE7D9400ACF42482791F1EC5E1589D4EA6A" validation="SHA1" />
156    </system.web>
157    <runtime>
158      <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
159        <dependentAssembly>
160          <assemblyIdentity name="Microsoft.SharePoint" publicKeyToken="71e9bce111e9429c" culture="neutral" />
161          <bindingRedirect oldVersion="11.0.0.0" newVersion="12.0.0.0" />
162        </dependentAssembly>
163        <dependentAssembly>
164          <assemblyIdentity name="Microsoft.SharePoint.Dsp" publicKeyToken="71e9bce111e9429c" culture="neutral" />
165          <bindingRedirect oldVersion="11.0.0.0" newVersion="12.0.0.0" />
166        </dependentAssembly>
167        <dependentAssembly>
168          <assemblyIdentity name="Microsoft.SharePoint.Dsp.OleDb" publicKeyToken="71e9bce111e9429c" culture="neutral" />
169          <bindingRedirect oldVersion="11.0.0.0" newVersion="12.0.0.0" />
170        </dependentAssembly>
171        <dependentAssembly>
172          <assemblyIdentity name="Microsoft.SharePoint.Dsp.SoapPT" publicKeyToken="71e9bce111e9429c" culture="neutral" />
173          <bindingRedirect oldVersion="11.0.0.0" newVersion="12.0.0.0" />
174        </dependentAssembly>
175        <dependentAssembly>
176          <assemblyIdentity name="Microsoft.SharePoint.Dsp.Sts" publicKeyToken="71e9bce111e9429c" culture="neutral" />
177          <bindingRedirect oldVersion="11.0.0.0" newVersion="12.0.0.0" />
178        </dependentAssembly>
179        <dependentAssembly>
180          <assemblyIdentity name="Microsoft.SharePoint.Dsp.XmlUrl" publicKeyToken="71e9bce111e9429c" culture="neutral" />
181          <bindingRedirect oldVersion="11.0.0.0" newVersion="12.0.0.0" />
182        </dependentAssembly>
183        <dependentAssembly>
184          <assemblyIdentity name="Microsoft.SharePoint.intl" publicKeyToken="71e9bce111e9429c" culture="neutral" />
185          <bindingRedirect oldVersion="11.0.0.0" newVersion="12.0.0.0" />
186        </dependentAssembly>
187        <dependentAssembly>
188          <assemblyIdentity name="Microsoft.SharePoint.Library" publicKeyToken="71e9bce111e9429c" culture="neutral" />
189          <bindingRedirect oldVersion="11.0.0.0" newVersion="12.0.0.0" />
190        </dependentAssembly>
191        <dependentAssembly>
192          <assemblyIdentity name="Microsoft.SharePoint.Security" publicKeyToken="71e9bce111e9429c" culture="neutral" />
193          <bindingRedirect oldVersion="11.0.0.0" newVersion="12.0.0.0" />
194        </dependentAssembly>
195        <probing privatePath="bin;_app_bin" />
196      </assemblyBinding>
197    </runtime>
198    <location path="_layouts/images">
199      <system.web>
200        <authorization>
201          <allow users="*" />
202        </authorization>
203      </system.web>
204    </location>
205    <location path="_layouts/mobile/mbllogin.aspx">
206      <system.web>
207        <authorization>
208          <allow users="*" />
209        </authorization>
210      </system.web>
211    </location>
212    <System.Workflow.ComponentModel.WorkflowCompiler>
213      <authorizedTypes>
214        <authorizedType Assembly="System.Workflow.Activities, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" Namespace="System.Workflow.*" TypeName="*" Authorized="True" />
215        <authorizedType Assembly="System.Workflow.ComponentModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" Namespace="System.Workflow.*" TypeName="*" Authorized="True" />
216        <authorizedType Assembly="System.Workflow.Runtime, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" Namespace="System.Workflow.*" TypeName="*" Authorized="True" />
217        <authorizedType Assembly="System.Transactions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Namespace="System*" TypeName="*" Authorized="True" />
218        <authorizedType Assembly="mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Namespace="System*" TypeName="*" Authorized="True" />
219        <authorizedType Assembly="System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Namespace="System*" TypeName="*" Authorized="True" />
220        <authorizedType Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.SharePoint.Workflow" TypeName="SPWorkflowActivationProperties" Authorized="True" />
221        <authorizedType Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.SharePoint.Workflow" TypeName="SPWorkflowTaskProperties" Authorized="True" />
222        <authorizedType Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.SharePoint.Workflow" TypeName="SPWorkflowHistoryEventType" Authorized="True" />
223        <authorizedType Assembly="Microsoft.SharePoint.WorkflowActions, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.SharePoint.WorkflowActions" TypeName="*" Authorized="True" />
224      </authorizedTypes>
225    </System.Workflow.ComponentModel.WorkflowCompiler>
226  </configuration>

Re: Custom Membership Provider User Rights Issue

senthilkumar_me2006 — Fri, 02 May 2008 21:11:43 GMT

Subhash,

Thanks for the hint, i was hitting my heads with the "Unexpected error happend" message from sharepoint. After looking into the logs. now i resolved my issues.

Hats of Subhash... sabbash!!!

Esen

Re: Custom Membership Provider User Rights Issue

chiranthk — Sun, 17 Jun 2007 13:39:17 GMT

Hi subhash

pls mail me to chiranthk@aditi.com

i require ur help send me ur contact number . I am not able to set up my custom provider

Expectin ur reply

chiranth

Re: Custom Membership Provider User Rights Issue

chiranthk — Thu, 14 Jun 2007 09:26:18 GMT

Hi subash

i have got the same error in the log file , pls tell me ASAP how to solve it.

I have done all the steps correctly .

Thanks

chiranth

Re: Custom Membership Provider User Rights Issue

neeraj79 — Thu, 10 May 2007 18:38:27 GMT

I tried using ur code, with my ConnectionString.

I tried to test it first frm the ASP.NET configuration tool...this is what error i get " Specified Method Not Supported "

I dont know which method is it talking about...

How did u deploy this code of urs into Sharepoint ? Can u pls explain

Neeraj ( neerajshah81@gmail.com)

Re: Custom Membership Provider User Rights Issue

xinarg — Thu, 08 Mar 2007 08:34:34 GMT

YESSSSS IT WORKS ;-), the mistake was in my web.conf.... I forgot to specify connectionStringName :-)....

Re: Custom Membership Provider User Rights Issue

xinarg — Wed, 07 Mar 2007 15:34:02 GMT

Hello,

It seem's that I'm not alone with my problems ;-)

For me the error is............ :

03/07/2007 16:16:53.42 	w3wp.exe (0x0F20)                       	0x064C	Windows SharePoint Services   	General                       	72e9	Medium  	Error in resolving user 'cgrisantv' : System.NullReferenceException: Object reference not set to an instance of an object.     at LMSP.LDAPMemberShipProvider.GetUser(String username, Boolean userIsOnline)     at Microsoft.SharePoint.Utilities.SPMembershipProviderPrincipalResolver.ResolvePrincipal(String input, Boolean inputIsEmailOnly, SPPrincipalType scopes, SPPrincipalSource sources, SPUserCollection usersContainer)     at Microsoft.SharePoint.Utilities.SPUtility.ResolvePrincipalInternal(SPWeb web, SPWebApplication webApp, Nullable`1 urlZone, String input, SPPrincipalType scopes, SPPrincipalSource sources, SPUserCollection usersContainer, Boolean inputIsEmailOnly, Boolean alwaysAddWindowsResolver).	 
03/07/2007 16:16:53.43 	w3wp.exe (0x0F20)                       	0x064C	Windows SharePoint Services   	General                       	72e7	Medium  	Error in searching user 'cgrisantv' : System.NullReferenceException: Object reference not set to an instance of an object.     at LMSP.LDAPMemberShipProvider.GetUser(String username, Boolean userIsOnline)     at Microsoft.SharePoint.Utilities.SPMembershipProviderPrincipalResolver.ResolvePrincipal(String input, Boolean inputIsEmailOnly, SPPrincipalType scopes, SPPrincipalSource sources, SPUserCollection usersContainer)     at Microsoft.SharePoint.Utilities.SPMembershipProviderPrincipalResolver.SearchPrincipals(String input, SPPrincipalType scopes, SPPrincipalSource sources, SPUserCollection usersContainer, Int32 maxCount, Boolean& bReachMaxCount)     at Microsoft.SharePoint.Utilities.SPUtility.SearchPrincipalFromResolvers(List`1 resolvers, String input, SPPrincipalType scopes, SPPrincipalSo...	 
03/07/2007 16:16:53.43*	w3wp.exe (0x0F20)                       	0x064C	Windows SharePoint Services   	General                       	72e7	Medium  	...urce sources, SPUserCollection usersContainer, Int32 maxCount, Boolean& reachMaxCount, Dictionary`2 usersDict).

I tested the method getUser separately and it don't return a nullpointer exception...

 I can say that the mapping in the web.conf is correct, the assembly loads correctly and the provider is good declared, (I corrected a lot of errors with the logs ;-) )

 For me the problem is in the way I writed my MembershipProvider :

  1    using System;
2    using System.Collections.Specialized;
3    using System.Web.Security;
4    using System.Data.SqlClient;
5    using System.Collections.Generic;
6    using System.Text;
7    
8    namespace LMSP
9    {
10       public class LDAPMemberShipProvider : MembershipProvider
11       {
12           private string _applicationName;
13           private string _connectionStringName;
14           private string _name;
15           //private string connectionString="Data Source=EIFRMOSS02;Initial Catalog=custom_identification;Integrated Security=True";
16           public LDAPMemberShipProvider()
17           {
18               //
19               // TODO: Add constructor logic here
20               //
21           }
22   
23   
24           // MembershipProvider Properties
25           public override string ApplicationName
26           {
27               get { return _applicationName; }
28               set { _applicationName = value; }
29           }
30   
31   
32           public override void Initialize(string name,
33           NameValueCollection config)
34           {
35               if (config == null)
36                   throw new ArgumentNullException();
37               _applicationName = config["applicationName"];
38               _connectionStringName = config["connectionStringName"];
39               _name = name;
40   
41               base.Initialize(name, config);
42           }
43   
44           public override bool EnablePasswordRetrieval
45           {
46               get { return false; }
47           }
48   
49           public override bool EnablePasswordReset
50           {
51               get { return false; }
52           }
53   
54           public override int MaxInvalidPasswordAttempts
55           {
56               get { throw new NotSupportedException(); }
57           }
58   
59           public override int MinRequiredNonAlphanumericCharacters
60           {
61               get { throw new NotSupportedException(); }
62           }
63   
64           public override int MinRequiredPasswordLength
65           {
66               get { throw new NotSupportedException(); }
67           }
68   
69           public override int PasswordAttemptWindow
70           {
71               get { throw new NotSupportedException(); }
72           }
73   
74           public override MembershipPasswordFormat PasswordFormat
75           {
76               get { throw new NotSupportedException(); }
77           }
78   
79           public override string PasswordStrengthRegularExpression
80           {
81               get { throw new NotSupportedException(); }
82           }
83   
84           public override bool RequiresQuestionAndAnswer
85           {
86               get { throw new NotSupportedException(); }
87           }
88   
89           public override bool RequiresUniqueEmail
90           {
91               get { throw new NotSupportedException(); }
92           }
93   
94           public override MembershipUser CreateUser(string username,
95               string password, string email, string passwordQuestion,
96               string passwordAnswer, bool isApproved, object providerUserKey,
97               out MembershipCreateStatus status)
98           {
99               throw new NotSupportedException();
100          }
101  
102          public override bool ChangePasswordQuestionAndAnswer
103              (string username, string password,
104              string newPasswordQuestion, string newPasswordAnswer)
105          {
106              throw new NotSupportedException();
107          }
108  
109          public override string GetPassword(string username,
110            string answer)
111          {
112              throw new NotSupportedException();
113          }
114  
115          public override bool ChangePassword(string username,
116              string oldPassword, string newPassword)
117          {
118              throw new NotSupportedException();
119          }
120  
121          public override string ResetPassword(string username,
122              string answer)
123          {
124              throw new NotSupportedException();
125          }
126  
127          public override void UpdateUser(MembershipUser user)
128          {
129              throw new NotSupportedException();
130          }
131  
132          public override bool ValidateUser(string username,
133              string password)
134          {
135              // je crée la connexion de mon serveur ainsi que la base de données concernée
136              SqlConnection databaseConnexion = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[_connectionStringName].ConnectionString);
137              //SqlConnection databaseConnexion = new SqlConnection(connectionString);
138  
139              // je crée maintenant une requête de selection qui permettra d'afficher les valeurs souhaités...
140              SqlCommand databaseCommand = new SqlCommand("SELECT password FROM T_Identification WHERE login='" + username + "'", databaseConnexion);
141  
142              // Là j'ouvre la connexion Sql
143              databaseConnexion.Open();
144  
145              // Et je définie une datareader...
146              SqlDataReader dr = databaseCommand.ExecuteReader();
147  
148              if (dr == null) return false;
149  
150              if (!dr.Read()) return false;
151  
152              if (dr["password"] != null && dr["password"].Equals(password))
153              {
154                  return true;
155              }
156              else
157              {
158                  return false;
159              }
160          }
161  
162          public override bool UnlockUser(string userName)
163          {
164              throw new NotSupportedException();
165          }
166  
167          public override MembershipUser GetUser(object providerUserKey,
168              bool userIsOnline)
169          {
170              /*SqlConnection databaseConnexion = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[_connectionStringName].ConnectionString);
171              //SqlConnection databaseConnexion = new SqlConnection(connectionString);
172              SqlCommand databaseCommand = new SqlCommand("SELECT ID_Login,login,email FROM T_Identification WHERE ID_LOGIN=" + providerUserKey.ToString(), databaseConnexion);
173              databaseConnexion.Open();
174  
175              // Et je définis un datareader...
176              SqlDataReader dr = databaseCommand.ExecuteReader();
177              if (dr == null) return null;
178              MembershipUser user = null;
179              while (dr.Read())
180              {
181                  user = new MembershipUser(_name, dr["login"].ToString(), dr["ID_Login"], dr["email"].ToString(), "", "", true, false, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now);
182              }
183              return user;*/
184              throw new NotSupportedException();
185          }
186  
187          public override MembershipUser GetUser(string username,
188              bool userIsOnline)
189          {
190              SqlConnection databaseConnexion = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[_connectionStringName].ConnectionString);
191              //SqlConnection databaseConnexion = new SqlConnection(connectionString);
192              SqlCommand databaseCommand = new SqlCommand("SELECT ID_Login,login,email FROM T_Identification WHERE login='" + username + "'", databaseConnexion);
193              databaseConnexion.Open();
194  
195              // Et je définis un datareader...
196              SqlDataReader dr = databaseCommand.ExecuteReader();
197              if (dr == null) return null;
198              MembershipUser user = null;
199              while (dr.Read())
200              {
201                  user = new MembershipUser(_name, dr["login"].ToString(), dr["ID_Login"], dr["email"].ToString(), "", "", true, false, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now);
202              }
203              return user;
204          }
205  
206          public override string GetUserNameByEmail(string email)
207          {
208              throw new NotSupportedException();
209          }
210  
211  
212          public override bool DeleteUser(string username,
213              bool deleteAllRelatedData)
214          {
215              throw new NotSupportedException();
216          }
217  
218          public override MembershipUserCollection GetAllUsers
219              (int pageIndex, int pageSize, out int totalRecords)
220          {
221              totalRecords = 0;
222              SqlConnection databaseConnexion = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[_connectionStringName].ConnectionString);
223              //SqlConnection databaseConnexion = new SqlConnection(connectionString);
224              SqlCommand databaseCommand = new SqlCommand("SELECT ID_Login,login,nom,prenom,email FROM T_Identification", databaseConnexion);
225              databaseConnexion.Open();
226  
227              // Et je définis un datareader...
228              SqlDataReader dr = databaseCommand.ExecuteReader();
229              if (dr == null) return null;
230              MembershipUserCollection users = new MembershipUserCollection();
231              while (dr.Read())
232              {
233                  totalRecords++;
234                  MembershipUser user = new MembershipUser(_name, dr["login"].ToString(), dr["ID_Login"], dr["email"].ToString(), "", "", true, false, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now);
235                  users.Add(user);
236              }
237              return users;
238          }
239  
240          public override int GetNumberOfUsersOnline()
241          {
242              throw new NotSupportedException();
243          }
244  
245          public override MembershipUserCollection FindUsersByName
246              (string usernameToMatch, int pageIndex, int pageSize,
247              out int totalRecords)
248          {
249              totalRecords = 0;
250              SqlConnection databaseConnexion = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[_connectionStringName].ConnectionString);
251              //SqlConnection databaseConnexion = new SqlConnection(connectionString);
252              SqlCommand databaseCommand = new SqlCommand("SELECT ID_Login,login,nom,prenom,email FROM T_Identification WHERE login LIKE '" + usernameToMatch + "'", databaseConnexion);
253              databaseConnexion.Open();
254  
255              // Et je définis un datareader...
256              SqlDataReader dr = databaseCommand.ExecuteReader();
257              if (dr == null) return null;
258              MembershipUserCollection users = new MembershipUserCollection();
259              while (dr.Read())
260              {
261                  totalRecords++;
262                  MembershipUser user = new MembershipUser(_name, dr["login"].ToString(), dr["ID_Login"], dr["email"].ToString(), "", "", true, false, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now);
263                  users.Add(user);
264              }
265              return users;
266          }
267  
268          public override MembershipUserCollection FindUsersByEmail
269              (string emailToMatch, int pageIndex, int pageSize,
270              out int totalRecords)
271          {
272              throw new NotSupportedException();
273          }
274          /*
275                  // Virtual methods
276                  protected virtual byte[] EncryptPassword(byte[] password);
277                  protected virtual byte[] DecryptPassword(byte[] encodedPassword);
278                  protected virtual void OnValidatingPassword
279                      (ValidatePasswordEventArgs e);
280          */
281      }
282  }
283

If someone could help me, I have a headache it's terrible

 Thanks a lot and cu

Re: Custom Membership Provider User Rights Issue

abhi123 — Thu, 11 Jan 2007 11:48:20 GMT

Hi Subash,

When I try to resolve user from central Admin, it shows red line. In log it shows:

Error in resolving user 'ebruser' : System.Configuration.ConfigurationErrorsException: Exception has been thrown by the target of an invocation. (C:\Inetpub\wwwroot\wss\VirtualDirectories\20277\web.config line 136) at System.Web.Security.Membership.Initialize() at System.Web.Security.Membership.get_Providers() at Microsoft.SharePoint.Utilities.SPMembershipProviderPrincipalResolver.get_Provider() at Microsoft.SharePoint.Utilities.SPMembershipProviderPrincipalResolver.SupportsPrincipal(SPPrincipalType scopes, SPPrincipalSource sources) at Microsoft.SharePoint.Utilities.SPUtility.ResolvePrincipalInternal(SPWeb web, SPWebApplication webApp, Nullable`1 urlZone, String input, SPPrincipalType scopes, SPPrincipalSource sources, SPUserCollection usersContainer, Boolean inputIsEmailOnly, Boolean alwaysAddWindowsResolver).

01/11/2007 17:00:08.97 w3wp.exe (0x1324) 0x11F0 Windows SharePoint Services General 72e7 Medium Error in searching user 'ebruser' : System.Configuration.ConfigurationErrorsException: Exception has been thrown by the target of an invocation. (C:\Inetpub\wwwroot\wss\VirtualDirectories\20277\web.config line 136) at System.Web.Security.Membership.Initialize() at System.Web.Security.Membership.get_Providers() at Microsoft.SharePoint.Utilities.SPMembershipProviderPrincipalResolver.get_Provider() at Microsoft.SharePoint.Utilities.SPMembershipProviderPrincipalResolver.SupportsPrincipal(SPPrincipalType scopes, SPPrincipalSource sources) at Microsoft.SharePoint.Utilities.SPUtility.SearchPrincipalFromResolvers(List`1 resolvers, String input, SPPrincipalType scopes, SPPrincipalSource sources, SPUserCollection usersContainer, Int32 maxCount, Boolean& reachMaxCount, Dictionary2 usersDict).

But my dll is registered in app as well as in admin web.config at two locations:

also at following place:

Same DLL is in GAC also.

It is not recognizing SPMembership from central admin, but going to code in debug mode while i tried to login (in ValidateUser(...)).

Please let me know ur more inputs.

Thanks,

Abhi

Re: Custom Membership Provider User Rights Issue

amolthombre — Thu, 11 Jan 2007 10:59:03 GMT

Hi,

I tried with the both the points mentioned above

1. Goto Application Management -> Site Collection Administrator, try to add your user as a site collection administrator, (For this you must have implemented Membership Provider methods like Getuserbyname, getuserbyemail, getallusers etc). If it resolves user name then there will be no problem. If it does not resolve the user name (shows red underline) then goto following step 2.

It does not resloves username

2. Check latest logs from C:\Program Files\Common Files\Microsoft Shared\Web Server Extension\12\Logs. You will find so many logs there, just take the latest (provided you tried to add user latest). Find out the latest action by time so that you can reach to the exact error. This log will give you exact error. Check and error and see if you could resolve that error. If yes, then no problem, if no then try to post that error from Log here so that we can answer.

I got the following error in the log file.

“Error in resolving user 'snehal' : System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.SharePoint.Utilities.SPMembershipProviderPrincipalResolver.ResolvePrincipal(String input, Boolean inputIsEmailOnly, SPPrincipalType scopes, SPPrincipalSource sources, SPUserCollection usersContainer) at Microsoft.SharePoint.Utilities.SPUtility.ResolvePrincipalInternal(SPWeb web, SPWebApplication webApp, Nullable`1 urlZone, String input, SPPrincipalType scopes, SPPrincipalSource sources, SPUserCollection usersContainer, Boolean inputIsEmailOnly, Boolean alwaysAddWindowsResolver).”