May
30
2009
We have seen a few posts on Freeradius user list and other forums asking how to collect accounting periodically. The Radius protocol provides accounting but not in the way that many would like. Here’s a short list of things we would like to modify or improve:
Traffic is not collected at regular intervals
As a result, it [...]
Tags: accounting, billing software, Cisco, daily, Database, Freeradius, Mysql, quota, radius, report, SQL, traffic
May
18
2009
Edit /etc/exports (or create it if it doesn’t exist) and add folders to be shared:
/home/public -access=client1,root=client1
Option access restricts the list of clients, root allows to mount the share by root user
Start nfsd services:
startsrc -s nfsd
startsrc -s mountd
Check daemons are running:
AIX_NFS_Server # lssrc -s nfsd
Sub-system Group [...]
Tags: Aix, export, mount, NFS, server, share
May
16
2009
You can easily graph your Freeradius number of active sessions with a simple shell script if you store accounting data in a SQL database.
Use the script below for Mysql:
#!/bin/bash
SQL_USERNAME=radius_username
SQL_DATABASE=radius
SQL_PASSWORD=your_password
SQL_SERVER=127.0.0.1
SQL_ACCOUNTING_TABLE=radacct
BACK_DAYS=5
SESSIONS=`mysql -BN -u$SQL_USERNAME -p$SQL_PASSWORD -h $SQL_SERVER $SQL_DATABASE -e \
“SELECT COUNT(*) FROM $SQL_ACCOUNTING_TABLE \
WHERE acctstoptime IS NULL \
AND Acctstarttime > NOW() – [...]
Tags: active, Freeradius, graph, monitor, mrtg, number, session