LDAP user authentication administration

The syntax of the sp_ldapadmin command is as follows:

sp_ldapadmin Usage: sp_ldapadmin command [, option1 [, option2]]

sp_ldapadmin commands include:

sp_ldapadmin 'set_primary_url', 'url'
sp_ldapadmin 'set_secondary_url', 'url'
sp_ldapadmin 'set_dn_lookup_url', 'url'
sp_ldapadmin 'set_secondary_dn_lookup_url', 'url'
sp_ldapadmin 'set_access_acct', 'distinguished name', 'password'
sp_ldapadmin 'set_secondary_access_acct', 'distinguished name', 'password'
sp_ldapadmin 'suspend', {'primary' | 'secondary'}
sp_ldapadmin 'activate', {'primary' | 'secondary'}
sp_ldapadmin 'list'
sp_ldapadmin 'list_urls'
sp_ldapadmin 'list_access_acct'
sp_ldapadmin 'check_url', 'url'
sp_ldapadmin 'check_login', 'name'
sp_ldapadmin 'set_timeout', timeout_in_milli_seconds
sp_ldapadmin 'set_max_ldapua_native_threads', max_ldapua_native_threads
sp_ldapadmin 'set_abandon_ldapua_when_full', {true|false}
sp_ldapadmin 'help'

The following is an example output from a client administration session:

1> sp_configure 'enable ldap', 2
2> go

 Parameter Name                Default     Memory Used Config Value
         Run Value   Unit                 Type 
------------------------------ ----------- ----------- ------------
         ----------- -------------------- ---------- 
enable ldap user auth                    0           0            2 
                   2 not applicable       dynamic 

(1 row affected)

1> sp_ldapadmin 'set_primary_url','ldap://primldap:30001/'
2> go
The URL 'ldap://primldap:30001/' is set for LDAP User
Authentication.
(return status = 0)

1> sp_ldapadmin 'set_dn_lookup_url',
'ldap://primldap:30001/dc=sybase,dc=com??sub?uid=*'
2> go
The URL 'ldap://primldap:30001/dc=sybase,dc=com??sub?uid=*' 
is set for LDAP User Authentication.
(return status = 0)

1> sp_ldapadmin 'set_access_acct','cn=directorymanager,dc=sybase,
dc=com', 'primpassword'
2> go
The LDAP account distinguished name 'cn=directory manager,dc=sybase,dc=com' is set for LDAP user
authentication.
(return status = 0)

1> sp_ldapadmin 'set_secondary_url',
'ldap://secldap:31001/'
2> go
The URL 'ldap://secldap:31001/' is set for LDAP User
Authentication.
(return status = 0)

1> sp_ldapadmin 'set_secondary_dn_lookup_url',
'ldap://secldap:31001//dc=sybase,dc=com??sub?uid=*' 
2> go
The URL 'ldap://secldap:31001//dc=sybase,dc=com??sub?uid=*' 
is set for LDAP User Authentication.
(return status = 0)
2> sp_ldapadmin 'set_secondary_access_acct',
'cn=Manager,dc=sybase,dc=com', 'secpassword'
3> go
The LDAP account distinguished name
'cn=Manager,dc=sybase,dc=com' is set for LDAP user
authentication.
(return status = 0)
1> sp_ldapadmin activate, primary
2> go
(return status = 0)

1> sp_ldapadmin activate, secondary
2> go
(return status = 0)
1> sp_ldapadmin 'list'
2> go
Primary:
      URL:                 'ldap://primldap:30001/'
      DN Lookup URL:
      'ldap://primldap:30001/dc=sybase,dc=com??sub?uid      =*' 
      Access Account: 
      'cn=directory manager,dc=sybase,dc=com
      Active:              'TRUE'
      Status:              'READY'
Secondary:
      URL:                 'ldap://secldap:31001/'
      DN Lookup URL:            'ldap://secldap:31001/dc=syase,dc=com??sub?uid=*'
      Access Account:      'cn=Manager,dc=sybase,dc=com'
      Active:              'TRUE'
      Status:              'READY'
Timeout value:           '-1'(10000) milliseconds
Maximum LDAPUA native threads per Engine: '49'
Abandon LDAP user authentication when full: 'false'
(return status = 0)

1> sp_ldapadmin 'list_urls'
2> go
Primary URL:         'ldap://primldap:30001/'
Secondary URL:       'ldap://secldap:31001/'
Distinguished Name Lookup URL:
'ldap://primldap:30001/dc=sybase,dc=com??sub?uid=*'
Secondary Distinguished Name Lookup URL:
'ldap://secldap:31001/dc=sybase,dc=com??sub?uid=*'
(return status = 0)

1> sp_ldapadmin 'list_access_acct'
2> go
Access Account DN:     
'cn=directory manager,dc=sybase,dc=com'
Secondary Access Account DN:     'cn=Manager,dc=sybase,dc=com'
(return status = 0)