Introduction
This document describes an issue encountered when you integrate Cisco Unity Connection with Active Directory to be able to import users from Lightweight Directory Access Protocol (LDAP) and offers a solution to the problem.
Problem
When you attempt to import a user via LDAP in Unity Connection, the user does not show as available for import. The user does not show as an existing user when you run a user search in the GUI. In this case, there is a stale entry in a table about this user that prevents it from being imported.
This document provides examples of searches for User: cisco test and for Userid: ciscotest.
Steps to Troubleshoot
- Verify that the user is not available when you try to import from LDAP.
- Verify that the user is on the LDAP server.
- Navigate to the users page on Unity Connection and search for the user in order to verify that users are not already present on Unity Connection.
- Check if the user is available in EndUser table with this Structured Query Language (SQL) query:
admin:run sql SELECT pkid, firstname, lastname, userid, telephonenumber
FROM EndUser u WHERE userid='ciscotest'
pkid firstname lastname userid telephonenumber
==================================== ========= ======== ========= ===============
e88525ef-ebce-4af1-bddb-ef58c8389700 Cisco Test ciscotest (444)555-6666
- Verify that the same user is not available in tbl_user:
admin:run cuc dbquery unitydirdb select * from tbl_user where ldapccmpkid=
'e88525ef-ebce-4af1-bddb-ef58c8389700'
No records found
2011-09-21 15:07:28,383 ERROR [ClassExecutionThread] cli.CucUtils -
Results array is empty!
- Check the enduserappservermap table for the same user. Take the pkid from Step 4 and use it as fkenduser.
admin:run sql select * from enduserappservermap where fkenduser=
'e88525ef-ebce-4af1-bddb-ef58c8389700'
pkid fkenduser
fkappserver content
==================================== ====================================
====================================
3725fca8-1b99-47cb-96f0-fd5641d13753 e88525ef-ebce-4af1-bddb-ef58c8389700
cd183532-15c3-4065-bd09-30991cf1bd1c b99b4440-1c64-4c30-9dee-3c8bd8808448
cbd62377-9a2a-4a8e-8685-220ba0af747d e88525ef-ebce-4af1-bddb-ef58c8389700
cd183532-15c3-4065-bd09-30991cf1bd1c b99b4440-1c64-4c30-9dee-3c8bd8808448
There are two records in this table. There should not be any records in order to make this user available for import. You must delete these records.
Before you delete the records, make sure that no entry is present in the Unity Connection tables.
- Take the content from the enduserappservermap table and use it as the objectid in these queries. All must return empty results.
admin:run cuc dbquery unitydirdb select * from tbl_globaluser where objectid=
'b99b4440-1c64-4c30-9dee-3c8bd8808448'
No records found
2011-09-21 15:12:37, 866 ERROR [ClassExecutionThread] cli.CucUtils -
Results array is empty!
admin:run cuc dbquery unitydirdb select * from tbl_user where ldapccmuserid=
'ciscotest'
No records found
2011-09-21 15:09:13, 195 ERROR [ClassExecutionThread] cli.CucUtils -
Results array is empty!
admin:run cuc dbquery unitydirdb select * from tbl_user where objectid=
'b99b4440-1c64-4c30-9dee-3c8bd8808448'
No records found
2011-09-21 15:12:49, 213 ERROR [ClassExecutionThread] cli.CucUtils -
Results array is empty!
Solution
Delete the entries from enduser servermap table so that the user can be imported from the GUI.
admin:run sql delete from enduserappservermap where fkenduser=
'e88525ef-ebce-4af1-bddb-ef58c8389700'
Related Information
Feedback