Manual Installation

Ubuntu20.04 LTS

Install squid

apt install squid apt install libmysqlclient-dev

# squid -v
Squid Cache: Version 5.2

Install Apache2 and MariaDB,PHP

apt install php8.1
apt install php8.1-gd php8.1-xml php8.1-mbstring php8.1-mysql php8.1-curl
apt install apache2
cd /var/www/
git clone -b v2.0 https://github.com/39ff/squid-db-auth-web
wget https://getcomposer.org/download/latest-stable/composer.phar
chmod +x composer.phar
./composer.phar install
curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash
apt install mariadb-server

CentOS7

yum install perl-DBD-mysql

Configure squid.conf

auth_param basic program /usr/lib/squid/basic_db_auth --dsn "DBI:mysql:host=172.17.0.1;port=3306;database=laravel;" --user phper --password secret --table squid_users --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

squidmin Setup

Create an Administrator

php artisan db:seed --class=CreateAdministratorSeeder