CA SSO MySQL Server Wire Protocol

Document ID : KB000032770
Last Modified Date : 14/02/2018
Show Technical Document Details

Summary

 When configuring an ODBC Data Source on a UNIX OS to connect to an MySQL Data Source, the 'mysqlwire.ini' data source template is used to configure the  'system_odbc.ini' file.  The template files are located in  <Siteminder_home>/db. 

The 'mysqlwire.ini' data source template is a basic template.  

Example:

[ODBC Data Sources]
Siteminder Data Source=DataDirect 7.1 MySQL Wire Protocol

[Siteminder Data Source]
Driver=/opt/CA/siteminder/odbc/lib/NSmysql27.so
Description=DataDirect 7.1 MySQL Wire Protocol
AlternateServers=
ApplicationUsingThreads=1
ConnectionReset=0
ConnectionRetryCount=0
ConnectionRetryDelay=3
Database=<database_name>
DefaultLongDataBuffLen=1024
EnableDescribeParam=0
EncryptionMethod=0
FailoverGranularity=0
FailoverMode=0
FailoverPreconnect=0
HostName=<MySQL_host>
HostNameInCertificate=
InteractiveClient=0
KeyPassword=
KeyStore=
KeyStorePassword=
LicenseNotice=You must purchase commercially licensed MySQL database software or a MySQL Enterprise subscription in order to use the DataDirect Connect for ODBC for MySQL Enterprise driver with MySQL software.
LoadBalanceTimeout=0
LoadBalancing=0
LoginTimeout=15
LogonID=
Password=
MaxPoolSize=100
MinPoolSize=0
Pooling=0
PortNumber=<MySQL_server_port>
QueryTimeout=0
ReportCodepageConversionErrors=0
TreatBinaryAsChar=0
TrustStore=
TrustStorePassword=
ValidateServerCertificate=1
 

The sample Data Source information includes the basic attributes necessary to establish a connection to the database.  Any additional features or settings supported by the ODBC server would require that the appropriate attribute be manually added to the Data Source.

Solution:

This is a list of all of the available Data Source attributes on the SQL Wire Protocol driver for MySQL.

Driver=C:\\Program Files (x86)\\CA\\siteminder\\bin\\NSMYSQL27.DLL
Description=
HostName=
PortNumber=3306
Database=
LogonID=
InteractiveClient=0
ApplicationUsingThreads=1
TreatBinaryAsChar=0
DefaultLongDataBuffLen=1024
LoadBalancing=0
ConnectionRetryCount=0
ConnectionRetryDelay=3
AlternateServers=
ReportCodepageConversionErrors=0
EnableDescribeParam=0
LicenseNotice"=You must purchase commercially licensed MySQL database software or a MySQL Enterprise subscription in order to use the DataDirect Connect for DBC for MySQL Enterprise driver with MySQL software.
EncryptionMethod=0
CryptoProtocolVersion=
TrustStore=
TrustStorePassword=
KeyStore=
KeyStorePassword=
KeyPassword=
HostNameInCertificate=
ValidateServerCertificate=1
LoginTimeout"=15
QueryTimeout=0
FailoverMode=0
FailoverGranularity=0
FailoverPreconnect=0
Pooling=0
ConnectionReset=0
MaxPoolSize=100
MinPoolSize=0
LoadBalanceTimeout=0
ExtendedOptions=
KeepAlive=0

NOTE: The attributes in the example (above) reflect the hardcoded, default values.  Adding the attribute and modifying the value will override the default value with the user-designated value.