Please find here below a correction of the previous post in "understandable English" format ;-) Hi all, I have installed freeRADIUS with mySQL backend. Into sql.conf there are defined several queries, on of these is the following: postauth_query = "INSERT into ${postauth_table} (id, user, pass, reply, date) values ('', '%{User-Name}', '%{User-Password:-Chap-Password}', '%{reply:Packet-Type}', NOW())" based on the previous one, I would like to build a new query to insert user's MAC address into radcheck table, as users log-out (accounting-stop packet). The query is as follows: MAC_insert_query = "INSERT into ${authcheck_table} (UserName, Attribute, op, Value) VALUES ('%{SQL-User-Name}', 'Calling-Station-Id', ':=', '%{Calling-Station-Id}' where UserName != '%{SQL-User-Name}'and Attribute != 'Calling-Station-Id' )"
From freeRADIUS logs (debug mode) I can see that newly defined query is not recognized by freeRADIUS: no logs in produced for MAC_insert_query.
How can I let freeRADIUS accept the new defined query? Thank you in advance Best regards