On May 31, 2018, at 7:35 AM, Uchenna Nebedum <nebeduch@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.