[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