Accessing mysql databases |
Virtual Machine |
 |
To access a MySQL database, you must configure the required variables. In general, these can be set in the operating system environment or in the PROIV configuration file pro4v8.ini; however, it is usual to set the variables in the PROIV configuration file on Windows platforms. Additionally, you can also set these variables in PROIV Dashboard > Virtual Machine > Database section.
The following tables provides the list of variables that has to be defined in their respective sections of the PROIV configuration file. The variables that has type ‘Logical Database’ must be set in the logical database section and those with type ‘Environment’ can be set either in the operating system environment or in the Environment section of the PROIV Configuration file.
|
Variable Name |
pro4v[n].ini Section |
Values and Description |
|
FILETYPE |
Logical Database |
Sets the database file type. For MySQL, it is FILETYPE = MYSQL |
|
CONNECTION |
Logical Database |
This is the connection string used to specify the parameters required in order for PROIV to connect to the MySQL database. It is normally enclosed in double quotes in the following format, <user>/<password>@<host>:<port>/database name> |
|
PRODB_CHARSET |
Logical Database |
This variable determines the character that will be used to define the highest value that a key can have in the collation scheme in use on the target RS. |
The variables in the following table are used to specify default parameters in the case where the PROIV configuration file does not have a ‘default database’ section.
|
Variable Name |
pro4v[n].ini Section |
Values and Description |
|
SQL_DBTYPE |
Environment |
MYSQL, specified the database type (must use upper case). |
|
SQL_USERNAME |
Environment |
The username of the RDBMS account used to connect to the database. |
|
SQL_PASSWORD |
Environment |
The password of the RDBMS account used to connect to the database. |
Topic ID: 720300