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:[EMAIL PROTECTED]]
> Sent: Saturday, January 12, 2002 5:25 AM
> To: [EMAIL PROTECTED]
> Cc: Atto Lorenz; [EMAIL PROTECTED]; [EMAIL PROTECTED]
> 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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
