Hello
Am 2013-02-05 12:41, schrieb [email protected]:
>
> is it possible to use postgresql to have a global address book ?
>
Sure.
You only have to add another SOGoUserSources of type sql.
You have to set it:
canAuthenticate NO
isAddressBook YES
Example:
{
type = sql;
id = global_addresses
viewURL = "postgresql://sogo:[email protected]:5432/sogo/sogo_view";
canAuthenticate = NO;
isAddressBook = YES;
displayName = "Addresses for Everyone"
}
> How are the schema to create the DB ?
>
>From the Documentation:
viewURL database URL of the view used by SOGo. The view expects
columns to be present. Required columns are :
• c_uid : will be used for authentication – it's a username
or [email protected]
• c_name : will be used to uniquely identify entries – which
can be identical to c_uid
• c_password : password of the user, plain text, crypt, md5
or sha encoded
• c_cn : the user's common name
• mail : the user's email address
Other columns can exist and will actually be mapped
automatically if they have the same name as popular LDAP
attributes (such as givenName, sn, department, title,
telephoneNumber, etc.)
Mind, that view is here used as synonym for table too.
Kind regards,
Christian Mack
--
Christian Mack
Gruppe Informationsdienste
Rechenzentrum Universität Konstanz
--
[email protected]
https://inverse.ca/sogo/lists
