To activate "squidalyser" you have to do the following steps:
-------------------------------------------------------------
1.
    Change the password for the user "proxymaster" in the
    "squidalyser.passwd" file with the htpasswd command. The
    default is "proxymaster".

2.
    Add the supplied include line from the file
    sqidalyser.apache to your apche.conf file and restart apache.

3.
    Follow the below directions to setup your mysql database
    and change the squidalyser.conf accordingly:



First, you need to create the database; then grant the
appropriate permissions to the database user; and finally create
the database tables and the information contained in them. The
"logfile" table contains a few entries for testing purposes, which
can be deleted after testing.

Access mysql using this command:

    mysql -u root -p 

`root' is the name of the user who has sufficient privileges to set
up users and databases, and may be different on your system (ask
your systems administrator if you are unsure). The `-p' option
specifies that you need a password to access mysql: if you haven't
set a root password, consult the MySQL documentation to find out how
to do so.

Create the database by typing: 

    create database <dbname>;

"squidalyser" is the suggested dbname. 

    grant all on <dbname>.* to <dbuser>@localhost identified by '<dbpass>';

"squidalyser" is the suggested dbuser. Make up your own password :-) 

    flush privileges;
    exit

When you've done that, create the tables and insert the
information they contain:

    mysql <dbname> -u <admin_username> -p < squid.sql


That's it. You have a database which is ready to hold the information
from your squid logfiles.

To ensure you have set up the database correctly, try submitting a few
queries via the mysql interface:

    mysql <dbname> -u <dbuser> -p

    select * from logfile;

You should see a list of URLs and associated data. 

    select * from list;
    
Should show the predefined lists of users and words. 

    select * from list_member, list where list_id=list.id and list.id=9;
    
Shows a list of advertising-related keywords. 

If it didn't work, you're on your own. Repeat the steps above (dropping
and recreating the database if necessary) and make sure you get the
details right.