FW: SQLRadius Extension - Where to start?

[Martin Edge]

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.

-------------------------------------------------------

-- 
Mike McCauley                               mikem at open.com.au
Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
Phone +61 3 9598-0985                       Fax   +61 3 9598-0955

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory etc etc 
on Unix, Win95/8, 2000, NT, MacOS 9, MacOS X etc etc
===
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.