Just in case anyone else is trawling the lists looking for a short answer to
installing Spectra 1.5 and cf 5.0 beta 3 together, this is what I found:
CF 5.0 occasionally has some install problems with advanced security etc
(this includes the message that the MFC components are missing etc) unless
you install it OVER THE TOP OF A PREVIOUS VERSION OF CF.
Make sure you install spectra AFTER installing CF 5.0
If you have problems with the security checks in the configuration wizard
for spectra, or logging in to the webtop, do this:
check CFAdmin advanced security to see that security context sc1 exists
make sure sc1 has the user directory "UserDirectory" assigned to it
make sure UserDirectory has "ODBC" selected as the namespace, and
"UserDirectory" as the location.
check that the file UserDirectory.mdb exists in your <spectra install
path>\database
check that the user you're attempting to log in as is in the database.
***** important *****
there were a couple of solutions posted to the list about getitng the user
directory to work - I don't know about anyone else but I couldn't get it to
work simply by pointing UserDirectory to the SmSampleUsers db. What I did
instead was:
Goto CFADMIN | SECURITY | ADVANCED SECURITY (SECURITY CONFIGURATION)
click the Userdirectories button
click the link for UserDirectory
COPY AND PASTE THE SQL STRINGS (thanks to Peter Watson) IN THE RELEVANT
FIELDS
UNDER "ODBC SETTINGS"
Enumerate: select UserName as Name, 'User' as Class from Users Union
select
GroupName as Name, 'Group' as Class from Groups order by Class
Lookup: select UserName, 'User' as Class from Users where UserName %s
Union select UserName, 'Group' as Class from Groups where UserName %s order
by Class
Lookup Users: select UserName, 'User' as Class from Users where %s
Lookup Groups: select UserName, 'Group' as Class from Groups where %s
Get User/Group Info: select UserName as Name, 'User' from Users where
UserName = '%s' Union select GroupName as Name, 'Group' from Groups where
GroupName = '%s'"
Init User: select UserName as Name from Users where UserName = '%s'
Authenticate User: select UserName as Name from Users where UserName =
'%s' and Password = '%s'
Is Group Member: select GroupName from Users_Groups where UserName = '%s'
and GroupName = '%s'
Get User Groups: select Groups.GroupName as Name from Groups, Users_Groups
where Users_Groups.UserName = '%s' and Groups.GroupName =
Users_Groups.GroupName
Get User Properties: UserName, Description
Get User Property: select %s from Users where UserName = '%s'
Set User Property: update Users set %s = %s where UserName = '%s'
Get Group Properties: select GroupName, Desciption from Group
Get Group Property: select %s from Groups where UserName = '%s'
Set Group Property: update Groups set %s = %s where UserName = '%s'
clear caches and restart services and all should be good from here on.
HTH
Toby
Toby Tremayne
Code Poet and Zen Master of the Heavy Sleep
Show Ads Interactive
359 Plummer St
Port Melbourne
VIC 3207
P +61 3 9245 1247
F +61 3 9646 9814
ICQ UIN 13107913
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
