...
Tip |
---|
Snare MSSQL Agent v5.1.0 was released on 11th April 2018. |
Enhancements
- New command line switch /license is introduced for the agent setup configuration file (.INF). This switch can point to the license file to be used during installation. This license file selected through /license switch has the higher priority than the license options selected though installer UI. For example /license="20180206-SnareAgent-Evaluation-AZP-CYT.sl"
- Previously, when option 'Host IP As Source' was selected then first IP address of machine was used as source address with reported events. Now user is shown all the IP address of the machine through a drop-down list. User can select the specific IP address to be used to report the source IP of the events.
- Any file destination now shows the real file name along with any date appended to file name for rotation, for example C:\file_events_YYYYMMDD.txt.
- User Interface (UI) update that affects the IP Address allowed to remote control SNARE field on the Access Configuration page. This data entry field is disabled if Restrict remote control of SNARE agent to certain hosts check box is not selected. Host IP Address or hostname details can only be entered if the checkbox has been selected.
- Updated usability on the Destination Configuration page, with a Hostname Options section.
- Trace level logging now displays the bytes and events sent per second (EPS) for each configured destination after 5 secs. This will aid in correlating and debugging the EPS rates when sending logs.
Security Updates
- Maintenance update for OpenSSL to patch to OpenSSL-1.0.2n.
Bug Fixes
- In previous releases of SnareMSSQL when 'Use HostIP' option was selected, SnareMSSQL use to select the IP address of the physical machine on which it is running. This was same for cluster mode too. Though, in cluster mode it should select the IP address of the virtual server on which SQL Server is installed. This issue is fixed in this release and now when 'Use HostIP' option is selected, SnareMSSQL selects the IP address of the virtual server on which cluster instance of SQL server is installed.
- There was a bug that can cause the installation of the SnareMSSQL on a clustered environment to fail when the SQL server instance name detected was MSSQLSERVER. This issue is fixed in this release and now SnareMSSQL installer properly handles the default SQL server instance name.
- Issue with agent running on SQL server cluster machine and Use Host IP options is selected. Due to this issue SnareMSSQL fails to determine the correct IP address of SQL cluster in some cases. This issue is fixed and now SnareMSSQL properly computes the IP address of SQL server cluster systems.
- There was an issue in previous release of SnareMSSQL where installation for some local instances of SQL server can be omitted in a hybrid installation environment i.e. where cluster instances and standalone instances of SQL server are installed on the same machine. This issue is fixed and now SnareMSSQL installer properly handles the installation of local and cluster instances of SQL server on the same machine.
- There was an issue in previous release the way SnareMSSQL used to determine the hostname of the generated SQL event. Due to this issue, the hostname of the SQL event may be determined as the machine hostname on which SnareMSSQL agent is running. This issue is fixed and now SnareMSSQL property determines the machine hostname as per user preferences.
- Fix for failed installations occurred on busy machines. The installer now properly checks the status of service operations and retries appropriately when needed.
- There was minor issue in existing release of SQL agent when installed on SQL server cluster installations. Due to this issue the web GUI ports were not sequentially allocated to the different instances of the Snare SQL agent on the same cluster node. In this release the agent correctly allocates the web ports sequentially. To use this sequential installation, the existing installation of the agent should be removed (uninstalled) or the agent installer should be rerun with the reinstall option.
- There was an issue in the installer not working correctly in the previous release of SnareMSSQL agent if the local SQL Server instances were in a failed state in a cluster environment. This problem was specifically prevalent in mixed installation scenarios where local and cluster instances of SQL Server are installed on a same cluster node.
- There was an issue the way SnareMSSQL was handling the username for Latest Events page. Due to this issue, username was shown on Latest Events page for some events. This issue is fixed in this release and now SnareMSSQL properly handles the username for Latest Events page. Also not that if a username is not reported by the SQL Server trace function then it will still not be shown and the username column will show '-'.
- Previous release with the agent where it cannot detect the 32-bit instances of SQL server installed on 64-bit machine. Due to this issue SnareMSSQL was unable to create objectives for such 32-bit SQL server instances on 64-bit machine. This is fixed and now SnareMSSQL is able to detect 32-bit instances of SQL Server on 64-bit machines and also able to generate trace logs from such instances.
- Fixed an issue with the CEF message format having missing/incorrect information as well as possible special characters causing the message to not display correctly in ArcSight.
- The agent installer is capable of listing any license files it finds in the same directory as the agent executable. This change updates the agent installer to include a "None" option, to not install any license file if present.
- Fixed a bug where the Snare Agent would not import the SyslogPriority and SyslogFacility values from an .INF (agent setup configuration file). Consequently CacheSizeEventLog was not used due to this bug.
- Objective matching in Snare support wildcards. In existing release of Snare in some situations this wildcard matching can cause stack overflow crash. This issue is fixed in this release and stack overflow possibility is removed during wildcard matching.
In previous release there was a bug in the user match using wildcard match. Due to this issue expected user names can be filtered in or out. This is fixed and now wildcard filter for user match works correctly. Now the wildcard pattern for user matching should be included within () i.e. (*sa*) and user filter on specific user should be included by mentioning it's name i.e sa. For example include user pattern {sysadmin:^sa},(!dummy*),*tom*,micky is that include all SQL server sysadmin users, do not include users starting with dummy,and include user name having tom in it and user micky.
Some agent settings are machine specific i.e. Clientname, HostIP and HostGUID. There was an issue in the export settings command -x that was causing these machine specific settings to be exported into the .inf file and then can subsequently be loaded with /loadinf option during install. This issue is fixed in this release and now machine specific values are not exported into .inf file and even if .inf file is manually edited; these values are ignored during loadinf option.
- Fix issue with heartbeat license messages spamming the logs with a license heatbeat every 60 minutes (if heartbeats are disabled) or every heartbeat period. Also fixed an issue with SAM issued licenses being immediately marked as expiring in 30 days and thus warning the customer that it was about to expire.
- Heartbeats events are added for the Information level to provide more information regarding the working of agent. These new heartbeats are sent when any setting is changed from GUI and when the agent service status is changed.
- This change modifies Agent behavior to not log any heartbeat if there is no SAM configured to connect. If there is a SAM configured, then to log a heartbeat if the connection is lost for every 2 hours.
- There was an issue with the internal restart of the agent. Due to this issue agent might keep holding a token handle during internal restart. This issue is fixed in this release and now agent properly releases all the token handles.
- Fixed an issue whereby the Snare Server (via AMC) could not retrieve the master configuration from a SnareMSSQL Agent using digest authentication.
Other
Version 5.1.0 is the final version to support operating system Windows XP for 32-bit and 64-bit.