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