8.2 Setting Up the SQL Database

Prepare your in-house SQL server by completing the steps in one of the following sections:

8.2.1 Configuring a PostgreSQL Server

IMPORTANT:Do not create the TeamWorks database on your PostgreSQL server manually.

Let the TeamWorks configuration wizard create the database to ensure the correct configuration.

Table 8-1 Configuring PostgreSQL for TeamWorks

File

Do This

 

1 - Edit the configuration file.

PostgreSQL server > /etc/my.cnf file

  1. Edit the file as follows:

    [client] 
default-character-set = utf8
    [PostgreSQLd]
character-set-server = utf8
max_connections = 900
transaction-isolation = READ-COMMITTED
expire_logs_days = 7

    The expire_logs_days setting is optional, but is recommended because it cleans up PostgreSQL-bin-* files.

    Unless this is done regularly, the files will consume significant disk space in the vastorage directory.

  2. Uncomment the InnoDB tables section.

  3. Increase the buffer pool size to approximately 60 percent of the amount of RAM that has been allocated to the dedicated server.

    For example, a dedicated server with 4 GB of RAM should have a buffer pool size of 2560 MB, as follows:

    innodb_buffer_pool_size = 2560M

  4. Identify or create a user account with sufficient rights to create and manage the TeamWorks database.

Worksheet 12

  1. Record the username and password on Worksheet 12.

  2. Continue with Setting Up Three Search Appliances.

8.2.2 Configuring a Microsoft SQL Server

IMPORTANT:Do not create the TeamWorks database on your MS SQL server manually.

Let the TeamWorks configuration wizard create the database to ensure the correct configuration.

Table 8-2 Configuring Microsoft SQL Server for TeamWorks

File

Do This

 

1 - Configure the server.

Server management console

  1. Enable remote access to the Microsoft SQL database server.

  2. Open port 1433 on the Windows firewall where the database server is running.

  3. Identify or create a user account that is configured with SQL Server Authentication and has sufficient rights to create and manage the TeamWorks database.

    IMPORTANT:TeamWorks supports only SQL Server Authentication. Windows Authentication and Windows Domain User Authentication to Microsoft SQL are not supported.

Worksheet 12

  1. Record the username and password on Worksheet 12.

Server management console

  1. Run the following queries against the database:

    ALTER DATABASE database-name SET READ_COMMITTED_SNAPSHOT ON         
ALTER DATABASE database-name COLLATE Latin1_General_CI_AS_KS_WS

  2. Continue with Setting Up Three Search Appliances.