Installing and Uninstalling › Installer Dialogs › Step 4: (Interface Server) Define Database User and Database

Step 4: (Interface Server) Define Database User and Database

The Database Information dialogs define a database user and the database for the CA XCOM Interface Server to store status information. The database can be DB2 or MySQL.

For MySQL, the installer can be requested to either create a new database or use an existing one. However, for DB2, the installer is unable to create databases and so the database must be predefined using DB2 administration tools.

A database user account is required by the CA XCOM Interface Server to enable it to access and update its database tables. This account needs read and update privileges for all tables in the designated database, but does not need any structure or administration privileges or any access privileges for any other database.

The installer also requests user ID and password credentials for an admin user database account. These will be used only during product installation, to create tables within the database. The admin user account needs to have table create and drop structure privileges for the designated database, to enable it to create tables. For MySQL only, the admin user account also needs database creation privilege, if the installer is to be requested to create a new database.

The database table names used by CA XCOM Data Transport are unique to each product. Consequently, you can share the same database between CA XCOM Interface Server, CA XCOM Gateway, and CA XCOM Management Center, or you can use separate databases for each component.

Depending on whether you use a DB2 or MySQL database, the procedure differs.

To define the DB2 user and database

1. On the first Database Information dialog, select DB2 from the Database drop-down list.

   The dialog displays the DB2 information fields:

   

2. Complete the fields:
   • Specify the ID and password of a previously defined DB2 user, together with the name of an existing database.

     If a suitable user does not exist, you can use your operating system tools to create a user account for connection and access to the database tables.

   • Specify the file folder locations at which the installer can locate the DB2 JDBC Connector and its license.
3. Click Next.

   The second Database Information dialog opens:

   

4. Complete the fields:
   • Specify the host name and port information that the CA XCOM Interface Server requires to connect to the DB2 database server (local or remote).

     The port number is set initially to the default value of 50000 for DB2.

   • Specify the ID and password for an administrative user account which has been granted the ability to create database tables.

     During installation, the installer connects to the database server as this user to create the required database tables.

5. Click Next.

   The installer connects to the specified database server to verify the validity of the specified information. The Application Server Information dialog opens.

   Note: Tables are not created at this stage. They are created later after you review your installation choices and request the installation to proceed.

To define the MySQL user and database

1. On the first Database Information dialog, select MySQL from the Database drop-down list.

   The dialog displays the MySQL information fields:

   

2. Complete the fields:
   • Specify the ID and password of a user, and the name of a database.

     You can specify an existing user and database, or you can ask the installer to create the user and database.

     The indicated user account will be used by the CA XCOM Interface Server, on an ongoing basis, to access and update database tables. Therefore, if you specify an existing user, this user account must have all data privileges (that is, select, insert, update, and delete) at either database or global level, but does not require structure or administrative privileges.

     Notes:

     • If you are using a database user that was created outside of the CA XCOM Gateway installer, you need to ensure that the database user already exists with the required access.
     • If the database server is in the local machine, user@localhost must exist
     • If the database server is in a remote machine, user@remote must exist.
     • If the database is in a remote machine and user@localhost exists but user@remote does not exist, the installer will not create user@remote, even if the Create User option is checked. The installer will produce an error.
     • Similarly, if the database is in the local machine and user@remote exists but user@localhost does not exist, the installer will not create user@localhost, even if the Create User option is checked. The installer will produce an error.
     • During installation, if there are any database errors, installation will not stop, but the database errors will be logged to “%INSTALL_DIR%\installlogs\CA XCOM Data Transport Gateway_install.log” for CA XCOM Gateway and to “%INSTALL_DIR%\installlogs\CA XCOM Data Transport Interface Server_install.log” for the CA XCOM Interface Server.
   • If you want to create a new database user, check the Create User option.

     Note: The installer will create the database user only if both of the following apply:

     • The Create User option is checked.
     • The user does not already exist as either user@localhost or user@remote.
   • Specify the file folder location at which the installer can locate MySQL Connector/J, the official JDBC driver for MySQL.
3. Click Next.

   The second Database Information dialog opens:

   

4. Complete the fields:
   • Specify the host name and port information that the CA XCOM Interface Server requires to connect to the MySQL database server.

     The port number is set initially to the default value of 3306, the standard MySQL server port number.

   • Specify the ID and password for an administrative user who has been granted the ability to create database tables, and when specified, a new user or database.

     Notes:

     • For MySQL, the administrative user must have all privileges. If the database server is in a remote machine, then the administrative user with remote access (%) must have all privileges.
     • During installation, the installer connects to the database server as this user to create the required database tables, and when specified, a new user or database.
5. Click Next.

   The installer connects to the specified database server to verify the validity of the specified information. The Application Server Information dialog opens.

   Note: Tables are not created at this stage. They are created later after you review your installation choices and request the installation to proceed.