Security Manager for Mantra

Release Notes

Date Published: May 2011

 
 

 

Security Manager for Mantra monitors events generated by Mantra devices in real-time. By detecting, alerting on, and automatically responding to critical events, Security Manager for Mantra helps identify, correct, and prevent possible configuration problems and external intrusions or attacks.

Security Manager for Mantra collects data from the Mantra device and stores the data in secure repositories so you can archive it, create reports for management or auditing purposes, and analyze critical events to research issues. Security Manager for Mantra collects all syslog data you configure the Mantra device to send to the Windows agent.

Improvements are made in direct response to suggestions from our customers. We thank you for your time and valuable input. We hope you continue to help us ensure our products meet all your needs. You can post feedback in the Security Manager forum on Qmunity, our community Web site that also includes product notifications, blogs, and the Security Manager user group.

This document outlines why you should install this module, lists any installation requirements, and identifies any known issues.

Supported Products

This release supports Mantra 6.0.2, 7.0 and 7.6.

Return to Top

Why Install This Module?

Security Manager for Mantra monitors real-time events that the Mantra device sends to the Windows agent computer and archives all data received from the device. This data includes any change or access event generated for a monitored file, file share, or database that matches the policy criteria configured on the Mantra device. The volume and type of data that Security Manager for Mantra collects is determined by the configuration of the device and the policies you have created on the device.

Security Manager for Mantra has the capability to monitor, alert and archive on the following events:

  • Schema changes to each monitored database
  • Configuration changes to each monitored database
  • Data read or changed from each monitored database, file, or file share
  • Logon and logoff activity for each monitored database, including login failures

Note
Security Manager for Mantra also receives syslog messages for activity on the Mantra device itself, such as logins to the device and configuration changes. However, these messages do not include any unique characteristics that enable Security Manager to identify them as Mantra-specific messages, so Security Manager archives these types of messages as generic syslog data.

You can use the data Security Manager collects to produce various reports. For example, you can report on the largest number of failed logins to monitored databases from a given source.

Return to Top

System Requirements

The following table lists additional requirements for a Windows agent computer monitoring Mantra. For more information about agent requirements, see the Installation Guide for NetIQ Security Manager.

Category Requirement
Processor 1.5 GHz Intel Pentium III or equivalent.
Memory 40 MB minimum. The amount of memory usage varies and depends on the environment, including event rate and other factors. Memory use for a Windows agent monitoring a Mantra device could reach 256 MB or higher.
Operating System All supported Windows agent platforms.
Software
  • Ensure you have Security Manager 6.5 SP1 or later installed.
  • Ensure you have the latest version of Security Manager Self-monitoring installed.
  • Ensure you install a separate Windows agent for each Mantra device you plan to monitor.
  • If the Mantra device and the agent are separated by a firewall, ensure the firewall allows syslog data through. In addition, install the Windows agent on a subnet as physically close to the firewall as possible. Fewer network hops provide better performance.
  • Install the Windows agent with Mantra support on a separate computer from the database server or central computer.

Return to Top

Installing This Module

Install the module using the Module Installer utility. For more information about installing modules, see the User Guide for NetIQ Security Manager.

You can verify successful installation of the module in the Module Installer. After the installation completes, verify the Status column indicates the module is current and the module version listed in the Installed Version column is the same as the version in the Available Version column. For more information about installing modules, see the Installation Guide for NetIQ Security Manager.

After you install this module, ensure you follow the steps below to configure the Windows agent computer you want to monitor your Mantra device and the Mantra device being monitored. With the agent and Mantra device configured, use the Configuration Wizard to configure the Security Manager for Mantra module.

Return to Top

Configuring the Agent

Add the name and IP address of the Mantra device to the Hosts file on the Windows agent computer. For more information about the Hosts file, see the Windows documentation.

Return to Top

Configuring the Mantra Device

Set up the Mantra device in your environment and configure the appropriate policies and custom actions for your organization. Security Manager collects all data received from the Mantra device and archives the data for analysis and reporting, but the data that the Mantra device sends is determined by the set of policies you configure on the device. For more information about setting up the Mantra device and configuring appropriate policies and actions, see the Mantra documentation.

