[turba] SQL based distribution list (Turba 1.2)

[fabricio bianco abreu]

Hi folks, 
 
I am having some trouble to set up distribution lists support in Turba 1.2. 
I was previously running Turba 1.1. 
 
In my Turba instalation users already have theier "Personal Address Book" in 
MySQL. So, I would like to set up such distribution list support based on 
MySQL tables. 
 
Can anybody send me a "howto" to do it? 
 
I have followed the "INSTALL" and "UPDATE" directions.  
 
Bellow you will find some "debug" information so that you can understand my 
situation. 
 
Thaks in advance. Best regards, 
--  
Fabricio Bianco Abreu  
Tribunal de Contas do DF  
Telefone/Phone +55-61-314-2236  
 
 
------------------------------------------------------------ 
Here are my MySQL Horde database tables for Turba: 
 
mysql> show tables; 
+-----------------------------+ 
| Tables_in_horde             | 
+-----------------------------+ 
| horde_categories            | 
| horde_categories_categories | 
| horde_prefs                 | 
| horde_users                 | 
| kronolith_events            | 
| kronolith_events_seq        | 
| nag_tasks                   | 
| turba_objects               | 
+-----------------------------+ 
8 rows in set (0.24 sec) 
 
mysql> desc turba_objects; 
+--------------------+--------------+------+-----+---------+-------+ 
| Field              | Type         | Null | Key | Default | Extra | 
+--------------------+--------------+------+-----+---------+-------+ 
| object_id          | varchar(32)  |      | PRI |         |       | 
| owner_id           | varchar(255) |      | MUL |         |       | 
| object_name        | varchar(255) | YES  |     | NULL    |       | 
| object_alias       | varchar(32)  | YES  |     | NULL    |       | 
| object_email       | varchar(255) | YES  |     | NULL    |       | 
| object_homeaddress | varchar(255) | YES  |     | NULL    |       | 
| object_workaddress | varchar(255) | YES  |     | NULL    |       | 
| object_homephone   | varchar(25)  | YES  |     | NULL    |       | 
| object_workphone   | varchar(25)  | YES  |     | NULL    |       | 
| object_cellphone   | varchar(25)  | YES  |     | NULL    |       | 
| object_fax         | varchar(25)  | YES  |     | NULL    |       | 
| object_title       | varchar(255) | YES  |     | NULL    |       | 
| object_company     | varchar(255) | YES  |     | NULL    |       | 
| object_notes       | text         | YES  |     | NULL    |       | 
| object_type        | varchar(255) |      |     | Object  |       | 
| object_members     | blob         | YES  |     | NULL    |       | 
+--------------------+--------------+------+-----+---------+-------+ 
16 rows in set (0.03 sec) 
 
 
--------------------------------------------------------- 
My sources.php for Turba is also listed bellow. 
 
$cfgSources['TCDF'] = array( 
    'title' => 'Tribunal de Contas do DF', 
    'type' => 'ldap', 
    'params' => array( 
        'server' => 'direto.tc.df.gov.br', 
        'port' => 389, 
        'root' => 'ou=people,o=tcdf,c=BR', 
        'dn' => array('cn'), 
        'objectclass' => 'person', 
        'filter' => '' 
    ), 
    'map' => array( 
        '__key' => 'dn', 
        'name' => 'cn', 
        'email' => 'mail', 
        'alias' => 'cn' 
    ), 
    'search' => array( 
        'name', 
        'email' 
    ), 
    'strict' => array( 
        'dn' 
    ), 
    'public' => true, 
    'readonly' => true, 
    'export' => false 
); 
 
/** 
 * A local address book in an SQL database. This implements a per-user 
 * address book. 
 * 
 * Be sure to create a turba_objects table in your Horde database 
 * from the schema in turba/scripts/drivers/turba.sql if you use 
 * this source. 
 */ 
*/ 
$cfgSources['localsql'] = array( 
    'title' => 'Meu Catálogo de Endereços', 
    'type' => 'sql', 
    'params' => array( 
        'phptype' => 'mysql', 
        'hostspec' => 'localhost', 
        'username' => 'horde', 
        'password' => 'secret password', 
        'database' => 'horde', 
        'table' => 'turba_objects' 
    ), 
    'map' => array( 
        '__key' => 'object_id', 
        '__owner' => 'owner_id', 
        '__type' => 'object_type', 
        '__members' => 'object_members', 
        'name' => 'object_name', 
        'email' => 'object_email', 
        'homeAddress' => 'object_homeaddress', 
        'workAddress' => 'object_workaddress', 
        'homePhone' => 'object_homephone', 
        'workPhone' => 'object_workphone', 
        'cellPhone' => 'object_cellphone', 
        'fax' => 'object_fax', 
        'title' => 'object_title', 
        'company' => 'object_company', 
        'notes' => 'object_notes' 
    ), 
    'search' => array( 
        'name', 
        'email' 
    ), 
    'strict' => array( 
        'object_id' 
    ), 
    'public' => false, 
    'readonly' => false, 
    'admin' => array(), 
    'export' => true 
 
 
 

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/