(RADIATOR) Easy add ascend-data-filter to mysql

[Hugh Irvine]

Hello Wayne -

You will be pleased to know that it _is_ this simple.

	<AuthBy SQL>
		.....
		AuthSelect select PASSWORD, CHECKATTR, REPLYATTR, ADDTOREPLY \
			from SUBSCRIBERS \
			where USERNAME='%n'
		AuthColumnDef 0, Password, check
		AuthColumnDef 1, GENERIC, check
		AuthColumnDef 2, GENERIC, reply
		AuthColumnDef 3, GENERIC, reply
		....
	</AuthBy>

then the ADDTOREPLY field would contain (if required):

	Ascend-Data-Filter=.......

Aren't you glad you use Radiator?

BTW - you could also just add the "Ascend-Data-Filter= ....." to the 
REPLYATTR field.

regards

Hugh



On 10 Aug 2004, at 13:45, Wayne wrote:

> Hello All,
>  
> I need to send a ascend-data-filter. I was looking for and easy add 
> but I don't think it's going to be this easy. I want to add a filter 
> to drop connections to port 25 that are not going to my mail server 
> but I want to do it on a per user bases in my mysql database. Could I 
> just add a Field to my table called ADDTOREPLY and put this in my 
> Authby SQL AuthSelect select PASSWORD, CHECKATTR, REPLYATTR, 
> ADDTOREPLY from SUBSCRIBERS where USERNAME='%n' ? This way if a 
> customer needs to use a different email server than our local one we 
> can just put a NULL in the ADDTOREPLY field. Some how this seems to 
> simple I don't think I can just a ADDTOREPLY. Has someone else done 
> this on a per user bases if so can you tell me how you went about it ?
>  
> Thanks Wayne
>

NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.

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