3.114.12. AddAddressQuery Previous topic Parent topic Child topic Next topic

This optional parameter allows you to define a custom SQL query to add an address to the pool if it is not found by CheckPoolQuery. The default is:
insert into RADPOOL (STATE, TIME_STAMP, POOL, YIADDR, SUBNETMASK, DNSSERVER)
       values (0, %t, %0, '%1', '%2', '%3')
The variables are replaced as follows:
  • %t by the current time in Unix epoch seconds
  • %0 by the pool name
  • %1 by the address
  • %2 by the subnet mask
  • %3 by the DNS server address
  • %4 by the pool's PoolGroup
  • %5 by the pool's Priority
  • %6 by the pool's NasIdentifier
If AddAddressQuery is set to an empty string, addresses are not automatically added to the pool.