configure mysql database - post installation |
Virtual Machine |
 |
This section describes the PROIV Virtual Machine runtime requirements for MySQL database. The Linux 64-bit includes MySQL - Connector/C Library “libmysqlclient.so�? which can be found in the PROIV_HOME/virtual_machine/lib/mysql directory of your installation. This directory is added to the LD_LIBRARY_PATH environment variable as part of the runproiv script.
The setup is a combination of installation and post-installation processes. The installation allows PROIV to connect to a single SQL database after installation.
The following information must be provided to PROIV to ensure successful connection to a SQL database.
-
File Type.
-
Connection string - The connection information to the database. For example, the Oracle connection string consists of userid/password@host-string as in pro4user/pro4pwd@t:pro4:orcl.
-
DLL Name - Each database access sub-module is created as a DLL (Dynamic Load Library). Where there are multiple versions (for example, PROIV supports Oracle versions 10 and 11) the DLL name must be provided to PROIV. This information is provided in the initialisation file using the "ORACLE_DLLNAME=" environment option.
-
Initialisation File - The Windows kernel looks at two initialisation files.
- Global Initialisation file - pro4v[n].ini located in the Windows directory.
- User specific initialisation file - which can be located in any directory.
One file per user is allowed. The location of the user specific initialization file must be specified in the user section of the global initialisation file. The user-specific initialisation file can contain user-specific environment settings and logical database path settings. The user specific file should not contain a [USER] section, and if one exists, the contents are ignored.
SQL database specific commands are searched in both initialisation files.
Topic ID: 720298