Re: Insert billiplan code in radacct table during authenticaiton
On Sun, Oct 26, 2008 at 4:12 AM, Bishal [EMAIL PROTECTED] wrote: Following is my radcheck table format: --+--+-+--+ | id | UserName | Attribute| op | Value| CrDate | creator | Usemac | activated | activeDate | status | rate | Type | BillingPlan | TimeToFinish | +--+--+--++--+-+-++---+-++--+--+-+--+ | 1272 | bishal | User-Password| == | testpass| 2006-07-28 18:42:58 | bishal | 0 | 0 | 2007-07-22 20:49:17 | 0 | 0 | | 001 |0 | | 1273 | Hary | User-Password | == | lamp | 2007-08-28 20:443:58 | bishal | 0| 0 | 2007-08-28 20:443:58 | 0 |0 | | 002 |0| = Yickes! Why would anyone torture radcheck table like that? :-) I'm curious to know which management application you are using if it's ok for you to let us know. Regards, Liran. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Insert billiplan code in radacct table during authenticaiton
Hi Liran, I have developed my own php based online viewing gui interface. Bishal On 10/27/2008, liran tal [EMAIL PROTECTED] wrote: On Sun, Oct 26, 2008 at 4:12 AM, Bishal [EMAIL PROTECTED] wrote: Following is my radcheck table format: --+--+-+--+ | id | UserName | Attribute| op | Value| CrDate | creator | Usemac | activated | activeDate | status | rate | Type | BillingPlan | TimeToFinish | +--+--+--++--+-+-++---+-++--+--+-+--+ | 1272 | bishal | User-Password| == | testpass| 2006-07-28 18:42:58 | bishal | 0 | 0 | 2007-07-22 20:49:17 | 0 | 0 | | 001 |0 | | 1273 | Hary | User-Password | == | lamp | 2007-08-28 20:443:58 | bishal | 0| 0 | 2007-08-28 20:443:58 | 0 |0 | | 002 |0| = Yickes! Why would anyone torture radcheck table like that? :-) I'm curious to know which management application you are using if it's ok for you to let us know. Regards, Liran. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Insert billiplan code in radacct table during authenticaiton
Hey Bishal, On Mon, Oct 27, 2008 at 5:08 PM, Bishal [EMAIL PROTECTED] wrote: Hi Liran, I have developed my own php based online viewing gui interface. That's somewhat sad for me to hear as I do believe that daloRADIUS is a great platform or at least honestly trying to be with a whole lot of effort that I put into it. Unless ofcourse you have developed it 2 years ago, which is when I started the daloRADIUS project too for the lack of proper management platform, in which case I symphatize with you. http://www.daloradius.com http://daloradius.sourceforge.net/ Regards, Liran. Bishal On 10/27/2008, liran tal [EMAIL PROTECTED] wrote: On Sun, Oct 26, 2008 at 4:12 AM, Bishal [EMAIL PROTECTED] wrote: Following is my radcheck table format: --+--+-+--+ | id | UserName | Attribute| op | Value| CrDate | creator | Usemac | activated | activeDate | status | rate | Type | BillingPlan | TimeToFinish | +--+--+--++--+-+-++---+-++--+--+-+--+ | 1272 | bishal | User-Password| == | testpass| 2006-07-28 18:42:58 | bishal | 0 | 0 | 2007-07-22 20:49:17 | 0 | 0 | | 001 |0 | | 1273 | Hary | User-Password | == | lamp | 2007-08-28 20:443:58 | bishal | 0| 0 | 2007-08-28 20:443:58 | 0 |0 | | 002 |0| = Yickes! Why would anyone torture radcheck table like that? :-) I'm curious to know which management application you are using if it's ok for you to let us know. Regards, Liran. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Insert billiplan code in radacct table during authenticaiton
Following is my radcheck table format: --+--+-+--+ | id | UserName | Attribute| op | Value| CrDate | creator | Usemac | activated | activeDate | status | rate | Type | BillingPlan | TimeToFinish | +--+--+--++--+-+-++---+-++--+--+-+--+ | 1272 | bishal | User-Password| == | testpass| 2006-07-28 18:42:58 | bishal | 0 | 0 | 2007-07-22 20:49:17 | 0 | 0 | | 001 |0 | | 1273 | Hary | User-Password | == | lamp | 2007-08-28 20:443:58 | bishal | 0| 0 | 2007-08-28 20:443:58 | 0 |0 | | 002 |0| = My scenario is I have two office and each office using same NAS to connect to internet. Office A users: Office B Users bishal Hary stephe Mic john test My question is if Office A support staff want to view the online users then he should not be able to view office B users online. In the same way office B staff should not be able to view Office A users online. I know if I use different NAs then it's possbile. is it possible by using same NAS with the help of mysql? This is absolutely nothing to do with freeradius. It's user management. Your appication that handles that is suposed to do these things. Simplest way is to extend the query: 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' add AND radcheck.BillingPlan='001' for users from officeA and '002' for users from officeB. Your application will have to know who is the user using it (ie. they will have to log into it). Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Insert billiplan code in radacct table during authenticaiton
Thanks Ivan, by extending my query in mysql it worked. Thanks Bishal On 10/26/2008, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Following is my radcheck table format: --+--+-+--+ | id | UserName | Attribute| op | Value| CrDate | creator | Usemac | activated | activeDate | status | rate | Type | BillingPlan | TimeToFinish | +--+--+--++--+-+-++---+-++--+--+-+--+ | 1272 | bishal | User-Password| == | testpass| 2006-07-28 18:42:58 | bishal | 0 | 0 | 2007-07-22 20:49:17 | 0 | 0 | | 001 |0 | | 1273 | Hary | User-Password | == | lamp | 2007-08-28 20:443:58 | bishal | 0| 0 | 2007-08-28 20:443:58 | 0 |0 | | 002 |0| = My scenario is I have two office and each office using same NAS to connect to internet. Office A users: Office B Users bishal Hary stephe Mic john test My question is if Office A support staff want to view the online users then he should not be able to view office B users online. In the same way office B staff should not be able to view Office A users online. I know if I use different NAs then it's possbile. is it possible by using same NAS with the help of mysql? This is absolutely nothing to do with freeradius. It's user management. Your appication that handles that is suposed to do these things. Simplest way is to extend the query: 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' add AND radcheck.BillingPlan='001' for users from officeA and '002' for users from officeB. Your application will have to know who is the user using it (ie. they will have to log into it). Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Insert billiplan code in radacct table during authenticaiton
Would a customers billing plan be determined if they sucessfully authenticate? Wouldn't they all then be in the same plan? Sorry, I just don't see your point. Sent from my iPhone On 25 Oct 2008, at 03:26, Bishal [EMAIL PROTECTED] wrote: Hi all, 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. Is it possible with rlm_perl module? Thank you Bishal - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Insert billiplan code in radacct table during authenticaiton
Following is my radcheck table format: --+--+-+--+ | id | UserName | Attribute| op | Value| CrDate | creator | Usemac | activated | activeDate | status | rate | Type | BillingPlan | TimeToFinish | +--+--+--++--+-+-++---+-++--+--+-+--+ | 1272 | bishal | User-Password| == | testpass| 2006-07-28 18:42:58 | bishal | 0 | 0 | 2007-07-22 20:49:17 | 0 | 0 | | 001 |0 | | 1273 | Hary | User-Password | == | lamp | 2007-08-28 20:443:58 | bishal | 0| 0 | 2007-08-28 20:443:58 | 0 |0 | | 002 |0| = My scenario is I have two office and each office using same NAS to connect to internet. Office A users: Office B Users bishal Hary stephe Mic john test My question is if Office A support staff want to view the online users then he should not be able to view office B users online. In the same way office B staff should not be able to view Office A users online. I know if I use different NAs then it's possbile. is it possible by using same NAS with the help of mysql? Thank you Bishal On 10/25/2008, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: 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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html