[turba] Public ldap & private sql

[Greg Wilson]

Thanks for the info. I have got it working OK now

________________________________

From: Michael Rubinsky [mailto:mike at theupstairsroom.com]
Sent: Sun 18/02/2007 10:26am
To: Greg Wilson
Cc: turba at lists.horde.org
Subject: Re: [turba] Public ldap & private sql



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