[EN] Squid with MySQL user authentication

apt-get update; apt-get install squid3
cd /etc/squid3

yum install squid
cd /etc/squid

mv squid.conf squid.conf.default
vi squid.conf

#Uncomment for transparent proxy
#http_port 3128 transparent
#
http_port 3128
acl localhost src 127.0.0.0/8
http_access allow localhost
cache_dir ufs /var/spool/squid3/ 3500 8 128
auth_param basic program /usr/lib/squid3/squid_db_auth --user squiduser --password password --plaintext --persist
auth_param basic children 5
auth_param basic realm Need login and password.
auth_param basic credentialsttl 1 minute
auth_param basic casesensitive off
acl db-auth proxy_auth REQUIRED
http_access allow db-auth
http_access allow localhost
http_access deny all
dns_defnames off
dns_v4_first on
dns_nameservers 8.8.8.8

mysql -p

use squid;
CREATE TABLE `passwd` (
`user` varchar(32) NOT NULL default '',
`password` varchar(35) NOT NULL default '',
`enabled` tinyint(1) NOT NULL default '1',
`fullname` varchar(60) default NULL,
`comment` varchar(60) default NULL,
PRIMARY KEY (`user`)
);

insert into passwd values('rcstar','rcstar',1,'Admin','Admin user');