How to Configure Squid with Mysql DB authentication
Download squid source from http://www.squid-cache.org/Versions/v3/3.0/squid-3.0.STABLE24.tar.gz Copy the downloaded file to /tmp Tar –zxvf squid-3.0.STABLE24.tar.gz Cd squid-3.0.STABLE24 ./configure --enable-basic-auth-helpers=DB make make install Download Current Mysql5.1 Source RPM from http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-5.1.44-1.glibc23.src.rpm/from/ftp://mirror.anl.gov/pub/mysql/ Copy MySQL-5.1.44-1.glibc23.src.rpm /tmp Rpm –ivh MySQL-5.1.44-1.glibc23.src.rpm Cd /usr/src/redhat/SPEC Rpmbuid –bb mysql-5.1.44.spec After compilation the RPM files will be in /usr/src/redhat/`uname –m`/RPMS Cd /usr/src/redhat/`uname –m`/RPMS Rpm –ivh MySQL-server-5.1.44-1.glibc23.ia64.rpm The service will start automatically after installation Here we are using Default Mysql database engine MyISAM (Non transactional Engine) In a large application Database we will use Engine INNODB (Transactional engine).It has many configurable options to get mysql to work efficiently with maximum perf