Shibboleth Developers

[giacomo tenaglia <>]

On Thu, Dec 06, 2007 at 04:08:51PM +0100, giacomo tenaglia wrote:
> In the next days I will test an Oracle backend.

Hi,
I got the ODBC store to work with Oracle Instant Client ODBC. I've
tested it on this environment:
- 32bit QEMU virtual machine (I think it's an emulated pII);
- OS Scientific Linux CERN 4;
- unixODBC version 2.2.11-1.RHEL4.1;
- Oracle Instant Client Basic version 10.2.0.3-1 (from otn.oracle.com);
- Oracle Instant Client ODBC plugin version 10.2.0.3-20061115 (from
  otn.oracle.com).

I run into a few issues I'm reporting here:

- 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);
- tell shibd to use the environment vars needed by Oracle Instant Client
  (ORACLE_HOME and TNS_ADMIN). 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.

Now I'm moving on real machines in order have some more intense testing.

giacomo

-- 
giacomo tenaglia
Technical Student at CERN IT/DES-SIS
CNR Biblioteca d'Area di Bologna - http://biblio.bo.cnr.it
Phone +41 76 5003376 - 
sip: