What would cause duplicate records after LDAP scheduled import for users?
What would cause duplicate records after LDAP scheduled import for users? We set up the import the exact same way as we did the initial import and it duplicated user records.
3 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
brucegoose03
10 years ago
There are 2 causes to this that I have seen:
- End user logs in before import happens
- 2 imports happening at the same time, and user exists i both
1. The first one is a simple fix; whenever you have new users added to your environment, make sure to not have them log in to the appliance until you have a chance to import them.
This really only matters if your LDAP import schedule requied mapped fields (the 3 in red, username,email,objectguid) are mapped to anything other than what the default is (ldapui,mail,samaccountname).
For example, some customers use their email address as their username instead of samaccount name.
2. This ones a little trickier. Download your server troubleshooting logs and look in the cron_server_error log for something like this:
[2013-09-14 08:00:21 -0700] KCronServer[78081]: running /kbox/bin/schedule_userimport.php --id=3 --db=1
[2013-09-14 08:00:21 -0700] KCronServer[78083]: running /kbox/bin/schedule_userimport.php --id=4 --db=1
[2013-09-14 08:30:14 -0700] KCronServer[88380]: running /kbox/bin/schedule_userimport.php --id=2 --db=1
kbox#
[2013-09-14 08:00:21 -0700] KCronServer[78083]: running /kbox/bin/schedule_userimport.php --id=4 --db=1
[2013-09-14 08:30:14 -0700] KCronServer[88380]: running /kbox/bin/schedule_userimport.php --id=2 --db=1
kbox#
This issue I worked on had really only one schedule set in the UI, but somehow there were 2 others that were running that weren't suppose to so we had to remove those via root access.
To go a step further, you can see what imports are setup in teh DB:
select * from USERIMPORT_SCHEDULE
Then see where they are set in IM_CRON. Replace X with the ID you want to look at:
select * from IM_CRON where ID = X
select * from IM_CRON where ID = X
http://www.kace.com/support/resources/kb/article/How-to-connect-to-the-K1000-appliance-database-using?action=artikel&cat=9&id=10&artlang=en - grayematter 10 years ago