Attributes Bandwidth in radgrouprepy table

["Belén Colmenar (Grupo GOWEX)"]

Thanks a lot!!!!

It'working :-)

[sql]   expand: %{User-Name} -> belen at host.com
[sql] sql_set_user escaped user --> 'belen at 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 at 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 at 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 at 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
>
>
>
>   

--