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.