Re: getting byte-in and byte-out on freeradius?

Hello Jabriel.

Dne sreda 09 marec 2005 11:36 je Jabriel Tezser napisal(a):
> Hi,
> I've a problem to getting byte-in and byte-out when processing accounting=
to=20
> database on freeradius.
> Anybody have experience on this?

I use this to log bytes-in/out and packets-in/out + other data to the
MySQL database:

CREATE TABLE ACCOUNTING (
`User-Name` varchar(100) NOT NULL default '',
`Calling-Station-Id` varchar(100) NOT NULL default '',
`Client-IP-Address` varchar(100) NOT NULL default '',
`Called-Station-Id` varchar(100) NOT NULL default '',
`NAS-Port` int(10) unsigned NOT NULL default '0',
`Timestamp Start` datetime NOT NULL default '0000-00-00 00:00:00',
`Timestamp Dhcp` datetime NOT NULL default '0000-00-00 00:00:00',
`Timestamp Stop` datetime NOT NULL default '0000-00-00 00:00:00',
`Acct-Unique-Session-Id` varchar(100) NOT NULL default '',
`Acct-Session-Time` int(10) unsigned NOT NULL default '0',
`Acct-Input-Octets` int(10) unsigned NOT NULL default '0',
`Acct-Output-Octets` int(10) unsigned NOT NULL default '0',
`Acct-Input-Packets` int(10) unsigned NOT NULL default '0',
`Acct-Output-Packets` int(10) unsigned NOT NULL default '0',
`Acct-Terminate-Cause` varchar(100) NOT NULL default ''
) TYPE=3DMyISAM;

Of course you will need to check your NAS and see the actual
attribute names. These are for the Cisco AP12xx.

sql.conf:
sql {
driver =3D "rlm_sql_mysql"
server =3D "localhost"
login =3D "<mysql user>"
password =3D "<mysql password>"
radius_db =3D "radius"

accounting_start_query =3D "INSERT into ACCOUNTING SET\
`User-Name` =3D '%{User-Name}',\
`Calling-Station-Id` =3D '%{Calling-Station-Id}',\
`Called-Station-Id` =3D '%{Called-Station-Id}',\
`NAS-Port` =3D %{NAS-Port},\
`Timestamp Start` =3D NOW(),\
`Acct-Unique-Session-Id` =3D '%{Acct-Unique-Session-Id}'
"

accounting_update_query =3D "UPDATE ACCOUNTING SET\
`Acct-Session-Time` =3D '%{Acct-Session-Time}',\
`Acct-Input-Octets` =3D '%{Acct-Input-Octets}',\
`Acct-Output-Octets` =3D '%{Acct-Output-Octets}',\
`Acct-Input-Packets` =3D '%{Acct-Input-Packets}',\
`Acct-Output-Packets` =3D '%{Acct-Output-Packets}'\
WHERE `Acct-Unique-Session-Id` =3D '%{Acct-Unique-Session-Id}'\
LIMIT 1
"

accounting_stop_query =3D "UPDATE ACCOUNTING SET\
`Timestamp Stop` =3D NOW(),\
`Acct-Session-Time` =3D '%{Acct-Session-Time}',\
`Acct-Input-Octets` =3D '%{Acct-Input-Octets}',\
`Acct-Output-Octets` =3D '%{Acct-Output-Octets}',\
`Acct-Input-Packets` =3D '%{Acct-Input-Packets}',\
`Acct-Output-Packets` =3D '%{Acct-Output-Packets}',\
`Acct-Terminate-Cause` =3D '%{Acct-Terminate-Cause}'\
WHERE `Acct-Unique-Session-Id` =3D '%{Acct-Unique-Session-Id}'\
LIMIT 1
"

}=20


=2D-=20
lep pozdrav,
Rok Pape=BE.

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html