locked
Unable to perform Forms Authentication with MYSQL RRS feed

  • Question

  • I've been asked to fulfill a requirement for the company where I have to create a Sharepoint portal and the users have to be authenticated via existing data store in MySQL, i.e. FBA with MySQL.

     

    We first tried connecting to the data store via a test ASP.NET website and were able to successfully authenticate with a pre-existing username and password after creating a custom membership provider and role provider using

     http://www.codeproject.com/KB/database/mysqlmembershipprovider.aspx?msg=3112859

    which we successfully tested in our test ASP.NET website. 

     

    Now, we followed steps from Andrew's blog -

    http://www.andrewconnell.com/blog/articles/HowToConfigPublishingSiteWithDualAuthProvidersAndAnonAccess.aspx

    Here we only want the FBA for one website and not dual authentication. 

     

    We made the requisite changes in the web config of both the website and the Central Administration Site.

     

    Snippet from the web.config -

     

    /SharePoint>
    
    	<connectionStrings>
    
    		<add name="ConnString" connectionString="Server=solar.mkcl.org;Database=erp;Uid=reader;Pwd=reader#@!;" providerName="MySql.Data.MySqlClient"/>
    
    		
    
    	</connectionStrings>
    
     <system.web>
    
    	 <membership defaultProvider="MySqlMembershipProvider" userIsOnlineTimeWindow="15">
    
    		 <providers>
    
    			 <clear/>
    
    			 <add name="MySqlMembershipProvider" type="MySqlMembershipProvider" connectionStringName="ConnString" applicationName="Shopping" enablePasswordRetrieval="false" enablePasswordReset="false" requiresQuestionAndAnswer="false" requiresUniqueEmail="false" passwordFormat="Hashed" writeExceptionsToEventLog="true"/>
    
    		 </providers>
    
    	 </membership>
    
    	 <roleManager >
    
    		 <providers>
    
    			 <clear/>
    
    			 <add name="MySqlRoleProvider" type="MySqlRoleProvider" connectionStringName="ConnString" applicationName="Shopping" writeExceptionsToEventLog="true"/>
    
    		 </providers>
    
    	 </roleManager>
    
     </system.web>
    
    

     

     

    When we enabled Anonymous access for the our site collection, we could log into the Sharepoint site (http://intranet) using the username and password already present in the MySQL database. So, the MySQL connector is working fine. 

     

    Now, we did the above changes for the Central Administration site too. When we tried to assign "Site Collection Administrators" permission to a user from the data store, the name does not get resolved on clicking the small blue

    Please advise on how to proceed! 

     

    Thanks in advance

    • Edited by Mike Walsh FIN Thursday, February 10, 2011 2:49 PM pressure removed
    Thursday, February 10, 2011 12:30 PM