Convert existing wiki users to external accounts such as LDAP

If you initially set up some users locally on the wiki and then add the LDAP authentication service, you may notice that when the same users (with the same usernames) login via LDAP, new accounts are created with a 1 appended after the name. For example, you create a local account Bob and then login using LDAP authentication also as username Bob, a new account will be created with the username Bob1.

Before making changes make sure that the username of the local user is the same username as the External Auth user that you want to map it to.

1. To change this login to the Control Panel -> User Management
2. Find the user that you want to change and hit Edit next to the user
3. Scroll down to the Service for the user and change it from Local to External Auth
4. Select the correct External Auth provider from the dropdown
5. Enter the username and credentials of an External Auth user that has query permissions to the External Auth server
6. Save 

The user will not have their service listed as the External Auth provider.

update users
set user_service_id = 8,
user_external_name = user_name
where user_name in ("Bob", "Susan");