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.
