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