Deploying and configuring the enterprise database
This section contains instructions for deploying and configuring DB2, SQL, and MySQL enterprise databases for HCL Traveler.
Install the Server
lower_case_table_names=1
in the MySQL configuration file
(my.cnf
for Linux or my.ini
for Windows).
This must be done before initialization and allows for the same table naming
actions across platforms. For more information, see this article.- Configure DB2 for HCL Traveler using the DB2 Command line
- Configure DB2 for HCL Traveler using DDL
- Configure SQL for HCL Traveler using the SQL Server Management Studio
- Configure SQL for HCL Traveler using DDL
- Configure MySQL for HCL Traveler using the MySQL Command Line
- Configure MySQL for HCL Traveler using DDL
Configure DB2® for HCL Traveler using the DB2® Command line
- Create the DB2 database for Traveler. Specify your DB name for
<db_name> in the command below.For Windows run the db2 command from Windows Command:
db2cmd -c -w -i DB2 CREATE DATABASE <db_name> USING CODESET UTF-8 TERRITORY US
For Linux or AIX:su - db2inst1 DB2 CREATE DATABASE <db_name> USING CODESET UTF-8 TERRITORY US;
- Grant the DB Login User the requisite permissions defined in Permissions for DB2 Enterprise Database.
Configure DB2® for HCL Traveler using DDL
- Unzip the HCL Traveler DDL in
<domino install datadir>\traveler\cfg\db\TravelerSQL.zip
orTravelerSQL.tar.gz
to the directory<sqldir> cd <sqldir>/DB2
. - Make any updates necessary, for example the location of files, sizes of the database, schema names, and so on.
- For Windows™, create the DB Login user, HCL Traveler DB
and DB objects, using the following
command:
db2cmd -c -w -i db2 -tvf createDb.sql
For Linux® or AIX®:su - db2inst1 db2 -tvf createDb.sql
- For Windows™, grant the necessary permissions to the DB
Login user to the HCL Traveler DB, using the following command.
db2cmd -c -w -i db2 -tvf appGrants.sql
For Linux® or AIX:db2 -tvf appGrants.sql
- Create an Operating System User that matches the DB2® user specified in the
appGrants.sql
file. - Update the
notes.ini
to add the following property to tell the system the HCL Traveler DB and its objects were created:NTS_AUTO_DBSCHEMA=false
If you changed the schema name in the DDL files, you must set the following property in thenotes.ini
, where<schemaname>
is the schema name used in the DDL files:NTS_DB2_SCHEMA=<schemaname>
Configure SQL for HCL Traveler using the SQL Server Management Studio
- Launch the SQL Server Management Studio and log in as an Admin user.
- Create a database user by right clicking Login from Security. Then select New Login.
- Enter a name and password for the user, set the password policies to your company's requirements, and keep the remaining settings as defaults.
- Click OK to create the profile.
- Create the database using the database wizard. Right click Database, then select New Database.
- Fill in the information in the wizard, selecting the defaults unless otherwise instructed. Enter
a database name, then enter the new user name you created previously as the owner of the
database.
The recommended collation setting is
Latin1_General_BIN
. - Click OK to create the database with these settings.
- Grant the DB Login User the requisite permissions defined in Permissions for Enterprise SQL server.
Configure SQL for HCL Traveler using DDL
- Unzip the HCL Traveler DDL in
<domino install data dir>\traveler\cfg\db\TravelerSQL.zip
orTravelerSQL.tar.gz
to the directory<sqldir> cd <sqldir>/SQLSERVER
. - Make any updates necessary, for example the location of files, sizes of the database, schema names, and so on.
- Create the DB Login user, HCL Traveler DB and DB
objects.
sqlcmd -U <admin_user> -P <admin_password> -i "createDb.sql" -v filepath=<path_to_db> password=<password to use for traveler d db user>
- Grant the necessary permissions to the DB Login user to the HCL Traveler DB.
sqlcmd -U <admin_user> -P <admin_password> -i "appGrants.sql"
- Update the
notes.ini
to add the following property to tell the system the HCL Traveler DB and its objects were created:NTS_AUTO_DBSCHEMA=false
Configure MySQL for HCL Traveler using the MySQL Command Line
- Start the MySQL Command Line Client and enter in the following to
authenticate:
mysql -u <admin_user> -p
- The prompt should now be the following format:
mysql>
. - Enter the following to create the
database:
create database <database name>;
- Alter the database collation:
alter database <database> collate utf8mb4_bin;
- Create a DB login User and grant User the requisite permissions defined in
Permissions for MySQL.Use the following command to assign the minimum required permissions:
create user <db login user> ; grant CREATE, ALTER, INDEX, INSERT, UPDATE, SELECT, DELETE, DROP on <dbname>.* to '<db login user>'@'<traveler servers>';
The
db login user
must have permissions granted for each server in the pool. The<traveler servers>
can specify a wildcard for a set of Traveler servers' hostnames in a pool, or the wildcard character (%
) to accept connection attempts for the user from any host. You can also specify a list of<db login user>@<traveler server>
. For more information on the syntax, see MySQL GRANT command documentation.
Configure MySQL for HCL Traveler using DDL
- Unzip the HCL Traveler DDL in
<domino install data dir>\traveler\cfg\db\TravelerSQL.zip
or TravelerSQL.tar.gz to the directory <mysqldir>, thencd <sqldir>/MYSQL
. - Make any updates necessary, for example the location of files, sizes of the database, schema names, username, and passwords.
- Start the MySQL Command Line Client and enter in the following command to build
the Traveler database and
user:
mysql -u <admin_user> -p < createDb.sql
- Grant the necessary permissions to the DB Login user to the HCL Traveler
DB:
mysql -u <admin_user> -p < appGrants.sql
- Update the notes.ini to add the following property to tell the system the HCL
Traveler DB and its objects were
created:
NTS_AUTO_DBSCHEMA=false