[horde] Hermes Question

[John H. Bennett III]

Quoting Jan Schneider <jan at horde.org>:

> Zitat von "John H. Bennett III" <bennettj at thebennetthome.com>:
>
>> Hello,
>>
>> Didn't see a Hermes list, which is why I posted here.  I have someone
>> that is interested in using Hermes.  I have downloaded it via CVS and
>> have it installed and somewhat working.
>>
>> My question is on the address book Hermes needs to use for its client
>> list.  I am using this link as a reference,
>> http://wiki.horde.org/HermesAddressBook, which was written by Michael
>> Rubinsky.  I have created the second table and it works fine for each
>> user.  But, each user must add their own clients individually, no
>> sharing.  In the link, under step 2, the directions state to
>> Permission your users to see/use this new database.  Is this what is
>> supposed to enable all users to use the same DB for clients, I don't
>> really think so, or is the only way to have a shared address book is
>> by using the Alternate suggestion?
>
> You can either create a shared address book that all users have access
> to, or create a global address book for the clients, i.e. a not shared
> address book with permissions set though Horde's permission interface.
>
> Jan.
>
I can get the shared address book to work.  It takes a little more  
work to setup, but fine, it's a solution.  I guess I'm not  
understanding how to create the global address book.  Can this only be  
done via ldap, or can MySQL be used?  I have followed the instructions  
in the link above, and when I do this, my users end up with a second  
local address book.  I also don't see how to do this from  
sources.php.dist.  If you can do it within MySQL, would you please  
show me an example of what my sources.php should look like, then any  
other steps needed.  I'm OK with setting the horde permissions, just  
getting the GAB is what is throwing me.

Here is my relevant sources.php:
//45LocalSQL
/**
  * 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/db/turba.sql if you use
  * this source.
  */
$cfgSources['localsql2'] = array(
     'title' => _("Hermes Address Book"),
     'type' => 'sql',
     'params' => array_merge($conf['sql'], array('table' => 'turba_objects2')),

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

Thanks again,

John