Sawmill 8.1.6 - Hierarchical web server log analyzer. (Demo)

Sawmill is a powerful, hierarchical log analysis tool, well suited for web server access and referrer logs, but can process almost any log. It runs as a CGI program on your web server, and publishes an intuitive graphical user interface which can be used from any web browser to configure and run Sawmill, or to view the statistics pages. The statistics pages are hierarchical, attractive, and heavily crosslinked for easy navigation. Complete documentation is built directly into the program. Sawmill provides an extensive set of features, including a persistent database, fine control over the appearance of stats pages, and versatile log filtering options.

WHAT'S NEW

Version 8.1.6:

Bugs fixed:

• [841842] Creating and building the database of a profile with a real-time log source on Windows sometimes results in an error, "Unable to read file LogAnalysisInfo\Databases\sawmill_realtime\main\Tables\bottomleveldatebo ttomlevelitem\header.cfg (Broken link)"
• [851291] Creating a profile with Microsoft Media Server log data, and unchecking "session events" gives an error, "Syntax error: Unknown variable 'session_events' in expression" on database build.
• [851829] Added local time zone support for the date filter string option; defaulted to local time zone for UI date filters.
• [860107] When using the "auto" date format, years past 2030 are considered corrupt (which is a problem for Thai log data, since Thai years are around 2553).
• [862673] This was an escaping issue with control characters for all filter expressions added in Config (per profile, per report or per report element filter expression) or entered via the command line.
• [868898] The Salang function current_log_pathname() returns the wrong pathname, for the first file of a multi-file log source, when using multiprocessor log processing.
• [869075] Field values containing ASCII code 26 (control-Z) cause an error on report generation like "Unterminated quote in LogAnalysisInfo\profiles_cache\\raw_report_elements\39f3bc8e94a923143b0ef079f5dc4805.cfg at line 1282."
• [870672] After importing a profile from v7 to v8, the Database Fields page of Config may show "Select log field" as the log field, or may not display at all.
• [877311] Using a "session start" filter on the Individual Sessions report, causes an error like, "Invalid integer size 63 in LocalFileTable::GetIntCell()."
• [880490] Building Sawmill from the encrypted source code, on Fedora Core 13, gives an error, "error: invalid conversion from ‘const SSL_METHOD*’ to ‘SSL_METHOD*"
• [883332] Build a database with Oracle back-end, with a xref table with four or more non-aggregating fields, gives an error when indexing the xref table similar to: "create index x19_3xbx19_13xbx19_17xbx19_18xb on x19l0_0_0_0ux19 (bottomleveldate, cs_username, sc_filter_result, sc_filter_category)'; diagnostics=ODBC error: rec1: SQLstate: 37000; msg=[Oracle][ODBC][Ora]ORA-00972: identifier is too long"
• [884348] When using an Oracle database with the Oracle client driver, if a string field has a value longer than 200 characters, but shorter than 255 characters, it will generate an error "value too long."
• [885674] When using the internal database, main table indices can become larger and larger (more than expected) as database updates occur.
• [886062] Building a database with an external SQL database back-end, and with a SQL prefix, results in indices with names do not include the prefix, potentially causing index name collisions on Oracle, if using multiple databases in the same server.
• [887931] If a database field name is too long, and an external SQL database is being used, report generation will fail with an error like, "Unable to Execute ODBC Query='select x.bottomleveldate, count(x.bottomleveldate) from zxref0 x inner join zbottomleveldatebottomlevelitem b on x.bottomleveldate = b.bottomlevelitem group by x.bottomleveldate'; diagnostics=ODBC error: rec1: SQLstate: 37000; msg=[Oracle][ODBC][Ora]ORA-00972: identifier is too long." This is more common on Oracle, where any hierarchical database field longer than 15 characters will cause this error.
• [888885] Many plug-ins, including Tomcat, show duplicate Day of Week and Hour of Day reports, both in the "Date and time" group and at the top level of the report menu.
• [890225] The built-in function convert_charset() deallocates memory improperly, resulting in crashes or incorrect results in some cases where it is used from a custom log filter.
• [891575] The default "web browser" is reported as "Netscape Navigator" for unknown "Mozilla" user agents (changed it to "Unknown Mozilla").
• [894120] When a report is filtered with a filter which excludes all rows, it generates an error like, "Unable to read 304 bytes from LogAnalysisInfo/Databases//main/Tables/_select_result_21095_0/data.tbl.moved; got only 0 bytes (No such file or directory)"
• [894684] When using a SQL table prefix with non-internal database, database export fails with an error like "Table 'profile.main_table' doesn't exist"
• [896378] A non-administrator can access Setup Wizard with a specially formatted URL.
• [896380] A non-administrator can gain access to user information with a specially-formatted URL.
• [896381] Non-administrators can create/delete user accounts with a specially formatted URL.
• [896383] By changing local JavaScript variables, a malicious non-administrator can gain access to some sections of the user interface restricted to administrators.
• [896387] A non-administrator can change the administrator password using a specially crafted URL.
• [906782] Import of exported database into an Oracle database gives an error like, "#### Unable to prepare ODBC query: ODBC error: rec1: SQLstate: S0002; msg=[Oracle][ODBC][Ora]ORA-00942: table or view does not exist."
• [911657] On Oracle databases using Unicode charset, database builds with fields with long string values can give an error like, 'ORA-12899: value too large for column "SYSTEM"."FILE_TYPEITEMNUM"."FILE_TYPE" (actual: 378, maximum: 255).'

REQUIREMENTS

Mac OS X 10.4 or later.

PRICE

$99.00

DEVELOPER

DOWNLOADS

23784