6.0.0-beta1
9/2/25

[#4466] shared address book
Summary shared address book
Queue Turba
Queue Version 2.1.2
Type Bug
State Not A Bug
Priority 2. Medium
Owners
Requester bruno (at) merjasec (dot) com
Created 09/26/2006 (6916 days ago)
Due
Updated 09/26/2006 (6916 days ago)
Assigned
Resolved 09/26/2006 (6916 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
09/26/2006 09:25:44 PM Chuck Hagenbuch Comment #3
State ⇒ Not A Bug
Reply to this comment
You should not be editing those tables directly. You should use the 
Administration -> Permissions admin interface to set permissions on 
address books. Add a permission for Turba if you don't already have 
one, and then add child permissions for Sources and finally the 
specific source you want to control.



Please ask further questions on the mailing list, this is not a support forum.
09/26/2006 09:17:37 PM bruno (at) merjasec (dot) com Comment #2 Reply to this comment
Sorry. One mistake. I added this line

+-------------+----------------+----------------+---------------------------------+

| datatree_id | attribute_name | attribute_key  | attribute_value       
            |

+-------------+----------------+----------------+---------------------------------+

|          15 | perm_users     | rkc4250@rkc.si | 30                   
            |

+-------------+----------------+----------------+---------------------------------+


09/26/2006 09:12:38 PM bruno (at) merjasec (dot) com Comment #1
State ⇒ Unconfirmed
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ shared address book
Queue ⇒ Turba
Reply to this comment
Hello there



I have a problem with Turba shared address book.



I tried to make some public address book (read-only) for all users, 
but I failed. How can I make some read-only/public/not exportable 
address book for all users?



I looked into horde_datatree and horde_datatree_attributes.



#table datatree

+-------------+------------------------+----------------+----------------+------------------+----------------+---------------+---------------------+

| datatree_id | group_uid              | user_uid       | 
datatree_name  | datatree_parents | datatree_order | datatree_data | 
datatree_serialized |

+-------------+------------------------+----------------+----------------+------------------+----------------+---------------+---------------------+

|          16 | horde.shares.turba     | gasper@domain  | localsql     
   |                  |           NULL |               |               
     0 |

|          15 | horde.shares.turba     | gasper@domain  | 
gasper@domain  | :16              |           NULL | NULL          |   
                 0 |

|          19 | horde.shares.turba     | usr4250@domain
usr4250@domain | :16              |           NULL | NULL          |   
                 0 |

+-------------+------------------------+----------------+----------------+------------------+----------------+---------------+---------------------+



#table datatree_attiributes

+-------------+----------------+----------------+---------------------------------+

| datatree_id | attribute_name | attribute_key  | attribute_value       
            |

+-------------+----------------+----------------+---------------------------------+

|          15 | uid            |                | gasper@domain         
            |

|          15 | name           |                | Gasper's Knjiga 
naslovov        |

|          15 | owner          |                | gasper@domain         
            |

|          15 | perm_users     | gasper@domain  | 30                   
            |

|          19 | uid            |                | rkc4250@domain       
            |

|          19 | name           |                | Spela's Knjiga 
naslovov         |

|          19 | owner          |                | usr4250@domain       
            |

|          19 | perm_users     | usr4250@domain | 30                   
            |

+-------------+----------------+----------------+---------------------------------+







When I added this line user usr4250 can read AND write my Address book



|          18 | perm_users     | usr4250@rkc.si | 30                   
            |





#sources.php

$cfgSources['localsql'] = array(

     'title' => _("My Address Book"),

     'type' => 'sql',

     'params' => array_merge($conf['sql'], array('table' => 'turba_objects')),

     'map' => array(

         '__key' => 'object_id',

         '__owner' => 'owner_id',

         '__type' => 'object_type',

         '__members' => 'object_members',

         '__uid' => 'object_uid',

         'name' => 'object_name',

         'email' => 'object_email',

         'alias' => 'object_alias',

         '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',

         'pgpPublicKey' => 'object_pgppublickey',

         'smimePublicKey' => 'object_smimepublickey',

         'freebusyUrl' => 'object_freebusyurl'

     ),

     'search' => array(

         'name',

         'email'

     ),

     'strict' => array(

         'object_id',

         'owner_id',

         'object_type',

     ),

     'export' => true,

     'browse' => true,

     'use_shares' => true,

);


Saved Queries