Administrator's Guide

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.jar where
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.