Insert billiplan code in radacct table during authenticaiton
tnt at kalik.net
tnt at kalik.net
Sat Oct 25 12:38:29 CEST 2008
> I am using freeradius for AAA of my cable users. Now what I want
>to do is, insert billiplan code 001 into radacct table during
>authentication so that I can view online users according to billingplan
>code. There will be Billingplan field in radcheck table and when users
>tries to login the script will check the radcheck table and update that
>billingplan code into radacct table.
Let's not. Use sql query to view online users with billing plan:
SELECT radacct.*,radcheck.Billingplan FROM radacct,radcheck WHERE
radacct.AcctStopTime IS NULL (or =0 for older schema) AND
radacct.UserName=radcheck.UserName AND radcheck.Attribute='Billingplan'
Ivan Kalik
Kalik Informatika ISP
More information about the Freeradius-Users
mailing list