]> git.ipfire.org Git - thirdparty/sarg.git/blame - ChangeLog
Add support for regular expressions in aliasing the hosts
[thirdparty/sarg.git] / ChangeLog
CommitLineData
25697a35
GS
1SARG ChangeLog
2
1c72006e
FM
3Dec-29-2011 Version 2.3.3-pre1
4 - Don't abort the report generation due to an error in a squidGuard error (wrapped over log lines).
5 - Support for gd, ldap and iconv can be disabled during configuration.
6
7Dec-07-2011 Version 2.3.2
89a11a43 8 - Add support for sorttable.js (http://www.kryogenix.org/code/browser/sorttable/) to dynamically sort some tables (thanks to Éric).
c995d358 9 - Add the two command line options --lastlog and --keeplogs to set the number of reports to keep or to keep all the reports respectively (thanks to Emmanuel Lacour for the suggestion).
02808722 10 - Report the user ID in the e-mail report.
70cab1a4 11 - Add an option to sort the top sites by time.
644f08d7 12 - Delete unused files from the directory containing the user report (thanks to alf-man).
9aaa3361 13 - Add the index_fields option to hide the directory size column in the index sorted by date.
2c7e8c23 14 - Split the input log file in several files each containing one day worth of data (thanks to Mauricio Silveira).
829a53c2
FM
15 - Take the date_format into account when converting a log file.
16 - Accept IPv6 addresses in the realtime report.
17 - Don't fail for an empty report directory when building the index.
c076946c 18 - Fix a read error when parsing the time of a common log format (thanks to Richard P Scott).
829a53c2 19 - Use anonymous file and directory names in the report to hide the identity of the user whose report is displayed and shorten the total path length.
c076946c 20 - More robust calls to external sort commands (guard against buffer overflows and use tab as column separator).
f59fe242
FM
21 - Replace host names by aliases and group identicaly aliased host names.
22 - IPv6 is accepted in the hosts exclusion list.
a9341a7c 23 - Discriminate between users whose name produce the same mangled temporary file name.
7ae50eee 24 - Write a note about the number of entries ignored in the reports (thanks to Iain Lopata).
b5aa53e2 25 - Command line option -z output some messages to explain why the reports are not generated due to the configuration.
a58e6d54 26 - The Sites & Users report page links to the user's page if the user is listed in the Top Users page.
ea275279 27
bf992832 28Sep-18-2010 Version 2.3.1
c20b1fe7 29 - Remove the distinct printf for the alpha architecture as it doesn't work anymore and is not necessary anyway.
d82e8117 30 - Don't abort if "onload" or "script" is found in the user agent string.
d49c75f3 31 - Take the configured locale path into account when installing sarg.
dff8d30f
FM
32 - Fix the realtime and e-mail reports.
33 - Allow for the translation of the sort criterion on the report pages.
34 - The mail_utility command isn't quoted any more so it is possible to add some command line arguments.
35 - Fix a wrongly reported error if the two "hours" and "weekdays" options are enabled in sarg.conf (thanks to guyizsolt).
36 - Add a link on the denied page to link the page to the corresponding user.
37 - Fix a problem with the progress indicator when reading from a compressed log file.
38 - Report an error if the output directory is a subdirectory of the temporary directory.
39 - Use a more robust protection against an attack using javascript in the useragent string.
86f4d07c 40 - Prevent a segfault if the parameter passed to command line option -d is invalid (thanks to ItalianPenguin).
89dbb8e8 41 - Check for the return code of the tail command to generate the realtime report.
bf992832 42 - Escape the invalid characters in the LDAP search string instead of truncating it at the first invalid character (thanks to mouchar for reporting the problem and testing the fix).
c20b1fe7 43
2141e6ca 44Jun-21-2010 Version 2.3
e3af0ae9
PO
45 - LDAP usertab added.
46 Now you can have your users in a LDAP Server.
47 Use these tags in sarg.conf: LDAPHost, LDAPPort, LDAPBindDN, LDAPBindPW,
48 LDAPBaseSearch, LDAPFilterSearch
085c1e1f 49 - Parse the string flags from sarg.conf once during the reading of sarg.conf instead of manipulating and duplicating the tests of the strings where they are used.
012ba254 50 - Useragent report limited to requested date range.
33dc7dec 51 - Link to external css file instead of including it verbatim in each HTML file (thanks to Maxim Britov).
095bc6be 52 - Enable gettext configuration for autotools.
74a5efbb
FM
53 - Use gettext translations instead of the custom languages files.
54 - Keep the user name unchanged in the report (suppress the replacement of some characters by underscores).
55 - Try to resolve a user's IP address only once and store the result. It can speed up the processing a lot.
56 - Resolve IPv6 addresses (to be tested).
57 - Don't limit the maximum length of a URL (the only limit is that a single line of text from the log file must fit in memory).
58 - The creation of the datafile is working again.
d5d021c5 59 - Use a template to build the .htaccess file of each report.
5e92ef88 60 - Accept spaces in the replacement label of the usertab file (thanks to Alex Sav).
6a593ca2 61 - Change the version number of the release candidate to conform to the numbering of the translationproject.org.
fa6552b0
FM
62 - Store the period internaly and get rid of the sarg-period file.
63 - Display the period using the locale's month name in the HTML files.
64 - Check the correct writing of the HTML files (thanks to Markus Elfring).
987e8375 65 - Use the word "Redirector" instead of mentioning explicitly squidGuard in the reports as at least Rejik is compatible with sarg (thanks to Maxim Britov).
42b117e3 66 - The date range passed as argument is not restricted to the actual range covered by the log files any more.
6e239b70 67 - Fix the exclusion of status codes to exclude more than one code.
a9565954
FM
68 - Accept date ranges for -d command line option as day-n, week-n and month-n where n is the number of backward days, weeks and months to report.
69 - Strengthen the making of the report file name to drastically limit the characters from the user ID that can appear in the file name. The presence of an unescaped backquote in the user ID would execute the rest of the name as a shell command (fixes bug #2997707 reported by anonymous).
80bc97f3 70 - Purge the content of sarg-general to free a lot of disk space.
1f482a8d
FM
71 - Use parameteric dimensions in the graph creation instead of hard coded constants.
72 - Remove the temporary file and sorting in graph creation.
73 - Add the redirector_log option in sarg.conf to read a log file created by squidGuard or Rejik (thanks to Maxim Britov for pointing out this missing option).
74 - Allow up to 64 redirector log files to be passed through the command line option -L and the sarg.conf option redirector_log.
75 - Configuration option squidguard_log_format renamed into redirector_log_format for equity with the various redirectors that can be used with sarg.
d2855b39 76 - Read a compressed log file through a pipe.
286f212b
FM
77 - The graph was wrong. The bars were not reaching the correct height with respect to the Y axis.
78 - Use a computed logarithmic scale for the Y axis when plotting bytes data instead of a fixed scale.
79 - Show the time when plotting the elapsed time.
1b81f396 80 - Fix the reporting of only one user with command line option -u.
84c9679c 81 - Output both date/time textual and graphical reports.
324ba7f3
FM
82 - Sarg log file now stores the date in the format dd/mm/yyyy and doesn't change it depending on the current date representation selected in sarg.conf. It will break existing sarg log files.
83 - Intermediary log files store the date as dd/mm/yyyy irrespective of the current date representation in sarg.conf.
5e6e0640 84 - Fix a regression to accept any directory name length in the index.
3a422572 85 - Change the CSS template file and cleanup of the hardcoded styles (thanks to Maxim Britov).
9b179eb0
FM
86 - Accept unlimited line length when converting or splitting the log file.
87 - Use long options on the command line.
d183fb7f 88 - Sarg can output the internal css inlined in the reports. It replaces the css.tpl distributed with the sources.
ed7127e3 89 - Command line option -l is optional. The input log files may be named on the command line without prefixing them with -l. It allows the use of wildcards in the command line.
2d4c92a1 90 - Accept unlimited URL length in the redirector log (thanks to Joseph L Casale).
64dfb824
FM
91 - Replace redirector_ignore_date by redirector_filter_out_date that behave as the name implies.
92 - Replace dansguardian_ignore_date by dansguardian_filter_out_date that behave as the name implies.
e3af0ae9 93
3becf85c
FM
94Feb-10-2010 Version 2.2.7.1
95 - Fixed compilation error reported by some compilers due to an sizeof in a fprintf (thanks to Maxim Britov and Renato Botelho).
96 - The path to the font used to create the graphs can be set in sarg.conf.
97 - The installation of our fonts can be disabled with --disable-fontdir.
98
99Feb-05-2010 Version 2.2.7
58d7d8fe 100 - Extra compile and run time protection (FORTIFY_SOURCE) fixed in configure.
58d7d8fe
FM
101 - Use tabulations as columns separator in intermediary files to avoid problems when a field of the log contains a space.
102 - Input log file type detection partly rewritten to clearly distinguish which type is processed where.
103 - Read the input log file from standard input if log file name is -.
9c7c6346 104 - Use string pointers in getword instead of copying the strings over and over.
a1de61fe 105 - Use LC_TIME to format some dates and times in the report according to the selected locale.
246c8489 106 - Sarg.conf can list up to 255 access.log files.
51465d08 107 - Downloaded files suffixes are matched against a sorted list and use a dichotomic search.
246c8489 108 - Added getword_atoll to read a number directly from a file without an intermediary string storage.
e6414a9d
FM
109 - Use boolean to enable the options instead of string compares.
110 - Accept an absolute path for the language file in sarg.conf.
111 - Experimental: Can show the backtrace of the program when a getword loop is detected to help in locating the origin of the error.
06ced858 112 - Protect the creation of the index against invalid directories.
c814928f 113 - Only copy the files (not the subdirs) when creating the directory with the images to include in the reports.
51465d08 114 - Directories deleted without using the rm system command.
b25b96fe 115 - Index created using an internal sort algorithm instead of a system call.
c814928f
FM
116 - Fixed Debian bug #408577 (changed exclude_hosts to exclude subdomains and IPv4 subnets).
117 - Replace --enable-htmldir by --enable-sargphp to avoid confusion on the name (thanks to Peter Nixon).
7bbc1de4 118 - Installation of sarg-php can be disabled with --disable-sargphp.
c11e2033 119 - Fixed empty entries in squidGuard log when the URL doesn't start with protocol://.
ff8d5836
FM
120 - Fixed regressions in creation and reading of a sarg parsed log (thanks to Joao Alves).
121 - Does not report URLs consisting of only a host name ending with .com as a downloaded file.
392760b3 122 - Mangle the $ and @ signs in user ID to make the resulting file name valid in shell commands.
af15cfa2 123 - Fixed a regression in the default value of --enable-sargphp.
ab950637 124 - Increase the maximum size of a line read from access.log and detect longer lines that were silently splitted in previous versions.
9a2c5753 125
a61fe05c 126Jan-06-2010 Version 2.2.6.1
51465d08 127 - Remove unnecessary dependency on off_t.
c5f6f33a 128 - Configuration doesn't fail if rlim_t is not available.
dcb54d06 129 - Test for the availability of -Werror=implicit-function-declaration and -Werror=format flags in gcc (thanks to Murilo Moreira de Oliveira and pjetko).
78015ea0 130 - Fix sort delimiter when reading useragent log (thanks to Maxim Britov).
dcb54d06
FM
131 - Fix user agent report font size and statistics on user agent.
132 - Test for the availability of -Werror=format-security in gcc (thanks to Maxim Britov).
51465d08 133 - Test the existence of bzero with autoconf and don't redefine it (thanks to Maxim Britov).
17c89803 134 - Remove warnings if libgd is not available.
fd4dbc54 135 - The date stored in sarg-date is now stored in a more machine readable form (thanks to rcastanheira for pointing this out).
51465d08 136 - The date read from sarg-date was not properly parsed and would produce a wrongly sorted index across a year change (thanks to rcastanheira for pointing this out).
a1de61fe 137 - my_mkdir changed to avoid the use of getword, be simpler and, maybe, work reliably on windows.
f251e023 138 - Makefile supports DESTDIR for easy package creation (thanks to Erjo).
be081e85 139 - Real time report honour the user_ip flag of the configuration file and the -l and -n passed on command line.
a61fe05c 140 - Fix usage of -Werror and detection of fopen64 with old compilers not supporting -Werror=implicit-function-declaration.
9a2c5753
PO
141
142Oct-14-2009 Version 2.2.6
b3695c67
FM
143 - Protection against buffer overflows in getword and friends and report the origin of the error instead of always blaming access.log.
144 - Patch #2224623 applied.
145 - Updated to autoconf 2.61.
146 - Detect external commands failures and print the exact command that produced the error. The offending file is kept for debugging if possible.
147 - The format of the date written in sarg-date is forced to prevent a failure if the locale is not en_US.
148 - Removed the duplicate file opening that resulted in a resource leak.
149 - Patch #1945235 applied.
150 - Patch #1918397 applied.
151 - Limit the content of the squidguard log file to the date of the day being processed.
152 - Removed fscanf that is prone to buffer overflows.
153 - Size of buffers increased.
154 - Protect ip2name against buffer overflows.
155 - Replace characters that are valid in URL but not in file names when building a file name from a URL.
156 - Patch #2657320 applied.
157 - Fix #else #if into #elif.
158 - Remove all the compilation warnings (inspired from patch #1771501).
159 - Fixed the real time report.
160 - Fixed the same bug as patch #1733337 but in a cleaner way.
161 - All the sprintf/fputs have been replaced by fprintf to avoid an intermediary buffer and possible buffer overflow.
162 - Moved all the functions declarations from conf.h to defs.h for consistency.
163 - Fixed bug #2089451.
164 - Fixed Debian bug #444845.
165 - Replaced the ifdef FOPEN64 by a single call to MY_FOPEN for code clarity.
166 - User IP/ID is searched only in the first column of the usertab file.
167 - Some of indentation fixes.
51465d08 168 - Speed up by removing two unnecessary ip resolutions.
b3695c67
FM
169 - Applied debian patches: sarg-polish.patch, sarg-turkish.patch
170 - Applied debian patch: opensuse_2_enlarge_report_buffers.patch
171 - Applied debian patch: opensuse_3_too_small_font_buffer.patch
172 - Applied debian patch: opensuse_4_enlarge_log_buffer.patch
173 - Applied and extended debian patch: opensuse_5_limit_sprintf.patch
174 - Function debuga format the output string itself, so there is no need to use sprintf.
175 - Applied debian patch: opensuse_7_year_assertion.patch
51465d08 176 - Removed a few unnecessary strings copy.
b3695c67
FM
177 - Embryo of documentation for the code with doxygen.
178 - Changed subs to replace the string in place and avoid allocating a memory that was freed on only one occasion.
179 - A few improvements on strings manipulations.
180 - Fixed debian bug #504749.
181 - Detect downloaded suffix bigger than 3 characters, don't match the cases and don't stop on a partial match.
182 - Fixed bug #2716729.
183 - Sanitized a little bit the generated HTML.
184 - Don't reject URL without directories.
185 - Use the correct format for off_t on amd64.
186 - Use the mechanism provided by configure to set the directories of the application instead of the custom variables.
187 - Fixed bug #1814212.
188 - Fixed bug #1847374.
189 - Partly applied advice of bug #1659784.
190 - Fixed bug #1740268.
191 - Applied suggestion of bug #2830643.
192 - Fixed bug #2216451.
193 - Fixed bug #2000178.
194 - Protect the reading of the configuration file against buffer overflows.
195 - Logo image height taken into account.
196 - Accept longer mail utility name.
197 - Fixed e-mail report (may also fix bug #2153024).
198 - Fixed total and percentages of topuser page.
199 - Applied Gentoo patch 10_all_sarg-2.2.5-enlarge-day-mon-buffers.patch.
200 - Applied Gentoo patch 12_all_sarg-2.2.5-enlarge-ntemp.patch.
201 - Open only once the denied.log and authfail.log when parsing more than one access.log.
202 - Use configurable paths for the files that used to reside in SYSCONFDIR.
203 - Add cmake configuration files.
6798f0a7
FM
204 - Compute the report date without resorting to the system command.
205 - Allow the use of spaces in the temporary directory.
39186a2f 206 - Fixed bug #2863485.
51465d08 207 - Removed misplaced off_t as suggested in bug #2864425.
b008f87f
FM
208 - Z files are uncompressed by zcat to avoid deleting the original log file.
209 - Compressed log files are uncompressed in /tmp/sarg to delete the file when the process completes.
3d254696 210 - Fixed several memory leaks.
b3695c67 211
d6e703cc
FM
212Mar-03-2008 Version 2.2.5
213 - new fix to the script insertion vulnerability via user-agent
214 report. javascript can still be executed via e.g. the "<BODY onload=function();>" scheme
215 Thanks to Alin Rad Pop, Security Specialist, Secunia, Denmark
216
217Mar-02-2008 version 2.2.4
218 - security issues can be exploited to execute arbitrary code when sarg
219 is used with malicious input files.
220 The vulnerability within the processing of the useragent.log is rather
221 critical, as this can be exploited by passing a long user agent string
222 when browsing via a squid proxy. the manipulated GET request in the
223 access log would not be accepted by squid, so that file has to be specially crafted.
224 Thank you to L4teral l4teral@gmail.com
225
226 - French language fixed.
227 Thanks to Nicod <smlpnicod@orange.fr>
228 - Fixed: Segfault in x86_64
229
230Jan-02-2007 version 2.2.3.1
231 - fixed -m option to show all the used tags
232 - date period invalid in download reports
233 - wrong results when userid contain '%20' character
234 - previous reports info wrong in index.html
235
51465d08 236Dec/23/2006 Version 2.2.3
d6e703cc
FM
237 - gd graph font change from FreeSans.ttf to DejaVuSans.ttf
238 - minor fixes when only denied records in access.log file.
239 - ulimit tag changed. If you run sarg with a low privilege user,
240 set to 'none' to disable ulimit.
241 Thanks to Jorge Morgado <jorge@morgado.ch>
242 - Russian_UTF-8 language fixed by Igor Ageikin <iageikin@lipen.elektra.ru>
243 - realtime_unauthenticated_records tag changed to show by default.
244 - chmod 755 in sarg-php due to errors in rpmbuild.
245 Thanks to Davide Madrisan <davide.madrisan@gmail.com>
246 - when the keyword "anonymous" is used in squidGuard.conf, Sarg does
247 not find the log-files anymore.
248 Thanks to Daniel Vogel <daniel_vogel@t-online.de>
249 - after reading the squidGuard configuration, the data read from the
250 usertab file was corrupted.
251 Thanks to Daniel Vogel <daniel_vogel@t-online.de>
51465d08 252 - millisec values showed as bytes. Thanks to Carlos <ke09@terra.com.br>
d6e703cc
FM
253 - with squidGuard, you can log groups in only one log file.
254 We must parse each log files only one time.
255 Thanks to Christophe BADINA <christophe.badina@ch-moulins-yzeure.fr>
256 - error message(removetmp) Cannot open /tmp/sarg_tmp/../general
257 when sending report by email. Thanks to Peter Volkov <pva@gentoo.org>
258 - incorrect off_t size in printf. In FreeBSD off_t is 64bit long long,
259 but sarg always use %d to display off_t in log processing. This cause garbage
260 while reading log files on a freebsd, and possible crash.
261 Thanks to Alex Samorukov <samm@os2.kiev.ua>
262 - squid24 on/off tag added in sarg.conf to implement compatibility if using
263 squid <= 2.4 and using squid common logs.
264 Thanks to Valter Dal Bo <dalbo@tesco.it>
265 - exclude_hosts and some code errors fixed by
266 Alexander Kozlov <avk@post.eao.ru>. Many thanks.
267 - temporary file names changed to sarg-... to avoid conflicts
268 with usernames. Thanks to Ukrainian Elephant <superlamer@users.sourceforge.net>
269 - SARG support Japanese wordset but not support charset.
51465d08 270 submitted by anonymous at sourceforge.net Many thanks.
d6e703cc
FM
271 - support for utf-8 character set added by Peter Warasin
272 <peter-endian@users.sourceforge.net>. Many thanks.
51465d08 273 - if all the data is at the hour each day, totaliza_day() treats it all as being
d6e703cc
FM
274 on the last day. This is observed for users which only download via a cron job
275 at the same time each day. Now the date and time will be
276 checked to see if changed.
277 Thanks to Ian Dall <iandall@users.sourceforge.net>
278 - greport_day() doesn't add the volume for the first hour of each day to the total.
279 Thanks to Ian Dall <iandall@users.sourceforge.net>
280 - Russian_koi8 and Russian_windows1251 languages updated by
281 Stas Degteff <stas.grumbler@gmail.com>. Many thanks
282 - realtime reporting is sorted by URL, and not by Date/Time.
51465d08 283 Thanks to Puce-Xcit <puce-xcit@users.sourceforge.net>
d6e703cc
FM
284
285Aug/29/2006 Version 2.2.2
286 - malloc test implemented to avoid high-memory consuming.
287 Thanks to Rodrigo Rubira Branco <rodrigo@kernelhacking.com>
288 - Czech UTF8 language added by Josef Karliak <karliak@ajetaci.cz>
289 - fixed: parsed mismatch in realtime_access_log_lines and
290 access_log_lines tags.
291 Thanks to Kuznetsov Andrey <pm_kan@mail.ru>
292 - changed: realtime report sort changed by date/time
293 Thanks to Leonardo Buonsanti <leonardo.buonsanti@gmail.com>
294 - GD minor fixes added.
295 - bug fixed. *** buffer overflow detected ***: sarg terminated
296 in Fedora Core 5 when using -D FORTIFY_SOURCE in gcc or in kernel.
297
298May/19/2006 Version 2.2.1
299 - iconv problems fixed in Freebsd and Slackware.
300 Thanks to Grigory Trenin <gtrenin@gmail.com>.
301 - new word added to languages: Topuser
302 - missing fclose fp-in in css.c
303 Thanks to Renato Botelho <rbgarga@gmail.com>.
304 - index.c fixed. Missing -r in reverse sort.
305 Thanks to Fernando Lemes da Silva <fernando@koho.com.br>
306 - wrong values in columns in-cache and out-cache.
307 Thanks to Hugo P S Costa <hpcosta@nutron.com.br>
308
309May/17/2006 Version 2.2
310 - sarg ported to 64 bits.
311 Thanks to Antonio F. Zago <zagolinux@uol.com.br>
312 to share your Fedora Core 5 64 bits with me.
313 - fixed conflict types for 'saverecs2' in .configure
51465d08 314 - fixed no index.html when lastlog tag is greater then 0,
d6e703cc
FM
315 caused by some debug messages.
316 - removed some development debug message
317 - user_limit_block script added to block users when limit exceeded
318 - fixed wrong sort in index.html
319 - removed '+' argument to sort utility.
320 Thanks to Julio Cesar Covolato <julio@psi.com.br>
321 - fixed "file too long" messages when using long_url
322 Thanks to Fabio Lo Votrico <fabio@link.it>
323 - fixes and improvements from Oleg <xsov@mail.ru> - Tanks.
324 . fprintf faster than sprintf+fputs (fixed in some places);
325 . strcpy+strcat is faster than sprintf (fixed in some places);
326 . unused variables removed;
327 . fixed headers look and feel (<th class="header3">);
51465d08 328 . fixed word 'BYTES' localization for datetime user report;
d6e703cc
FM
329 . fixed corrupted top header on index, denied, download and tt-reports;
330 . fixed "No" table header in topsites;
331 . fixed user report table look;
332 . fixed floating point exception on long url (added checks
333 for division by zero);
334 . fixed incorrect long url view;
335 . fixed too wide table entries in user report by adding url_limit
336 internal parameter in html.c (default 40);
337 . fixed charset.c file (was in MS-DOS text format);
338 . also included all previous fixes by other people (from
339 datafile.patch and lastlog.patch files).
340
491b862f
GS
341Nov/29/2005 version 2.1
342 - index_tree tag added.
343 Look at TAG: index_tree in sarg.conf file
344 default is file - old format.
345 - realtime report added. sarg -r option
346 Look at these tags ion sarg.conf file:
347 TAG: realtime_refresh_time num sec
348 TAG: realtime_access_log_lines num
349 TAG: realtime_types: GET,PUT,CONNECT,ICP_QUERY,POST
350 TAG: realtime_unauthenticated_records: ignore|show
51465d08 351 - garbage in topuser report with uninitialized variable.
491b862f
GS
352 Thanks to Craig Brockmeier <craig@ppco.com>
353 - memory leaks caused by a wrong variable size
354 Fixed by Klaus Singvogel <kssingvo@suse.de>. Thanks.
355 - ignoring users with '.' in password file.
356 Thanks to Emerson Valdir Pellis <webmaster@marisol.com.br>
357 - error with "resolve_ip" with "user_authentication yes"
358 Fixed by Grigory Trenin <gtrenin@gmail.com>. Thanks.
359 - long url causing fault.
360 Thanks to Vassily Andin <vasya@avitalight.com>
361 - hanging on a log file containing space.
362 Thanks to Fabio Lo Votrico <fabio@link.it>
363 - bug fixed in squidguard report module
364 - squidguard_ignore_date on|off tag added to sarg.conf file
51465d08 365 You can ignore the squidguard log record date if outside of
491b862f
GS
366 date range in squid access.log file.
367 - alternate squidguard log added using -L option on sarg command line.
368 Thanks to Dave Karlson <dkarlson@r9esd.k12.or.us>
51465d08 369 - fixed malloc without free.
491b862f
GS
370 - datafile-url ip|name added to sarg.conf file - saves ip address or name
371 in url when using datafile tag. Thanks to Calvin Muller <calvin@siryn.co.za>
51465d08 372 - wrong link point in Generated by sarg-2..
491b862f 373 Thanks to Markus Hoffmann <ipcop@mh-lantech.de>
d6e703cc 374 - Russian_UTF-8 language added by Alex Deiter <tiamat@komi.mts.ru>
491b862f 375
94ff9470
GS
376Aug/04/2005 version 2.0.9
377 - dansguardian_report_limit missing in sarg.conf file.
378 - ntlm domain+user format added.
379 - index date sort fixed by Olivier JAVAUX. Thanks
380 - Improve broken record detection
381 Thanks to Artem Korneev <akorneev@intelsysus.com>
382 - sort open failed causing an empty topuser report
383 - sarg losslessly size optimized images
b3695c67 384 Thanks to Tonda M��ek <tonda.misek@post.cz> and Luigi Gangitano.
94ff9470
GS
385 - sarg calling sort without quoting filenames
386 Thanks to Luigi Gangitano.
387 - download_report_limit tag added.
388 Thanks to Leonardo Rodrigues <leonardo@solutti.com.br>
389 - logo css class defined but never used.
390 Thanks to Roger Favero <favero@sparkenergy.it>
391
25697a35
GS
392May/29/2005 version 2.0.8
393 - verdana.ttf font removed to avoid patent infringement issues.
394 Now sarg uses a GPL FreeSans font from http://savannah.gnu.org
395 - ISA report with wrong date in date/time report.
396 Thanks to Richard Berndt
397 - connect records ignored when using emulate_http_log on in squid.conf file.
398 Thanks to Dusan Woletz
399 - bug that prevents the correct usage of switch -d <date1-date2> when using
400 an "emulate_httpd_log on" logfile and some performance improvements
401 added.
402 Thanks to Filippo Grassilli
b3695c67 403 - Spanish language fixed by Jos� Luis Hern�ndez L�pez. Thanks.
51465d08 404 - url variable size changed to accommodate big urls with coded symbols and some
25697a35
GS
405 minor changes in util.c file.
406 Thanks to Oleg <xsov@mail.ru>
407 - download suffixes improved by Oleg <xsov@mail.ru>. Thanks.
408 Now sarg uses these suffixes:
409 7z,ace,arj,avi,bat,bin,bz2,bzip,cab,com,cpio,dll,doc,dot,exe,gz,iso,
410 lha,lzh,mdb,mov,mp3,mpeg,mpg,mso,nrg,ogg,ppt,rar,rtf,shs,src,sys,tar,
411 tgz,vcd,vob,wma,wmv,zip
412
413May/02/2005 version 2.0.7
414 - DansGuardian report added.
415 Thanks to Adolfas Kupliauskas for the access.log
416 - Slovak language added by Dusan Woletz
417 Thank you
418 - wrong usertab user on topuser report.
419 Thanks to Marcos Favoretto
420 - ntlm_user_format added to sarg.conf. Now you can choose the following formats
421 for the username on reports: user|domainname+user
422 Suggested by Roger Favero
423 - exclude_users ignored in some situations.
424 - Fixes by Sapon Oleg from Russia:
425 . there are two equal lines about Evren Yurtesen in CONTRIBUTORS file.
51465d08 426 . Internationalization of SARG user graph added, using iconv function, which
25697a35
GS
427 is presented only in Linux, so I add required #ifdef and other stuff to clean
428 compile code on other platforms.
429 . Fixed two issues:
430 - '?' symbol problems for apache and other cgi-supporting web server which
51465d08 431 doesn't support '?' symbol in links (all of them interpret this like
25697a35
GS
432 parameter to cgi script);
433 - some good optimization to all three similar cicles in these files by
434 reducing false checks in 'if ...' strings.
51465d08 435 . Fixes segfault, produced by improper use of strncpy functions, look - strncpy
25697a35 436 doesn't copy leading '\0' symbol!
51465d08 437 . Just localization support for repday report.
25697a35 438 . Support usertab IP->USERNAME change in siteuser report.
51465d08 439 . Just proper Russian koi8 localization.
25697a35
GS
440
441Apr/22/2005 version 2.0.6
442 - Greek language by Antonis Maglaras <vegos@magla.gr>
443 Thank you.
444 - time period added to -t option. Now you can use -t HH-HH, HH:MM-HH:MM
445 - support to isa proxy 2004 log added.
446 Thanks to William da Rocha Lima <wrochal@linuxit.com.br>
447 - French language fixed by Alexey Znamerovskiy <alexz@everys.com>
448 Thanks
449 - internal LC_ALL=C removed to avoid errors on Solaris.
450 Thanks to Hraska, Frantisek <frantisek.hraska@hupro.sk>
451 - non authenticated records removed from Topuser report.
452 Thanks to Brian <brian@reginachristianschool.org>
453 - Compilation error on FreeBSD > 5 - log.c:645: error: `RLIMIT_OFILE' undeclared
454 - Sarg abbreviation values improved.
455
456Mar/21/2005 version 2.0.5
457 - fixed: some changes to avoid segmentation fault.
458 - fixed: some changes to avoid compilation errors on freeBSD.
459 - fixed: exclude_hosts not excluding correctly.
460
461Feb/17/2005 version 2.0.4
462 - exclude hosts not excluding correctly.
463 Thanks to Oleg
464 - download report showing jpeg files.
465 - support to Microsoft isa proxy log files added.
466 Thanks to Trankov Vladislav <vtrankov@kb-obibank.ru>
467 - fixed: error when using relative paths in -o and -w options. Just absolute paths
468 can be used now.
469 Thanks to Andreas Grosse <andi@majestyk.de>
470 - fixed: segfault fix in vrfydir() in util.c
471 Prevent buffer overflow in subs(); replace one constant with sizeof() in my_lltoa().
472 vrfydir(): fix segfault if sub-directory "images" is not exists
473 function builddia() don't check the parameters. Result: segmentation fault in some cases.
474 Thanks to Stas Degteff stas_degteff@users.sourceforge.net for the fixes.
51465d08 475 - fixed: wrong date period in squidguard_log when using European date format.
25697a35
GS
476 Thanks to Guenther Mair <gunnyst@users.sourceforge.net>
477 - ulimit tag added on sarg.conf to avoid "Too many open files" error.
478 Thanks to Paulo Pires <paulo.pires@vodafone.pt>
479
480
51465d08 481Feb/02/2005 version 2.0.3
25697a35
GS
482 - squidguard parse logs method changed.
483 Thanks to Joao Mendes <jmendes@credibom.pt>
484 Thanks to Guenther Mair <gunnyst@users.sourceforge.net>
485 - wrong results in -v option.
486 - fixed: error when using -u (include user)
487 Thanks to Bochkarev Vladimi <bochkarev@expocentr.ru>
488 - export LC_ALL=C will be issued before sort to avoid high cpu usage
489
490Nov/22/2004: version 2.0.2
491 - grepday with invalid font path.
492 Thanks to Marcelo Ricardo Leitner <mrl@conectiva.com.br>
493 - -v option added to display Sarg version on console
51465d08 494 - Segmentation fault caused by an unclosed file.
25697a35
GS
495 Thanks to Pustovalov Leonid
496 - SquidGuard log formats added.
497 Thanks to Kolotov Alexandr
498 - time field added to topsites report
499 Thanks to Miles Roper <mroper@westcoastdhb.org.nz>
500 - fixtime function with wrong definition, changed to long long
501 Thanks to Valery from Russia
502 - Solaris 9 compiling error: error: conflicting types for 'my_mkdir'
503 Thanks to Brad Larden <Brad.Larden@alphawest.com.au>
504 - segfaults if the denied report is disabled in sarg.conf.
505 Thanks to Filippo Carletti <filippo.carletti@nethesis.it>
506 - reading performance improved by Francesco Perrillo <fperillo@totalfax.it>
507 Thanks
508 - Russian sarg-php translation added.
509 Thanks to Michael Stepanenko <mistic@ecolines.ru>
510
511
512Oct/04/2004: version 2.0.1
513 - configure error with no gd installed.
514 - graph with no text when using --enable-sysconfdir
515 - graph day incorrect when using dd/mm/yy date format
516 - show_sarg_logo yes|no added
517 - site_user_time_date with wrong patch.
518 Thanks to Ricardo R. Hoffmann <hoffmann@uninet.com.br>
519
520
521Sep/29/2004: - version 2.0
522 - Internal/External css implemented
523 - User authentication access (htaccess) implemented
524 - large file support added
525 - Report limits implemented
526 - Download report implemented
527 - Sarg logo by Osamu Matsuzaki <matsu_o@robata.org> added.
51465d08 528 - Internal mkdir added to easy port to various platform.
25697a35
GS
529 - long url now show only accessed site and module name.
530 - now you can add a user report url to a flat file to be blocked
531 by some Squid acl.
532 Request by Francesco Collini <collini@colliniconsulting.it>
51465d08 533 - remove temporary files, if already exist, to avoid conflicts with a
25697a35
GS
534 previous sarg process..
535 Thanks to Renato Leon <rl_sita@hotmail.com>
536 - squidGuard improved
537 - now only records with the same period from access.log
538 will be in squidGuard report.
539 - squidGuard limit report
540 - now you can save some urls in squidGuard db using
541 sarg-squidguard PHP utility.
542
543 bug fixed: fault caused by rewinddir after closedir.
544 Thanks to Lucas Bocchi <challado@ibocchi.com.br>
545 and to Freek
546 Fixed: - missing </body> tags in all HTML pages
547 - missing </html> tag in some HTML pages
548 - missing DOCTYPE in all HTML pages
549 - grammar in man page
550 - URL Links to SourceForge http://sarg.sourceforge.net/
551 Added: - Included more detailed information in man the page
552 Thanks to Billy Newsom of U.S.
553 To Do: - There are still major validation problems in the HTML generated
554
555
556Apr/25/2003: - fixed: - link error to denied site in squidGuard report
557 - resolve name error in squidGuard report
558 - some fixes to HPUX. Thanks to Miles Roper <mroper@westcoastdhb.org.nz>
559 - index_sort_order tag don't work correctly.
560 - too many open files fixed. Thanks to Francesco Perrillo <fperillo@totalfax.it>
561 - Ukrainian_windows1251 included in sarg.conf file
b3695c67 562 - exclude_string don�t work correctly. Thanks to Modric Kristijan
25697a35
GS
563 <Kristijan.Modric@pliva.hr>
564
565Mar/17/2003: - Release 1.4
566 Added: Now you can choose the fields that will be in User Reports.
567 Look at user_report_fields tag in sarg.conf file
568 Implementation requested by Daniel T. Joye <daniel@dragontail.com>
569
570 Added: Now sarg saves the processed log in a sarg format after parsing
571 the squid log file. This allow futures sarg reprocess and data
572 will be smaller than Squid the log files
573 Look at parsed_output_log directory and
574 parsed_output_log_compress tags in sarg.conf file
575 Implementation requested by Joe Cooper <joe@swelltech.com>.
576 Many thanks for the donation.
577
578 Added: Now sarg can display the report values in abbreviation format.
579 Look at displayed_values in sarg.conf
580
581 Added: Ukrainian_windows1251 language by Roman Vynar <rvynar@icqmail.com>
582 Thank you.
583
584 Added: Catalan language by Andreu Sanchez <tanis@lleida.com>
585 Thank you.
586
587Nov/16/2002: - Fixed: squidGuard report fail with non authenticated users.
588 Thanks to Dan Ratzlaff <norb@norbysoft.com>
589 Fixed: Turkish language by Evren Yurtesen
590 <yurtesen@ispro.net.tr>. Thanks
591 Fixed: English language by Luigi Gangitano
592 <gangitano@lugroma3.org>. Thanks
593 Fixed: "CONNECT" average values are incorrectly calculated.
594 Arvids <arvids@vendomar.lv>. Thanks
595
596Oct/15/2002: - Added: sarg man page created by Luigi Gangitano
597 <gangitano@lugroma3.org>
598 Added: Reading statistics, show_read_statistics tag
599 Added: Index sort order. See index_sort_order tag
600 Added: squidGuard report - squidguard_log_path tag
601 Added: show_sarg_info on report bottom optional - show_sarg_info tag
602 Changed: gzipped file will be decompressed using zcat
603 bzipped file will be decompressed using bzcat
604 Changed: new sort routine added.
605 Changed: strsep changed to getnumlist function by Robert Tiismus
606
607Jun/02/2002: - Added: save the results in a flat file to use to populate some
608 database. Look at these tags in sarg.conf file:
609 TAG: datafile file
610 TAG: datafile_delimiter ";"
611 TAG: datafile_fields all
612 Added: logic to detect a broken record in access.log file
613 and ignore it.
614 Added: now you can select the records to be processed by
615 week and/or time using these tags in sarg.conf file:
616 TAG: weekdays
617 TAG: hours
618 Thanks to Robert Tiismus from Institute of Physics,
619 University of Tartu, Estonia.
620 <robert@fi.tartu.ee>, and for the repday.c
621 improvements.
622
623Apr/03/2002: - bug fixed: cannot create temporary file when url contain '/'
624 and using long_url
625 Thanks to Enrico Sorge <enrico.sorge@activevr.it>
626
51465d08 627Dez/10/2001: - Added: sarg now shows statistics when reading the log file
25697a35
GS
628 if running with -x option
629
51465d08 630Dez/05/2001: - bug fixed: - loop process when using "tmp" chars in usernames
25697a35
GS
631 Thanks to Jasper vd Heijden <extern@midkemia.nl>
632 new tag added: show_successful_message yes
633 Show "Successful report generated on dir" message at end of process.
634 Requested by: Wendell Schubert <wendell@webeworld.com>
635 Mauricio Felizardo dos Santos <mfelizardo@ansett.com.br>
636 bug fixed: core dump when removing auth_failures report from
637 report_type tag.
638 Thanks to Leonardo Rodrigues <coelho@persogo.com.br>
639 bug fixed: core dump with a big number of users.
640 Thanks to Zverev, Alexandr V. <AVZverev@rtc.tnk.ru>
641 new tags added: topuser_fields
642 topuser_num
643 Now you can choose which fields must be in Topuser report and how many users.
644 Requested by Hidde Beumer <Hidde.Beumer@cmg.nl>
51465d08 645 bug fixed: auth_failures report missing
25697a35
GS
646 Thanks to Clary Harridge <clary@csee.uq.edu.au>
647 Polish language added by Wszebor Boksa <Wszebor_Boksa@koncept.pl>
648 Thank you.
649 Romanian language added by Adi Cretu <adi@usv.ro>
650 Thank you.
651
652Jul/03/2001: - new report added: site/user/date/time
653 Now report_type tag has the following default setup:
654 report_type topsites sites_users date_time denied auth_failures site_user_date_time
655 - bug fixed - error when using squid-ntlm authenticator (domain\user)
656 Thanks to Jakob Curdes <jc@info-systems.de>
657 - ignoring changes in report_type tag
658 - Site&Users report with users shifted down one row.
659 Thanks to Jason Urkow <jaque@telusplanet.net>
660 - some temporary files not removed.
661 - site/user/date/time report without </table> and </html>
662
663May/30/2001: - bug fixed: - user table garbage
664 - chmod 644 removed from makefile
665 - ignoring first user in usertable
666 - ignoring users names with dots (".")
667 Thanks to Daniel Malmgren <daniel@leeloo.lund.se>
668 - same values for connect and bytes fields in reports on Solaris 8
669 Thanks to Craig Brockmeier <craig@ppco.com>
670 New tag added: user_invalid_char "&/"
671 To avoid core dumps, records that contain invalid characters
672 in userid will be ignored by Sarg.
673 New tag added: privacy yes|no
674 privacy_string "***.***.***.***"
675 privacy_string_color blue
676 In some countries the sysadm cannot see the visited sites by a restrictive law.
677 Using privacy yes the visited url will be changed by privacy_string and
678 the link will be removed from reports.
679 Requested by Diaolin <diaolin@diaolin.com> (Natali Giuliano)
680 New tag added: include_users "user1:user2:...:usern"
681 Reports will be generated only for listed users.
682 exclude_string "string1:string2:...:stringn"
683 Records from access.log file that contain one of listed strings will be ignored.
684 Requested by Michael Koptyaev <mk@aney.ru>
685
686
687Apr/02/2001: - implementation of --enable-bindir and --enable-sysconfdir in configure script.
688 Thanks to Sergei Dushenkov <dusha@dnttm.ru>
689 - bug fixed: getword excessive long string detection function fixed.
690 Thanks to Junghausz Norbert <nigga@nigga.hu>
691 - bug fixed: wrong charset for windows-1251 and koi8 Russian languages.
692 Thanks to Alexey Zhigayev <murphy@fio.samara.ru>
693 - bug fixed: - Help page (-h) is empty because at start (log.c) program doesn't
694 load definitions to text[][] array.
695 - Definitions for Russian language doesn't have last 2 lines.
696 - Definitions of Charset field for Russian language is not so correct.
697 Better is 'windows-1251' or 'koi8-r'
698 - I think in topuser.c the definition of wheader[] is too short for words
699 on some languages
700 - Initialization and use of variables TopuserSortField and
701 TopuserSortOrder is mismatch
702 Thanks to Alex Voronin <al_vg@mail.ru>
703 - bug fixed: core dump with big user table.
704 Thanks to Jorge Cuellar Martinez <jorge.cuellar@sat.gob.mx>
705 - Latvian languages by Juris Valdovskis <juris@auce.lv>
706 Thank you
707
51465d08 708Mar/22/2001: - Now the user can choose the language using the language TAG in /usr/local/sarg/sarg.conf file.
25697a35 709 There is no more --enable-language in configure script.
51465d08 710 - New report added: Authentication Failures
25697a35
GS
711 Requested by Sergei Dushenkov <dusha@dnttm.ru>
712 - NONE/400 (bad request) is excluded by default (/usr/local/sarg/exclude_codes)
713 - Now sarg support big numbers (64 bits) in any platform.
714 - Date/Time report now use bytes or elapsed time as specified in date_time_by tag in sarg.conf
715 Requested by Inters <inters@mailbox.riga.lv>
716 - bug fixed: sites&users report sorted on the User field rather than the Site field
717 Thanks to Simon Bryan <sbryan@olmc.nsw.edu.au>
718 - sites&users report was changed.
719 - Russian_windows125 language fixed.
720 Thanks to Dima I. Allaverdov <allav@ur.rags.ru> (rasa)
721 - bug fixed: getconf was catching a wrong value in replace_index tag
722 Thanks to vrush_22@softhome.net
723 - bug fixed: per_user_limit file with duplicate users.
724 - Russian languages fixed by Nikolai V. Ivanyushin <koko@infocenter.bryansk.ru>. Thank you.
51465d08 725 - charset TAG added to sarg.conf file. The following charsets are available:
25697a35
GS
726 Latin1 (West European), Latin2 (East European), Latin3 (South European)
727 Latin4 (North European), Cyrillic, Arabic, Greek, Hebrew
728 Latin5 (Turkish), Latin6 (Nordic)
729 Requested by Nikolai V. Ivanyushin <koko@infocenter.bryansk.ru>
730 - configure now accept only two options:
731 --enable-bindir - where sarg binary will be saved
732 --enable-sysconfdir - where the configuration directory is
733
734Mar/09/2001: Sqmgrlog has gained a new name: SARG - Squid Analysis Report Generator.
b3695c67 735 Many people have asked me about why sqmgrlog. I really don�t know.
25697a35
GS
736 No inspiration I think.
737 SARG was suggested by an user from Philippines, but, I lost his email
b3695c67 738 and don�t remember his name.
25697a35
GS
739
740 Thank you anyway.
741
742
743
744sqmgrlog ChangeLog
745
746Feb/06/2001: Version 3.0 released:
747 - Denied report added.
748 Request by Jason Staudenmayer <JasonS@NJAQUARIUM.ORG>
749 - User table added. You can override your userid or IP Address with
750 a real user name.
751 TAG usertab added to sqmgrlog.conf
752 - Now you can have the long url in reports
753 TAG long_url added to sqmgrlog.conf
754 - Now you can choose the report types
755 TAG report_type added to sqmgrlog.conf
756 - sqmgrlog.conf file now will be in 644 mod.
757 Request by Michail Vidiassov <master@iaas.msu.ru>
758 - sqmgrlog coredumps if there is a very long line in the config file.
759 Thank you to Michail Vidiassov <master@iaas.msu.ru>
760 - Url parser changed to get connect records from a better way
761 Thanks to Sergey Erokhin <esl@vechnost.com>
762 - Michail Vidiassov <master@iaas.msu.ru> made gcc -Wall ... happy on FreeBSD 4.1
763 Thank you
764 - Russian_Koi8 language fixed by
765 Andrew Okhmat <andy@crgu.com>. Thank you.
766 Maks Nefedchenko <maks@viaduk.net>. Thank you.
767 - Russian and Bulgarian language fixed by
768 Nikolai V. Ivanyushin <koko@infocenter.bryansk.ru>
769
770
771
772Nov/09/2000: Two patches form Brad Guillory <proxyadm@baileylink.net> added:
773 1. max-elapsed tag added to sqmgrlog.conf file:
774 # TAG: max_elapsed milliseconds
775 # If elapsed time is recorded in log is greater than max_elapsed use 0 for elapsed time.
776 # Use 0 for no checking
777 #
778 #max_elapsed 0
779 # 8 Hours
780 max_elapsed 28800000
781 2. day report (the one that looks like a calendar) changed:
782 Every minute that a request is logged your time is incremented by the smaller
783 of 1 minute or the total time for the requests.
784
785 Thank you Brad. Brad Guillory is the newest sqmgrlog contributor.
786
787 Changed: sort now compare according to arithmetic value.
788
789Jul/11/2000: Dutch language fixed by Pieter Kooistra <pkooistra@hr.nl>
790 Thank you.
791 Changed: Russian_koi8 changed to Russian_Koi8.
792 Thank you to Eugene AKA Kevin Kevin <kevin@id.ru>
793 Slightly changed Czech language
794 Added: TAG: replace_index
795 Replace "index.html" in the main index file with this string
796 Vladimir Smelhaus <smelhaus@atlas.cz>
797 Bug fixed: For some reason, Squid occasionally logs a blank line. Running sqmgrlog
798 against a log containing a blank line causes sqmgrlog to take 99+% CPU
799 Thanks to Giese, Bill <bill@gieses.com>
800 Added: now every squid code that contain the MISS word will be counted as out cache.
801 Thanks to Kostya Panov <twin@beep.ru>
802
803Jun/09/2000: Bug fixed: abnormal end if userid contain ';'
804 Thanks to Victor Feoktistov <feoktist@triniti.ru>
805 Japanese language fixed by
806 Akira Kitamura <click@anet.ne.jp> Takamatsu-City Kagawa Japan
807 Bug fixed: Wrong date when setting date_format u in sqmgrlog.conf file
808 Thanks to Dale Perkel <dale@think.co.za, Nuno Almeida <nalm@vanguarda.com>,
809 Marcio Rodrigo Bordignon <mrbordignon@uol.com.br>
810
811Mar/15/2000: Japanese language added by
812 Akira Kitamura <click@anet.ne.jp> Takamatsu-City Kagawa Japan
813 Thank you.
814 Serbian language added by
815 Radovan Drobnjakovic <admin.rts@rts.co.yu>
816 Thank you.
817 Bug fixed: wrong sort field when lower case used in
818 sort tags.
51465d08 819 Thanks to Scott Larsen <slarsen@cascorp.com>
25697a35
GS
820 and to WOLETZ, Dusan <woletz@globtel.sk>
821 Abuse report removed.
822 Changed: report1_sort_field TAG in sqmgrlog.conf
823 changed to topuser_sort_field
824 Changed: report2_sort_field TAG in sqmgrlog.conf
825 changed to user_sort_field
826 Added: topsites sort field options added:
827 # TAG: topsites_sort_order CONNECT|BYTES A|D
51465d08 828 # Sort for topsites report, where A=Ascendant, D=Descendant
25697a35
GS
829 #
830 #topsite_sort_oder CONNECT D
831 Implementation requested by
832 Michael G. Koch <Michael.G.Koch@globalknowledge.de>
833
834Feb/26/2000: Bulgarian-windows1251 language added by
835 Ivan Minchev <vanko@uni-svishtov.bg>.
836 Thank you.
837 French language updated by
838 Olivier Rousselot <olivier.rousselot@ssti.fr>
839 Thank you.
840
841Feb/15/2000: SmarfFilter report added.
842 Implementation requested by Andrew Bradshaw <andyb@excite.co.uk>
843 Bug fixed: files created with 09Feb2000-09022000 instead 09Feb2000-09Feb2000
844 Thanks to Andy Parfenov <andy@nursat.net>
845 Changed: ignore records with HTTP/0.0 string.
846 Implementation requested by Bernd Kossmann <bko@shd.de>
847 Changed: some code added to ignore broken records in access.log file
848 Bug fixed: removing old file with lastlog dont work.
849 Thanks to Evren Yurtesen <yurtesen@ispro.net.tr>
850
851Jan/20/2000: Indonesian language added by V Gatut Harijoso <gatut@student.unpar.ac.id>
852 Thank you.
853 Fixed: change in conf.h to compile on OpenBSD 2.6 system.
854 Thanks to Kenneth Ingham <ingham@i-pi.com>
855 Fixed: small bug, which fills the "periodo" with
856 "01Jan2000-20000101" instead of "01Jan2000-01Jan2000".
857 Thanks to Schlosser, Carsten ECOFIS <c.schlosser@ecofis.de>
858 Fixed: After calling system function malloc, variable excludecode
859 have some symbols inside (excludecode wasn't zeroed).
860 Thanks to Andrew Katkov <askat@crimea.net>
861
862Dec/29/1999: Czech language added by Milos Prudek <prudek@nembv.cz>
863 Thank you.
864 Russian-windows1251 language added by Dima I. Allaverdov <allav@ur.rags.ru>
865 Thank you.
866 Changed: Russian language changed to Russian_koi8 language.
867 Bug fixed: Sites&Users report dont resolve ip address.
868 Thanks to Pavel Jezek <Pavel.Jezek@i.cz>
869
870Nov/29/1999: Bug fixed: DENIED word translated to another language never printed.
871 Thanks to Rodolphe SIBERT <rsi@kyxar.fr>
872 New report added: Sites & Users
873 Implementation requested by Rodolphe SIBERT <rsi@kyxar.fr>
874 Added: The date format now also has the option "w" for week.
875 The report is then 1999.47-1999.47 for instance.
876 Implemented by Seth Mos <stimpy@stimpy.multiweb.nl>, thank you for the patch.
877 Dutch language added by Seth Mos <stimpy@stimpy.multiweb.nl>
878 Thank you.
879 Added: new tag on sqmgrlog.conf, named user_ip, for setting a system wire -p, use ip address
880 instead userid.
881 Implemented by Carlo Marcelo Arenas Belon <carenas@chasqui.lared.net.pe>
882 Thank you for the patch.
883 Added: new tag on sqmgrlog.conf, exclude_codes pointing to a file with codes to be
884 ignored by sqmgrlog. Eg.: NONE/400
885 Implementation asked by Doug Burks <DBurks@Augserv.com>
886
887Sep/28/1999: Bug fixed: -split and -convert dont work with multiples -l options.
888 Thanks to G. Kelana Sudibyo" <kelana@inn.bppt.go.id>
889 Bug fixed: Bytes and Average corrupted in index.html after second execution.
890 Thanks to Rob Glasser <orso@onelist.com>
891
892Sep/13/1999: Bug fixed: get wrong access.log file when using access_log in sqmgrlog.conf file.
893 Thanks to Michael G. Koch <Michael.G.Koch@globalknowledge.de>
894
895Sep/10/1999: Spanish language added by Leonardo A. D'Angelo <ldangelo@san-cayetano.com>
896 Thank you.
897 New report added: topsites. This report show the top n sites accessed.
898 You can set the top num sites in topuser_num tag in sqmgrlog.conf file.
899 Bug fixed: wrong userid when using Samba authenticator.
900 Thanks to klaubert@bcb.gov.br (Klaubert Herr da Silveira)
51465d08 901 Changed: -v option removed. No more support for Squid-1 log format.
25697a35
GS
902 Thanks to Nik Oxley <nik.oxley@iholland.co.uk>
903
904Aug/18/1999: New fields added to sqmgrlog.conf:
905 - lastlog n
906 With lastlog you can tell to sqmgrlog to remove old reports files.
907 Usage: lastlog 0 - no remove nothing
908 lastlog 10 - maintain only the last 10 reports
909 Implementation requested by Evren Yurtesen <yurtesen@ispro.net.tr>
910 Thank you for your help.
911 - remove_temp_files yes|no
912 Remove temporary files: geral, usuarios, top, periodo from root report directory.
51465d08 913 Implementation requested by Fred Pacquier <fredp@dial.oleane.com>
25697a35 914 - index yes|no|only
51465d08 915 Usage: index yes - will generate the main index.html in reports
25697a35
GS
916 index no - dont generate the main index.html in reports
917 index only - generate only the main index.html in reports
918 Implementation asked by Fred Pacquier <fredp@dial.oleane.com>
919 - overwrite_report yes|no
51465d08
FM
920 If yes and the report already exist for that date, the reports will be overwritten.
921 If no and the report already exist, that report will be renamed to filename.n, filename.n+1
25697a35
GS
922 Implementation requested by Eugeny Kuzakov <CoreDumped@CoreDumped.null.ru>
923 - records_without_userid ignore|ip|everybody
924 What can I do with records without user id (no authentication) in access.log file ?
925 ignore - This record will be ignored.
926 ip - Use ip address instead. (default)
927 everybody - Use "everybody" instead.
928 - use_comma
929 Use comma instead point in reports.
930 Eg.: use_comma yes => 23,450,110
931 use_comma no => 23.450.110
932 - mail_utility mail|mailx
933 Which mail command must I use to send reports ?
934
935 Added: now every squid code that contain the MISS word will be counted as out cache.
936 Implementation requested by Eugeny Kuzakov <CoreDumped@CoreDumped.null.ru>
937 Thank you for your help and for share your FreeBSD with me.
51465d08 938 Changed: the field url was changed to 8192 bytes to support big urls.
25697a35
GS
939 Thanks to Eugeny Kuzakov <CoreDumped@CoreDumped.null.ru>
940 Changed: the header "TIME SPENT" changed to "USED TIME" in topuser report.
941 Changed: no more nouser will be in reports but IP address instead.
942 Changed: no more squid 1 log format supported.
943 Bug fixed: wrong reports when using common log format (emulate_http on).
944 Thanks to Patrick LIN <patrickl@cst.ca>
945
946Aug/06/1999: French language added by Fred Pacquier <fredp@dial.oleane.com>
947 Thank you
948 Bug fixed: negative percentage in IN-CACHE-OUT.
949 Thanks to brad@baileylink.net
950 Bug fixed: wrong directory name created when using -g e and -d
951 Thanks to Fred Pacquier <fredp@dial.oleane.com>
952 Changed: atol use to get total bytes changed to atoll.
953 Thanks to brad@baileylink.net for the patch.
954 Changed: now use ',' as separator instead '.' when using US date (-g u)
955 Implementations requested by brad@baileylink.net
956 Changed: added -convert and -split to usage help (-h)
957 new messages added to easy translation.
958 Implementations requested by Fred Pacquier <fredp@dial.oleane.com>
959
960Jul/29/1999: Changed: convert userid to lowercase to disable username case-sensitivity
961 when using auth_smb.
962 Implementations requested by Doug Burks <DBurks@Augserv.com>
963 Changed: the sqmgrlog.conf now installs into /usr/local/etc
964 Implementations requested by Daniel L Sjvsvdrd <daniel.sjosvard@paals.se>
965
966Jul/06/1999: Y2K bug fixes.
967 Thanks to askat@crimea.net (JSC CRELCOM)
968 Bug fixed: special character in userid cause core dump.
969 Thanks to Rick_Barzilli@xircom.com
970 Splitlog function added: -split will split the log file by date in -d parameter.
971 Eg.: sqmgrlog -split -d 01/07/1999-02/07/1999 [-convert] [-g e]
972
973Jun/14/1999: German language added by Andreas Piesk <a.piesk@gmx.net>
974 Thank you
975 Some minor changes made by Andreas Piesk, thanks for the patches.
976
977Jun/09/1999: Bug fixed: to send reports via mail, use mail instead mailx in FreeBSD.
978 Thanks to Evren Yurtesen <yurtesen@ispro.net.tr> to share your FreeBSD with me.
51465d08 979 Bug fixed: wrong userid when using smb_auth authenticator.
25697a35
GS
980 The userid will be changed from NTDOMAIN\username to NTDOMAIN.username.
981 Thanks to Jouko Ylikulju <Jouko.Ylikulju@pkcables.com>
982
983Jun/04/1999: Y2K compliance implemented.
984 Bug fixed: wrong report created when using common log format.
985 Thanks to Carlos Santillana <Carlos@los-fresnos-cons.k12.tx.us>
986 Bug fixed: wrong fopen with "rt", must be "r".
987 Thanks to Wayne Bastow <wbastow@ccahs.health.nsw.gov.au>
988
989May/31/1999: Turkish language added by Evren Yurtesen <yurtesen@ispro.net.tr>
990 Thank you
991 Bug fixed: users in exclude_users file were not removed from reports.
992 Thanks to Arthur S. Petrossian <arthur@ipia.sci.am>
993 Thanks to Evren Yurtesen <yurtesen@ispro.net.tr>
994 Bug fixed: core dump when using output_email parm and mailx not installed.
995 Thanks to Evren Yurtesen <yurtesen@ispro.net.tr>
996 Thanks to Evren Yurtesen <yurtesen@ispro.net.tr> to share your FreeBSD with me.
997
998May/20/1999: New report field added: IN CACHE and OUT CACHE.
999 This field show how many bytes (percent) was retrieved from the cache.
1000 Implementations requested by Arthur S. Petrossian <arthur@ipia.sci.am>
1001
1002May/14/1999: Bug fixed. Abnormal End when using -i option
1003 Thanks to Carlos Canau <canau@ionia.EUnet.pt> for the patch.
1004 Bug fixed. Sqmgrlog freeze if some records are broken in access.log file.
1005 Thanks to Rick_Barzilli@xircom.com
1006 Bugfix that prevents sqmgrlog from freezing up if a log file has "holes" (sequences of zeros)
1007 (caused by filesystem crash).
1008 Thanks to drdivano@mail.axon.ru for the patch.
1009
1010Apr/14/1999: Per user limit added.
1011 If the user exceed the limit, userid will be saved in a file that can
1012 be used in squid acl.
1013 Field per_user_limit added to sqmgrlog.conf: per_user_limit file limit
1014 file : where userid must be saved
1015 limit: in MB Eg. 40 will limit in 40 MB.
1016 Implementation requested by Csaba Kabai <ckabai@icnpharm.com>
1017
1018Mar/11/1999: Field exclude_users now accept indexonly to create only index.html report.
1019 Implementation requested by Hanni Daniel <daniel.haenni@softlab.ch>
1020 Bug fixed for FreeBSD. Missing \n on topuser.
1021 Thanks to Andrew <andrew@extrim.ru> for share your FreeBSD-3.1
1022 Some minors fixes and changes in html layout.
1023 Thanks to Andrew Barnes <a.barnes@kaldor.com.au>
1024
1025Mar/03/1999: Bug fixed. Wrong href link if userid in format userid.name...
1026 Thanks to Manon Goo <manon@manon.de>
1027 Some changes on variable translations.
1028 Thanks to Matteo Colombo <matteo@calcol.it>
1029 Russian language (KOI8-R) added by Palamarchuk Eugen <eugen@cit.od.ukrtel.net>
1030 Thank you
1031 Field exclude_users added to sqmgrlog.conf.
1032 Users within the file will be excluded from reports.
1033 Implementation requested by Hanni Daniel <daniel.haenni@softlab.ch>
1034
1035Feb/26/1999: New date/time report added.
1036 Look at http://www.orso.x5.net/squid-reports/1999Feb01-1999Feb08/duser24.html
1037 -d option now accept from-until (dd/mm/yy-dd/mm/yy) dates.
1038 Requested by Eric V. Pino <ericvp@roadrunner.com.ph>
1039
1040Feb/10/1999: Italian language added by Matteo Colombo <matteo@calcol.it>
1041 Thank you.
1042 -convert option added. Convert the access.log file to a legible date
1043 and time format. May be used with -l and/or -g options.
1044
1045Feb/05/1999: Field date_format added to sqmgrlog.conf.
1046 date_format u: reports with USA format mm/dd/yy
1047 date_format e: reports with Europe format dd/mm/yy
1048 Implementation requested by Matteo Colombo <matteo@calcol.it>
1049 Bug fixed: temporary file cannot be created if not run in root.
1050 Thanks to Carlos Canau <canau@ionia.EUnet.pt> for the patch.
1051 Changes from Tony Lorime <alorimes@csc.com>: use atoll instead atol in Solaris
1052 : ignore .htaccess when selecting files
1053 Thank you.
1054
1055Dec/21/1998: -b option added. Generate useragent report.
1056 field useragent_log added to sqmgrlog.conf
1057 Implementation requested by Alp <support@x5.net>
1058 -j option added. Generate a kind of abuse report.
1059 Implementation requested by Alp <support@x5.net>
1060 To use this feature you must apply a patch (http://www.orso.x5.net/patches) on Squid.
1061 -c exclude option improved. Now you can exclude B classes
1062 Implementation requested by Yin Jun <yinj@mars.ahu.edu.cn>
1063 Bug fixed for Solaris. Must user -lsocket and -lnsl to resolve names.
1064 Thanks to Ryan Roehrich <ryanscott@mindless.com>
1065
1066Dec/11/1998: Bug fixed for long long int in Alpha Digital
1067 Thanks to Ilya V. Komarov <mur@mur.lynx.ru> for share your Digital server.
1068
1069Dec/10/1998: Version 2.2 released
1070 -n option added. Resolve domain name for reports with IP Address.
1071 Field resolve_ip added to sqmgrlog.conf
1072 Sort report by header fields implemented
1073 Fields report1_sort_field and report2_sort_field added to sqmgrlog.conf
1074 -f option added. Allow config file override
1075 Exclude hosts implemented
1076 Field exclude_hosts file added to sqmgrlog.conf. Exclude ips, names, subnets
1077 from reports.
1078 Implementations requested by Arthur S. Petrossian <arthur@ipia.sci.am>
1079
1080Dec/07/1998: Version 2.1 released
1081 sqmgrlog now can read log file in gzip or compress format.
1082 Implementation requested by Alp <support@x5.net>
1083
1084Nov/09/1998: Version 2.0 released
1085 -p option added. Allow redirect output report to email address.
51465d08 1086 sqmgrlog.conf with colors, headers, title, font size, background color, text color,
25697a35
GS
1087 background image, font face, etc... added.
1088 Reports will be generated only for users in passwd file (tag password in sqmgrlog.conf).
1089 Many changes in html output layout.
1090 Thanks to Alp <support@x5.net>
1091
1092Oct/19/1998: Bug fixed by Maxim Berlin <mak@unesco.mitht.rssi.ru> for long long int in FreeBsd.
1093 Many thanks.
1094 Thanks to Ilya V. Komarov <mur@mur.lynx.ru> to share your FreeBSD 3.0 server to help on fixing.
1095
1096Sep/28/1998: Bug fixed for log with emulate http on (Squid 1.2.beta)
1097 Thanks to Alp <support@x5.net>
51465d08 1098 -p option added. Generated reports with IP Address instead Userid.
25697a35
GS
1099 Use this option if you do not use Proxy authentication on Squid.
1100 Implementation requested by Szalma Zoltan <zszalma@file.matav.hu>
1101
1102Aug/11/1998: Bug fixed for memory slack.
1103 Thanks to kevin@mcpeake.net
1104 Jose Luiz <jluiz@projesom.com.br>
1105 Patrick Darden <darden@server2.armc.org>
1106 Steve Chan <Steve.Chan@lucasfilm.com>
1107
1108Jul/07/1998: Spent time added for native Squid log format (emulate_httpd_log off).
1109 Connect added.
1110 Layout change in html reports.
1111
1112Jun/02/1998: -o option added. Allow output dir override.
1113 Implemented index.html on root output dir.
1114 Implemented auto rename if output dir already exist.
1115 bug fixed, link error if user change output dir in conf.h
1116 Thanks to Alp <cybergulf@cybergulf.net>
1117
1118May/28/1998: -v option added. Allow Squid version override.
1119
1120May/28/1998: Bug fixed in common log format
1121 Thanks to Tony Lorimer <tlorimer@health.csc.com.au>
1122 Alp <cybergulf@cybergulf.net>
1123 Carlos Santillana <carlos@los-fresnos-cons.k12.tx.us
1124
1125May/21/1998: Implemented Squid version verification because common log
1126 from 1.1 differ from 1.2 version.
1127 -i option added (report by user and IP address)
1128
1129May/19/1998: configure script implemented.
1130
1131May/18/1998: Implemented auto log format recognize (Squid and Common log)
1132
1133Apr/15/1998: bug fixed. Some garbage on period.
1134 Thanks to Lee Shakespeare <lee@webfoundry.co.uk>
1135
1136Apr/15/1998: -z option added (debug)
1137
1138Apr/07/1998: top.html changed to index.html
1139
1140Mar/31/1998: index.html added
1141
1142Mar/25/1998: sqmgrlog was created