Sample 3 - Scripted SQL

-----------------------

This sample demonstrates an example configuration for a scripted SQL

connector, a connector that communicates with a database through configurable

SQL scripts. This example requires a fresh installation of OpenIDM.

For documentation pertaining to this example see:

http://openidm.forgerock.org/doc/install-guide/index.html#more-sample3

To try the example, follow these steps.

1. Copy the MySQL Connector/J .jar to the OpenIDM bundle/ directory.

$ cp mysql-connector-java-5.1.18-bin.jar /path/to/openidm/bundle/

3. Set up MySQL to listen on localhost:3306, connecting as root:password.

4. Import the sample data definition language file into MySQL.

$ ./bin/mysql -u root -p < /path/to/openidm/samples/sample3/data/sample_HR_DB.mysql

Enter password:

$ ./bin/mysql -u root -p

Enter password:

mysql> use HRDB;

mysql> select * from Users;

+----+--------+------------------------------------------+-----------+----------+---------------+---------------------------+--------------+---------------------+

| id | uid | password | firstname | lastname | fullname | email | organization | timestamp |

+----+--------+------------------------------------------+-----------+----------+---------------+---------------------------+--------------+---------------------+

| 1 | bob | e38ad214943daad1d64c102faec29de4afe9da3d | Bob | Fleming | Bob Fleming | Bob.Fleming@example.com | HR | 2014-04-04 07:03:12 |

| 2 | rowley | 2aa60a8ff7fcd473d321e0146afd9e26df395147 | Rowley | Birkin | Rowley Birkin | Rowley.Birkin@example.com | SALES | 2014-04-04 07:03:12 |

| 3 | louis | 1119cfd37ee247357e034a08d844eea25f6fd20f | Louis | Balfour | Louis Balfour | Louis.Balfour@example.com | SALES | 2014-04-04 07:03:12 |

| 4 | john | a1d7584daaca4738d499ad7082886b01117275d8 | John | Smith | John Smith | John.Smith@example.com | SUPPORT | 2014-04-04 07:03:12 |

| 5 | jdoe | edba955d0ea15fdef4f61726ef97e5af507430c0 | John | Doe | John Doe | John.Does@example.com | ENG | 2014-04-04 07:03:12 |

+----+--------+------------------------------------------+-----------+----------+---------------+---------------------------+--------------+---------------------+

5 rows in set (0.01 sec)

mysql> quit

Bye

* Note that these passwords are hashed, and not available to be read into OpenIDM as cleartext.

* sha1 is used to hash these passwords for compatiblity reasons; in production uses, more secure algorithms should be used.

5. Start OpenIDM with the configuration for sample 3.

$ /path/to/openidm/startup.sh -p samples/sample3

6. Run reconciliation:

$ curl -k -H "Content-type: application/json" -u "openidm-admin:openidm-admin" -X POST "https://localhost:8443/openidm/recon?_action=recon&mapping=systemHrdb_managedUser"

7. Retrieve the list of users from OpenIDM's internal repository: