ml_add_ldap_server system procedure

Create, drop or update LDAP servers.

Syntax

ml_add_ldap_server ( 
'ldsrv_name', 
'search_url', 
'access_dn', 
'access_dn_pwd'
'auth_url'
'conn_retries'
'conn_timeout'
'use_tls'   
)

Parameters

Syntax	Description
`ldsrv_name`	VARCHAR(128). A unique LDAP server name.
`search_url`	VARCHAR(1024). A URL string that identifies the host by name or IP address, port number, and search string to perform the DN (distinguished name) lookup for a given user id.
`access_dn`	VARCHAR(1024). The distinguished name for an LDAP user that is used by the MobiLink server to connect to the LDAP server. The LDAP user must have permission on the LDAP server to search for DNs.
`access_dn_pwd`	VARCHAR(1024). The password associated with the DN specified with the access_dn parameter.
`auth_url`	VARCHAR(1024). A URL string that identifies the host by name or IP address and the port number of the LDAP server used to authenticate a user.
`conn_retries`	TINYINT. The number of times the MobiLink server tries to connect to the LDAP server for DN searches and authentication. The valid range is 1-60. The default is 3.
`conn_timeout`	TINYINT. The connection timeout from the MobiLink server to the LDAP server for DN searches and authentication. The value is specified in seconds. The default value is 10 seconds.
`start_tls`	TINYINT. Specifies that TLS be used for connections to the LDAP server for DN searches and authentication.

Remarks

This procedure populates the ml_ldap_server table with information about the specified LDAP server.

Example

The following example adds an LDAP server named my_primary into the ml_ldap_server table.

CALL ml_add_ldap_server(
'my_primary',                                        //server name
'ldap://voyager:389/dc=MyCompany,dc=com??sub?cn=*',  //search URL
'cn=aseadmin, cn=Users, dc=mycompany, dc=com',       //access DN
'Secret99Password',                                  //access DN password
'ldap://voyager:389/',                               //authentication URL
10,                                                  //connection retries
5,                                                   //connection timeout
0                                                    //no TLS
)