[imp] Help Installing IMP-2.3

Max Kalika max@the-triumvirate.net
Wed, 15 Nov 2000 19:23:46 -0800


Quoting ted <ted@rkl.com>:

> can someone direct me to a  MySQL table schema for the current
> Hored-1.2x-cvs and IMP-2.3.x-cvs? I can not find one.

You mean Horde-1.3 cvs, right?

Well, there are two tables you _may_ need for IMP.  I say may because they are 
not required, unless you want to track preferences (and filters) and/or 
connections (login screens for security purposes).

You can find both schemas in horde/lib/Prefs/mysql.php and 
horde/lib/Connection/mysql.php respectively.  Here is what they look like in 
their current state (they may change in the future).

Prefs:

  create table user_webmail_prefs (
      uid             char(32) not null,
      pref_name       char(32) not null,
      pref_value      text null,
      primary key (uid, pref_name)
  );

and to make it work, you'll need to configure imp in horde/imp/config/conf.php: 
(of course, changing whatever values are appropriate)

$conf['prefs'] = array();
$conf['prefs']['driver'] = 'mysql';
$conf['prefs']['params'] = array();
$conf['prefs']['params']['hostspec'] = 'localhost';
$conf['prefs']['params']['username'] = 'horde';
$conf['prefs']['params']['password'] = '*****';
$conf['prefs']['params']['database'] = 'horde';
$conf['prefs']['params']['table'] = 'user_webmail_prefs';

As well as that you may want to take a look at horde/imp/config/prefs.php for 
further enabling/disabling of various preference options.

As far as Connections go here's the table definition:

  create table connections (
      addr        varchar(8)  not null,
      conn_id     varchar(32) not null,
      conn_ts     int(14)     not null,
      primary key (addr, conn_id)
  );

And in horde/imp/config/conf.php: (again, changing values according to your 
configuration)

$conf['connections']['track'] = true;
$conf['connections']['driver'] = 'mysql';
$conf['connections']['params'] = array();
$conf['connections']['params']['hostspec'] = 'localhost';
$conf['connections']['params']['username'] = 'horde';
$conf['connections']['params']['password'] = '*****';
$conf['connections']['params']['database'] = 'horde';
$conf['connections']['params']['table'] = 'connections';

> I have upgraded to php-403pl1 and I wold like very much to get
> Horde/IMP/Jonah

Just FYI...you will need the latest php4 cvs to be able to run horde/imp cvs

> ps. do I need a table shema for Jonah too? (if so, I kneed that one
> aswell)

Sorry, I know nothing of Jonah. :-)

Good luck!

--mk23