[squid-users] squid and mysql to autenticate groups

Ottavia Neruda ottaviane at gmail.com
Thu Jul 14 17:14:00 UTC 2016


hello,
I'have 2 tables in mysql.
First table is Group1 and other is Group2.
I'd like that user in Group1 are enabled to surfing in Sites1 list of 
sites and Group2 in Sites2 list of sites.
In squid.conf I did:

auth_param basic program  /usr/lib/squid/basic_db_auth --dsn 
"DBI:mysql:database=squid" --user "utente_lettore" --password "password" 
--table "Group1" --usercol "user" --passwdcol "passwor$

auth_param basic children 15
auth_param basic realm proxy2
auth_param basic credentialsttl 1 minute
auth_param basic casesensitive off

acl db-Group1 proxy_auth REQUIRED

auth_param basic program  /usr/lib/squid/basic_db_auth --dsn 
"DBI:mysql:database=squid" --user "utente_lettore" --password "password" 
--table "Group2" --usercol "user" --passwdcol "passwor$

auth_param basic children 15
auth_param basic realm proxy2
auth_param basic credentialsttl 1 minute
auth_param basic casesensitive off

acl db-Group2 proxy_auth REQUIRED


acl Sites1 dstdomain "/etc/squid/webconsentiti.txt"
acl Sites2 dstdomain "/etc/squid/webconsentiti2.txt"


http_access allow db-Group1 Sites1
http_access allow db-Group2 Sites2
 
http_access deny all


Why it does'nt work?
bye.



More information about the squid-users mailing list