(RADIATOR) Rejecting Caller-ID from SQL without auth from SQL

[Hugh Irvine]

Hello Viraj -

You have to do this with different AuthBy clauses, something like this:

# define AuthBy clauses

<AuthBy SQL>
	Identifier CheckNumber
	.....
	AuthSelect select ACTION from BLACKLIST \
		where NUMBER = %{Calling-Station-Id}
	AccountingTable
</AuthBy>

<AuthBy FILE>
	Identifier CheckBlacklist
	Filename %D/blacklist
	NoDefaultIfFound
</AuthBy>

<AuthBy FILE>
	Identifier YourNormalAuthBy
	Filename %D/users
	.....
</AuthBy>

# define Realms or Handlers

<Realm ...>
	AuthByPolicy ContinueWhileAccept
	AuthBy CheckBlacklist
	AuthBy YourNormalAuthBy
	.....
</Realm>


The BLACKLIST table in the database would have the list of numbers in the 
NUMBER column and "Auth-Type = Reject" in the ACTION column.


The file %D/blacklist would contain this:

# DEFAULT entries to check blacklist

DEFAULT  Auth-Type = CheckNumber

DEFAULT  Auth-Type = Accept


If you have any questions, please ask.

regards

Hugh


On Thu, 14 Feb 2002 09:40, Viraj Alankar wrote:
> Hello,
>
> I'm trying to setup Radiator to do the following:
>
> if access request's Calling-Station-Id exists in a callerid SQL table
>         reject the request
> else
>         authenticate with a FILE
>
> What would be the simplest way to do this? Note I am not authenticating via
> SQL, but only checking a callerid table for existence of a number.
>
> Thanks,
>
> Viraj.
> ===
> 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.

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