SQL.conf new query

[Paolo Pellicori]

hello, type is possible to insert one new query in the rows sql.conf this:

 

postauth_query = "INSERT into ${postauth_table} (id, user, pass, reply,
date) values ('', '%{User-Name}', '%{User-Password:-Chap-Password}',
'%{reply:Packet-Type}', NOW())"

 

modified in this way with name postauth_query_mac:

 

  postauth_query_mac = "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' )"

 

where I can find the rows for invocare the new query?  Thanks

 

Regards

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