Introduction

This wiki page shows all the steps needed to synchronize an external Active Directory resource with a MySQL database.

Pre-Requisites

1. MySQL JDBC driver
2. Active Directory JNDI connector bundle (check latest version)
3. Database Table connector bundle (check latest version)

Configuration steps

1. Include MySQL JDBC driver into the JEE container classpath.
2. Install Active Directory JNDI connector bundle.
3. Install Database Table connector bundle.
4. Configure Active Directory connector instance.
5. Configure Active Directory external resource.
6. Configure MySQL connector instance.
7. Configure MySQL external resource.
8. Create a synchronization task.
9. Provide user template.
10. Schedule the synchronization task.
11. Check your configuration.

Configure external resources

• Active Directory
• MySQL

Configure synchronization

Synchronization is performed by configuring and executing a synchronization task.

A synchronization task could be started manually or automatically by providing a schedule.

Please, consider that searching for users to be synchronized involves result pagination: if your Active Directory instance is not empty but provisioned with a lot of matching users you have to put into account some delay (sometimes, more than one synchronization request).

Create a synchronization task

1. Click on tab Tasks.
2. Click on subtab Synchronization Tasks.
3. Click on Create new task button.
4. Click on Profile tab and provide the following information.
   
   1. Resource Name: Active Directory demo
   2. Create new identities: checked
   3. Update matched identities: checked
   4. Delete matched identities: checked
5. Click on Save button to save the task.

Be careful not to schedule the first execution of this task before defining a user template to be used during synchronization (if you need such feature, of course).

Please, take a look at task management for more details.

Provide a user template

Specify a user template to assign default attributes, resources, roles, to each synchronized user.

1. Click on tab Tasks.
2. Click on subtab Synchronization Tasks.
3. Click on Edit link (corresponding to User template column) in order to configure a user template.
4. Click on Resources tab.
   
   1. Select MySQL resource in order to assign it automatically to each new user.
5. Click on Save button to save changes.

Please, take a look at task management for more details.

Schedule the task

You can start the task manually or automatically by scheduling it.

In order to schedule a task the following steps are needed.

1. Click on tab Tasks.
2. Click on subtab Synchronization Tasks.
3. Click on Edit link.
4. Click on Schedule tab to schedule task executions.
   
   1. Schedule execution every minute (you can use 'Every 5 minutes' template and replace '5' with '1')
5. Click on Save button to save the task.

Check your configuration

1. Create new user.
   • Create a new user on Active Directory.
   • Wait for a minute and check user presence either on Syncope and MySQL.
2. Update user.
   • Update created user on Active Directory by modifying the firstname.
   • Wait for a minute and check user update either on Syncope and MySQL.
3. Delete user.
   • Delete modified user on Active Directory.
   • Wait for a minute and check user deletion either on Syncope and MySQL.