(RADIATOR) NumHosts in SQLRadius

[Martin Edge]

Yeah, the issue is that SQLRadius works around the default of a maximum 2
within the object code.. (or whatever I manually set it to).

Technically perhaps I could make the value so 'large' that it would hit
no-rows first, and have to bail to the Host Failover settings..

The difference is, the way I have setup SQLRADIUS, I'm not limited by a set
of hosts, for instance, in the configuration you supply within the goodies
directory..

...
HostSelect select R.HOST%0, R.SECRET, R.AUTHPORT, \
R.ACCTPORT, R.RETRIES, R.RETRYTIMEOUT, \
R.USEOLDASCENDPASSWORDS, R.SERVERHASBROKENPORTNUMBERS, \
R.SERVERHASBROKENADDRESSES, R.IGNOREREPLYSIGNATURE, \
R.FAILUREPOLICY from RADSQLRADIUS R, RADSQLRADIUSINDIRECT I \
 where I.SOURCENAME='%{Called-Station-Id}' and I.TARGETNAME=R.TARGETNAME
...

In this example, NumHosts 2 is fine, because if we exceed this, It's
designed to fallover to the default host config, the database structure has
limited any further hosts being configurd.

My issue is, there can be any number of RADIUS hosts, and I'd like to design
the system so that it's happy to figure out how many hosts it has to choose
from.

My HostSelect:

HostSelect

SELECT downh.ip_address, downh.secret, downh.authport, downh.acctport,
downh.retries, downh.retrytimeout, downh.failurebackofftime,
down.failurepolicy,  down.addtoreply, down.stripfromreply,
down.allowinreply, down.addtoreplyifnotexist, down.defaultreply,
down.addtorequest, down.stripfromrequest, down.addtorequestifnotexist,
down.useoldascendpasswords, down.serverhasbrokenportnumbers,
down.serverhasbrokenaddresses, down.ignorereplysignature

FROM downstream_host downh, downstream_dnis ddnis, downstream down,
downstream_host_preference downhp

WHERE ddnis.dnis = '%{Called-Station-Id}' and  ddnis.target_id =
downhp.target_id and downhp.hostid = downh.hostid and ddnis.target_id =
down.target_id and downhp.preftype = '%{Packet-Type}' and  downhp.priority =
'%0';

Perhaps the NumHosts flag could be rewrite to accept an SQL Query as well
that allowed Radiator to figure out how many RADIUS targets maximum it had
to deal with.. ?

Stats: Yeah Cool :)

Thanks,
Martin


-----Original Message-----
From: Hugh Irvine [mailto:hugh at open.com.au]
Sent: Tuesday, August 20, 2002 5:27 PM
To: Martin Edge
Cc: radiator at open.com.au
Subject: Re: (RADIATOR) NumHosts in SQLRadius



Hello Martin -

For the first point, no you cannot specify the number of hosts in the
database, but I don't believe you need to have the number specified in
any case as the query will just fail and fall back to the local Host
definition.

For the StatsLog, I suggest yo try some experiments to see what you get
(and have a look at Radar).

regards

Hugh


On Tuesday, August 20, 2002, at 02:52 AM, Martin Edge wrote:

> Hey Guys,
>
> Is there anyway to set NumHosts dynamically? Say perhaps via the first
> SQLRADIUS lookup, it returns the NumHosts variable?
>
> I'd prefer to not have to hard set this, as I'm trying to design the
> system
> around a dynamic number of destination RADIUS servers..
>
> also..
>
> What type of detail can I expect with trying to run StatsLogSQL with
> SQLRADIUS, as I would like to be able to scalably count the
> request/responses along with the number of downstream ISPs I am
> supporting.
>> From what I read in the documentation, statistics are kept for each
> "Identifier", the SQLRADIUS itself as an Identifier, but each downstream
> within the database, I would expect does not have it's own unique
> Identifier..
>
> Thanks,
> Martin
>
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
>
>

NB: I am travelling this week, so there may be delays in our
correspondence.

--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.


===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.