(RADIATOR) problem with changing attributes during an PreAuthHook

[Atto Lorenz]

Yes, I use MySql.

This solution look's interesting. I will try it in the next day's. In my
case I have to add to the SELECT statement "...and CALLINGSTATID regexp
'%{Calling-Station-Id}'" one more rule, because a customer/accounts is
allowed to have no calling_station_id in the database. So I have to add "...
or CALLINGSTATID is null" and then it should work.

Thanks for your help.

Atto

> -----Original Message-----
> From: mns [mailto:mns at hiwire.net.ph]
> Sent: Saturday, January 12, 2002 5:25 AM
> To: hugh at open.com.au
> Cc: Atto Lorenz; radiator at open.com.au; alorenz at cybernet-ag.net
> Subject: Re: (RADIATOR) problem with changing attributes during an
> PreAuthHook
>
>
> are you using a mysql? If you do you can add a field
> CALLINGSTATID on your
> table and the value of that field may look something like this
> +------------------------------+
> |CALLINGSTATID                 |
> +------------------------------+
> | 021111111:022222222:023333333|
> +------------------------------+
> a callerid delimited by any non numeric character
> then use this in your authselect statement
>
> <AuthBy SQL>
> 	.....
> 	AuthSelect select PASSWORD, CHECKATTR, REPLYATTR \
> 		from SUBSCRIBERS where USERNAME = '%n' \
>                and CALLINGSTATID regexp '%{Calling-Station-Id}'
> 	AuthColumnDef 0, Password, check
> 	AuthColumnDef 1, GENERIC, check
> 	AuthColumnDef 2, GENERIC, reply
> 	.....
> </AuthBy>

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