Documentation | Support

Go to the table of contents Go to the previous page You are at the end of the document View or print as PDF
Moving the Reporting Databases : Update Log Server and Log Database settings
Update Log Server and Log Database settings
Moving the Reporting Databases | Web, Data, and Email Solutions | 8-June-2020
 
Applies to:                                         
*
Forcepoint Web Security and Forcepoint URL Filtering, v8.5.x
*
Forcepoint DLP, v8.5.1, v8.6.x, v8.7.x
*
Forcepoint Email Security, v8.5.x
*
Forcepoint appliances, v8.5.x
Once the Log Database has been moved and the SQL Server jobs have been created, configure Log Server to send data to the new database location, and configure the Log Database to use the new location when it creates new partitions.
Web Log Server and Log Database settings
To update database connection settings for Forcepoint Web Security or Forcepoint URL Filtering:
1.
Log on to the Web Security module of the Security Manager.
2.
Navigate to the Settings > Reporting > Log Server page.
3.
Under Log Database Connection, update all of the connection information to enable communication with the new SQL Server installation.
4.
Click Test Connection to validate the new connection information.
5.
Click OK, then Save and Deploy to implement the changes.
6.
Log off of the Security Manager.
7.
Use the Windows Services tool to restart the following services:
*
Websense TRITON Web Security
*
Websense Log Server
8.
When the services have finished restarted, wait 30 seconds, then log on to the Security Manager again.
9.
On the Settings > Reporting > Log Database page, under Partition Management, update the Data and Log File Path entries as needed.
This ensures that new database partitions are created in the correct (new) location.
Email Log Server and Log Database settings
To update database connection settings for Forcepoint Email Security:
1.
Log on to Email Security modules of the Security Manager.
2.
Go to the Settings > Reporting > Log Database page and enter the IP address of the new SQL Server installation in the Log database field.
3.
(Optional) On the Settings > Reporting > Log Database page, under Partition Management, update the Data and Log File Path entries as needed.
This ensures that new database partitions are created in the correct (new) location. Do not follow this step if you intend to place database partitions in the old location.
4.
Click OK (in the Log Database Location area of the screen).
5.
On the machine running Email Log Server, start the Email Log Server Configuration utility (Start > All Programs > Forcepoint > Forcepoint Email Security > Email Log Server Configuration).
See Email Log Server Configuration Utility Help for more information.
6.
In the Database tab, click Connection to open the Select Data Source dialog box.
7.
Select the Machine Data Source tab and click New to open the Create New Data Source dialog box.
8.
Select System Data Source (Applies to this machine only) and then click Next.
9.
In the list of drivers, select SQL Server and then click Next.
10.
In the next dialog box, click Finish.
11.
In the Create a New Data Source to SQL Server wizard, enter a Name, Description, and the Server IP address for the new data source connection. Then click Next.
The server IP address should be the new IP address of the machine on which the Email Log Database is located.
12.
In the next dialog box, select options as described below.
a.
Select an authentication method for connecting to the database:
*
With Windows NT authentication using the network login ID: to use a Windows trusted account.
*
With SQL Server authentication using a login ID and password entered by the user: to use a SQL Server account.
b.
Enable Connect to SQL Server to obtain default settings for the additional configuration options.
c.
Enter the Login ID and Password of the sa SQL Server account if you selected SQL Server authentication in Step a above).
d.
Click Next.
13.
In the next dialog box, enable Change the default database to and then select esglogdb76 from the drop-down menu. Then click Next.
14.
In the next dialog box, accept the default settings and click Finish.
15.
Click Test Data Source to test the connection. Upon test success, click OK.
16.
Click OK, then click OK once more.
17.
In the SQL Server Login dialog box, enter a Login ID (by default, sa) and Password. Then click OK.
If you choose to Use Trusted Connection (i.e., Windows NT authentication), Login ID and Password are not necessary.
18.
In the Email Log Server Configuration utility, click Apply and then OK to the warning message about stopping and restarting Log Server.
19.
On the Connection tab, under Service Status, click Stop.
This stops Email Log Server.
20.
Click the same button (it now is labeled Start).
This starts Email Log Server. It is now configured to use the new database location.
21.
Click OK to close the Email Log Server Configuration utility.
 
©2020 Forcepoint. Forcepoint and the FORCEPOINT logo are trademarks of Forcepoint. All other trademarks used in this document are the property of their respective owners.

Go to the table of contents Go to the previous page You are at the end of the document View or print as PDF
Moving the Reporting Databases : Update Log Server and Log Database settings
Copyright 2021 Forcepoint. All rights reserved.