Sun Java[TM] System Identity Manager 7.1 Resources Reference |
MySQLThe MySQL resource adapter is defined in the com.waveset.adapter.MySQLResourceAdapter class. This adapter supports the following versions of MySQL:
Use this adapter to support user accounts for logging into MySQL. If you have a custom table, see Database Tablefor information about using the Resource Adapter Wizard to create a custom MySQL table resource.
Resource Configuration Notes
None
Identity Manager Installation Notes
The MySQL resource adapter is a custom adapter. You must perform the following steps to complete the installation process:
- To add this resource to the Identity Manager resources list, you must add the following value in the Custom Resources section of the Configure Managed Resources page.
com.waveset.adapter.MySQLResourceAdapter
- Go to http://www.mysql.com/downloads/api-jdbc-stable.html and download the latest version of the Connector/J 3.0 JDBC driver.
- Unzip the downloaded file.
- Copy the mysqlconnector-java-3.0.x-stable-bin.jar file to the InstallDir\idm\WEB-INF\lib directory.
Usage Notes
Identity Manager creates a new user based on the account properties of the user specified in the User Model resource parameter. If the User Model parameter is left blank, then new users will be granted default MySQL privileges. The access host would be set to %, indicating the user can access the database from any host.
The MySQL resource adapter can update MySQL user passwords only.
Security Notes
This section provides information about supported connections and privilege requirements.
Supported Connections
Identity Manager uses JDBC over SSL to communicate with MySQL.
Required Administrative Privileges
You must be the MySQL root user or have GRANT privilege to create a user. Deleting a user requires the REVOKE privilege.
Provisioning Notes
The following table summarizes the provisioning capabilities of this adapter.
Feature
Supported?
Enable/disable account
No
Rename account
No
Pass-through authentication
No
Before/after actions
No
Data loading methods
Account Attributes
None
Resource Object Management
None
Identity Template
$accountId$
Sample Forms
None
Troubleshooting
Use the Identity Manager debug pages to set trace options on the following class:
com.waveset.adapter.MySQLResourceAdapter