---------------------------------------------------------------------- ELOQUENCE B.07.10 - patch PE71-0705231 ---------------------------------------------------------------------- This patch adds enhancements or fixes defects of the fwaudit utility as released with Eloquence B.07.10. This patch will be integrated in the Eloquence B.07.10 release. Eloquence B.07.10 must be installed before applying this patch. Severity: PE71-0705231: BUG FIX Superseded patches: PE71-0705230: BUG FIX PE71-0608010: BUG FIX PE71-0606293: BUG FIX PE71-0602283: ENHANCEMENT Patch PE71-0705231 ------------------ Platforms: All * The previous patch PE71-0705230 introduced a problem where numeric filter values could cause unexpected results. * Changed the Windows file version to "7.1.0.10" Patch PE71-0705230 ------------------ Platforms: All * If the same item name is used with different types in different databases, fwaudit could fail with an error message indicating a wrong syntax was used (#3370). item requires a string filter argument This could happen when a numeric item value is used in a filter expression. If an item with the same name exists in another database that has a non-numeric item type (X, U or B), fwaudit aborted on any record referring to that item. item requires a numeric filter argument This could happen if a string item value is used in a filter expression and fwaudit encountered an item with the same name that has a numeric item type. As a solution, fwaudit now accepts both string and numeric values on all item types. For numeric item types, if a string can be converted to a numeric value, it will be used, otherwise the value does not match and fwaudit continues. For string item types, a numeric value will be used literally for an alphanumeric comparison. * The "id" session item was added to allow to filter by a specific session identifier (#3343). The syntax is: id relational-op {integral-value} id BETWEEN {integral-value} AND {integral-value} relational-op: < <= = <> >= > integral-value: session identifier to compare with If using BETWEEN, the AND keyword may be omitted. For example: id = {42} ID BETWEEN {108} AND {110} * The "conntime" session item was added to allow to filter by the session connection timestamp (#3343). The syntax is: conntime relational-op {date-time-value} conntime BETWEEN {date-time-value} AND {date-time-value} relational-op: < <= = <> >= > date-time-value: YYYY-MM-DD HH:MM:SS MM/DD/YYYY HH:MM:SS DD.MM.YYYY HH:MM:SS In date-time-value, the time part is optional (defaults to 00:00:00). If using BETWEEN, the AND keyword may be omitted. For example: conntime >= {2005-07-26} conntime between {07/26/2005 10:00} and {07/26/2005 12:00} CONNTIME BETWEEN {26.07.2005 15:31:40} {26.07.2005 15:31:50} * Changed the Windows file version to "7.1.0.9" Patch PE71-0608010 ------------------ Platforms: All * The fwaudit utility was incompatible with previous forward-log file revision 1.1 to 1.3. * Changed the Windows file version to "7.1.0.8" Patch PE71-0606293 ------------------ Platforms: All * The fwaudit utility was modified to add support for the modified forward-log file format added with eloqdb6 patch PE71-0606290. * Changed the Windows file version to "7.1.0.7" Notes / Related patches: - The following related patches (or superseding) should be installed with this patch: - PE71-0606290 - eloqdb6 server - PE71-0606291 - dblogreset utility - PE71-0606292 - dbrecover utility Patch PE71-0602283 ------------------ Platforms: All * The fwaudit utility was modified to add support for the modified forward-log file format added with eloqdb6 patch PE71-0602280. The eloqdb6 server process was enhanced to use a more efficient format to record index and meta data changes. This enhancement results in a substantial reduction in disk space for the forward-log file when index entries are changed frequently. This change required a modification of the forward-log file format. While older forward-log files are still supported, related utility programs need to be updated to handle the new format. Notes / Related patches: - The following related patches (or superseding) should be installed with this patch: - PE71-0602280 - eloqdb6 server - PE71-0602283 - dblogreset utility - PE71-0602282 - dbrecover utility Installation: ------------- Please download the patch archive that corresponds with the installed release. The patch files follow the conventions below: PE71-0705231-hpux-ia64.tar.gz ^ ^ ^ | | Architecture / OS specific build | Operating system Patch ID HP-UX: In order to install this patch, you need to unpack it with gzip and tar. Gzip is included with HP-UX. Installation requires root privileges. cd /opt/eloquence6 gzip -dc /path/to/PE71-0705231-hpux.tar.gz | tar xf - Files: bin/fwaudit share/doc/PE71-0705231-README Linux: In order to install this patch, you need to unpack it with tar. Installation requires root privileges. cd /opt/eloquence6 tar xzf /path/to/PE71-0705231-linux.tar.gz Files: bin/fwaudit share/doc/PE71-0705231-README Windows XP/2000/NT: This patch should *only* be installed if you previously installed the Eloquence server components on your system. Installation requires administrative capabilities. Two options are available for patch installation. The patch is available as self extracting archive for automatic installation and as a zip archive for manual installation. Both patches are equivalent. Installation requires administrative capabilities. For autmatic installation of this patch, please download the patch file PE71-0705231-win32.exe file. Before installation, please consider closing all applications and execute the patch installation program. Installation does not require a reboot unless the patched files were active. For a manual installation of the patch, please download the patch file PE71-0705231-win32.zip file and unpack its contents. Then perform the following steps: * Please copy the fwaudit.exe file into the bin subdirectory of your Eloquence installation (for example C:\Programs\Eloquence\bin). * Please copy the PE71-0705231-README.txt file into the share\doc subdirectory of your Eloquence installation (for example C:\Programs\Eloquence\share\doc). Files: fwaudit.exe PE71-0705231-README.txt