Once you have set up the Mantra device and configured policies and actions, complete the following required steps on the Mantra device. These steps ensure the Mantra device sends syslog data to the Windows agent in the required format so Security Manager logs events and responds with custom actions where appropriate.

To configure the Mantra device to work with Security Manager:

  1. On the Mantra device, add the IP address of the Windows proxy agent computer you configured to monitor the device.
  2. Review each policy configured on the Mantra device and associate the appropriate custom action with the policy. For each policy whose events you want to send to Security Manager, ensure you select the Log to syslog checkbox option in the Mantra user interface. For more information about configuring custom actions on the Mantra device, see the Mantra documentation.
  3. Use the Mantra Console to assign Security Manager syslog format strings to custom actions. You can assign each syslog string in Security Manager (SecurityManagerArchiveOnly, SecurityManagerAlertWarning, SecurityManagerAlertError, SecurityManagerAlertCritical, and SecurityManagerAlertSecurityBreach) to an action, but you cannot assign more than one syslog string to the same action. Assigning the MantraSMLogOnly syslog format string to an action results in matching events being sent to the log archive only. In order to use the archival and reporting functions in Security Manager for Mantra events, at a minimum you must assign the MantraSMLogOnly syslog format string to an action. If you assign any of the other four syslog format strings to an action, Security Manager automatically logs matching events in addition to performing the assigned custom action.
  4. To assign custom actions, perform the following steps:

    1. Open the command line interface on the Mantra device and type each of the following commands on a separate line:
    2. 	enable
      
      	configure terminal
      
    3. Using the following syntax, type a separate command for each action to which you want to assign the Security Manager syslog string:
      	tzaction name <name of action> format-syslog "<syslog string>"
      

    For example, the following command assigns the MantraSMCritical syslog format string to the SecurityManagerAlertCritical action:

    	tzaction name SecurityManagerAlertCritical format-syslog "MantraSMCritical:$datetime|
    	$server.type|$policy|$server.application|$server.info|$location.clientip|
    	$location.clientport|$location.serverip|$location.serverport|$operation.file|
    	$operation.sql|$user.serveruser|$user.hostuser|$content.table|$content.column|
    	$content.filepath|$content.filename|$eventid|$session.source|$session.sourcename|
    	$command.text|$size.rows|$Response.Status|$session.programname|$session.id"
    

    Note
    Ensure you type each command, including the syslog format string, on a single line, using only a pipe character (|) delimiter between parameters in the string. Enclose the syslog string in double quotes and do not use spaces.

    Use the following syslog strings to assign the syslog format to the actions you want to send to Security Manager:

Return to Top

Configuring Security Manager for Mantra

After configuring the Windows agent and monitored Mantra device, configure this module using the Configuration Wizard. Open the Configuration Wizard from the Security Manager Control Center, then click Support for Databases > Configure the module for Mantra. In the Configuration Wizard, specify the Windows agent computer you want to receive syslog data from the Mantra device and specify the IP address or host name of the Mantra device.

For more information about using the Configuration Wizard to configure the Security Manager for Mantra module, see the Configuration Wizard Help.

You can verify successful configuration of your environment by logging onto a Windows agent computer you specified in the Configuration Wizard for monitoring Mantra devices, opening a command prompt, and typing the following command:

	netstat -ano -p UDP

In the list of active connections, look for an open port used for syslog communication. The default port is 514.

Creating Custom Processing Rules

NetIQ recommends you create your own custom processing rule group outside of the processing rule group installed with the module and then create custom processing rules for your environment. You can copy the predefined rules included in the module processing rule group to your custom processing rule group or create new rules within your custom processing rule group.

If you create or modify processing rules within the module processing rule group, the next time you install an updated version of the module, Security Manager may remove your customized rules. If you use your custom processing rule group to create or modify rules, Security Manager does not remove your customized rules when you install a new version of the module.

Return to Top

