shibboleth-dev - RE: Testing ODBC store
Subject: Shibboleth Developers
List archive
- From: "Scott Cantor" <>
- To: <>
- Subject: RE: Testing ODBC store
- Date: Fri, 14 Dec 2007 10:35:22 -0500
- Organization: The Ohio State University
> - some data type adjustement to the storage creation sql:
> datetime -> date, text -> clob (this because I dont't know what can be
> the maximum size of the field "value" in table "texts", otherwise I'd
> used varchar);
The text type is used because those operations don't impose any size limits
(beyond what's practical to store). Usually there's a "long text" type of
some sort that isn't exactly a blob, but I'm not familiar with Oracle.
Did you have to change code at all?
> - tell shibd to use the environment vars needed by Oracle Instant Client
> (ORACLE_HOME and TNS_ADMIN).
Are there any other mechanisms for supplying that information? If it could
be done programmatically somehow, we could work out some kind of secondary
plugin model.
> I've had to modify the init script to
> have it export these vars, and start the daemon with "su -p" instead
> of "su -". Do you think there can be a better method for doing this?
> Other daemons on redhat-like systems uses /etc/sysconfig/daemon to
> define the vars and include it from the init script.
I don't think that's particularly any better myself, I'd just as soon have a
single script to deal with, but there's no reason you can't do that if you
want to.
Thanks again,
-- Scott
- Testing ODBC store, giacomo tenaglia, 12/06/2007
- RE: Testing ODBC store, Scott Cantor, 12/06/2007
- Re: Testing ODBC store, giacomo tenaglia, 12/14/2007
- RE: Testing ODBC store, Scott Cantor, 12/14/2007
- <Possible follow-up(s)>
- Re: Testing ODBC store, giacomo tenaglia, 12/08/2007
- RE: Testing ODBC store, Scott Cantor, 12/08/2007
- Re: Testing ODBC store, giacomo tenaglia, 12/10/2007
- RE: Testing ODBC store, Scott Cantor, 12/10/2007
- RE: Testing ODBC store, Scott Cantor, 12/10/2007
- Re: Testing ODBC store, giacomo tenaglia, 12/18/2007
Archive powered by MHonArc 2.6.16.