I should have mentioned,
There is an extra quote, which needs to be deleted, at the end of the line
for Get User/Group Info:
If anyone else wants to use this data for a userdirectory
spike
At 19:29 03/04/2001 Tuesday, you wrote:
>Thanks Peter,
>
>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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> >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:[EMAIL PROTECTED]]
> >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:[EMAIL PROTECTED]]
> > > >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 : [EMAIL PROTECTED]
> > > > > >ICQ UIN : 3679482
> > > > > >
> > > > > >"My ally is the Force, and a powerful ally it is." - Yoda
> > > > > >
> > > > > > > -----Original Message-----
> > > > > > > From: Spike [mailto:[EMAIL PROTECTED]]
> > > > > > > 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: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> > > > > > > "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 [EMAIL PROTECTED] with 'unsubscribe' in the body.
