MySAR

MySQL Squid Access Report is a reporting system for user web traffic activity, as logged from a squid proxy. MySAR consists of two parts: Command line utilities which import a squid log file in a MySQL database and maintain the database and a web interface for accessing the reports.

Prerequisites

MySQL database server
Apache web server
PHP

Installation

cd /extra/source
wget http://softlayer-ams.dl.sourceforge.net/project/mysar/mysar/2.1.4/mysar-2.1.4.tar.gz
tar zxf mysar-2.1.4.tar.gz
mv mysar /usr/local/

Configure your Apache Web Server to point the /mysar/ directory to the local directory /usr/local/mysar/www/.

 Alias /mysar "/usr/local/mysar/www"
 <Directory "/usr/local/mysar/www">
    Options None
    AllowOverride None
    Order allow,deny
    Allow from all
  </Directory>

Restart your webserver and then use your web browser to load http://<your server>/mysar. Follow the provided instructions for installing MySAR. You will need to create the config file, /usr/local/mysar/etc/config.ini, with the information provided. Once installation is done, remove the MySAR install directory:

rm -rf /usr/local/mysar/www/install

In the MySAR web interface Administration options (http:///mysar/index.php?a=administration), adjust the location the Squid access log:

/usr/local/squid/var/logs/access.log

Add the cron jobs that will automatically parse the Squid log files. On a CentOS machine with /etc/cron.d, this can be done by linking the included cron.d task which will run every minute:

chmod go-w /usr/local/mysar/etc/mysar.cron
ln -s /usr/local/mysar/etc/mysar.cron /etc/cron.d/mysar

The import scripts expect that the PHP binary will be located in /usr/bin, if it's not, link it there:

ln -s /usr/local/bin/php /usr/bin/php

Binary Log Importer

cd /usr/local/mysar/bin/mysar-binary-importer
./configure --with-mysql-lib=/usr/local/mysql/lib
make
make install

Recent Updates

Apache

2 years 2 days ago
Apache

2 years 2 days ago
lighttpd

2 years 5 days ago

php 8.x
MariaDB

2 years 6 days ago

10.6.7
CentOS

2 years 1 week ago

Drop Centos 5/6 stuff

Recent Links

SquidGuard

SquidGuard is a URL redirector used to use blacklists with the proxysoftware Squid. There are two big advantages to squidguard: it is fast and it is free.
NCurses Disk Usage

A disk usage analyzer with an ncurses interface, aimed to be run on a remote server where you don't have an entire gaphical setup, but have to do with a simple SSH connection. ncdu aims to be fast, simple and easy to use, and should be able to run in any minimal POSIX-like environment with ncurses installed.
WPKG

WPKG is an automated software deployment, upgrade and removal program for Windows.

It can be used to push/pull software packages, such as Service Packs, hotfixes, or program installations from a central server (for example, Samba or Active Directory) to a number of workstations.

It can run as a service to install software in the background (silent install), without user interaction.

It can install MSI, InstallShield, PackagefortheWeb, Inno Setup, Nullsoft, other software installers or .exe packages, .bat and .cmd scripts and similar: no more repackaging to perform software installation.

WPKG is open source software.
opsi

opsi (Open PC Server Integration) the Open Source client management system
Vagrant

Vagrant is a tool for building complete development environments. With an easy-to-use workflow and focus on automation, Vagrant lowers development environment setup time, increases development/production parity, and makes the "works on my machine" excuse a relic of the past.

Main menu

You are here

MySAR

Recent Updates

Recent Links