Squid 3.x with Mysql Authentication
Upon your Mysql table, in addition you might have to review the user’s query from this file:
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