Hi Hugh,
sorry for my kinda vague question in there.. actually i got my
radiator doing just fine authenticating via SQL.
what i'm interested in knowing is whether i can do something like
this:
<Handler Caller-Id="select BLOCKED_CLI from BLOCKED_FONE_TBL where
BLOCKED_CLI='%{Caller-Id}'">
<AuthBy FILE>
Filename %D/reject-users
</AuthBy>
</Handler>
errr... i'm not sure about my select statement there but i don't see
any chance for me to place my SQL server,database,username/password
connection parameters anywhere.
reject-users file contains:
DEFAULT Auth-Type = "Reject:Blocked Caller-Id."
my objective is to have a list of phone numbers (dynamic too) that
will served as basis for rejecting authentication via Caller-IDs.
will this be possible?
Hugh Irvine wrote:
>
> Hello Darwin -
>
> On Tue, 19 Oct 1999, Darwin A. Bawasanta wrote:
> > Hi All,
> >
> > i could have sworn Mike gave me a hint on this way way back but
> > somehow i can't find it anywhere on the archive. i'm thinking of
> > setting up another SQL table which will hold the _phone_numbers_ NOT
> > allowed to have access to our network.
> >
> > can i use a "select" statement inside the handler clause? or is there
> > a better way of dealing with this setup? anyone?
> >
>
> Sure - like this:
>
> <Handler ....>
> <AuthBy SQL>
> DBSource ....
> DBUsername ....
> DBAuth ....
> AuthSelect ....
> AuthColumnDef ....
> </AuthBy>
> </Handler>
>
> See Section 6.24 in the Radiator 2.14.1 reference manual.
>
> hth
>
> Hugh
>
> --
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
> Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
> NT, Rhapsody
--
.._.,+=~`^"-.,,.-"^'~=+,.__.,+=~`^"-.,,.-"^'~=+,.__.,+=~`^"-,,
darwin a. bawasanta [EMAIL PROTECTED] pgp-id: 0x367CADAC
SKYinternet incorporated philippines http://www.skyinet.net
mobile: +63 917.322.6299 pager: ec# 963589 marsma|ow@IRC
.._.,+=~`^"-.,,.-"^'~=+,.__.,+=~`^"-.,,.-"^'~=+,.__.,+=~`^"-,,
"Thousands of geniuses live and die undiscovered either
by themselves or by others." - Mark Twain
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
