Kevin, I have done this on a number of sites to pull in usernames/passwords from external DBs. It is very simple.
Create views in your external DB called dmUser, dmgroup and dmUserToGroup the data in these views will be based on the users in your external DB, you must have the same column names. Then, in _serverSpecificVarsAfterInit.cfm add the following: <!--- dmSec User Directory setup ---> <cfscript> // External Authentication Client User Directory application.dmSec.UserDirectory.customerUD = structNew(); // choose a unique struct name in place of 'myUD' temp = application.dmSec.UserDirectory.customerUD; temp.type = "Daemon"; // the type MUST be "Daemon" when using a SQL database temp.datasource = "yourExternalDBDataSource"; // the name of the ColdFusion DSN created previously </cfscript> You can use "customerUD" or anything other than "clientUD" this is how you refer to the new user directory within Farcry. See http://docs.farcrycms.org:8080/confluence/display/FCDEV30/Authentication+Using+an+Existing+MSSQL+Application in the WIKI. It is written for V3 but is still valid for V4 - the only difference is to place the code above in _serverSpecificVarsAfterInit.cfm and not _dmSecUserDirectories.cfm Chris. On Oct 31, 8:50 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > I currently have Farcry 4.0.3 installed using MS SQLServer 2000. > > Our client has a MSSQL Server database that contains all of their > membership data (name, emails, usernames, passwords, etc.) We need to > be able to use our client's database to authenticate members accessing > info to the website if it is password protected. > > I saw the article "Authentication Using an Existing MSSQL > Application", but this option requires three specific tables to be > created in the external database (dmUser, dmGroup, & dmUserToGroup), > we need the ability to use the eisting DB structure. > > I also saw info about setting up an Active Directory, but it was based > on Farcry version 3. Any help in this matter is appreciated. Thanks. > > --Kevin --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
