Novell Sentinel™ 6.1.1.0
7
5.2.2 Installing Database Patch with SQL Server Authentication
To install the database patch with SQL Server authentication, you need the credentials for the
Sentinel Database User.
1
Log into the database machine as the Windows Domain user who is the Sentinel Database User.
2
Shut down the Sentinel Server processes (if this has not already been done).
3
Extract the Service Pack zip file (if this has not already been done).
4
Open a command prompt.
5
Change directories to the following directory under the extracted directory:
db_patch\bin
6
Enter the
.\PatchDb.bat
command.
7
Follow the prompts and enter the following information:
Hostname or static IP address of the SQL Server Sentinel Database machine.
SQL Server Database instance name, if any.
Port number of the SQL Server database.
Name of the SQL Server database to patch (ESEC by default).
2 for the SQL Authentication option.
esecdba user password.
After you press
Enter
the final time, the script verifies the entered information and proceeds if
authentication is successful.
8
After the script is done applying the patch, check for any errors. If there are errors, resolve the
errors and re-run the PatchDb utility.
9
After the patch runs with no errors, “Sentinel” services should be restarted.
6 Post-Installation
After running the installer, some additional updates may be necessary.
By default, the Sentinel Control Center (SCC) uses a date and time format that is appropriate for the
locale for which the Sentinel Control Center is configured, but that default can be overridden. For
formatting details on customizing the date and time format in event field in Sentinel Control Center,
see the
Java Web site (http://java.sun.com/j2se/1.5.0/docs/api/java/text/SimpleDateFormat.html)
.
1
Edit the
SentinelPreferences.properties
file.
On Windows:
%ESEC_HOME%\config\SentinelPreferences.properties
On *NIX:
$ESEC_HOME/config/SentinelPreferences.properties
2
Uncomment the following line and modify to customize date and time format for Sentinel
Control Center event date/time fields.
com.eSecurity.Sentinel.event.datetimeformat=yyyy-MM-dd'T'HH:mm:ss.SSSZ
