From 9c440892dcce003dbe03925c4e2c6499e3ab76ec Mon Sep 17 00:00:00 2001 From: kkalev Date: Sun, 6 Apr 2003 13:55:34 +0000 Subject: [PATCH] Update the README file with notes about the scripts present in the bin folder --- Changelog | 1 + README | 8 ++++++++ 2 files changed, 9 insertions(+) diff --git a/Changelog b/Changelog index 8c9dfa2..9cf4f2b 100644 --- a/Changelog +++ b/Changelog @@ -16,6 +16,7 @@ Ver 1.63: * Add an entry in the FAQ about adding .php3 handling * Add a few installation notes * Fix a problem with user_stats.php3 +* Update the README file with notes about the scripts present in the bin folder Ver 1.62: * Remove one sql query from user_admin which was not needed. * Instead of a query like "LIKE 'YYYY-MM-DD%'" use "AcctStopTime >= 'YYYY-MM-DD 00:00:00 AND AcctStopTime diff --git a/README b/README index db111e9..0879efd 100644 --- a/README +++ b/README @@ -26,6 +26,14 @@ There are also a few more things included: * bin/clean_radacct: It will delete all entries in the radacct table with a starttime > 1 day and stoptime = 0. It will not do an harm even if it deletes valid entries since radiusd will fall back to insert if update fails. +* bin/truncate_radacct: It will delete sessions from the radacct table which are older than a configurable + number of days +* bin/tot_stats: Update the totacct table with aggregated daily accounting information for each user. + We keep a row per user for each day. +* bin/monthly_tot_stats: Log in the mtotacct table aggregated accounting information for each user spaning + in one month period. If the current month has not ended it will log information up to the current month day + + The structure of the tree is: -- 2.39.5