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.