Hello Chris -
I am not an SQL expert, so I suggest you try it and see.
(and check an SQL manual)
regards
Hugh
On Monday 19 March 2001 16:16, Chris M wrote:
> 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.
--
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.
