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