Technical Library | 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 TRITON Reporting Databases : Update Log Server and Log Database settings
Update Log Server and Log Database settings
Topic 45176 | Web and Email Solutions | v8.2.x | Updated 18-Apr-2016
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
1.
Log on to TRITON Manager and select the Web module.
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 from TRITON Manager and use the Windows Services tool to restart:
*
Websense TRITON Web Security
*
Websense Log Server
7.
When the TRITON service has restarted, log on to TRITON Manager again.
8.
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
Update TRITON Manager and Email Log Server to use the new Log Database location.
1.
Log on to TRITON Manager and select the Email module.
2.
Go to Settings > Reporting > Log Database and enter the IP address of the new SQL Server installation in the Log database field.
3.
Click OK (in the Log Database Location area of the screen).
4.
On the machine running Email Log Server, start the Email Log Server Configuration utility (Start > All Programs > Websense > TRITON AP-EMAIL > Email Log Server Configuration).
5.
In the Database tab, click Connection to open the Select Data Source dialog box.
6.
Select the Machine Data Source tab and click New to open the Create New Data Source dialog box.
You will create a new data source connection to the new email database location.
7.
Select System Data Source (Applies to this machine only) and then click Next.
8.
In the list of drivers, select SQL Server and then click Next.
9.
In the next dialog box, click Finish.
10.
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 TRITON AP-EMAIL database is located.
11.
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.
12.
In the next dialog box, enable Change the default database to and then select esglogdb76 from the drop-down menu. Then click Next.
13.
In the next dialog box, accept the default settings and click Finish.
14.
Click Test Data Source to test the connection. Upon test success, click OK.
15.
Click OK, then click OK once more.
16.
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.
17.
In the Email Log Server Configuration utility, click Apply and then OK to the warning message about stopping and restarting Log Server.
18.
On the Connection tab, under Service Status, click Stop.
This stops Email Log Server.
19.
Click the same button (it now is labeled Start).
This starts Email Log Server. It is now configured to use the new TRITON AP-EMAIL database location.
20.
Click OK to close the Email Log Server Configuration utility.

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 TRITON Reporting Databases : Update Log Server and Log Database settings
Copyright 2016 Forcepoint LLC. All rights reserved.