(RADIATOR) ClientListSQL question
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). Chris === 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.
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.
Re: (RADIATOR) ClientListSQL question
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.
Re: (RADIATOR) ClientListSQL question
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.
