Not Receiving radreply Attribute set for user in Access-Accept Freeradius3.0

[Alan DeKok]

On May 31, 2018, at 7:35 AM, Uchenna Nebedum <nebeduch at gmail.com> wrote:
> 
> Good Day all,
> 
> I'm new to FreeRadius and radius in general.
> I set up a freeradius3.0 server on my ubuntu18.04 machine
> I created a few users and and gave them radcheck and radreply attributes
> but when i test the users with radtest, In the Access-Accept message the
> reply attributes are not included
> here's the debug output

  How read the debug output:

 http://wiki.freeradius.org/radiusd-X

> (0) sql: Executing select query: SELECT id, username, attribute, value, op
> FROM radcheck WHERE username = 'F0:3D:03:EC:42:66' ORDER BY id
> (0) sql: User found in radcheck table
> (0) sql: Conditional check items matched, merging assignment check items
> (0) sql:   Cleartext-Password := "F0:3D:03:EC:42:66"

  That's good...

> (0) sql: EXPAND SELECT id, username, attribute, value, op FROM radreply
> WHERE username = '%{SQL-User-Name}' ORDER BY id
> (0) sql:    --> SELECT id, username, attribute, value, op FROM radreply
> WHERE username = 'F0:3D:03:EC:42:66' ORDER BY id
> (0) sql: Executing select query: SELECT id, username, attribute, value, op
> FROM radreply WHERE username = 'F0:3D:03:EC:42:66' ORDER BY id
> (0) sql: User found in radreply table, merging reply items
> (0) sql:   Mikrotik-Rate-Limit == "1024k/1024k"

  That's wrong.  See the Wiki for how the SQL module works.  There is extensive documentation.

  Use ":=", not "==".

  Alan DeKok.