|
|
|
Create a MySQL Data Source on UNIX Systems
The SOA Security Manager ODBC data sources are configured using a system_odbc.ini file, which you create by renaming mysqlwire.ini to system_odbc.ini. The mysqlwire.ini file is located in siteminder_home/db.
Specifies the Policy Server installation path.
This system_odbc.ini file contains all of the names of the available ODBC data sources and the attributes that are associated with these data sources. This file must be customized to work for each site. Also, you can add additional data sources to this file, such as defining additional ODBC user directories for SOA Security Manager.
The first section of the system_odbc.ini file, [ODBC Data Sources], contains a list of all of the currently available data sources. The name before the “=” refers to a subsequent section of the file describing each individual data source. After the “=” is a comment field.
Note: If you modify of the first line of data source entry, which is [SOA Security Manager Data Source], take note of the value. The value is required when you configure the database as a policy store.
Each data source has a section in the system_odbc.ini file describing its attributes. The first attribute is the ODBC driver that is loaded when SOA Security Manager uses this data source. The remaining attributes are specific to the driver.
Adding a MySQL Server Data source involves:
If you create a new service name or want to use a different driver, update the system_odbc.ini file. You should have entries for the MySQL driver under [SOA Security Manager Data Source].
Again, to configure a MySQL Server data source, you create the system_odbc.ini file by renaming mysqlwire.ini to system_odbc.ini.
| Copyright © 2011 CA. All rights reserved. | Email CA Technologies about this topic |