Недавно возникла такая проблема с Sarg'ом - останавливается на сортировке, в чем дело, куда рыть ума не приложу. Выглядит это примерно так:#sarg -z -x -g e -d 01/04/2011-30/04/2011 -f /etc/sarg/sarg.month.conf
SARG: Init
SARG: Loading configuration from: /etc/sarg/sarg.month.conf
SARG: TAG: language English
SARG: TAG: access_log /var/log/squid3/access.log.1
SARG: TAG: title "Squid User Access Reports"
SARG: TAG: font_face Tahoma,Verdana,Arial
SARG: TAG: header_color darkblue
SARG: TAG: header_bgcolor blanchedalmond
SARG: TAG: font_size 14px
SARG: TAG: background_color white
SARG: TAG: text_color #000000
SARG: TAG: text_bgcolor lavender
SARG: TAG: title_color green
SARG: TAG: temporary_dir /tmp
SARG: TAG: output_dir /var/www/webiface/sarg/month
SARG: TAG: resolve_ip
SARG: TAG: user_ip no
SARG: TAG: topuser_sort_field BYTES reverse
SARG: TAG: user_sort_field BYTES reverse
SARG: TAG: exclude_users /etc/sarg/exclude_users
SARG: TAG: exclude_hosts /etc/sarg/exclude_hosts
SARG: TAG: date_format u
SARG: TAG: lastlog 0
SARG: TAG: remove_temp_files yes
SARG: TAG: index yes
SARG: TAG: index_tree file
SARG: TAG: overwrite_report yes
SARG: TAG: records_without_userid ip
SARG: TAG: use_comma yes
SARG: TAG: mail_utility mailx
SARG: TAG: topsites_num 100
SARG: TAG: topsites_sort_order CONNECT D
SARG: TAG: index_sort_order D
SARG: TAG: exclude_codes /etc/sarg/exclude_codes
SARG: TAG: max_elapsed 0
SARG: TAG: report_type topusers topsites sites_users users_sites date_time denied auth_failures site_user_time_date downloads
SARG: TAG: usertab /etc/sarg/usertab
SARG: TAG: long_url no
SARG: TAG: date_time_by bytes
SARG: TAG: charset Latin1
SARG: TAG: user_invalid_char "&/"
SARG: TAG: show_successful_message no
SARG: TAG: show_read_statistics yes
SARG: TAG: topuser_fields NUM DATE_TIME USERID CONNECT BYTES %BYTES IN-CACHE-OUT USED_TIME MILISEC %TIME TOTAL AVERAGE
SARG: TAG: user_report_fields CONNECT BYTES %BYTES IN-CACHE-OUT USED_TIME MILISE C %TIME TOTAL AVERAGE
SARG: TAG: topuser_num 0
SARG: TAG: authfail_report_limit 10
SARG: TAG: squidguard_report_limit 10
SARG: TAG: user_report_limit 50
SARG: TAG: download_suffix "zip,arj,bzip,gz,ace,doc,iso,adt,bin,cab,com,dot,drv$ ,lha,lzh,mdb,mso,ppt,rtf,src,shs,sys,exe,dll,mp3,avi,mpg,mpeg"
SARG: Loading exclude file from: /etc/sarg/exclude_hosts
SARG: Loading exclude file from: /etc/sarg/exclude_users
SARG: Parameters:
SARG:
SARG: Hostname or IP address (-a) =
SARG: Useragent log (-b) =
SARG: Exclude file (-c) = /etc/sarg/exclude_hosts
SARG: Date from-until (-d) = 01/04/2011-30/04/2011
SARG: Email address to send reports (-e) =
SARG: Config file (-f) = /etc/sarg/sarg.month.conf
SARG: Date format (-g) = Europe (dd/mm/yyyy)
SARG: IP report (-i) = No
SARG: Input log (-l) = /var/log/squid3/access.log.1
SARG: Resolve IP Address (-n) = No
SARG: Output dir (-o) = /var/www/webiface/sarg/month/
SARG: Use Ip Address instead of userid (-p) = No
SARG: Accessed site (-s) =
SARG: Time (-t) =
SARG: User (-u) =
SARG: Temporary dir (-w) = /tmp
SARG: Debug messages (-x) = Yes
SARG: Process messages (-z) = Yes
SARG:
SARG: sarg version: 2.2.6 Dec-01-2009
SARG: Loading User table: /etc/sarg/usertab
SARG: Reading access log file: /var/log/squid3/access.log.1
SARG: (util) tbuf=01Apr20116815, reading: 0.00%
SARG: (util) period=01Apr2011-30Apr2011
SARG: Records in file: 23606815, reading: 100.00%
SARG: Records read: 23606815, written: 21816781, excluded: 127583
SARG: Squid log format
SARG: (util) data=01/05/2011
SARG: (util) tbuf=01May2011
SARG: (util) period=01Apr2011-30Apr2011
SARG: Period: 01Apr2011-30Apr2011
SARG: pre-sorting files
На другом терминале выполняю:
# ps aux | grep sarg
root 32137 56.0 0.1 20248 1524 pts/0 S+ 09:46 13:49 sarg -z -x -g e -d 01/04/2011-30/04/2011 -f /etc/sarg/sarg.month.conf
root 32432 0.0 0.0 4088 604 pts/0 S+ 10:02 0:00 sh -c sort -T "/tmp" -k 5,5 -k 1,1 -k 2,2 -o "/tmp/sarg/v.vinakovskaya"z88.log" "/tmp/sarg/v.vinakovskaya"z88.unsort"
root 32433 0.0 0.0 58496 756 pts/0 S+ 10:02 0:00 sort -T /tmp -k 5,5 -k 1,1 -k 2,2 -o /tmp/sarg/v.vinakovskayaz88.log /tmp/sarg/v.vinakovskayaz88.unsort
И на сортировке этой v.vinakovskaya он может висеть сутками - ничего не происходит.
Гугл про проблемы сортировки sarg'а ничего не знает. Уже не знаю, куда копать. Подскажите пожалуйста.