Hello Vangelis -
This is from the Radiator 3.7.1 reference manual ("doc/ref.html"):
6.56.5 FindQuery
This optional parameter allows you to define a custom SQL query to find an available address. Defaults to
select TIME_STAMP, YIADDR, SUBNETMASK, DNSSERVER from RADPOOL where POOL='%0' and STATE=0 order by TIME_STAMP
%0 is replaced by the pool hint. %1 is replaced by the username.
Hint : You can get a substantial speedup during address allocation with mysql by adding `limit 1'' to the end of the FindQuery.
You should check your Sybase documentation to ascertain what the equivalent syntax is.
A quick Google search on "sybase select limit" turns up quite a few useful hits.
regards
Hugh
On 17/12/2003, at 8:26 PM, Vangelis Kyriakakis wrote:
Hello,
we are trying to use AddressAllocator with Microsoft SQL and Sybase.
In both situations the default FindQuery
select TIME_STAMP,YIADDR,SUBNETMASK,DNSSERVER from RADPOOL where POOL='%0' and STATE=0 order by TIME_STAMP
tries to allocate a lot of addresses and finally returns an error "Too many simultaneous address requests"
In Microsoft SQL I can use the following query:
select top 1 TIME_STAMP,YIADDR,SUBNETMASK,DNSSERVER from RADPOOL where POOL='%0' and STATE=0 order by TIME_STAMP
and it works fine, trying once to allocate an IP. But this query doesn't work with Sybase. What can I use instead of this? Do I do something wrong with default query?
Regards Vangelis
=== Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
NB: have you included a copy of your configuration file (no secrets), together with a trace 4 debug showing what is happening?
-- Radiator: the most portable, flexible and configurable RADIUS server anywhere. Available on *NIX, *BSD, Windows, MacOS X. - Nets: internetwork inventory and management - graphical, extensible, flexible with hardware, software, platform and database independence. - CATool: Private Certificate Authority for Unix and Unix-like systems.
=== Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
