Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Manually Creating the Web Security Log Database : Running the database creation utility
Running the database creation utility
Topic 50336 | Creating the Log Database | Updated 22-Oct-2013
A database creation utility (createdbu) is installed with Websense Log Server. You can use this command-line utility to create or upgrade the Log Database manually.
To use the database creation utility, you must provide a database name and the IP address of the Microsoft SQL Server machine.
*
*
If the database name is found, the existing database is upgraded.
*
To run the database creation utility:
1.
2.
Navigate to the Websense SQL directory (C:\Program Files (x86)\Websense\Web Security\SQL, by default).
3.
createdbu -ip <IP_address> -name <db_name> -user <user_name> -pass <password>
For example:
createdbu -ip 10.123.123.123 -name wslogdb70 -user sa -pass testpassword
This prompts the utility to create or upgrade the database "wslogdb70" on the SQL Server machine at 10.123.123.123. The SQL Server "sa" account is used, and the password is "testpassword."
*
*
*
4.
*
*
*
5.
Enter database connection information on the Settings > Reporting > Log Server page in the Web Security manager, then click OK and Save and Deploy.
Log Server creates the ODBC connection and provides connection information for the other reporting components.
6.
*
(v7.7) Go to the Log Server machine and use the Windows Services dialog box to start Websense Log Server.
*
(v7.8) Use the Component List tab of the Status > Deployment page to start Log server.
Once Websense Web Security installation is complete and policy enforcement has started, data should begin to appear in the Web Security manager. Use Real-Time Monitor, dashboard charts, investigative reports, or presentation reports to verify that reporting data is being recorded. If no data or incomplete data appears in reporting tools, see Incorrect or missing data in Web Security reports.

Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Manually Creating the Web Security Log Database : Running the database creation utility
Copyright 2016 Forcepoint LLC. All rights reserved.