Read Me

TRC v3.1 is the TRaffic Counter -  squid log analyzer, that allow you view where you useres was
Developer: Kitov Anton (kaa-work@rambler.ru, vaitmar2012@gmail.com)


0. Requirements
1. Installation
    a. Configure system 
    b. Create MySQL db
    c. Configure web scripts

2. Using



0. The TRC v3.1 need: Webserver with php support, Mysql server, DNS server is recomended for local network 

1. Installation    
    a. TRC need to run some scripts (When I was testing I do it every 20 min)
	./bin/analyse - move squid access.log information into MySQL `source` table,
    squid access.log file must be this logformat(standart)
    (squid.conf#logformat: logformat squid %ts.%03tu %6tr %>a %Ss/%03Hs %<st %rm %ru %un %Sh/%<A %mt)
	./bin/1strun  - Processes raw data in `source` table into the `user_traf` table for the program. Usually starts after `analyse`
	./bin/runrec  - run this script	at 1 hour am.
    b. Create db `trc` and do `trc.sql` into this db, or in other db (you mast make changes in ./lib/sql.in.php in Connect funtion if db is not `trc` name)
    
    c. Make changes in ./lib/sql.inc.php in funtion Connect: edit server hostname,username and password for Mysql server
    
    d. Make /var/log/squid/arc and /var/log/squid/old directories for save source log files just in case.
    
2. The TRC v3.1 is ready to use, go to your squid-proxy server in trc webdir.