Configuration Guides › Directory Configuration Guide › MySQL Server › How to Configure a MySQL User Store › Import the SOA Security Manager Sample Users

Import the SOA Security Manager Sample Users

Importing the SOA Security Manager sample users is optional. You import these users to populate the database with fictional SOA Security Manager users.

To import the SOA Security Manager sample users

1. Navigate to path\MySQL.

   path

   Specifies the path to the schema files extracted from the tier 2 directory zip.

2. Open the following file in a text editor:

   smsampleusers_mysql.sql

3. Locate the following lines:

   DROP FUNCTION IF EXISTS `databaseName`.`getdate` $$
   CREATE FUNCTION `databaseName`.`getdate` () RETURNS DATE
   

4. Replace each instance of 'databaseName' with the name of the database functioning as the sample user store.

   Example: If the name of the database is smsampleuserstore, the required update appears as follows:

   DROP FUNCTION IF EXISTS `smsampleuserstore`.`getdate` $$
   CREATE FUNCTION `smsampleuserstore`.`getdate` () RETURNS DATE
   

5. Copy the contents of the entire file.
6. Paste the file contents into a query and execute the query.

   Note: For more information about executing a query, see the MySQL documentation.

   The user store is populated with the sample users.

7. Configure the user directory connection to the Policy Server.