radius does not check table radgroupcheck

[Bjørn Mork]

"Erick de A. Fabbio" <erickfabbio at 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