LDAP Configuration - socket closed

Hello, I am currently trying to connect Denodo to LDAP. When trying to test the connection I get the following error message: "Unable to establish Connection: <LDAP_URL><LDAP_Port>; socket closed". What does socket closed mean? I am pretty sure that the URL, port and credentials are correct. Thanks
10-07-2019 09:02:40 -0400

1 Answer

Hi, The socket closed may usually occur due to issue in LDAP Server itself. It could be a timeout from LDAP Server. So, I would cross verify the same by trying to connect the LDAP Server through external client tool like Active Directory Explorer. If there is no abnormality or issues in my source LDAP Server then I will try to do the below configuration changes in Denodo platform to see if that works. * Make sure the Enable Connection Pool checkbox is selected in the configuration section of LDAP datasource in Denodo. * If the connection pool enablement does not help, Would try to increase the connection timeout value for LDAP Connection Pool in VDBConfiguration.properties file present in <DENODO_HOME>\conf\vdp folder. For example: > #LDAP - Connection Pool > com.denodo.vdb.misc.datasource.LDAPDataSource.pool.connectionTimeout=30000 The above default connectionTimeout in the properties file can be increased. * Make sure to stop the Denodo server before changing the above .properties file. * After saving the changes, restart the Virtual DataPort Server. I would go through [**LDAP Sources**](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/ldap_sources/ldap_sources#ldap-sources) section of Virtual DataPort Administration Guide to get more details on LDAP datasource connection. With respect to Active Directory Explorer testing, I would use [**this**](https://docs.microsoft.com/en-us/sysinternals/downloads/adexplorer) link to download. While configuring connection, provide the <HOSTNAME>:<PORT> along with proper credentials for LDAP datasource. Hope this helps!
Denodo Team
11-07-2019 05:59:19 -0400
You must sign in to add an answer. If you do not have an account, you can register here