Mantra Event Fields Used by Security Manager

Security Manager for Mantra collects various fields from the data received from monitored Mantra devices. Security Manager stores some of those fields in the log archive and uses some fields for generating real-time alerts or in Forensic Analysis queries.

The following table lists the Mantra data fields most commonly used by Security Manager and maps those fields to the corresponding names and values used for real-time alerting, log archival, and Forensic Analysis. You can use these fields to create processing rules or Forensic Analysis queries tailored to your specific environment. For more information about creating processing rules, see the Programming Guide for NetIQ Security Manager.

Real-Time Parameter Name/Number Log Archive Field Name Forensic Analysis Column Name
$Computer Analyzer.node.name Mantra Device
$Computer analyzer.node.address.address Device Address
Source classification.origin Not used
N/A analyzer.model Not used
$EventType Event Type Not used
$EventNumber Not stored in log archive Not used
$ProviderName Log Source Not used
$Message Not stored in log archive Not used
3 target.object.type Server Type
4 Rule Name Policy Name
5 target.service.name Server Application
6 target.database.info Affected Databases
7 source.node.name
source.node.address.address
Client Address
8 source.service.port Client Port
9 target.node.name
target.node.address.address
Server Address
10 target.service.port Server Port
11 action Operation
13 target.user.userid.name Server User
14 source.user.userid.name Host User
15 target.table.info Affected Tables
16 target.column.info Affected Columns
17 target.object.path Target File Path
18 target.file.info Affected Files
19 event.Sequence.Id Mantra Event Id
20 source.interface.type Session Source
21 source.interface Session Source Name
22 message Command Text
23 size.count Rows Returned
24 Status Response Status
25 source.process.name Program Name
26 Session name Session ID

Return to Top

Known Issues

NetIQ Corporation strives to ensure our products provide quality solutions for your enterprise software needs. The following issues are currently being researched. If you need further assistance with any issue, please contact Technical Support.

Upgrading Requires Updated Version of Previously Installed Log Manager for Mantra Module

The Security Manager for Mantra module replaces the Event Manager for Mantra and Log Manager for Mantra modules. However, if you upgrade from Log Manager for Mantra to the Security Manager for Mantra module, you must also use the Module Installer to install the latest version of the Log Manager for Mantra module, available on the NetIQ AutoSync Server. In the Module Installer, the name of the Log Manager for Mantra module is "Log Manager for Mantra (Obsolete)," located in the "zzz Obsolete Modules - Only select if already installed" category.

If you did not previously install the Log Manager for Mantra or Event Manager for Mantra modules, you need to install only the Security Manager for Mantra module. (DOC300057)

Top-Level Log Manager for Databases Processing Rule Group Displayed After Upgrade

After you upgrade from the Log Manager for Mantra module to the Security Manager for Mantra module, the Development Console displays not only the new top-level Support for Databases processing rule group and Support for Mantra sub-processing rule group but also the previous top-level Log Manager for Databases processing rule group. The Log Manager for Databases processing rule group is only a "container" processing rule group that includes no rules of its own. You can delete the unneeded processing rule group by right-clicking Log Manager for Databases and selecting Delete. (ENG299313)

Superseded Release Notes Not Removed on Upgrade

The Security Manager for Mantra module replaces the Event Manager for Mantra and Log Manager for Mantra modules. However, a known issue exists where Security Manager cannot remove old release notes files when installing updated modules. Release notes are installed by default in the \Program Files\NetIQ Security Manager\OnePoint\Documentation\Release Notes\Module Release Notes folder on the central computer, but may have been moved or copied to a different location in your environment. After upgrading this module, you should manually delete any superseded release notes in the default folder or in other folders.

Return to Top

Contact Information

Please contact us with your questions and comments. We look forward to hearing from you.

For detailed contact information, see the Support Contact Information Web site.

For interactive conversations with your peers and NetIQ experts, become an active member of Qmunity, our community Web site that offers product forums, product notifications, blogs, and user groups.

Return to Top

Legal Notice

Return to Top