No subject

 6.6.2 GetClientQuery

This parameter specifies the SQL query that will be used to fetch client details from the SQL database specified by DBSource. The database can store all the same parameters that are used to configure a <Client> clause ( See <Client xxxxxx>. )

The default for this parameter is:

 
select NASIDENTIFIER,SECRET,IGNOREACCTSIGNATURE,DUPINTERVAL,
	DEFAULTREALM,NASTYPE,SNMPCOMMUNITY,LIVINGSTONOFFS,
	LIVINGSTONHOLE,FRAMEDGROUPBASEADDRESS,
	FRAMEDGROUPMAXPORTSPERCLASSC,REWRITEUSERNAME,
	NOIGNOREDUPLICATES,PREHANDLERHOOK from RADCLIENTLIST

The default GetClientQuery will work with the sample database schemas provided in the goodies directory of your Radiator distribution.

Your database table must include at least the first and second fields (i.e. the NAS name or IP address and the shared secret). All the other fields are optional, but if they occur, they must occur in the given order. When they occur, they are used to initialize the Client parameter of the same name as shown above. The FRAMEDGROUPBASEADDRESS column may contain multiple comma-separated base addresses. You can customise the GetClientQuery select clause to have additional fields. If they are present in the result of GetClientQuery, they will be used as described below:

    * Identifier field as field 14,
    * DefaultReply as field 15,
    * FramedGroup as field 16,
    * StripFromReply as field 17,
    * AllowInReply as field 18,
    * AddToReply as field 19,
    * AddToReplyIfNotExist as field 20,
    * DynamicReply as field 21,

 
# Our custom client table only has NAS identifier, 
# shared secret and default realm in it:
GetClientQuery select NAME,SECRET,NULL,NULL,DREALM from CLIENTS

-- 
Matt S Trout
Network Programmer
Business Serve plc

--
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.