Operator rlm_sql question

2007-07-11 Thread Dave
HI, I have a question regarding the rlm_sql module and the := operator. In going through the documentation, the rlm_sql module goes through the radcheck table, then pulls the reply items from the radreply table. Then the usergroup, radgroupcheck and radgroupreply table. So if I specify for example

Re: rlm_sql question

2007-02-15 Thread Norbert Wegener
Please forget this question. Someone had changed a network setting, so that mysql and rlm_sql did not reach the same databases. Right now everything works as expected. Sorry Norbert Wegener Norbert Wegener schrieb: > I am using freeradius 1.1.4 with mysql. > > I had to change the authorize_chec

rlm_sql question

2007-02-15 Thread Norbert Wegener
I am using freeradius 1.1.4 with mysql. I had to change the authorize_check_query. authorize_check_query = "SELECT radcheck.id, radcheck.UserName, radcheck.Attribute, radcheck.Value, radcheck.op \ FROM radcheck,nas \ WHERE (Username = '%{SQL-User-Name}') \ and (nas.type='Enterasys Net