Re: Re: mysql radcheck table
On Wednesday 30 Oct 2002 5:54 pm, you wrote: > At 05:48 PM 10/30/2002 +0000, 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
mysql radcheck table
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? thanks in advance. Mark -- http://www.thedumbterminal.co.uk - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
mysql authentication with multiple CLIs
All, i'm using freeradius with mysql to authentication users based on username, password, and their calling station id. but now i have some users that wish to dial up from two or more different CLIs. I need a bit of help on setting up the database records in the radcheck table, this is what i am using at the moment, is this correct? +--+--+++--+ | id | UserName | Attribute | Value | op | +--+--+++--+ | 35 | 102523 | User-Password | password | NULL | | 36 | 102523 | Calling-Station-Id | 123456 | NULL | | 1152 | 102523 | Calling-Station-Id | 123457 | NULL | +--+--+++--+ or should it be like this, using two separate records: +--+--+++--+ | id | UserName | Attribute | Value | op | +--+--+++--+ | 35 | 102523 | User-Password | password | NULL | | 36 | 102523 | Calling-Station-Id | 123456 | NULL | | 1151 | 102523 | User-Password | password | NULL | | 1152 | 102523 | Calling-Station-Id | 123457 | NULL | +--+--+++--+ do i need a value in the last "op" field? thanks in advance. Mark -- http://www.thedumbterminal.co.uk - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Auth with 2 different MySQL servers
All, How easy is it to have freeradius use two different mysql servers (with different username/pass etc) depending on what CLI a user has. i know you can proxy to a different server depending on the cli. Thanls for you help -- http://www.thedumbterminal.co.uk - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html