Hi Tristan
For one thing, you will need to set up datasource in CF Admin and point that
to your upsized userDirectory
Also go into the ODBC Datasource under Control Panel and change the settings
as well
Need to stop-start all cf and siteminder services
Hope this helps
cheers
wai leng
----- Original Message -----
From: Tristan Roddis <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 02, 2000 9:50 PM
Subject: Siteminder caching (was RE: Problems with moving the user directory
to SQLServer)
> Well, we finally managed to get the userdirectory out of Access and over
to
> SQLServer - and we got around the problem of database connections by
> switching from SQLServer authentication (woes detailed below) to NT
> authentication for the database login (thanks to Richard Ragan for this
one:
> searching through past messages it turns out he'd already come across
this).
>
> However, we have since been unable to get this working again on other
> machines due BLOODY SITEMINDER CACHING. It seems that although we have
> repointed the data source to look at SQLServer, siteminder is *still*
> checking the old database. And no amount of restarting the services (and
> even rebooting the machine) seems to shift it.
>
> Does anybody have any tips for how to get siteminder to recognise the new
> data source?
>
> Many thanks,
>
> -Tristan.
>
> > > > ----- Original Message -----
> > > > From: Tristan Roddis <[EMAIL PROTECTED]>
> > > > To: <[EMAIL PROTECTED]>
> > > > Sent: Wednesday, July 26, 2000 7:28 AM
> > > > Subject: Problems with moving the user directory to SQLServer
> > > >
> > > >
> > > > > Folks,
> > > > >
> > > > > I wonder if anybody would be able to help me with the
> > > > following problem.
> > > > >
> > > > > We recently tried to 'upsize' our user directory from
> > > > Access to SQLServer
> > > > > 7.0 by following the instructions in KB Article # 14566
> > > > >
> > > > (http://www.allaire.com/Handlers/index.cfm?ID=14566&Method=Ful
> > > > l). However,
> > > > > although the policy store is now sitting there happily (and
> > > > the 'test ODBC
> > > > > connection' works fine from smconsole.exe), and coldfusion
> > > > will happily
> > > > > insert users to the directory table, we cannot get anything
> > > > out of the
> > > > user
> > > > > directory using siteminder. This appears to be because
> > siteminder is
> > > > trying
> > > > > to log in as the (invalid) user '\' according to the debug log:
> > > > >
> > > > > -----------------------------------------
>
> > > > > [26/Aug/2000:13:08:47 0000][300-SmServAuth] User directory
> > > > 'userDirectory'
> > > > > can not be contacted
> > > > > [26/Aug/2000:13:08:47 0000][300-I] ** Status r# 1/5 :
> > Authentication
> > > > Attempt
> > > > > Failed.
> > > > > [26/Aug/2000:13:08:48 0000][300-I] req r# 1/6 > 200 : 'CFSM'
> > > > > [26/Aug/2000:13:08:48 0000][300-I] req r# 1/6 > 208 : ''
> > > > > [26/Aug/2000:13:08:48 0000][300-I] req r# 1/6 > 204 :
> > > > > '06-5cd88360-618c-11d4-a6c9-00d0b72a137f'
> > > > > [26/Aug/2000:13:08:48 0000][300-I] req r# 1/6 > 210 :
> > > > > 'FC558595621D11D4A6CA00D0B72A137F'
> > > > > [26/Aug/2000:13:08:48 0000][300-I] req r# 1/6 > 211 : '**
> > > > Not Shown **'
> > > > > [26/Aug/2000:13:08:48 0000][300-SmObjProvider] Fetching
> > > > object 'Realm'
> > > > > 06-5cd88360-618c-11d4-a6c9-00d0b72a137f
> > > > > [26/Aug/2000:13:08:48 0000][300-SmObjProvider] Fetching property
> > > > > 'UserDirectories' of object 'Domain'
> > > > 03-5cd88352-618c-11d4-a6c9-00d0b72a137f
> > > > > [26/Aug/2000:13:08:48 0000][300-SmObjProvider] Fetching object
> > > > > 'UserDirectory' 0e-f8e954a0-618a-11d4-a6c9-00d0b72a137f
> > > > > [26/Aug/2000:13:08:48 0000][300-SmDs] Directory 'userDirectory'
> > > > > [26/Aug/2000:13:08:48 0000][300-E] Failed to connect to
> > > > ODBC data source
> > > > > 'userDirectory. Login failed for user '\'.
> > > > >
> > > > > [26/Aug/2000:13:08:48 0000][300-SmServAuth] User directory
> > > > 'userDirectory'
> > > > > can not be contacted
> > > > > [26/Aug/2000:13:08:48 0000][300-I] ** Status r# 1/6 :
> > Authentication
> > > > Attempt
> > > > > Failed.
> > > > > -----------------------------------------
> > > > >
> > > > > Has anybody on the planet ever managed to get their user
> > > > directory in to
> > > > > SQLServer? And if so, do you have any pointers?
> > > > >
> > > > > Thanks,
> > > > >
> > > > > -Tristan.
> > > > >
> > > > --------------------------------------------------------------
> > > > ------------
> > > > ----
> > > > > To Unsubscribe visit
> > > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> > > s/spectra_talk
> > > or send a message to [EMAIL PROTECTED] with
> > > 'unsubscribe' in the body.
> > >
> > > ------------------------------------------------------------------
> > > ----------
> > > --
> > > To Unsubscribe visit
> > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/sp
> > ectra_talk
> > or send a message to [EMAIL PROTECTED] with
> > 'unsubscribe' in the body.
> > --------------------------------------------------------------
> > ----------------
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> s/spectra_talk or send a message to [EMAIL PROTECTED]
> with 'unsubscribe' in the body.
>
> --------------------------------------------------------------------------
--
> --
> 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.
> --------------------------------------------------------------------------
----
> 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.
------------------------------------------------------------------------------
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.
