Guest Management Software Administrator Guide

10

2 Installation

If running the Guest Management Software on a single computer, you can select Local (to use its own internal database) or a third-party database. If you plan to run the Guest Management Software on multiple computers, select a third-party database.

See “Installing on multiple computers” on page 8 for more information.

The Guest Management Software has been tested with the following third-party database engines:

•PostGRE SQL 8.3.7 (Linux). This is the recommended external database.

•Microsoft SQL Server 9.0.1399 (Windows)

•Oracle XE 10.2.0.1-1.0 (Linux)

•MySQL Standard 5.0.51 (Linux).

Note: To use the MySQL database, you must first install the driver. Proceed as follows:

1.Acquire a commercial license for the Connector/J (JDBC driver) component of MySQL, version 5.0.2 or greater.

2.Copy the driver file (which should be called mysql-connector-java-x.x.x-bin.jarwhere x.x.x is the version number of the driver) to the lib subdirectory of where you installed the Guest Management Software.

3.Modify the file VisitorManagementTool.cmd to reflect the exact version of the driver used. Look for the line starting with @set MYSQL and change the version number there.

Note: The Guest Management Software may work with the listed databases under other operating systems, provided the same version is used. However, you assume the risks of running the Guest Management Software on any non-tested platform or database.

Note: The database type cannot be changed without re-installing the Guest

Management Software.

C. Certificate Authority (CA) certificate creation

After the database selection is complete, the Certificate Authority Creation Wizard starts. The Certificate authority is used as follows:

•When a controller is added to the Guest Management Software database, the CA certificate is automatically installed on the controller. This certificate is used to validate the identities of the Guest Management Software and the controller when they exchange information.

•The CA certificate is used to sign the certificates for operator accounts.

•The username and password defined for the CA certificate are used as the login credentials for the administrator account.