oh, sorry! my mystake! the correct groupname is 27... I've used "office" just for example...
> *radusergroup* > idrevenda: 1 > username: "john" > groupname: "27" > priority: 1 just replace groupname "office" by "27". thanx! On Sat, Aug 7, 2010 at 6:51 AM, Bjørn Mork <bj...@mork.no> wrote: > "Erick de A. Fabbio" <erickfab...@gmail.com> writes: > > > *radusergroup* > > idrevenda: 1 > > username: "john" > > groupname: "office" > > priority: 1 > > Nope, I don't think so. > > > [sql] expand: SELECT ug.groupname FROM radusergroup ug > > WHERE ug.username = '%{SQL-User-Name}' and ug.idrevenda = > > (SELECT distinct n.idrevenda FROM nas n WHERE n.nasname = > > '%{NAS-IP-Address}' LIMIT 0,1) ORDER BY ug.priority -> SELECT > > ug.groupname FROM radusergroup ug WHERE ug.username = > > 'john' and ug.idrevenda = (SELECT distinct n.idrevenda FROM > nas > > n WHERE n.nasname = '192.168.0.10' LIMIT 0,1) ORDER BY > ug.priority > > [sql] expand: SELECT gc.id, gc.groupname, gc.attribute, > > gc.Value, gc.op FROM radgroupcheck gc WHERE > > gc.groupname = '%{Sql-Group}' and gc.idrevenda = (SELECT > distinct > > n.idrevenda FROM nas n WHERE n.nasname = '%{NAS-IP-Address}' LIMIT > > 0,1) ORDER BY gc.id -> SELECT gc.id, gc.groupname, > > gc.attribute, gc.Value, gc.op FROM radgroupcheck > > gc WHERE gc.groupname = '27' and gc.idrevenda = > > > This looks up groupname = '27', so I guess that's what you actually got > in your radusergroup table. > > > Bjørn > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html -- Erick de A. Fabbio MSN/GTalk: erickfab...@gmail.com Skype: erickfabbio Cel: 19 - 9105 5028
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html