[turba] Public ldap & private sql

[Michael Rubinsky]

Greg Wilson wrote:
> Using Horde Groupware 1.0, mysql storage.
>
> I prefer to use my existing ldap address book so I only need to maintain
> one.
>
>  
>
> I can get either the public ldap or the private sql address books
> working. Can someone please provide the correct syntax in turba
> sources.php to have multiple address books?
>   
Do you mean single address books from multiple sources (such as 1 public 
ldap address book along with 1 private SQL book)?  If so, just define 
the two sources in sources.php.  The example sources.php.dist file 
probably contains something very close to what you would need.  OR, do 
you mean a single source, such as SQL that allows a user to have an 
arbitrary number of multiple address books that they can create/delete 
themselves at will?


> The data tree under Turba is getting fairly busy too as I've been
> experimenting trying to get this working. Is there a way to clean this
> out?
>   
You can execute a SQL statement directly against the database removing 
the entries you need. Just be very careful, and DON'T do this if this is 
a production system!!  For example, to get rid of all the turba shares 
do something like DELETE FROM horde_datatree WHERE group_uid = 
'horde.shares.turba'; This might orphan some entries in the 
horde_datatree_attributes table, I remember seeing a SQL script commited 
not too long ago that had a command to clean this up as well...I don't 
remember what file that was off the top of my head though...


-- 
Thanks,
Mike

--
The Horde Project (www.horde.org)
mrubinsk at horde.org