Cool, so...
Would this work to query 3 different clients tables in the database to
populate the client list?
<ClientListSQL>
DBSource %{GlobalVar:database2}
DBUsername username
DBAuth somepasswd
GetClientQuery NASIDENTIFIER,SECRET,NASTYPE,SNMPCOMMUNITY, \
LIVINGSTONOFFS,LIVINGSTONHOLE,DUPINTERVAL \
from LOCALCLIENTLIST,NEXTCLIENTLIST,MORECLIENTLIST
</ClientListSQL>
Chris
> From: Hugh Irvine <[EMAIL PROTECTED]>
> Organization: Open System Consultants
> Reply-To: [EMAIL PROTECTED]
> Date: Mon, 19 Mar 2001 16:06:10 +1100
> To: Chris M <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
> Subject: Re: (RADIATOR) <ClientListSQL> question
>
>
> Hello Chris -
>
> On Monday 19 March 2001 15:13, Chris M wrote:
>> Is it possible to have multiple <ClientListSQL> tags in a config file? I'd
>> like to maintain the client lists in separate tables for separate cities
>> (it simplifies some SQL queries later).
>>
>
> No. ClientListSQL is a global definition.
>
> You can however specify whatever SQL query you need in the GetClientQuery
> parameter, or you can call a stored procedure (if your database supports
> them).
>
> Alternatively, you could write a StartupHook to do whatever is needed, in
> addition to the ClientListSQL clause.
>
> hth
>
> Hugh
>
>
> --
> 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.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
