Configuration Guides › Directory Configuration Guide › MySQL Server › Configure a MySQL Policy Store › How to Configure the Policy Store › Configure a MySQL Data Source for SOA Security Manager › Create the MySQL Wire Protocol Driver

Create the MySQL Wire Protocol Driver

You configure the wire protocol driver to specify the settings SOA Security Manager uses to connect to the database.

Note: This procedure only applies if the Policy Server is installed on a UNIX system. If you have not already done so, copy one of the following files and rename it system_odbc.ini. The file you rename depends on the database vendor you are configuring as a SOA Security Manager data store.

• sqlserverwire.ini
• oraclewire.ini
• mysqlwire.ini

These files are located in siteminder_home/db

The system_odbc.ini file contains the following sections. The data source that you are configuring determine the section or sections that you edit:

[SOA Security Manager Data Source]

Specifies the settings SOA Security Manager should use to connect to the database functioning as the policy store.

[SOA Security Manager Logs Data Source]

Specifies the settings SOA Security Manager should use to connect to the database functioning as the audit log database.

[SOA Security Manager Keys Data Source]

Specifies the settings SOA Security Manager should use to connect to the database functioning as the key store.

[SOA Security Manager Session Data Source]

Specifies the settings SOA Security Manager should use to connect to the database functioning as the session store.

[SmSampleUsers Data Source]

Specifies the settings SOA Security Manager should use to connect to the database functioning as the sample user data store.

To configure the wire protocol driver

1. Open the system_odbc.ini file.
2. Enter the following under [ODBC Data Sources]:

   SiteMinder Data Source=DataDirect 6.0 MySQL Wire Protocol.
   

3. Depending on the data source you are configuring, edit the one or more of the data source sections with the following information:

   Driver=nete_ps_root/odbc/lib/NSmysql24.so
   Description=DataDirect 6.0 MySQL Wire Protocol
   Database=database_name
   HostName=host_name
   LogonID=root_user
   Password=root_user_password
   PortNumber=mysql_port
   

   Note: When editing data source information, do not use the pound sign (#). Entering a pound sign comments the information, which truncates the value. The truncated value can cause ODBC connections to fail.

   nete_ps_root

   Specifies the Policy Server installation path. Enter this value as an explicit path, rather than one with an environment variable.

   Example: /export/smuser/siteminder

   database_name

   Specifies the name of the MySQL database that is to function as the SOA Security Manager data store.

   host_name

   Specifies the name of the MySQL database host system.

   root_user

   Specifies the login ID of the MySQL root user.

   root_user_password

   Specifies the password for the MySQL root user.

   mysql_port

   Specifies the port on which the MySQL database is listening.

4. Save the file.

   The wire protocol driver is configured.