Re: Insert billiplan code in radacct table during authenticaiton

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