On Tue, 09 Feb 2010 16:42:25 +0100, Frank Bonnet f.bonnet@esiee.fr wrote:
Hi again
I'm trying to configure roundcube to use our LDAP directory to SEARCH names/addresses but I don't want to store address books into LDAP I want to store them in SQL database,
Does someone could give some good starting point to configure roudcube to do so ?
Frank, I have mine set to use SQL for users' personal addressbooks, but have several read-only LDAP directories configured as global organization address lookups. (Works well with auto-complete from SQL but using the compose-addressbook for the LDAP lookups). Here are the salient parts from my main.config.php:
=======================================
$rcmail_config['address_book_type'] = 'sql';
$rcmail_config['ldap_public']['Global'] = array( 'name' => 'All Districts', 'hosts' => array('directory.yourorg.org'), 'port' => 389, 'use_tls' => false, 'user_specific' => false, 'base_dn' => 'dc=yourorg,dc=org', 'ldap_version' => 3, 'search_fields' => array('mail', 'gn', 'sn'), 'name_field' => 'cn', 'email_field' => 'mail', 'surname_field' => 'sn', 'firstname_field' => 'gn', 'sort' => 'sn', 'scope' => 'sub', 'filter' => 'objectclass=inetOrgPerson', 'fuzzy_search' => true);
$rcmail_config['autocomplete_addressbooks'] = array('sql');
===================================================
On a related note, I've been trying to move my LDAP lookup to TLS (port 636) unsuccessfully thus far. It seems straightforward, but has failed so far. If anyone has any suggestions I'd love to hear them.