From Alpine Linux
Jump to: navigation, search

What is SqStat

SqStat is a script which allows to look through active squid users connections. It use cachemgr protocol to get information from squid proxy server.

Set up SqStat on Alpine Linux

This document will be a quick c/p guide to setup SqStat acive squid log viewer on Alpine linux. What we will install is the following:

  • Lighttpd
  • PHP

Installing Lighthttpd and PHP

Install the additional packages:

apk add lighttpd php5-common php5-iconv php5-json php5-gd php5-curl php5-xml php5-pgsql php5-mysql php5-imap php5-cgi fcgi

apk add php5-pdo php5-pdo_pgsql php5-pdo_mysql php5-soap php5-xmlrpc php5-posix php5-mcrypt php5-gettext php5-ldap php5-ctype php5-dom

Configure Lighttpd

Edit lighttpd.conf

vi /etc/lighttpd/lighttpd.conf

Uncomment line:

include "mod_fastcgi.conf"

Edit mod_fastcgi.conf

vi /etc/lighttpd/mod_fastcgi.conf

Edit the section:




Start lighttpd service and add to needed runlevel

rc-service lighttpd start && rc-update add lighttpd default

Installing SqStat

Download SqStat

cd /tmp wget http://samm.kiev.ua/sqstat/sqstat-1.20.tar.gz

Configuring SqStat

Unpack and move SqStat

gunzip sqstat-1.20.tar.gz tar xvf sqstat-1.20.tar -C /var/www/localhost/htdocs/ mv /var/www/localhost/htdocs/sqstat-1.20 /var/www/localhost/htdocs/sqstat

Copy and edit the sqstats config file

cp /var/www/localhost/htdocs/sqstat/config.inc.php.defaults /var/www/localhost/htdocs/sqstat/config.inc.php nano /var/www/localhost/htdocs/sqstat/config.inc.php

  • Modify this lines with your proxy ip addres and port
/* Squid proxy server ip address or host name */
/* Squid proxy server port */

Configuring your squid server

Note: You need edit your squid.conf to allow cachemgr protocol

Edit squid.conf

nano /etc/squid/squid.conf

  • Add this lines and replace the ip addres with your webserver IP
acl manager proto cache_object
# replace with your webserver IP
acl webserver src
http_access allow manager webserver
http_access deny manager

Restart squid

/etc/init.d/squid restart

  • Browse and see