squid 3.x with Mysql Authentication

Squid 3.x with Mysql Authentication

Upon your Mysql table, in addition you might have to review the user's query from this file:

 

/usr/lib/squid3/squid_db_auth

 

You will require to change these lines to work with your MySql intance:

my $dsn = "DBI:mysql:database=DB_NAME"; <= your DB Name
my $db_table = "members"; <= your DB table name
my $db_usercol = "username"; <= User column from your table
my $db_passwdcol = "passcode"; <= Password column from your table

 


As the end of this file, you might have to check and try some of the SQL queries in order to confrm that Squid is able to validate the credential.

 

auth_param basic program /usr/lib/squid3/squid_db_auth --user 'Mysql user'--password 'Mysql password' --plaintext --persist

auth_param basic children 5

auth_param basic realm Linux Class
auth_param basic credentialsttl 2 hours
auth_param basic casesensitive off

acl mynetwork proxy_auth REQUIRED

Leave a Reply

Your email address will not be published. Required fields are marked *