3.114.8. UpdateQuery Previous topic Parent topic Child topic Next topic

This optional parameter allows you to define a custom SQL query to update the address or prefix when accounting Start or Alive requests are received. There is no default.
UpdateQuery update RADPOOL set TIME_STAMP=?, EXPIRY=? where YIADDR=?
UpdateQueryBindVar %t
UpdateQueryBindVar %0
UpdateQueryBindVar %1
The variables are replaced as follows:
  • %0 by the lease expiry time (the current time + the lease period)
  • %1 by the address
  • %2 by the SQL quoted NasId
If the UpdateQuery is an empty string, the query is not executed.