[imp] MySQL Setup

[Max Kalika]

Quoting Joerg Werner <jwerner@gandalf.physik.uni-konstanz.de>:

> I just grabbed and installed horde/imp from the CVS (Version 2.3.6-cvs).
> What do i have to do to setup MySQL for working with imp? Is this still
> necessary?

For preferences:

 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 in imp/config/conf.php

/* Preference System Settings */
$conf['prefs'] = array();
$conf['prefs']['driver'] = 'sql';
$conf['prefs']['params'] = array();
$conf['prefs']['params']['phptype'] = 'mysql';
$conf['prefs']['params']['hostspec'] = 'localhost';
$conf['prefs']['params']['username'] = 'user';
$conf['prefs']['params']['password'] = 'pass';
$conf['prefs']['params']['database'] = 'horde';
$conf['prefs']['params']['table'] = 'user_webmail_prefs';

And for connection tracking:

 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 imp/config/conf.php

/* Connection Tracking */
$conf['connections']['track'] = true;
$conf['connections']['driver'] = 'sql';
$conf['connections']['params'] = array();
$conf['connections']['params']['phptype'] = 'mysql';
$conf['connections']['params']['hostspec'] = 'localhost';
$conf['connections']['params']['username'] = 'user';
$conf['connections']['params']['password'] = 'pass';
$conf['connections']['params']['database'] = 'horde';
$conf['connections']['params']['table'] = 'connections';


--mk23