--- Begin Message ---
- To: Debian Bug Tracking System <maintonly@bugs.debian.org>
- Subject: radiuscontext: monthly statistics
- From: Al Nikolov <al@iac.spb.ru>
- Date: Wed, 06 Apr 2005 18:41:10 +0400
- Message-id: <E1DJBiQ-0000A9-00@alligator.lan.iac.spb.ru>
Package: radiuscontext
Version: 1.76-3
Severity: wishlist
Tags: patch
The package, out of a box, unable to produce even simple monthly
statistics.
Here is useful script:
--- /usr/local/sbin/radius-report
#!/bin/sh -e
###########################################################################
#
# Monthly reporting tool for radiuscontext
#
# Usage: radius-report [this|daily|...]
#
# While started without any arguments, generates report for the last
# calendar month. Else (think "_this_ month" or "_daily_ report") generates
# "cumulative" report for the current month.
#
# In /etc/cron.d/radiuscontext:
#
# @daily root /usr/local/sbin/radius-report daily
# @monthly root /usr/local/sbin/radius-report
#
# You have to provide the radius accounting "detail" logs rotated with
# enough rate (with logrotate, for instance), since this tool time filter
# is based on log file modification time. Logs may be gzipped and spreaded
# under several subdirectories of the find start point.
#
###########################################################################
#
# Copyright (c) Al Nikolov <alnikolov@narod.ru>, 2005
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
#
###########################################################################
# Where you want temporary database to be created
TMPDIR=/tmp
# Where you store radius accounting logs
LOGDIR=/var/log/radacct
# Where you want reports to be created
REPDIR=/var/www/radius-reports
# Options for reporting
OPTS='-g html -s 0'
###########################################################################
offset () {
OFFSET=$((($(/bin/date +%s) - $(/bin/date -d $1 +%s)) / 60))
/bin/echo $(($OFFSET > 0 ? $OFFSET : 0))
}
ym () {
/bin/echo $(/usr/bin/expr substr $1 1 7)
}
TODAY=$(/bin/date +%F)
if [ "$1" == "" ]; then
START=$(/bin/date -d "$(ym $TODAY)-15 -1 month" +%Y-%m)-01
END=$(ym $TODAY)-01
else
START=$(ym $TODAY)-01
END=$(/bin/date -d "$TODAY tomorrow" +%F)
fi
TEMP=$(/bin/mktemp)
/usr/bin/find $LOGDIR -name detail* \
-mmin +$(offset $END) -mmin -$(offset $START) \
-exec /bin/zcat -f {} \;|/usr/bin/raddetail -d $TEMP
REPDIR=$REPDIR/$(ym $START)
/bin/mkdir -p $REPDIR
/usr/bin/radreport -d $TEMP -D $REPDIR $OPTS
/bin/rm $TEMP
-- System Information
Debian Release: 3.0
Architecture: i386
Kernel: Linux alligator 2.4.18 #1 SMP Thu Jun 17 16:44:46 MSD 2004 i686
Locale: LANG=ru_RU.KOI8-R, LC_CTYPE=ru_RU.KOI8-R
Versions of packages radiuscontext depends on:
ii python 2.1.3-3.2 An interactive object-oriented scr
ii python1.5 1.5.2-23.3 An interactive object-oriented scr
ii python1.5-gdbm 1.5.2-23.3 GNU dbm database support for Pytho
--- End Message ---