Re: mysql radcheck table
Mark Terry [EMAIL PROTECTED] wrote: currently i'm using this but i am unsure whether it is correct: +-+--+---++--+ | id | UserName | Attribute | Value | op | +-+--+---++--+ | 311 | 102523 | User-Password | password | == | +-+--+---++--+ The SQL schema is meant to mimic what goes on in the 'users' file. So look at the 'users' file for examples... should the op field be null? Absolutely not. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: mysql radcheck table
At 05:48 PM 10/30/2002 +, Mark Terry wrote: all, can anyone give me an example radcheck table entry for using freeradius with mysql, please? currently i'm using this but i am unsure whether it is correct: +-+--+---++--+ | id | UserName | Attribute | Value | op | +-+--+---++--+ | 311 | 102523 | User-Password | password | == | +-+--+---++--+ should the op field be null? Would you put the following entry in the users file? 102523 User-Password password or would you put? 102523 User-Password == password Regardless of where they are stored you need attribute, operator, and value to compare a check-item. If you are unsure of something, try it, and run the server in debugging mode. It is very good about telling you very specifically what you have done wrong if something is incorrect. -Chris -- \\\|||/// \ StarNet Inc. \ Chris Parker \ ~ ~ / \ WX *is* Wireless!\ Director, Engineering | |\ http://www.starnetwx.net \ (847) 963-0116 oOo---(_)---oOo--\-- \ Wholesale Internet Services - http://www.megapop.net - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Re: mysql radcheck table
On Wednesday 30 Oct 2002 5:54 pm, you wrote: At 05:48 PM 10/30/2002 +, Mark Terry wrote: all, can anyone give me an example radcheck table entry for using freeradius with mysql, please? currently i'm using this but i am unsure whether it is correct: +-+--+---++--+ | id | UserName | Attribute | Value | op | +-+--+---++--+ | 311 | 102523 | User-Password | password | == | +-+--+---++--+ should the op field be null? Would you put the following entry in the users file? 102523 User-Password password or would you put? 102523 User-Password == password Regardless of where they are stored you need attribute, operator, and value to compare a check-item. If you are unsure of something, try it, and run the server in debugging mode. It is very good about telling you very specifically what you have done wrong if something is incorrect. -Chris thanks for your help. ok, so if i wanted to check againist three items then these table records would work. (as i see no AND, OR fields)? +-+--+++--+ | id | UserName | Attribute | Value | op | +-+--+++--+ | 836 | 101302 | User-Password | password| == | | 837 | 101302 | Calling-Station-Id | 123456 | == | | 838 | 101302 | Calling-Station-Id | 123457 | == | +-+--+++--+ if possible i would like the user to dial up from anyone of the clis in the database. But if their password was incorrect and they used the correct cli would they get authenticated? so about the basic questions, i'm just trying to get the database ready for when the radius gets restarted in the morning. Mark -- http://www.thedumbterminal.co.uk - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html