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