|
Hi
I am somewhat confuse about how or when Radiator
issues an Accounting Request. All I am trying to do is to update the
balancetime field in the subscribers table on an informix database. I am
not sure if I need to define an AccountingTable in order for me to update the
subscribers table or not. From what I have gathered in order for me to
update the subscribers table all I have to do is just issued the following
statement. Please tell me what it is that I am doing wrong.
In the radius.cfg file in the realm sql.realm and
in the method AuthBy SQL I have the following.
<Realm sql.realm>
RewriteUserName S/^([^@]+).*/$1/
<AuthBy SQL>
Identifier SQL
DBSource
dbi:Infomix:tis
DBUsername
informix
DBAuth
l1gaw01
AuthSelect
select password, balancetime from subscribers where (username = '%n' and
balancetime > 0)
AuthColumnDef
0,Password, check
AuthColumnDef
1,Session-Timeout, reply
AddToReply
Service-Type = Framed-User, Framed-Protocol =
PPP
AuthSQLStatement
update subscribers set balancetime =
balancetime-0%{Acct-Session-Time}
where
username = '%n"
</AuthBy>
</Realm>
The problem that I am having is I dont know how or
when an accounting request is received, therefore I am unsuccessful at updating
the subscribers balancetime. Is there something outside the scope of this
handler thats affecting the update statement?
Please Can you point me in the right
direction
Peace!
|
