[imp] oracle table definitions for imp 2.3.x?

liamr@umich.edu liamr@umich.edu
Tue, 21 Aug 2001 18:52:32 -0400


After doing a CVS update...

I'm curious where it's getting / storing the "Last Login" information, cuz it 
isn't getting stored in my oracle database.

Thought some other people might like to know what to set to make it talk to 
oracle 8i.

Here's what I've added to my horde/config/horde.php...:

$conf['prefs']['driver'] = 'sql';
$conf['prefs']['params'] = array();
$conf['prefs']['params']['phptype'] = 'oci8';
$conf['prefs']['params']['hostspec'] = 'mojojojo.world';
$conf['prefs']['params']['protocol'] = '';
$conf['prefs']['params']['username'] = 'hordemgr';
$conf['prefs']['params']['password'] = 'horde';
$conf['prefs']['params']['database'] = '';
$conf['prefs']['params']['table'] = 'horde_prefs';
$conf['prefs']['params']['options'] = '';
$conf['prefs']['params']['tty'] = '';
$conf['prefs']['params']['port'] = '';

which corresponds to this entry in my tnsnames.ora:
####################################################################
# Server:  mojojojo.blah.blah.umich.edu  Instances: DFLT
####################################################################
MOJOJOJO.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS =
        (COMMUNITY = tcp.world)
        (PROTOCOL = TCP)
        (HOST = mojojojo.blah.blah.umich.edu)
        (PORT = 1521)
      )
    )
    (CONNECT_DATA =
      (SID = DFLT)
      (GLOBAL_NAME = mojojojo.world)
    )
  )

I mainly pass this on because I'd have expected that I should have set the 
database instance in $conf['prefs']['params']['database'] instead of 
$conf['prefs']['params']['hostspec'].. because the stuff for phplib and horde 
1.2.2 looks like...

local.inc:

class HordeDB extends DB_Sql {
  var $Host = '';
  var $Database = 'mojojojo.world';
  var $User = 'horde';
  var $Password = 'hordemgr';
  var $Port = '';

Anyhooo....
Seems to handle the imp preferences just dandy.  Thanks for making the field 
names "safe", Chuck.

Liam