Installation and Upgrade Guides › Directory Configuration Guide › MySQL Server › How to Configure a MySQL User Store › Import the SiteMinder Sample Users

Import the SiteMinder Sample Users

You configure a sample user directory to populate a database with sample users.

Follow these steps:

1. Log in to the Policy Server host system.
2. Navigate to siteminder_home\db\tier2\MySQL.

   siteminder_home

   Specifies the Policy Server installation path.

3. Open the following file in a text editor:

   smsampleusers_mysql.sql

4. Locate the following lines:

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

5. 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
   

6. Copy the contents of the entire file.
7. 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.