squid2mysql

[muthu]

hi all,

I am using redhat linux 9 and configure squid proxy.

I don't know how to install and configure squid2mysql in linux.


plz help me.


thanks and Regrads


S.Muthu

[Ricky]

Well squid2mysql needs you to have preconfigured apache with php, mysql and perl with DBI module.

Squid2mysql also includes instructions that how to install..
It contains following

Installation guide.
1. Unpack tarball.
2. Put squid2mysql perl script and sqauth sh script into squid directory.
3. Remove squid log file and create named pipe file with name of squid log
   file ("mknod /var/log/squid/access.log p").
4. Configure squid Authenticate_program record, set it (for example) to
   /usr/local/squid/bin/sqauth. Set authenticate_ttl to 5 minutes.
Set acl proxy-auth to REQUIRED.
5. When you started squid, you must start squid2mysql too. Before or after,
   it depends on system what you are using. Before script example:
   #!/bin/sh
   /usr/local/squid/bin/squid2mysql < /var/log/squid/access.log &
   /usr/local/squid/bin/squid -D &
   EOF
6. Put report scripts to your web-server htdocs directory (example,
   /usr/local/apache/htdocs/squid)
7. Put sqlogarch and sqlogupload from modules directory to /var/arch/squid.
8. Configure squid2mysql, sqauth, include.php, sqlogarch and sqlogupload
files (some first lines). Note, that you have to has installed Apache with
PHP and MySQL support and DBI perl modules.