[turba] SQL based distribution list (Turba 1.2)
fabricio bianco abreu
fabricio at tc.df.gov.br
Mon May 26 13:52:42 PDT 2003
Hi folks,
I am sorry that I asked this such basic question. Just after I sent it I
understood what was going on.
I expected some icon in turba interface to administer the distribution lists.
I my humble opinion, the way turba interface is designed is not intuitive to
find out how to manage distribution lists.
Nevertheless, it is now working as designed.
Thank you all.
Best regards,
--
Fabricio Bianco Abreu
Tribunal de Contas do DF
Telefone/Phone +55-61-314-2236
Citando fabricio bianco abreu <fabricio at tc.df.gov.br>:
> 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/
>
>
> --
> Turba mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: turba-unsubscribe at lists.horde.org
>
>
-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/
More information about the turba
mailing list