Por favor, para la próxima utiliza un asunto relacionado con tu duda en
cuestión. Aqui te cito esto, tomado de la wiki oficial de Squid [1], espero que
te sirva de algo:
Configuring a Squid Server to authenticate from MySQL database
By Askar Ali Khan
Warning: Any example presented here is provided "as-is" with no support or
guarantee of suitability. If you have any further questions about these
examples please email the squid-users mailing list.
Contents
1. Configuring a Squid Server to authenticate from MySQL database
1. Outline
2. Squid Installation
3. Creating MySQL db/table to hold user credentials
4. Squid Configuration File
5. Testing the squid_db_auth helper
Outline
In this example a squid installation will use MySQL to authenticate users
before allowing them to surf the web. For security reasons users need to enter
their username and password before they are allowed to surf the internet.
Squid Installation
Install squid using your distro package management system or using source.
Make sure squid is compiled with --enable-basic-auth-helpers=DB option.
Creating MySQL db/table to hold user credentials
mysql> create database squid;
mysql> grant select on squid.* to someuser@localhost identified by 'xxxx';
Create table 'passwd' in 'squid' db.
mysql> 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`)
);
Populate the table with some test data, eg
mysql> insert into passwd values('testuser','test',1,'Test User','for testing
purpose');
Squid Configuration File
Edit squid.conf so that authentication against MySQL db works
auth_param basic program /usr/local/squid/libexec/squid_db_auth --user someuser
--password xxxx --plaintext --persist
auth_param basic children 5
auth_param basic realm Web-Proxy
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
Testing the squid_db_auth helper
It good idea to test the squid_db_auth helper from command line to make sure it
authenticating with mysql before trying from browser.
/usr/local/squid/libexec/squid_db_auth --user someuser --password xxxx
--plaintext --persist
Type the user/password on the same line separated with space, on successful
authentication it will give "OK" otherwise "ERR login failure"
[1] http://wiki.squid-cache.org/ConfigExamples/Authenticate/Mysql
______________________________________________________________________
Lista de correos del Grupo de Usuarios de Tecnologías Libres de Cuba.
Gutl-l@jovenclub.cu
https://listas.jovenclub.cu/cgi-bin/mailman/listinfo/gutl-l
