Skip to Content.
Sympa Menu

shibboleth-dev - RE: Testing ODBC store

Subject: Shibboleth Developers

List archive

RE: Testing ODBC store


Chronological Thread 
  • 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





Archive powered by MHonArc 2.6.16.

Top of Page