(RADIATOR) Cli Authentication through DB ...

[Hugh Irvine]

Hello Mushtaque -

This topic has been discussed many times on the mailing list.

Please check the archive site:

	http://www.open.com.au/archives/radiator

This is very easy to do with an AuthBy FILE clause that calls an AuthBy 
SQL clause.

# define AuthBy clauses

<AuthBy FILE>
	Identifier CheckNumber
	Filename %D/users.numbers
	.....
</AuthBy>

<AuthBy SQL>
	Identifier CheckDatabase
	.....
	AuthSelect select ......
	AuthColumnDef .....
	.....
</AuthBy>

# define Realms or Handlers

<Handler ....>
	AuthByPolicy ContinueWhileAccept
	AuthBy CheckNumber
	AuthBy ......
</Handler>

......


Your file %D/users.numbers would look something like this:

# %D/users.numbers

DEFAULT Auth-Type = CheckDatabase

DEFAULT Auth-Type = Accept


regards

Hugh


On Wednesday, September 11, 2002, at 09:25 AM, Muhammad Mushtaque wrote:

> Hi,
>
> I want to implement CLI Authentication through MSSQL Database, is there
> any way to match the attribute Calling-Station-ID from any other field
> in DB. like if the CLI Authentication field is Yes and user is
> connecting from any number, request should first check and match with
> that field and if number is matched then user gets connect else user
> should not be able to connect.
>
> any idea??
>
> regards,
> Mushtaque.
>
>
> _______
> This email and any files transmitted with it are confidential and are
> intended solely for the use of the individual or entity to which they
> are addressed. This communication represents the originator's personal
> views and opinions, which do not necessarily reflect those of eWorld
> (Pvt) Ltd. If you are not the original  / intended recipient or the
> person responsible for delivering the email to the intended recipient,
> be advised that you have received this email in error, and that any
> use, dissemination, forwarding, printing, or copying of this email is
> strictly prohibited. If you have received this email in error, we
> regret the inconvenience and request you to please immediately notify
> at info at eworld.net.pk
>
> ===
> 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.