(RADIATOR) Re: FW: SQLRadius Extension - Where to start?

[Hugh Irvine]

Hello Martin -

What you show below looks alright - you should set up a test machine and 
test it thoroughly to verify that it is correct.

regards

Hugh


On Monday, May 20, 2002, at 02:16 PM, Martin Edge wrote:

> Er, that wasn't meant to send yet.
>
> I have finished what I was saying, below..
>
> -----Original Message-----
> From: Martin Edge
> Sent: Monday, 20 May 2002 2:14 PM
> To: 'hugh at open.com.au'
> Cc: 'radiator at open.com.au'
> Subject: RE: FW: SQLRadius Extension - Where to start?
>
>
> Hey Hugh,
>
> Are the rest of these as follows:
>
> 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,
> R.ADDTOREPLY, R.STRIPFROMREPLY from RADSQLRADIUS R, RADSQLRADIUSINDIRECT
> I where I.SOURCENAME='%{Called-Station-Id}' and
> I.TARGETNAME=R.TARGETNAME
>
> HostColumnDef 0, Host
> HostColumnDef 1, Secret
> HostColumnDef 2, AuthPort
> HostColumnDef 3, AcctPort
> HostColumnDef 4, Retries
> HostColumnDef 5, RetryTimeout
> HostColumnDef 6, UseOldAscendPasswords
> HostColumnDef 7, ServerHasBrokenPortNumbers
> HostColumnDef 8, ServerHasBrokenAddresses
> HostColumnDef 9, IgnoreReplySignature
> HostColumnDef 10, FailurePolicy
> HostColumnDef 11, AddToReply
> HostColumnDef 12, StripFromReply
>
> Thanks,
> Martin
>
>
> -----Original Message-----
> From: Hugh Irvine [mailto:hugh at open.com.au]
> Sent: Monday, 20 May 2002 10:25 AM
> To: Martin Edge
> Cc: radiator at open.com.au
> Subject: Re: FW: SQLRadius Extension - Where to start?
>
>
>
> Hello Martin -
>
> You are probably not subscribed to the list with the address that you
> sent
> this message from.
>
> The answers to your questions are:
>
> 1. AddToReply, StripFromReply, etc. are all supported in Radiator 3.0
> with
> the "HostColumnDef" construct.
>
> HostSelect select HOST%0, SECRET, ADDTOREPLY, STRIPFROMREPLY from \
> 	RADSQLRADIUS where TARGETNAME='%R'
> HostColumnDef 0, Host
> HostColumnDef 1, Secret
> HostColumnDef 2, AddToReply
> HostColumnDef 3, StripFromReply
>
> 2. The simplest way to use the same SQL connection is to specify an
> AuthBy
> SQL clause with an Identifier, then do a lookup on the AuthBy clause and
> use
> the database handle from there.
>
> There are some example hooks in the file "goodies/hooks.txt".
>
> regards
>
> Hugh
>
>
> On Mon, 20 May 2002 09:32, Martin Edge wrote:
>> Hey Hugh,
>>
>> I didn't notice this message pop out on the list..
>>
>> Thanks,
>> Martin
>>
>> -----Original Message-----
>> From: Martin Edge
>> Sent: Thursday, 16 May 2002 10:47 PM
>> To: radiator at open.com.au
>> Subject: SQLRadius Extension - Where to start?
>>
>>
>> Hey Guys,
>>
>> As part of my SQLRadius configuration, I want to be able to specify
>> StripFromReply and AddToReply fields in my database, and be able to
>> utilise these from the SQLRadius.pm module automagically.
>>
>> What would be the best place/module to start?
>>
>> Also, how does one utilise the existing database connection being used
>> in an AuthBy so another connection doesn't have to be spawned ? (say
>> if I have a hook that looks up information on a user).
>>
>> Thanks,
>> Martin
>
> --
> 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.