Apart from the cfauthenticate problem and horribly kludged fix everything works now.

spike

At 18:07 03/04/2001 Tuesday, you wrote: >Sorry, > >Thought I could attach. > >Watch the syntax, I know this formatting isn't pretty. > >- peter > >**************************************************************************** >***** >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' >**************************************************************************** >**** > >-----Original Message----- >From: pwatson@macromedia.com [mailto:pwatson@macromedia.com] >Sent: Tuesday, April 03, 2001 11:47 AM >To: Spectra-Talk >Subject: RE: Spectra and cf 5.0 beta 3 > > >Attached is a text file with the Cf 5.0 ODBC settings for the Spectra user >directory. > > > > > >-----Original Message----- >From: Spike [mailto:Spike@zen2000.com] >Sent: Tuesday, April 03, 2001 7:09 AM >To: Spectra-Talk >Subject: RE: Spectra and cf 5.0 beta 3 > > >David, > >Can you post the strings you used from the 4.5 install. > >I tried playing around with this a bit with no success. > >There seemed to be quite a few extra ones in the interface for 5.0. > >I am also finding the same problem with the authentication cookie. > >You can, of course create your own encrypted cookie containing security >context, username and password and put a cfauthenticate tag at the top of >the application.cfm and pass the decrypted values in as attributes. > >It's an awful hack, but it works. > >The problem I am hitting now is that the cfa_userget tag expects the old >userdirectory structure with username and groupname as fields. So if you >could post the strings you used I should be able to use the old >userdirectory and have a fully working webtop. > >spike > >At 23:23 02/04/2001 Monday, you wrote: > >Peter - > > > >Is the reason you need to use SmSampleUsers.mdb instead of Spectra's > >UserDirectory.mdb because of the SQL queries associated with the UD for > >InitUser, GetUserProp, etc (all of the stuff at the bottom of the page)? > > > >I updated this on my userdirectory definition with the appropriate strings > >from the SmDsQuery.ini file from a 4.5 installation, and I was able to get > >the userdirectory.mdb database to work. > > > >Still haven't worked out the cookie/authentication issues, though. > > > >-- David > > > >At 05:06 PM 4/2/2001 Monday, you wrote: > > >David, Spike & All, > > > > > >I've been working on Spectra 1.5 and CF 5.0 compatibility. > > >We have new Netegrity Siteminder (v 4.11) bits w/ cf 5.0 -so there are a >few > > >issues to work out. > > > > > >I was able to get Spectra 1.5 up and running w/ Beta 2 on Solaris without >to > > >much effort. > > >(*Advanced Security was not available for NT) > > > > > >With NT we've been running into some issues w/ ODBC policy store >migrations > > >(*see beta 3 release notes for details) > > >and also with ODBC userdirectories (I'm currently debugging this one). > > >Something with the default spectra user directory is causing the >problems. > > > > > > > > >To get around this and get the webtop up do the following: > > >(*** obviously a hack - we are working to resolve the issues) > > > > > >BASICALLY WHAT YOU NEED TO DO IS POINT "UserDirectory" TO ANOTHER ACCESS > > >DATABASE: > > > > > >1. Go into the cfadmin/ advanced security and turn off all caches - then > > >click "apply changes" > > > > > >2. under "Flush ColdFusion and Security Server Caches" click "purge all". > > > (** This is a cool enhancement for cf 5.0 that saves you from having >to > > >cycle the services while debugging) > > > > > >3. click on user directories and select UserDirectory > > > > > >4. change the location from UserDirectory to smsampleusers and click >apply > > > (** this is the test .mdb user directory that ships w/ CF - should >be > > >listed under ODBC datasources) > > > > > >5. Change the URL of the config wizard to: > > > http://127.0.0.1/allaire/spectra/install/index.cfm?step=5 > > > > > >6. select "Launch the Allaire Spectra Webtop" > > > > > >7. login with username=admin password=siteminder > > > *** you can modify the admin username and password by going directly >to > > >the Access database located at: > > > C:\cfusion\database\smsampleusers.mdb - just modify the smuser >table. > > > > > >This will skip all of the UserDirectory specific steps and allow you to > > >login to the webtop. > > >The configuration wizard is being updated for compatibility w/ CF 5.0 and >I > > >will post any fixes to this thread going forward. > > > > > >Also note that the Spectra collections creation step will be skipped. We > > >are also working with new verity binaries and need to resolve a few >issues. > > > > > >regards, > > >peter watson > > >cf & spectra qa > > > > > >-----Original Message----- > > >From: David An [mailto:davida@mindseye.com] > > >Sent: Monday, April 02, 2001 4:00 PM > > >To: Spectra-Talk > > >Subject: RE: Spectra and cf 5.0 beta 3 > > > > > > > > >Hi Spike - > > > > > >I'm having the same problems :) > > > > > >I've got it narrowed down to the IsAuthenticated()/AuthenticatedUser() > > >functions. > > > > > >Try this on a CF4.5/Spectra 1.5 box ... > > >#IsAuthenticated()# > > ><cfa_authenticate ... (stuff) > > > >#IsAuthenticated()# > > > > > >load the page twice ... you'll see that the second load, IsAuthenticated > > >returns true even before you've cfa_authenticated ... it's reading that > > >from the cfauth cookie (right?) > > > > > >Then try the same code on CF5.0b3/Spectra 1.5 ... you never return true > > >based on your cookie. Thus, the whole cfa_secure tag is hosed and you > > >can't get anywhere in the webtop. > > > > > >-- David > > > > > >At 09:21 PM 4/2/2001 Monday, you wrote: > > > >At 21:14 02/04/2001 Monday, you wrote: >Did you install Spectra _after_ CF 5 b3? > > > > > > > >Nope... > > > > > > > >Am I a stoopid person for not reading the manual? > > > > > > > > >Go into your advanced security settings and double check that SC1 is > > >using >"UserDirectory" as the user directory. >Go to ODBC and confirm UserDirectory points to the mdb file Spectra >installs. >Open the MDB file and confirm your username/password are in there. > > > > > > > >I've done all of these things and everything checks out fine. > > > > > > > > > > > > > >======================================================================= >Raymond Camden, Principal Spectra Compliance Engineer for Macromedia > >Email : jedimaster@macromedia.com >ICQ UIN : 3679482 > >"My ally is the Force, and a powerful ally it is." - Yoda > > > -----Original Message----- > > From: Spike [mailto:spike@zen2000.com] > > Sent: Monday, April 02, 2001 3:01 PM > > To: Spectra-Talk > > Subject: Spectra and cf 5.0 beta 3 > > > > > > Hi all, > > > > Has anyone managed to get Spectra working on Beta3? > > > > I have been mucking around with it all day and have got the >security > > context working fine, but the webtop says that the username and > > >password > > I'm using doesn't correspond with a valid user. > > > > I'm using Spectra 1.5 on Win2k with an odbc database as the user > > directory. > > > > Spike > > > > Stephen Milligan > > Internet Developer and Allaire training guru > > Tel: +34 686 021171 > > ICQ: 15831735 > > Email: spike@spike.org.uk <mailto:spike@spike.org.uk> > > "A good developer is the type of person who looks both ways on an >one > > >way > > street!" > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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 spectra-talk-request@houseoffusion.com with 'unsubscribe' in the body.