|
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 |
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
