> 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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html