Chris, Thanks, this seems to be the workable solution. I've setup the views in the external database and added the script to "_serverSpecificVarsAfterInit.cfm" and can now search those users via the farcry admin area (security >user management > user search). However, I'm still unable to login using one of those external member logins. How will this work if I can't populate the dmGroup view?
--Kevin On Oct 31, 7:15 pm, Chris Kent <[EMAIL PROTECTED]> wrote: > Forgot to add, once done you can use the dmGroups created in the > external DB view to set Farcry permissions and users can login as if > their dmUser had been created directly in Farcry. > > You can view these groups/users in the security admin of Farcry but > you can not maintain them. > > These users/groups are in addition to any that you maintain within the > main Farcry clientUD. > > Chris. > > On Oct 31, 11:09 pm, Chris Kent <[EMAIL PROTECTED]> wrote: > > > > > 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. > > > Seehttp://docs.farcrycms.org:8080/confluence/display/FCDEV30/Authenticat... > > 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- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
