March 29, 2024, 11:43:14 AM

News : LinuxSolved.com Linux Help Community Forum..


Author Topic: squid2mysql  (Read 4472 times)

Offline muthu

  • Linux Noob !
  • *
  • Posts: 17
squid2mysql
« on: September 05, 2005, 10:40:45 AM »
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

Offline Ricky

  • LST CareTaker
  • Specially Skilled
  • *****
  • Posts: 2381
squid2mysql
« Reply #1 on: September 06, 2005, 11:50:32 AM »
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
Quote from: "Squid2mysql Install documents"
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.