[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freeradius-users
Subject:    Re: Attributes Bandwidth in radgrouprepy table
From:       "Belén_Colmenar_(Grupo_GOWEX)"
Date:       2008-12-23 16:42:43
Message-ID: 49511503.5000401 () gowex ! com
[Download RAW message or body]

Thanks a lot!!!!

It'working :-)

[sql]   expand: %{User-Name} -> belen@host.com
[sql] sql_set_user escaped user --> 'belen@host.com'
rlm_sql (sql): Reserving sql socket id: 4
[sql]   expand: SELECT id, username, attribute, value, op           FROM 
radcheck           WHERE username = '%{SQL-User-Name}'           ORDER 
BY id -> SELECT id, username, attribute, value, op           FROM 
radcheck           WHERE username = 'belen@host.com'           ORDER BY id
[sql] User found in radcheck table
[sql]   expand: SELECT groupname           FROM usergroup           
WHERE username = '%{SQL-User-Name}'           ORDER BY id -> SELECT 
groupname           FROM usergroup           WHERE username = 
'belen@host.com'           ORDER BY id
[sql]   expand: SELECT id, groupname, attribute,           Value, 
op           FROM radgroupcheck           WHERE groupname = 
'%{Sql-Group}'           ORDER BY id -> SELECT id, groupname, 
attribute,           Value, op           FROM radgroupcheck           
WHERE groupname = 'pruebas'           ORDER BY id
[sql] User found in group pruebas
[sql]   expand: SELECT id, groupname, attribute, value, op           
FROM radgroupreply           WHERE groupname = '%{Sql-Group}'           
ORDER BY id -> SELECT id, groupname, attribute, value, op           FROM 
radgroupreply           WHERE groupname = 'pruebas'           ORDER BY id
rlm_sql (sql): Released sql socket id: 4
++[sql] returns ok


Sending Access-Accept of id 0 to 192.168.1.39 port 2050
        Idle-Timeout := 300
        WISPr-Bandwidth-Max-Up := 128000
        WISPr-Bandwidth-Max-Down := 128000
        Session-Timeout := 259199


Thanks again and Happy holidays!


tnt@kalik.net escribió:
> > My whole log debug is the next (I only have changed the MACs and IP, 
> > user y pass of database). I think it's correct but I don't understand 
> > why the sql queries are ignored by Radius ¿? or at least their aren't in 
> > the debug, only radcheck query
> > 
> > 
> ..
> 
> > Module: Instantiating sql
> > sql {
> > 
> ..
> 
> > *       authorize_check_query = "SELECT id, username, attribute, value, 
> > op           FROM radcheck           WHERE username = 
> > '%{SQL-User-Name}'           ORDER BY id"
> > authorize_group_check_query = "SELECT 
> > radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op \
> >  
> > FROM radgroupcheck,usergroup WHERE usergroup.Username = 
> 
> > '%{SQL-User-Name}' AND usergroup.GroupName = radgroupcheck.GroupName 
> > ORDER BY radgroupcheck.id"
> > authorize_group_reply_query = "SELECT radgroupreply.id, 
> > radgroupreply.GroupName,radgroupreply.Attribute, 
> > radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE 
> > usergroup.Username = '%{SQL-User-Name}' AND usergroup.GroupName = 
> > radgroupreply.GroupName ORDER BY radgroupreply.id"*
> > 
> 
> You are missing authorize_reply_query and group_membership_query. Queries
> you are using belong to the 1.1.x schema. Use default queries in
> dialup.conf that belong to 2.1.3.
> 
> You can change the accounting queries to old ones if you don't want to
> change the schema but keep the authorize.
> 
> Ivan Kalik
> Kalik Informatika ISP
> 
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
> 
> 
> 
> 

-- 


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


[prev in list] [next in list] [prev in thread] [next in thread]