R: SQL.conf new query

[Carlo Prestopino]

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

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20060126/4d39c814/attachment.html>