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 <bjorn at mork.no> wrote:
> "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
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
--
Erick de A. Fabbio
MSN/GTalk: erickfabbio at gmail.com
Skype: erickfabbio
Cel: 19 - 9105 5028
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20100807/39c3dc59/attachment.html>