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.

On Tue, 09 Feb 2010 11:36:27 -0600, Ryan Horrisberger rhorrisb@ssc.wisc.edu wrote:

On Tue, 09 Feb 2010 08:23:01 -0800, Arne Berglund wrote:

...

On a rela<script type="text/javascript"

src="http://dexter.ssc.wisc.edu/mail/program/js/tiny_mce/themes/advanced/langs/en...</script>ted

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.

I've not setup TLS for our Roundcube install (I am not that worried

about

read-only, email address/name lookups), but TLS over ldap generally

happens

on port 389 (same as regular LDAP). Not on port 636 which is for LDAPS (LDAP over SSL).

TLS over port 389 is generally preferred instead LDAPS on port 636

(which

was deprecated in 2003).

-ryan

LDAPS on 636 may be deprecated, but that is the only secure connection that Thunderbird and Apple's Addressbook will perform, even the very latest versions. Since I must support those clients (no choice there politically), LDAPS is must be.

Arne Berglund System Administrator, Internet Services Lane Education Service District Eugene, OR ______________ _______________________________________________ List info: http://lists.roundcube.net/users/

On Tue, 9 Feb 2010 12:13:29 -0600, Ryan Horrisberger rhorrisb@ssc.wisc.edu wrote:

On Feb 9, 2010, at 11:48 AM, Arne Berglund wrote:

...

I've been trying to move my LDAP lookup to TLS (port 636) unsuccessfully

I was trying to clarify that TLS and LDAPS are different technologies to solve the same problem. So in your case you mention you've been trying

to

do TLS over port 636 which I don't think would ever work. Even though

you

support LDAPS for thunderbird et al. you can still choose either option

for

Roundcube.

I hope this helps.

-ryan

Actually, that helps a lot. Thanks!

Arne Berglund System Administrator, Internet Services Lane Education Service District Eugene, OR ______________

List info: http://lists.roundcube.net/users/

Duuh ... Forget my preceding message ... I forgot to uncomment the ldap_public section due to my missunderstanding of PHP ...

Sorry for the noise ... everything works well as expected now :-)

Thanks a lot.

On 02/10/10 11:51, Frank Bonnet wrote:

Hello Arne

Thanks a lot for your help , I have configured "my" roundcube for my organization, but I don't find WHERE to configure the use of LDAP to search names / addresses and if I type a known name, I do not have any result except the SQL address book.

On 02/09/10 17:23, Arne Berglund wrote:

...

On Tue, 09 Feb 2010 16:42:25 +0100, Frank Bonnetf.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.

---

List info: http://lists.roundcube.net/users/

List info: http://lists.roundcube.net/users/