Configuring databases for SafeLinx with DDL
The SafeLinx installation provides a set of database definition language (DDL) scripts to create and configure the SafeLinx session and accounting databases.
About this task
To prepare a relational database for use with SafeLinx, you must apply a schema, configure specific database objects, and grant permissions. In many situations, you can complete these tasks automatically when you run the configuration wizards from the SafeLinx Administrator. However, in organizations that grant direct access to database servers, to designated database admins only, it might not be possible to use the configuration wizards. Instead, when a SafeLinx admin is not allowed to access the database server, a database admin can run a set of DDL scripts to create and configure the SafeLinx databases.
When you install SafeLinx, three sets of DDL scripts are copied to the installation directory on the SafeLinx Server. One set is for use with DB2 databases, another set for MySQL databases, and the third is for SQL Server databases. DDL scripts for Oracle database are not provided. Table 1 lists the scripts in the order in which you use them, and describes the action that each script performs. The scripts for DB2, MySQL, and SQL are identically named. Table 2 specifies the directories in which the scripts are installed on each supported operating system.
Script name | Description |
---|---|
wgdata-create.sql | Script to create a session database. |
wgacct-create.sql | Script to create an accounting database. |
wgdata-update.sql | Script to update a session database. Run this script to update a session database that you created with an earlier version of wgdata-create.sql. If you created the session database with the current version of the creation script, do not run the update script. |
wgdata-grant.sql | Script to grant a user limited access permissions to the session database. |
wgacct-grant.sql | Script to grant a user limited access permissions to the accounting database |
Operating system | Script locations |
---|---|
Linux™ |
/opt/hcl/SafeLinx/conf/DB2 /opt/hcl/SafeLinx/conf/MYSQL /opt/hcl/SafeLinx/conf/SQL |
Windows™ |
<Installation_directory>\SafeLinx\conf\DB2 <Installation_directory>\SafeLinx\conf\MySQL <Installation_directory>\SafeLinx\conf\SQL |